XPRA_EXECTION MSS_SDBP_AFTER_IMP for SDBP L Error

[Former Member]

Hello everybody,

I'm trying to implement these patches in our DEV ERP system. The import process stopped at phase XPRA_EXECUTION with this message:

The following details help you to analyze the problem:

    -   Error in phase: XPRA_EXECUTION

    -   Reason for error: TP_STEP_FAILURE

    -   Return code: 0008

    -   Error message: OCS Package SAPKB70030, tp step "R", return code

        0008

In the Action and Import Logs can be found this records:

This is the error on the log:

2 EPU122XPost-import method "MSS_SDBP_AFTER_IMP" started for "SDBP" "L", date and time: "20140307103739"

4 E0Q045 Starting processing of SQL scripts (R3TR SDBP)...

4 E0Q043 SQL script "sap_dbcoll" " " " " being executed

4 E0Q043 SQL script "sap_get_table_size_info" "9.0" "A" being executed

4 E0Q041 SQL script "sap_get_table_size_info" "A.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_get_table_size_info" "B.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_get_table_size_info" "C.0" "A" will be ignored (incorrect release)

4 E0Q043 SQL script "sap_mon_sqlsetup" "9.0" "A" being executed

4 E0Q041 SQL script "sap_mon_sqlsetup" "A.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_mon_sqlsetup" "B.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_mon_sqlsetup" "C.0" "A" will be ignored (incorrect release)

4 E0Q043 SQL script "sap_p_snapshot" "9.0" "A" being executed

4 E0Q041 SQL script "sap_p_snapshot" "A.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_p_snapshot" "B.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_p_snapshot" "C.0" "A" will be ignored (incorrect release)

4 E0Q042 Deletion request for SQL script "sap_tabstats" " " " "

4 E0Q041 SQL script "sap_tabstats" "8.0" "A" will be ignored (incorrect release)

4 E0Q043 SQL script "sap_tabstats" "9.0" "A" being executed

A2EESMMSS_ANALYZE 000 SQL error "156": "'object_schema_name' is not a recognized built-in" "function name.Incorrect syntax near the keyword 'A" "S'.Incor

4 E0Q041 SQL script "sap_tabstats" "A.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_tabstats" "B.0" "A" will be ignored (incorrect release)

4 E0Q041 SQL script "sap_tabstats" "C.0" "A" will be ignored (incorrect release)

3 E0Q044 SQL scripts executed / deleted / ignored: "5" / "1" / "13"

2EEPU133 Errors occurred during post-handling "MSS_SDBP_AFTER_IMP" for "SDBP" "L"

3 EPU135 "MSS_SDBP_AFTER_IMP" belongs to package "SMSS_TOOLS"

2EEPU136 The errors affect the following components:

2EEPU137    "BC-DB-MSS" ("Microsoft SQL Server")

3 EPU123 Post-import method "MSS_SDBP_AFTER_IMP" completed for "SDBP" "L", date and time: "20140307103748"

any idea?

thanks in advance,

Carlos

[Former Member · Accepted solution]

Hello,

Can you please put where the log of SAPKB70030?

I suppose that you running SUM so can you find the log in /SUM/Abap/log

Best regards

Joao

[Former Member · Accepted solution]

Hi Joao,

I attach the log.

Any Idea?

thanks in advance

SAPKB70030.XGD.txt.zip

[Former Member · Accepted solution]

Hello,

What is the version and SP of your SQL Server?

Best regards

Joao

[Former Member · Accepted solution]

Hello,

My Version of SQL Server is 2005 and the SP is Microsoft SQL Server Management Studio   9.00.1399.00.

Any Idea?

[former_member188883 · Accepted solution]

Hi Carlos,

It looks to be issue with MSSQL patch.

Is it possible for you to update SQL patch SP2 and test it.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi,

Can you find any error in SQL logs (in management studio you can see the logs)?

I suppose that your SP is very low.

Another question: during the previous phases of patches all activities run well withou any error?

Best regards

Joao

[former_member184473 · Accepted solution]

Hello Carlos,

As Deepak mentioned, SQL Server 2005 RTM is not supported (note 62988😞

SQL Server:	Minimum Version
SQL Server 2005	9.00.3042 (**) (1)

You can find the SQL Server 2005 SP2 in the following website:

Download Microsoft SQL Server 2005 Service Pack 2 from Official Microsoft Download Center

But I strongly advice to implement SQL Server 2005 SP4:

Download Microsoft SQL Server 2005 Service Pack 4 RTM from Official Microsoft Download Center

Regards,

Eduardo Rezende

[Former Member]

Hi All,

One more info, I got the same error while Importing SAPKB70028 Support Pack.

SQL Error 170: Line 1: Incorrect syntax near 'INDEX'

    SQL Scripts executed /deleted / ignored: 3 / 0 / 10

    Errors ocurred during post-handling MSS_SDBP_AFTER_IMP for SDBP L

    MSS_SDBP_AFTER_IMP belongs to package SMSS_TOOLS

    The error affect the following components:

    BC-DB-MSS

SAP Version: ECC 6.0

Database: MSSQL 2000 R2

Finally i found the below sap note and solved my issue.

1832133 - SQL Server 2000: Importing SAPKB70028 fails with "SQL Error 170 Line 1 Incorrect Syntax ne...

Regards,

Vino

[former_member188883]

Hi Carlos,

Are you maybe running into the problem described in Note "598767 - DB13 - SQL error 229 when creating new jobs"? I know, it´s not DB13 causing this but the symptoms looks the same.

The XPRA problem is also described in note "669236 - Enhancements to upgrade to WEB AS 6.40 with MS SQL Server" which says to use the first note I gave you to solve the problem.

Also Could you check SAP note 1551067

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

I have seen this notes:

738950     SPAM error in "Method Execution" on Microsoft SQL Server

1719979    SPAM/SUM: SQL error 208: Invalid object name 'sap_get_para'

928915     DB privileges lacking when applying support package

769842     SQL errors occur in XPRAS_UPG phase

1832133 *     SQL Server 2000: Importing SAPKB70028 fails with "SQL Error 170 Line 1 Incorrec

1045797     Upgrade error in phase XPRAS_UPG

1131766     Error in XPRA on sap_tabstats_job_update

927614     MSSQL : Empty log entries in MSSPROCS / "Start all"

but i dont find the solution.

any idea?

thanks