cancel
Showing results for 
Search instead for 
Did you mean: 

Error updating SPAM

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member264034
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Aidan,

I have just done this, and SPAM finished without problems. The probleme was that sapconn script hadn't been executed.

Regards.