Forum Discussion
Solved
Datamart not refreshing
I'm getting the following error when I try to refesh my DataMart. "Error: undefinedErrorMessage=The current operation was canceled because one or more operations failed..HttpStatusCode=0." Does ...
We found the problem. One of the data sources had a field with a marked key on. We changed the format of this field from text to number, and this seems to have caused the problem.
It would have been really helpful if the error messages had told us this, as when we went to refresh the data source, there was no indication that this was what was causing the whole Datamart not to run.
I added the suggestion as you recommended and have fed this back
The error was caused by faulty data in one of the sheets sourced from Smartsheets. It took some time to identify the problematic table, but eventually, I pinpointed the specific column causing the issue. I resolved it by changing the column's data type to "any."