error with DNL_CUST_ADDR "Sysfail"

[former_member248975]

Hi Experts,

We are implementing SAP CRM 2007, conected to SAP ECC.

When we are doing the initial customizing load of the objects DNL_CUST_ADDR, it stopped in the inbound Queue with the error message u201CSysfailu201D invalid Context Handle / The ABAP/4 Open SQL array insert results in dupl. I made the replication for other objects after that and the replication is fine.

in tx st22 I found this dump SAPSQL_ARRAY_INSERT_DUPREC exception CX_SY_OPEN_SQL_DB.

Please help me how I do to fix this issue.

Lidisaid

[Former Member · Accepted solution]

Hi,

This dump is created because a wrong entry was made, by the system, in table BALHR.

In this table logs are saved by the sytem and a number is assigned.The last number is incorrect and causes the dump.

SAP has a solution for this. Please check out SAP OSS note 196113.

Regards,

Marc

[former_member562530]

Hi Lidisaid, Use Transaction R3AC3 to start the maintenance of the adapter object and insert the "NO ISO CODES" string in the FUNCTIONS field OR please use report SMOF_INSERT_NO_ISO_CODES in order to do the maintenance described. After the maintenance please clean up all remaining queue in transactions SMQ1/SMQ2 and re-execute the adapter object. If the mentioned solution do not fix your problem AND if this is NOT your production environment, please reset the data stored into all following tables using transaction SE14: ADRCITY ADRCITYPRT ADRCITYT ADRDIFINFO ADRDIF_CP ADRDIF_CT ADRDIF_PC ADRDIF_PO ADRDIF_ST ADRPCDCITY ADRPOBOX ADRPSTCODE ADRREGGRP ADRREGGRPT ADRSTREET ADRSTREETT ADRSTRPCD ADRSTRTYPE ADRSTRTYPT I hope it helps. Best Regards, Gabriel Santana