on 02-26-2014 9:32 PM
Hello,
we are trying to upgrade the SPAM on the PI SAP EHP 1 for SAP
NetWeaver 7.1 this is installed in windows with the DB MSSQL 2012.
the SPAM is in 7.11/0030 int#1 and we try to upgraded to the SPAM/SAINT
Update - Version 7.11/0052 but we are geting this error:
the import was stopped, since an error occurred during the phase
IMPORT_PROPER, which the Support Package Manager is unable to resolve
without your input.
After you have corrected the cause of the error, continue with the
import by choosing Support Package -> Import queue from the initial
screen of the Support Package Manager.
The following details help you to analyze the problem:
- 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
i attach the transport log.
log:
-------------------------------------------------------------
| | Activation of sample nametabs with appended fields |
| | ------------------------------------- |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:07:06: Retcode 1: error in DDL statement for CLNT_CVRS2 - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error CLNT_CVRS2 when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of CLNT_CVRS2 |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:07:18: Retcode 1: error in DDL statement for PAT03_PRE - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PAT03_PRE when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PAT03_PRE |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:07:31: Retcode 1: error in DDL statement for PAT05 - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PAT05 when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PAT05 |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:07:43: Retcode 1: error in DDL statement for PATACP - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATACP when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATACP |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:07:55: Retcode 1: error in DDL statement for PATHISTORY - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATHISTORY when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATHISTORY |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:08:07: Retcode 1: error in DDL statement for PATRTCONF - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATRTCONF when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATRTCONF |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:08:19: Retcode 1: error in DDL statement for PATRTPHASE - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATRTPHASE when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATRTPHASE |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:08:31: Retcode 1: error in DDL statement for PATRTVERS - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATRTVERS when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATRTVERS |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:08:43: Retcode 1: error in DDL statement for PATRTVERS2 - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATRTVERS2 when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATRTVERS2 |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | 16:08:55: Retcode 1: error in DDL statement for PATSWFTINC - repeat |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error PATSWFTINC when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of PATSWFTINC |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error STACKHEADR when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of STACKHEADR |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error SWFEATUREINC when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of SWFEATUREINC |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error TECHUSAGES when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of TECHUSAGES |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error TLANOCS when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of TLANOCS |
| | (dummy, do not translate) |
| | (dummy, do not translate) |
| | Error 15016-The default 'str_default' does not exist. when executing ADD-FIELD of |
| | Error TLANOCSTA when executing ADD-FIELD of |
| | (dummy, do not translate) |
| | No DDL commands found for activation of TLANOCSTA |
| | ------------------------------------- |
| | 15 shadow nametab activations resulted in errors |
| | Begin: Activation of shadow nametabs with DDL (2014/02/26 16:07:06) |
| | End: Activation of shadow nametabs with DDL (2014/02/26 16:09:07) |
| | ------------------------------------- |
| | ------------------------------------- |
| | Begin: Activation of shadow nametabs with DDL (2014/02/26 16:09:07) |
| | ------------------------------------- |
| | (dummy, do not translate) |
| | -------------------------------------
anything i can do to solve this issue?
thanks for your help,
Regards,
Hello Experts, i Downgrade teh SQL to 2008 R2 and that solve my problem.
Thanks for the help,
Alejandro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you please try updating tp & r3trans in the system and then try patch the SPAM/SAINT.
BR,
Apoorv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check the PAM for what you are installing and make sure you have the right level of KERNEL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alejandro,
Firstly just re-import the spam again and check whether it's successful.
Let us know is this a new system (fresh installation ) or you performed refresh activity on it with some other data.
Also take help from your DBA and check whether 'str_default' is exist with correct schema/owner in DB side.
sp_help str_default;
Regards,
Rafikul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello Rafikul thanksfor your help,
i already try to reimport and i get the same message.
this is a fresh installation, i check the 'str_default' and i get this message:
sp_help str_default;
Msg 15009, Level 16, State 1, Procedure sp_help, Line 79
The object 'str_default' does not exist in database 'PIM' or is invalid for this operation.
that means that the
how can i solve this issue?
Regards,
Alejandro
Hi Alejandro,
Hope you follwed the below mentioned sap note when installation /configuration MS SQL 2012
1676665 Setting up Microsoft SQL Server 2012
1651862 Release planning for Microsoft SQL Server 2012
Also re check whether all the required minimum patch for software component are same in your system as mentioned in 1651862. If all are good in your system then just raise a SAP message.
Regards,
Rafikul
Hello,
Check SAP note 1651862.
Regards,
David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Palazon,
Did you try to re-import the SPAM update.
Support Package -> Import queue from the initial screen of the Support Package Manager.
Basically SPAM update will get ended up with an error first time. The next re-import will get completed.
Regards,
Akram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.