Shot Dump while updating record in ETTIFN using the FM ISU_DB_ETTIFN_UPDATE

[Former Member]

Hi All,

Am getting shot dump while trying to update an entry in ETTIFN database table using the FM ISU_DB_ETTIFN_UPDATE.

If this FM fails to update then it tries to raise error message using the macro

MAC_MSG_PUTX CO_MSG_PROGRAMMING_ERROR '016' 'E9'

'ETTIFN' SPACE SPACE SPACE

SPACE .

Runtime Errors MESSAGE_TYPE_X

Error analysis

Short text of error message:

Error in changing table ETTIFN

Long text of error message:

Diagnosis

An error occurred when one or more table entries were being

changed. This error was reported by the database system.

System Response

The system does not permit changes to one or more table entries.

It is possible that an SAP short dump has been written from the SAP

basis system.

Procedure

Find out if the SAP short dump provides additional information.

You can view SAP short dumps using Transaction SM21.

Technical information about the message:

Message class....... "E9"

Number.............. 016

Variable 1.......... "ETTIFN"

Variable 2.......... " "

Variable 3.......... " "

Variable 4.......... " "

Please advice inorder to fix the same.

Regards,

Deepthi

[Former Member]

If you are trying to update installation facts you can use following BAPI

BAPI_UTILINSTALLATION_CHANFACT

I hope this helps you.

[Former Member]

Hi ,

Yes , FM BAPI_UTILINSTALLATION_CHANFACT can be used to update ETTIFN table but without changing the current code (which is using "ISU_DB_ETTIFN_UPDATE" fm) I have to fix the issue.

Thanks and Regards,

Deepthi

[Former Member · Accepted solution]

Hi,

This could have happened because you might be calling this FM to update an entry and that particular entry may not exist in table.

If you are using update (U), i guess you will have to make sure the corresponding entry exists in database table ..otherwise use modify (M) option which either updates the existing entry or create a new one if not found.

Regards,

Pranav.

[raviahuja]

Hi Deepthi,

Updating database using statement update can give dumps because of below issues:

"At least one line was not able to be changed, either because no appropriate line was found, or because the change would generate a line that leads to double entries in the primary key or a unique secondary index in the database table."

I would rather suggest you to call the FM in Mode 'M', i.e. Modify so if entry in table is not there to update, it will insert that record and also won't give dump.

Thanks.

Ravi