Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Activation of records in Datastore objects - Giving error

Hi team,

I have one std infopackage and i am trying to load the data into 2 datastore objects,

i.e. in infopackage --> Data Targets --> Select Data Targets --> i select 2 data store objects,

My update rule is Initil Delta Process --> With Data transfer,

When i start load the data gets loaded in PSA and can be seen via maintain PSA option,

however my processing gets stuck at one particular point where it says

"Activation of M records from DataStore object XXX started", and loading goes on for sometime after tht it terminates

When i do se11 and see the table associated with my datastore objects the table is populated,

Now when i activate data in DSO its not geting activated , i did /nst22 and observed the dump,

i received the following in

Error analysis

The occurrence of the exception is closel

a previous exception "CX_SQL_EXCEPTION",

"CL_SQL_STATEMENT==============CP",

specifically in line 31 of the (include)

"CL_SQL_STATEMENT==============CM002".

The cause of the exception was:

ORA-20000: Unable to analyze TABLE "SAPSR3"."/BI0/AAI_DS0140", insufficient

privileges or does not exist#ORA-06512: at "SYS.DBMS_STATS", line

13149#ORA-06512: at "SYS.DBMS_STATS", line 13179#ORA-06512: at line 1

could this be cause of error, or are there any other way to overcome this issue,

kindly assist,

regards

blusky

Former Member
Former Member replied

Hi,

Once chk in RSRV for tht ODS for any inconsistency.... if any errors repair it...then try to reactivate the ODS again...

Before to that once chk with basis team they'll fix these dumps easily...

--

rgds,

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question