Unsolved
This post is more than 5 years old
1 Message
0
8752
OME 1.3 Retarget Database from SQL 2012 to SQL 2014 Cluster
I have an existing OME 1.3 install attached to a remote SQL 2012 database. Backing up and restoring the database wasn't working because of permissions on the Cluster Shared Storage, so I have been using SQL Server Import Export Wizard. The wizzard completes, I shutdown the old server, restart OME, get the new DB credentials window, fill in the correct information, but when it starts up, I get the following logs in the browser. Does anyone know what I need to do to fix this?
| Severity | Start Time | Source | Description |
| Critical | 8/7/2014 5:06:43 PM | DataCache.LoadCheck() | Data Cache load error |
| Critical | 8/7/2014 5:06:43 PM | DataCache.LoadCheck() | Data Cache load error |
| Warning | 8/7/2014 5:06:43 PM | ProxyManager.FaultTolerate() | Fault tolerance on communication exception in progress -> Count: 1 |
| Critical | 8/7/2014 5:06:43 PM | DataCache.LoadCheck() | Exception loading the cache occurred: System.ServiceModel.FaultException: Message Could not find stored procedure 'dbo.SecureUser_GetPermissions'. #2812.62 Details System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbo.SecureUser_GetPermissions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) at DataProvider.Security.SecureDataContext.SecureUser_GetPermissions(Nullable`1 idSecureUser) at DataProvider.Security.SecureUser.LoadPermissions(SecureDataContext secureDataContext) at DataProvider.Security.SecureUser.GetActiveUser(SecureDataContext dataContext, String userSid) at DataProvider.Security.SecureUser.GetActive(WindowsIdentity activeIdentity) at DataProvider.Security.SecureUser.GetActive() at SmartConsole.Service.DataService.AccessCheck(Permission[] requiredPermissions) ClientConnectionId:2c48e527-f6d9-4d17-b161-f501eba4140c SqlException.Number 2812 SqlException.State 62 Id SqlException;2812;62 at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result) at System.ServiceModel.ClientBase`1.ChannelBase`1.EndInvoke(String methodName, Object[] args, IAsyncResult result) at SmartConsole.DataServiceReference.DataServiceClient.DataServiceClientChannel.EndGetHelp(IAsyncResult result) at SmartConsole.DataServiceReference.DataServiceClient.SmartConsole.DataServiceReference.IDataService.EndGetHelp(IAsyncResult result) at SmartConsole.DataServiceReference.DataServiceClient.OnEndGetHelp(IAsyncResult result) at System.ServiceModel.ClientBase`1.OnAsyncCallCompleted(IAsyncResult result) |
| Critical | 8/7/2014 5:06:43 PM | DataCache.LoadCheck() | Data Cache load error: SmartConsole.DataServiceReference.GetHelpCompletedEventArgs |
| General Information | 8/7/2014 5:06:43 PM | App.xaml | DataCache load starting... |
| General Information | 8/7/2014 5:06:42 PM | App.xaml | Splash screen instantiated... |
| General Information | 8/7/2014 5:06:42 PM | App.xaml | Application_Startup: Starting... |
DELL-Rob C
2.8K Posts
0
August 8th, 2014 07:00
Hi Anthony,
SQL Server import / export wizard probably won't be sufficient in this case.
The database copy you made doesn't look clean:
“Could not find stored procedure 'dbo.SecureUser_GetPermissions'”
Thanks,
Rob
www.delltechcenter.com/ome