Job Collection Error - Column `` does not exist on facts table

[alaher1]

Hello,

We have encountered the following error - Column `` does not exist on facts table. 

This error occurs during the job collection of both daily and historical indicators. Please find attached details about the error (sequence 2).

Could you please help with this issue?


Thank you,

Aarif

[qprinsloo]

I'm running into the same issue. @alaher1 did you happen to find the solution?

[qprinsloo · Accepted solution]

Found the issue, this error occurs when the "field"  on the indicator source is empty.

 

[GlideFather]

Hi,

I would like to thank you for this! Today I was re-creating a Dashboard and Performance Analytics Indicator and Indicator Sources (too many Inserts and Stays into a custom scope) and the "Field" field was not properly populated by that UI Action! When the Job was collecting data it threw that bloody error, which I happened to fix easily with your help.

So you saved me long time investigating and debugging and as it was quite urgent this has helped me a lot.

Thank you so much and have a wonderful day,
Kamil

[qprinsloo]

Glad it helped. I'm surprised it is not a required field.