Error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available" in EXO Analytics

When using tabs with widgets in Exo Analytics, the error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available" can occur.

This error is caused by spaces in the SQL query that runs to refresh widgets with pivot functions, such as this Cumulative Sales Vs Cumulative Budget widget.

To fix this error, delete the spaces in the SQL query.

Delete spaces in the pivot widget SQL query

1. Refresh the pivot widget until you see the error.
2. Go to ExoConfig > Staff > Setup Widgets.
3. Search for the widget by name.
4. In the SQL field, delete any spaces from the query.
5. Click Save.