We deleted a field in Salesforce, which used to be captured in one of our QS datasets. Our scheduled refresh on that Dataset is throwing the following error:
“[Simba]JSQLEngine The column “Amount_Check_Validation__c” could not be found.”
I checked the fields list in the Dataset and it’s not appearing there, so I’m not sure why it’s throwing this error.
The field is still showing in the dataset field list when in an Analysis, so I’m not sure if this is the issue or how to remove it from there.
Hi @SPCorpTechOps,
Normally when a dataset that’s being utilized in an analysis gets altered, it will affect that analysis as it no longer has the information within it that was once required. If you’re receiving that error, it’s most likely because that field was being utilized somewhere.
Were any of your visuals or calculated fields utilizing that deleted field?
When encountering this issue in the past, I had to recreate the visuals that had gotten affected as there’s no way to go in and remove or fix unfortunately.