cancel
Showing results for 
Search instead for 
Did you mean: 

Error while applying SPAM

Former Member
0 Kudos

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:

TASK |PROJECT |P|CMD Im|DD Im |DD

Act|MainIm|ADO Im|VersFl|Deploy|XPRA |ChkDpl|Gener |UMODE|TAGS

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

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

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

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

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

RB

Former Member
0 Kudos

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

Reagan
Advisor
Advisor
0 Kudos

Do you have a valid backup taken before this activity ?

Regards

RB

Former Member
0 Kudos

Hi,

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

Regards,

Sandeep Singh

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member45419
Active Contributor
0 Kudos