on 12-15-2009 2:34 PM
Hi,
Updating SPAM to patch SAPKD64036 I get the error message:
Retcode 1: error in DDL statement for VE071LOCKFLAG - repeat
Error 1031-ORA-01031: insufficient privileges when executing ADD-FIELD of
Error VE071LOCKFLAG when executing ADD-FIELD of
(dummy, do not translate)
No DDL commands found for activation of VE071LOCKFLAG
Any idea?
Regards.
Hi,
Please let us know which version of oracle you are running. Assuming it
is 10, please review the following notes :
- 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role
- 985607 - ORA-01031 Creating views after upgrade to Oracle 10g;
It is probable that the database user does not have required privileges.
After executing SAPCONN_ROLE.SQL, restart the SAP system. Otherwise, the
connected WP still will use the old authorizations.
After you try the above, continue the SPAM import again.
Aidan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Aidan,
I have just done this, and SPAM finished without problems. The probleme was that sapconn script hadn't been executed.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.