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()
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156