cancel
Showing results for 
Search instead for 
Did you mean: 

SPAM upgrade ERROR in PI

Former Member
0 Kudos

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,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Hello Experts, i Downgrade teh SQL to 2008 R2 and that solve my problem.

Thanks for the help,

Alejandro

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi,

Could you please try updating tp & r3trans in the system and then try patch the SPAM/SAINT.

BR,

Apoorv

Former Member
0 Kudos


Check the PAM for what you are installing and make sure you have the right level of KERNEL

i015409
Advisor
Advisor
0 Kudos


hi,

what is your current kernel version?

the below doc maybe helpful to you.

Regards,

Johnny

former_member187565
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member187565
Active Contributor
0 Kudos

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

former_member189797
Active Contributor
0 Kudos

Hello,

CREATE DEFAULT str_default AS ' ';

please create str_default as above if this does not exist then repeat the phase.

Regards,
Gaurav

DavidLY
Advisor
Advisor
0 Kudos

Hello,

Check SAP note 1651862.

Regards,

David

Former Member
0 Kudos

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