Home > DPM > DPM 2012 Rollup Update 3 Failed to execute SQL string

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 🙂

Advertisements
Categories: DPM Tags: ,
  1. mark
    December 30, 2012 at 12:31 pm

    Amazing..I was facing this problem, Thank you

  2. RoryD
    January 21, 2013 at 6:37 pm

    You beauty! I was pulling what’s left of my hair out until I found this!

    Thanks

  3. Son
    February 18, 2013 at 5:38 pm

    Quality posts is the key to be a focus for the visitors to go to see the
    web site, that’s what this website is providing.

  4. April 11, 2013 at 2:54 pm

    Thanks for this, solved my problem and helped me get it installed. Still kind of curious what caused the problem I suppose or why it wasn’t more widespread?

  5. Kingsley
    July 12, 2013 at 4:47 am

    Thank you very much

  6. Blu Bro
    August 23, 2013 at 12:10 pm

    TANKS!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: