Exception CX_SDB_ORA_PROGRAM_ERROR occurred when activating Request in DSO

[Former Member]

I have created a DSO for which data has to be loaded from 0mat_plant_attr datasource  . DTP is executed successfully. When I activate the request

, it is giving  error as follows

The exception 'CX_SDB_ORA_PROGRAM_ERROR' was raised, but it was not caught
  anywhere along
the call hierarchy.

Since exceptions represent error situations and this error was not
adequately responded to, the running ABAP program
  'CL_SDB_ORA_UPDATE_STATS=======CP' has to be terminated.

Can anyone give solution ?

Regard

Jayaanand

[MGrob · Accepted solution]

Hi

You might want to check Note 1417124.

Why are you loading 0mat_plant_attr to DSO instead of 0MAT_PLANT?

Martin

[Former Member · Accepted solution]

I have informed basis team about this issue.

I have also told them to apply the notes 1417124 and 963760 , I will get back once issue is solved

[former_member182470 · Accepted solution]

I am confident that the first note which i gave you will resolve the issue for sure..

[Former Member · Accepted solution]

thanks for all,

issue is resolved by our basis team. They said authorisation for SID table was provided.

Thanks for all

[Former Member · Accepted solution]

Sorry , but what do you mean for ".....authorization for SID table...."?

Could you provide the instuctions to do this?

Thanks.

[RamanKorrapati]

Hi,

Try to use settings Tx -  RSODSO_SETTINGS for dso activation and try.

even though not solved try the mentioned oss note by Suman..

Mean while check with DB Team.

Thanks

[former_member182470]

1417124 - You can implement this Note

963760- Oracle databse

930712

CX_SY_OPEN_SQL_DB exception when you execute DTPs