Dynamics Community Forum Thread Details

Analysis Cubes Configuration Error

We are on GP 2010 R2 and have Dynamics GP Analysis Cubes installed. I have installed the cubes service pack update.

I am trying to add another company to the Cubes. All other companies process ok, but near the end of the configuration I am getting this error...

Ideas?

***Fatal Error Encountered***
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Column name or number of supplied values does not match table definition.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
   at Microsoft.Dynamics.GP.AnalysisCubes.CubesDB.UpdateInstalledCubes()
   at Microsoft.Dynamics.GP.AnalysisCubes.CubesDB.UpdateCubes()
   at Microsoft.Dynamics.GP.AnalysisCubes.CubesDB.CreateDB()
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.CreateOLAPCubes()
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.InstallAnalysisCubesProduct()