on 10-29-2009 2:44 PM
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)
After Oracle Upgrade ; is the transport system up and running ; I mean is it working fine ?
Also check SAPCONN role ;
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you perform all the required post-upgrade steps?
A quick guess: sapconn_role.sql, SAP note 834917.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.