SPAM, MSSQL, SAPKB70017

[former_member246028]

Hi all,

I try to install SAPKB70017 in transaction SPAM.

It gives me the following error:

Post-import method MSS_SDBP_AFTER_IMP started for SDBP L, date and time: 20110316132447

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

SQL script sap_delete_part_orphans being executed

SQL error 197: EXECUTE cannot be used as a source when inserting into a table variable.EXECUTE cannot be used as a source wh

SQL script sap_get_all_part_orphans being executed

SQL script sap_get_jobs 8.0 A being executed

SQL script sap_get_jobschedules 8.0 A being executed

SQL script sap_list_sch_agent_jobs 8.0 A being executed

SQL script sap_mon_all_tasks 8.0 A being executed

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

SQL scripts executed / deleted / ignored: 6 / 0 / 1

Errors occurred during post-handling MSS_SDBP_AFTER_IMP for SDBP L

MSS_SDBP_AFTER_IMP belongs to package SMSS_TOOLS

The errors affect the following components:

BC-DB-MSS (Microsoft SQL Server)

Post-import method MSS_SDBP_AFTER_IMP completed for SDBP L, date and time: 20110316132450

We are running: SAP ECC 6.0 (non Unicode)

Windows 2003 x86

Mssql 8.00.2039

SPAM: Level 42

Kernel: 700 Level 292 (Non-Unicode)

Regards,

Jan Reiser

[sivakumar_kilari3 · Accepted solution]

Hi,

Read this SAP note.

Note 928915 - DB privileges lacking when applying support package

Regards

Siva

[former_member246028 · Accepted solution]

Hi Siva,

did try the note, but still exactly the same error as posted above.

Any other ideas?

Regards,

Jan Reiser

[sivakumar_kilari3 · Accepted solution]

>

> did try the note, but still exactly the same error as posted above.
> 
> Any other ideas?
> 
> Regards,
> Jan Reiser

The system is running as a SQL Server MCOD?

[former_member246028 · Accepted solution]

Yes,

Msslq server is running MCOD.

[sivakumar_kilari3 · Accepted solution]

Follow this .

Note 1252672 - Error in XPRA_EXECUTION when applying NW04s SP17+ for MSSQL

[former_member246028 · Accepted solution]

Thank you,

you are the man!!

Works now perfect!

Regards,

Jan Reiser

Edited by: Jan Reiser on Mar 17, 2011 11:28 AM