cancel
Showing results for 
Search instead for 
Did you mean: 

Error while activating data loaded into DataStore Object in BI 7.0

Former Member
0 Kudos

Hi Guys,

I am facing the following problem :

When I load data into a Datastore Object, all the records get loaded but the job fails during activation of the data.

Below is the job log :

Activation is running: Data target 0RPM_DS07, from 77 to 77

Overlapping check with archived data areas for InfoProvider 0RPM_DS07

Check not necessary, as no data has been archived for 0RPM_DS07

Data to be activated successfully checked against archiving objects

SQL-END: 14.06.2007 12:33:25 00:00:00

SQL Error: ORA-20000: Insufficient privileges

Parallel processes (for Activation); 000003

Timeout for parallel process (for Activation): 000300

Package size (for Activation): 020000

Task handling (for Activation): Backgr Process

Server group (for Activation): No Server Group Configured

All data fields updated in mode "overwrite"

Resource error. No batch process available. Process terminated

Time limit exceeded. No return of the split processes

Resource error. No batch process available. Process terminated

Request you to kindly help me resolve this issue.

I am runnning the infopackage manually. Should I run it by a process chain??

If I run by process chain, I get the following error in 1st step:

You do not have authorization for InfoSource 0RPM_ITEM_FIN_PLANNING.

Awaiting your replies,

Thanks,

punkuj...

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I think this problem remains unanswered.

The issue behind this problem is, during parellel activation the child jobs acknowledge the parent job about status. If the child job takes long time to read data from active data table, then it times out and fails.

Check the primary index on Active data table and it should be missing in your case. See the se11 index or db02 missing indexes. That is the reason that causes time out. Rebuild the primary index by asking your basis folks and repeat the activation. It should succeed.

Thanks,

Sri.

Former Member
0 Kudos

Hi,

It seems to be issue with Database system specifically memory part, Seek basis guy and he/she should be able to resolve .

Also refer to link

http://www.dba-oracle.com/t_ora_120000_insufficient_privileges.htm

Hope that helps.

Regards

Mr Kapadia

Assigning points is the way to say thanks in SDN.

Former Member
0 Kudos

Hi,

it looks like you don't have the authority you need for scheduling jobs. Ask your basis team to get these authorities.

regards

Siggi

Former Member
0 Kudos

Hello,

I am facing problems only for the DSO activation job.

All other jobs are running successfullly.

Thanks,

Punkuj