Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Tracking workflow in error state

Avatar

Level 4

Hi All,

tracking workflow of our environment is in error state.

below is the error snapshot.


Does anyone has any idea about this.

Regards.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Thank you for adding the screenshot.  From the error it looks like you have a custom tracking table schema called "HC3TrackingLogrc2".

The error is basically stating that there is no index on the sourceID field.  If this is a primary or foreign key then it should have an index.  I would recommend having whoever created this table add an index to this field.

Regards,

Craig

View solution in original post

4 Replies

Avatar

Level 4

Hi,

Can you re-upload the image ? i dont know if its just me but i cant see your image.

Regards.

Badr.

Avatar

Employee Advisor

Not just you Badr, I can't see the image either.

Avatar

Level 4

thumbnail_image.png

Sorry for the isuue.

re-adding image

Avatar

Correct answer by
Employee Advisor

Thank you for adding the screenshot.  From the error it looks like you have a custom tracking table schema called "HC3TrackingLogrc2".

The error is basically stating that there is no index on the sourceID field.  If this is a primary or foreign key then it should have an index.  I would recommend having whoever created this table add an index to this field.

Regards,

Craig