BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-16-2007, 10:20 AM   #1 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default DB Upgrade Failed. Error Executing SQL statement

Please Login to Remove!

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?
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!


Last edited by SimonMac : 08-16-2007 at 10:21 AM.
Offline  
Old 08-16-2007, 02:05 PM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Jul 2006
Model: 7290
Carrier: Rogers In Canada - Cingular in US
Posts: 127
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Offline  
Old 08-16-2007, 02:44 PM   #3 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

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.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 08-16-2007, 04:11 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Jul 2006
Model: 7290
Carrier: Rogers In Canada - Cingular in US
Posts: 127
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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..
Offline  
Old 08-16-2007, 08:50 PM   #5 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes yes yes, post the loggies !
Offline  
Old 08-20-2007, 03:36 AM   #6 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not sure which is the db_install log but:

Code:
[30000] (08/16 16:20:27.875):{0x398} Processing file 4.1\UpgradeV20060502.sql
[30000] (08/16 16:20:27.875):{0x398} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (08/16 16:20:27.875):{0x398} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060502.sql]
[30000] (08/16 16:20:27.875):{0x398} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060502V070816162026.sql]
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 USE "mdss"
[30000] (08/16 16:20:27.875):{0x398} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss'.
[30000] (08/16 16:20:27.875):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='FEATURE_VERSION')
begin
    CREATE TABLE dbo.FEATURE_VERSION
    (
      NAME varchar(256) NOT NULL,
      MIN_VERSION  varchar(128), 
      MAX_VERSION varchar(128), 
      CURRENT_VERSION varchar(128), 
      DEVICE_ID bigint NOT NULL,
        CONSTRAINT   PK_FEATURE_VER   PRIMARY KEY (NAME,DEVICE_ID)
    );
end
[30000] (08/16 16:20:27.875):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 
if not exists(select name from sysobjects where xtype='F' and name='relationship28')
begin
    ALTER TABLE dbo.FEATURE_VERSION ADD CONSTRAINT relationship28 FOREIGN KEY (
    DEVICE_ID
    )
    REFERENCES DEVICE (
    DEVICE_ID
    );
end
[30000] (08/16 16:20:27.890):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.890):{0x398} SQL being executed:
 
DECLARE @id bigint;
DECLARE tmp_cursor CURSOR FOR SELECT DEVICE_ID FROM DEVICE
OPEN tmp_cursor;
FETCH NEXT FROM tmp_cursor INTO @id;
WHILE @@FETCH_STATUS = 0
begin
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Discovery', '1.1.0', '1.1.0', '1.1.0'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Provisioning', '1.1.0', '1.1.0', '1.1.0'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'System', '1', '1', '1'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Transport', '1', '1', '1'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Security', '1', '1', '1')
[20000] (08/16 16:20:27.890):{0x398} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 23000 Native error: 2627 Message: Violation of PRIMARY KEY constraint 'PK_FEATURE_VER'. Cannot insert duplicate key in object 'FEATURE_VERSION'.
[30000] (08/16 16:20:27.890):{0x398} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  The statement has been terminated.
[30000] (08/16 16:20:34.249):{0x398} [PIPTOOL]: Exiting PIPTool from AGDBDlg.
====== END OF LOG ======
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 08-21-2007, 06:35 AM   #7 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do these logs mean anything to anyone????
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 08-21-2007, 07:03 AM   #8 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Offline  
Old 08-21-2007, 07:57 AM   #9 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

From 4.1.3 to 4.1.4, if i delete the MDSS and start again, what will happen?
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 08-21-2007, 08:10 AM   #10 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Offline  
Old 08-21-2007, 09:47 AM   #11 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We use the BlackBerry browser to access our intranet.
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!


Last edited by SimonMac : 08-21-2007 at 09:48 AM.
Offline  
Old 08-21-2007, 09:55 AM   #12 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

ah you're good. You're using MDS but not the MDS Services database; you can remove the MDSS stuff safely.
Offline  
Old 08-21-2007, 10:13 AM   #13 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Decisions, decisions!

Should I randomly start deleting things from the SQL dB 20mins before hometime or wait until the morning?
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 08-21-2007, 10:24 AM   #14 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would schedule it during a change window myself

update that sig, you're at 4.1.4 now, BE PROUD !!!!
Offline  
Old 08-21-2007, 10:29 AM   #15 (permalink)
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Its my server I'll take it down when I want!
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline  
Old 08-21-2007, 10:44 AM   #16 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm too poor to own servers; I just let other people buy them for me and I manage em.
Offline  
Old 09-18-2007, 04:41 AM   #17 (permalink)
New Member
 
Join Date: Sep 2007
Model: 8100
PIN: N/A
Carrier: IT
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
There are no primary or candidate keys in the referenced table 'ServerConfig' that match the referencing column list in the foreign key 'FK_ServerStats_ServerConfig'.
Server: Msg 1750, Level 16, State 1, Line 8
Could not create constraint. See previous errors.
.......
The db creating is runing away to this error message.
Any idea?

Thanking in advance.
Offline  
Old 09-27-2007, 07:50 AM   #18 (permalink)
New Member
 
Join Date: Sep 2007
Model: 8300
PIN: N/A
Carrier: Cingular
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.).
Offline  
Old 09-27-2007, 08:03 AM   #19 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Database upgrade fails and Cannot load the DLL xpstar.dll error message appears
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.