Skip to Content
author's profile photo Former Member
Former Member

Error while activating data loaded into DataStore Object in BI 7.0

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...

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2007 at 08:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2007 at 09:21 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2007 at 06:42 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.