Database error 1039 at XPL

[Former Member]

Hi All,

I am seeing follwoing error in system log.

02:30:17 DIA 06 400 BY2 Database error 1039 at XPL

ORA-01039: insufficient privileges on underlying objects of

and in the user field it shows my user ID ( while I am not there logged into the system at 2.30 am ( i.e. in the morning )

Also it is showing the Dialog mode that means this problem is not occuring for any job scheduled by me in background.

Can anybody please tell me why am I getting this error. in what circumstances do we get such error. has anybody faced such error message before?

From a bit search I found description of this error as follows.

<b>ORA-01039</b> insufficient privileges on underlying objects of the view

<b>Cause:</b> An attempt was made to explain plan on other people's view without

the necessary privileges on the underlying objects of the view.

<b>Action:</b> Get necessary privileges or do not perform the offending operation.

But I can't link it in my case...

Thanks.

--Shamish

Message was edited by:

Shamish Lele

[Former Member · Accepted solution]

Hi

An attempt was made to explain plan on other people's view without

the necessary privileges on the underlying objects of the view.

This means in this activity it is trying to access view in which there may be certain objects/tables which does not belong to this user. So because of this the user is not able to access the view as it is not having sufficient privileges as in the error. So you need to find out the objects which are there in the view so that those objects access can be given to the current user.

It is merely a problem with the permissions on the objects being accessed. Try to give the authorization to the current user u r using as the objects belong to a different schema/user. For accessing objects of other schema you need to have rights for that. When trying to Explain Plan for a object in a view its falling short of permissions.

Regards

Sumit Jain

[reward with points if the answer is useful]

[Former Member · Accepted solution]

HI Sumit,

thanks for reply.

But I don't understand what activity am I doing and that too in dialog mode!!

Because this error says that I am doing some activity at 2.30 in the morning ... But fact is I am not logged into the system at all at this time. ( Also nobody else is using my ID )

Then why this error am I getting?

Also what do you mean by accessing objects of other schema?

And whose permission should I change ? for which object?

Are you talking about ora<SID> or <SID>adm or something else.

Also how should I find what kind of activity it is tryong to run ( and that too with my SAP login ID ) ?

I hope I am explaining my querry clearly..

Thanks.

--Shamish

[Former Member · Accepted solution]

Hi Shamish,

From SM37 find a batch job running at 2:30h. Then search into it for a step executed by your user.

Best Regards,

JC Llanes.

[Former Member · Accepted solution]

Hi Juan,

Following job was running at the particular time.

ASM_Z000000064_COLL_TRANS And it was executed successfully.

It had following steps.

1 BDLCOLL ABAP &0000000000067

2 BDLSEND ABAP &0000000000067

But I don't think this would have cased this problem. The reason behind this is that; in SM21 log it shows the type as <b>DIA</b> and not BTC.

Still I will appreciate your comment on my assumption.

What do you think?

--Shamish

[Former Member · Accepted solution]

Hello,

A job working in background can launch dialog processes.

The name of the job seems related with the issue...

Have you seen the user who launch these steps?

Regards,

JC Llanes.

[Former Member · Accepted solution]

Oh.. If background process triggers dialog processes.. then it is a new information for me.

Yes, I checked the user name. it is the same that is my login ID.

But in SM 37 it shows that it was completed successfully. Then why did it threw error message in system log?

--Shamish

[Former Member · Accepted solution]

Hello all,

May I have your opinion on this?

--Shamish

[Former Member · Accepted solution]

Hi Shamish,

I've found Note 313412. It talks about this issue.

You can ignore this warning, or else you can search for the DB tables belonging to a user who's not SAPR3, and change the access permissions...

Best Regards,

JC Llanes.

[fidel_vales · Accepted solution]

Hi,

Take a look also to note 640553

But the warning can be ignored as indicated by Juan Carlos

[Former Member · Accepted solution]

Thanks Juan.

Fidel,

The note you mentioned does not exist.

--Shamish

[fidel_vales · Accepted solution]

Hi,

The note is being modified.

I hope will be released soon.

[Former Member]

Hi,

For ora1039 Please refer note 640553, which says about the ora error's

further regarding the ora authorization please check the note 700548.

Hope this will help you in resoving issue.. if any thing revert back.

Thanks & Regards,

Balaji.S

[Former Member]

Sorry it was by mistake i replied to this message.!!!!

I was supposed to reply to other message Sorry!!!

--

Balaji.S

[Former Member]

hi,

i think that is the problem of ur user authorisations(rights).

regards

ajai