ERROR - 1021001 Failed to Establish Connection with SQL Database Server

ERROR - 1021001 Failed to Establish Connection with SQL Database Server. See Log file for more information. Couple things could be happening here:

- You do not have permissions to access that SQL environment

- The ODBC Connection on the server is not set up properly.

- The table/view that you are calling no longer exists

Error '1,030,006' opening the outline.

EAS - Error '1,030,006' opening the outline.

Essbase Administration Services has become corrupt. Can occur when peforming a dim build that did not build successfully. I do not know the full cause of it, but restarting the EAS Server will rectify this issue.

ASO Model - Solve Order

When you member of a formula is dependant on another member, ensure the solve order is setup properly, making the first member have a solve order of 0, then the next to have 1, etc.

ERROR 1012703

"Unknown calculation type [0] during the dynamic calculation. Only default agg/formula/time balance operations are handled."

There is an error in a formula(s), therefore, no calculations will work. The problem is that when you have the outline open in Edit mode and you try to 'Validate', it does not identify any of these errors, nor does it write it to a log. However, you can go one by one and validate each formula. So any time you delete a member or modify a member name, be sure that this member is not included in any formula.