Question Re: Error while applying SPAM in Technology Q&A

Error while applying SPAM

Former Member — Wed, 11 Dec 2013 06:23:34 GMT

Hi Techies,

I have no backup of the present system.

We have encountered the below dump while appyilying the SPAM (SAPKD70051). i am able to open all the transcation expect SPAM and

SAINT

========================DUMP=========================================

Syntax error in program "SAPLOCS_EXTIF ".

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLOCS_CRM" had to be terminated because

it has

come across a statement that unfortunately cannot be executed.

The following syntax error occurred in program "SAPLOCS_EXTIF " in

include

"LOCS_EXTIFU43 " in

line 468:

"The data object "LS_STACKHEADR" does not have a component

called "GEN_"

"VERS"."

" "

The include has been created and last changed by:

Created by: "SAP "

Last changed by: "SAP "

Error in the ABAP Application Program

The current ABAP program "SAPLOCS_CRM" had to be terminated because

it has come across a statement that unfortunately cannot be

executed.

========================================================================

a. Intially it terminated at IMPORT_PROPER phase.

b. Ran the below command at os level.

idsadm> tp R3I SAPKD70051 IDS pf=/usr/sap/trans/bin/TP_DOMAIN_IDS.PFL

tag=spam -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8

This is tp version 380.08.41 (release 720, unicode enabled)

This is R3trans version 6.23 (release 720 - 15.05.12 - 20:12:03).

unicode enabled version

R3trans finished (0004).

tp finished with return code: 4

meaning:

A tool used by tp produced warnings

Then the above dump stated.

Please adivse the steps to over come the error as we have no

backup of the present system.

I see the SPAM patch still in the buffer.

idsadm> tp showbuffer IDS pf=/usr/sap/trans/bin/TP_DOMAIN_IDS.PFL

tag=spam

This is tp version 380.08.41 (release 720, unicode enabled)

IDS buffer:

--------------------+--------------------+-+------+------+------+------

+------+------+------+------+------+------+-----+----

SAPKD70051 | | |*0004 |*0004 |*0004 |*0004

| | | |7 | | | |D

that makes 1 transport to be imported.

tp finished with return code: 0

meaning:

Everything OK

I see the STACKHEADR table does exist in database when trying to create vis Txn Se11 getting the below error

sql:

CREATE TABLE "STACKHEADR"

("ID" SAPDB6VARCHAR(000020)

DEFAULT ' ' NOT NULL,

"QUEUE_ID" SAPDB6VARCHAR(000040)

DEFAULT ' ' NOT NULL,

"TYPE" SAPDB6VARCHAR(000010)

DEFAULT ' ' NOT NULL,

"PROD_ID" SAPDB6VARCHAR(000020)

DEFAULT ' ' NOT NULL,

"DESCRIPT" SAPDB6VARCHAR(000072)

DEFAULT ' ' NOT NULL,

"INSTSTATUS" SAPDB6VARCHAR(000001)

DEFAULT ' ' NOT NULL,

"INST_DATE" SAPDB6VARCHAR(000008)

DEFAULT '00000000' NOT NULL,

"INST_TIME" SAPDB6VARCHAR(000006)

DEFAULT '000000' NOT NULL,

"RESPONSIBL" SAPDB6VARCHAR(000012)

DEFAULT ' ' NOT NULL)

IN "IDS#STABD"

INDEX IN "IDS#STABI"

LONG IN "IDS#STABD COMPRESS YES"

SQL0107N The name "IDS#STABD COMPRESS YES" is too long. The maximum

length is "18". SQLSTATE=42622

DDL time(___1): ........64 milliseconds

The SQL statement was not executed

Statements for Table STACKHEADR could not be executed

Request for STACKHEADR could not be executed

Regards,

Sandeep Singh

Re: Error while applying SPAM

Reagan — Wed, 11 Dec 2013 09:29:32 GMT

Hello


b. Ran the below command at os level.
idsadm> tp R3I SAPKD70051 IDS pf=/usr/sap/trans/bin/TP_DOMAIN_IDS.PFL tag=spam -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8

Was this something suggested by the SAP support ?


SQL0107N The name "IDS#STABD COMPRESS YES" is too long. The maximum length is "18". SQLSTATE=42622

Check the database logs.

Also check the import logs for more information.

Try restarting the system and call Tx SPAM.

684564 - Re-importing a SPAM/SAINT update

Regards

Re: Error while applying SPAM

Former Member — Wed, 11 Dec 2013 09:41:14 GMT

Hi,

When imported the to it ended with RC=0. when i tried to login to spam it has started giving dump.

I also restarted the system but dump still prevailed.

When i checked the logs i found STACKHEADR table does exist in the database that the reason the dump was thrown. when i tried to create the table STACKHEADR via. TX se11 or se14 i am getting the error

SQL0107N The name "IDS#STABD COMPRESS YES" is too long. The maximum length is "18". SQLSTATE=42622

Regards,

Sandeep Singh

Re: Error while applying SPAM

Reagan — Wed, 11 Dec 2013 13:23:21 GMT

Do you have a valid backup taken before this activity ?

Regards

Re: Error while applying SPAM

Former Member — Thu, 12 Dec 2013 03:00:59 GMT

Hi,

We have no backup for this. Planning to reinstall the system trying up few things which would avoid reinstallation.

Regards,

Sandeep Singh

Re: Error while applying SPAM

former_member45419 — Thu, 12 Dec 2013 07:07:43 GMT

Hi Sandeep,

pls refer below links for similar error

http://scn.sap.com/thread/3286183

http://scn.sap.com/thread/3457334

http://scn.sap.com/thread/1534449

http://scn.sap.com/thread/3387207

Regards

Nayeem

Re: Error while applying SPAM

Former Member — Wed, 15 Jan 2014 07:28:01 GMT

Hi All,

The Problem has been resolved by when i followed the instrustion followed in the SAP Note 1126127.

went to SE13 -> database object -> remove Longspace and reactivated the table the issue got resolved.

If any help you can contact me on sandeepsinghd@gmail.com, i would help in the above issue.

Regards,

Sandeep Singh