DB Upgrade Failed. Error Executing SQL statement
I'm trying to sort out my post SP4 install that went tits up and am getting
"DB Upgrade Failed. Error Executing SQL statement" Looking at the Tech Support it mentione a cause of this could be that the MDSS and MDSS_Dis databases already exist If i delete these dB's what will happen to the other servers that are already using MDS? |
Look up the db_install logs and post the last 10 lines from the logs.
This error can be caused due to various different reasons. |
We don't use MDSS but I've seen that error. The account you are using may not have enough permission run the sp. I usually bump the account up to System Administrators when I do a SP or upgrade.
|
To install MDS Services and create the MDSS database you need to be using a SA account and need to have mix mode auth enabled on BES
However I am still interested to know what does th db_install logs say.. |
Yes yes yes, post the loggies :) !
|
Not sure which is the db_install log but:
Code:
[30000] (08/16 16:20:27.875):{0x398} Processing file 4.1\UpgradeV20060502.sql |
Do these logs mean anything to anyone????
|
Are you using MDS Services?
The upgrade that you just did, what version was it from? It looks like the database was partially upgraded / changed and then attempted again; hence the duplicate key in FEATURE_VERSION. |
From 4.1.3 to 4.1.4, if i delete the MDSS and start again, what will happen?
|
Are you using MDS Services for anything?
If you're not sure, then I'd say no, and would remove it! How to remove BlackBerry MDS Services, BlackBerry MDS Connection Service or instant messaging service Also check out BlackBerry MDS Services components do not appear in BlackBerry Manager You could remove it and then reinstall; but if you're not using it, why reinstall? |
We use the BlackBerry browser to access our intranet.
|
ah you're good. You're using MDS but not the MDS Services database; you can remove the MDSS stuff safely.
|
Decisions, decisions!
Should I randomly start deleting things from the SQL dB 20mins before hometime or wait until the morning? |
I would schedule it during a change window myself :)
update that sig, you're at 4.1.4 now, BE PROUD !!!! |
Its my server I'll take it down when I want!
|
I'm too poor to own servers; I just let other people buy them for me and I manage em.
|
I have this problem too. I try to run the table.sql script in sql analyzer on the sqlserver, but i see a very lot of error in that. I repair some error (small and big characters...)
But I Don't know what can I do whit this: Code:
Server: Msg 1776, Level 16, State 1, Line 8 Any idea? Thanking in advance. |
I'm am getting a different error...can anyone help?? my logs are below....
[30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: /************************************************** ************************** SchedulePurgeJobs.sql This SQL script will create the jobs that will remove old data Procedure List: (C) 1997-2004 Research In Motion Limited. ************************************************** **************************/ /* Note - There is no easy of determining if these jobs exists unless one is a member of sysadm (as queries would be needed against msdb tables and public doesn't have access). Thus, the installer program running this script will suppress errors that get reported when the job already exists. */ USE msdb [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Changed database context to 'msdb'. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeHistory - delete rows from ServerConfigHistory table *+--------------------------------------------------------------------------*/ exec sp_add_job 'RIMPurgeHistoryBESMgmt', @description = 'Remove old data from history table' [20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeHistoryBESMgmt') already exists. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: exec sp_add_jobstep @job_name = 'RIMPurgeHistoryBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec RemoveOldHistoryRows 60' -- 60 day retention [20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: exec sp_add_jobschedule @job_name = 'RIMPurgeHistoryBESMgmt', @name = 'RIMPurgeHistory', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 10000 -- 1:00 am [20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeHistory') already exists. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: exec sp_add_jobserver @job_name = 'RIMPurgeHistoryBESMgmt' [20000] (09/27 07:54:44.014):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeHistoryBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeDeletedUsers - delete rows from DeletedUserConfig * no longer used *+--------------------------------------------------------------------------*/ exec sp_delete_job @job_name = 'RIMPurgeDeletedUsersBESMgmt' [30000] (09/27 07:54:44.014):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @job_name ('RIMPurgeDeletedUsersBESMgmt') does not exist. [30000] (09/27 07:54:44.014):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.014):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeWorkQueue - delete rows from WorkQueue *+--------------------------------------------------------------------------*/ exec sp_add_job 'RIMPurgeWorkQueueBESMgmt', @description = 'Remove old work queue entries' [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeWorkQueueBESMgmt') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: exec sp_add_jobstep @job_name = 'RIMPurgeWorkQueueBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec RemoveOldWorkQueue 15' -- 15 day retention [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: exec sp_add_jobschedule @job_name = 'RIMPurgeWorkQueueBESMgmt', @name = 'RIMPurgeWorkQueue', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 20000 -- 2:00 am [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeWorkQueue') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: exec sp_add_jobserver @job_name = 'RIMPurgeWorkQueueBESMgmt' [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeWorkQueueBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMCheckFor2GB - warn if we're on MSDE and are approaching MSDE 2GB limit *+--------------------------------------------------------------------------*/ declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_job 'RIMCheckFor2GBBESMgmt', @description = 'Check to see if approaching MSDE 2 GB limit' end [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMCheckFor2GBBESMgmt') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobstep @job_name = 'RIMCheckFor2GBBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec CheckFor2GB 1500' -- 1500MB threshold end [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobschedule @job_name = 'RIMCheckFor2GBBESMgmt', @name = 'RIMCheckFor2GB', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 50000 -- 5:00 am end [20000] (09/27 07:54:44.030):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.030):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMCheckFor2GB') already exists. [30000] (09/27 07:54:44.030):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.030):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobserver @job_name = 'RIMCheckFor2GBBESMgmt' end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMCheckFor2GBBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMIndexDefrag - defrag the indexes *+--------------------------------------------------------------------------*/ declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_job 'RIMIndexDefragBESMgmt', @description = 'Index defrag' end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMIndexDefragBESMgmt') already exists. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobstep @job_name = 'RIMIndexDefragBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec IndexDefrag 10' -- % threshold to defrag end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobschedule @job_name = 'RIMIndexDefragBESMgmt', @name = 'RIMIndexDefrag', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 30000 -- 3:00 am end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMIndexDefrag') already exists. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobserver @job_name = 'RIMIndexDefragBESMgmt' end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMIndexDefragBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMShrinkDb - reduce space used *+--------------------------------------------------------------------------*/ declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_job 'RIMShrinkDbBESMgmt', @description = 'DBCC ShrinkDb' end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMShrinkDbBESMgmt') already exists. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobstep @job_name = 'RIMShrinkDbBESMgmt', @step_id = 1, @step_name = 'Shrink', @database_name = 'BESMgmt', @command = 'DBCC SHRINKDATABASE (BESMgmt, 10, NOTRUNCATE)' end [20000] (09/27 07:54:44.045):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.045):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('Shrink') already exists. [30000] (09/27 07:54:44.045):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.045):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobstep @job_name = 'RIMShrinkDbBESMgmt', @step_id = 2, @step_name = 'UpdateSize', @database_name = 'BESMgmt', @command = 'dbcc updateusage (BESMgmt)' end [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('UpdateSize') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobschedule @job_name = 'RIMShrinkDbBESMgmt', @name = 'RIMShrinkDb', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 40000 -- 4:00 am end [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMShrinkDb') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: declare @edition varchar(128) set @edition = cast(serverproperty('Edition') as varchar(128)) if @edition = 'Desktop Engine' begin exec sp_add_jobserver @job_name = 'RIMShrinkDbBESMgmt' end [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMShrinkDbBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeMDSMsg - delete rows from MDSPushMessages *+--------------------------------------------------------------------------*/ exec sp_add_job 'RIMPurgeMDSMsgBESMgmt', @description = 'Remove old data from push messages table' [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSMsgBESMgmt') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: exec sp_add_jobstep @job_name = 'RIMPurgeMDSMsgBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec RemoveMDSPushMsgs' [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: exec sp_add_jobschedule @job_name = 'RIMPurgeMDSMsgBESMgmt', @name = 'RIMPurgeMDSMsg', @freq_type = 4, -- daily @freq_interval = 1, -- every day @active_start_time = 33300 -- 3:33 am [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSMsg') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: exec sp_add_jobserver @job_name = 'RIMPurgeMDSMsgBESMgmt' [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeMDSMsgBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeMDSStats - delete rows from MDSPushMessages *+--------------------------------------------------------------------------*/ exec sp_add_job 'RIMPurgeMDSStatsBESMgmt', @description = 'Remove old data from stats table' [20000] (09/27 07:54:44.061):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.061):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSStatsBESMgmt') already exists. [30000] (09/27 07:54:44.061):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.061):{0x1D24} SQL being executed: exec sp_add_jobstep @job_name = 'RIMPurgeMDSStatsBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec RemoveOldMDSStats' [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_jobschedule @job_name = 'RIMPurgeMDSStatsBESMgmt', @name = 'RIMPurgeMDSStats', @freq_type = 4, -- daily @freq_interval = 1, -- every day @active_start_time = 22200 -- 2:22 am [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeMDSStats') already exists. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_jobserver @job_name = 'RIMPurgeMDSStatsBESMgmt' [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Job 'RIMPurgeMDSStatsBESMgmt' is already targeted at server 'EXPCAP-BES'. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: /*+--------------------------------------------------------------------------- * RIMPurgeOTASL - delete rows from DSUPRequest *+--------------------------------------------------------------------------*/ use msdb [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: Changed database context to 'msdb'. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_job 'RIMPurgeOTASLBESMgmt', @description = 'Remove old data from stats table' [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeOTASLBESMgmt') already exists. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_jobstep @job_name = 'RIMPurgeOTASLBESMgmt', @step_id = 1, @step_name = 'DoIt', @database_name = 'BESMgmt', @command = 'exec RemoveOldOTASL 31' [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @step_name ('DoIt') already exists. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_jobschedule @job_name = 'RIMPurgeOTASLBESMgmt', @name = 'RIMPurgeOTASL', @freq_type = 8, -- weekly @freq_interval = 1, -- Sunday @freq_recurrence_factor = 1, -- every week @active_start_time = 14400 -- 1:44 am [20000] (09/27 07:54:44.076):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [30000] (09/27 07:54:44.076):{0x1D24} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect: The specified @name ('RIMPurgeOTASL') already exists. [30000] (09/27 07:54:44.076):{0x1D24} SQL executed successfully [30000] (09/27 07:54:44.076):{0x1D24} SQL being executed: exec sp_add_jobserver @job_name = 'RIMPurgeOTASLBESMgmt' [20000] (09/27 07:54:44.264):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [20000] (09/27 07:54:44.264):{0x1D24} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 0 Message: Cannot load the DLL xpstar.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). |
|
All times are GMT -5. The time now is 09:50 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.