DSO data Activation Time out-DATABASE ERROR-440

[Former Member]

Hello all,

We are getting  error in one of our standard DSO during activation -Error-Process 000001 did not confirm within the permitted time period,we repeated process chain ,we got the same error,we activated manually -we got the same error, I need to mention that we only have 3278 records which should not take more than few seconds-minutes to activate. we reset RSODSO_SETTINGS wait time by increasing still did do it , we changed data package 10,000 ,50,000 but it didn't correct the error, we even change DSO  SID generation setting during activation to never create SID ,it didn't correct the error, we reactivated DSO,we indexed the table both new and active table but we are getting the same error, in a SM21 we are getting error DATABASE ERROR -440  [IBM][CLI Driver][DB2] NO AUTHORIZED PROCEDURE NAMED > DSO_VERSION HAVING COMPATIBLE ARGUMENTS WAS FOUND... DBA reorg and did some other things but we are still getting the same error and the are not sure what the procedure DSO_VERSION is ,Any body have any idea what that procedure is and why we are getting that in sm21 during one DSO data activation?  Has anybody had this kind of experience before? by the way we have researched on google SCN and nothing close to our scenario. By the way we ran the activation with the different settings both in dialog and background.We also got error  Background process BCTL_4Z81MSY8311QNTKRYGRDYVFXY terminated due to missing confirmation ...Any suggestions will be of great help and points will be awarded....

Thank you.

[RamanKorrapati]

Hi,

Guessing some inconsistencies are exist on your dso tables.

Please try to do RSRV tests on DSO tables(new,active and changelog)

if there is no reporting on dso, please delete the indexes.

Other than present request how many requests(activated) are exist at DSO? is this new dso or old dso?

Mean while please check DB team.

Thanks

[Former Member]

Thank you Ramanjaneyulu for your reply. I have RSRV the DSO and status was successful.,We have 110 requests activated..DSO is not too old It was created sometime this year in May or so. DBA have worked on it and we are still getting the same error. And the do not understand what procedure DSO_VERSION is....

Any other suggestions please.....

[RamanKorrapati]

Hi Grace,

Can you provide exact error message. if possible share error screen shot.

Mean while can you look at SAP Note 1919101.

Thanks

[Former Member]

Error in Sm21-

04:57:20 BTC  036 810 PRGRAU0                   BY  2 Database error -440 at EXE

04:57:20 BTC  036 810 PRGRAU0                   BY  0 > [IBM][CLI Driver][DB2] NO AUTHORIZED PROCEDURE NAME

04:57:20 BTC  036 810 PRGRAU0                   BY  0 > DSO_VERSION HAVING COMPATIBLE ARGUMENTS WAS FOUND

04:57:20 BTC  036 810 PRGRAU0                   BY  1 Database error -440

Background process BCTL_4Z9BTOI3XPN2XB0VL9IUZ08ZA terminated due to missing
confirmation

Message no. RSODSO_PROCESSING041

Diagnosis

The confirmation from the background process BCTL_4Z9BTOI3XPN2XB0VL9IUZ08ZA
did not occur within the set time. It was thus ended by the system.

System Response

Background process: BCTL_4Z9BTOI3XPN2XB0VL9IUZ08ZA

Number: 1

Procedure

Check the package size for the application to be processed or change the
package size.

[RamanKorrapati]

Please go thru this note.

Note 1118205 - RSODSO_SETTINGS Maintain runtime parameter of DataStore obj.

[Former Member]

I have looked at that note

1919101

Is not completely the same with the symptoms in that note. The error am having does not completely activate it times out

[Former Member]

I have gone through note 1118205
I have maintained RSODSO_SETTINGS but It won't correct the error it kee timing out and I have ran it on Dialog still no correction

[RamanKorrapati]

at RSODSO_SETTINGS, Wait time how much you increased from 600.

600 to 3600? if not then try to increase to 3600 and try to activate dso request.

[Former Member]

Ramanjaneyulu, I have increase to that but It didn't correct my error.