Troubleshooting

Fix for Overflow of Data Type

Symptom Deployment fails at Process step.  The message indicates there is an overflow of the data type, see below. Internal error: The operation terminated unsuccessfully. Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0. Errors in the OLAP storage … Read More

Fix for Violation of Primary Key Constraint Error

Symptom When user posts in Apps, an error message pops out stating violation of primary key constraint. Resolution This issue is related to a bug with SQL Server. The details can be read here. FIX: Sequence object generates duplicate sequence values when SQL Server 2012 or SQL Server 2014 … Read More

Why My APPS Are Disappeared?

Symptom In APPS page, the app that was once available disappeared all of a sudden. Resolution Your workflow may be expired. Please check the workflow status in ADMINISTRATOR. The icon of expired workflow turns gray in the right navigation section. To activate the workflow, you can simply modify the … Read More

Cannot Find Application When Attaching

Symptom When trying to attach applications, this window doesn’t return any database from SQL Server. Resolution Please first verify that you are pointing to the right SQL server. It is suggested using server name or IP address instead of localhost. If you confirmed you are referring to the right … Read More

Errors in the Metadata Manager in Apps

Symptom In apps, users encounter an error message reporting that an error occurred when loading database role from file. Resolution The error is coming from Analysis Services. SSAS depends on the file system and for some reason, the files appear to be getting corrupted on a regular basis. Please … Read More