DPM 2012 Rollup Update 3 Failed to execute SQL string

We faced that during our Private cloud update to SC 2012 SP1

trying to install Rollup Update 3 to DPM 2012 server we got this error

MSI (s) (28!F4) [16:08:33:788]: Note: 1: 2262 2: Error 3: -2147287038
ExecuteSqlStrings:  Error 0x80040e2f: failed to execute SQL string, error: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting
(PropertyName, PropertyValue)
values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ’1′)
MSI (s) (28!F4) [16:08:33:788]: Transforming table Error.

MSI (s) (28!F4) [16:08:33:788]: Transforming table Error.

MSI (s) (28!F4) [16:08:33:788]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (28!F4) [16:08:33:788]: Product: Microsoft System Center 2012 – Data Protection Manager — Error 26204. Error -2147217873: failed to execute SQL string, error detail: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting
(PropertyName, PropertyValue)
values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ’1′)

 

it seem that the update running a script which need to insert a property in a database table as this error state

ExecuteSqlStrings:  Error 0x80040e2f: failed to execute SQL string, error: The statement has been terminated., SQL key: sqlscript_KB2751230Fix.sql SQL string: insert into tbl_DLS_GlobalSetting

(PropertyName, PropertyValue) values (‘ConsiderOfflineMediaToCheckOffsiteReady’, ’1′)

so we try to run a query on the Database to check this property value and found that its already exist with same value which prevent the update from continue updating the DB

Select * from tbl_DLS_GlobalSetting where PropertyName = ‘ConsiderOfflineMediaToCheckOffsiteReady’

so we backed up the database and delete this RAW from the effected table:

Delete from tbl_DLS_GlobalSetting where PropertyName = ‘ConsiderOfflineMediaToCheckOffsiteReady’

then the update went successfully

About these ads