cancel
Showing results for 
Search instead for 
Did you mean: 

1031-ORA-01031: insufficient privileges error in Support package Upgrade

Former Member
0 Kudos

After the Oracle Upgrade from 9.2.0.8 to 10.2 , unable to upgrade the support package.Error are listed below.Kindly help.

- Error in phase: IMPORT_PROPER

- Reason for error: TP_STEP_FAILURE

- Return code: 0008

- Error message: OCS Package ALL , tp step "6", return code 0008

Notes on phase IMPORT_PROPER

In this phase repository objects and table entries are imported. This

phase can terminate due to the following reasons:

o TP_INTERFACE_FAILURE: The tp interface could not be called.

o TP_FAILURE: The program tp could not be executed. For more

information on this, see the SLOG or ALOG log file.

o TP_STEP_FAILURE: A tp step could not be executed. To find the cause

of the error, see the appropriate log, such as the import log.

If the cancelation message contains a tp step 6, N or S, the step in

question is independent of the transport request. You can find these

logs under the node Import steps not specific to transport request

in the log overview.

Alternatively, you can find these logs in the following files in the

log directory of your transport directory (usually:

/usr/sap/trans/log):

- tp Step 6: P<YY><MM><DD>.<SID>

- tp Step N: N<YY><MM><DD>.<SID>

- tp Step S: DS<YY><MM><DD>.<SID>

You can display these files using the report RSPUTPRT or by calling

transaction AL11.

When checked the logs in STMS , we are getting

SQL error 942 occurred at location CWBCMDEV (object ) - IGNORED

SQL error - IGNORED occurred at location (object ) - IGNORED

14:24:12: Retcode 1: error in DDL statement for CWBCMDEV - repeat

Error 1031-ORA-01031: insufficient privileges when executing ADD-FIELD of

Error in DDL statement for when executing ADD-FIELD of

(dummy, do not translate)

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

After Oracle Upgrade ; is the transport system up and running ; I mean is it working fine ?

Also check SAPCONN role ;

Rishi

Former Member
0 Kudos

Did you perform all the required post-upgrade steps?

A quick guess: sapconn_role.sql, SAP note 834917.