Error while Extraction of HR Data to LDAP with report RPLDAP_EXTRACT_IDM

[Former Member]

Hello Experts,

After executing report RPLDAP_EXTRACT_IDM to extract data from HCM system to IDM 7.1 i am getting following runtime error:

SAPSQL_ARRAY_INSERT_DUPREC,

Statement not getting executed is:

INSERT tlda_log FROM TABLE ilda_log

I have deleted all entries from tlda_log table but no luck:(

Any help will be really appreciated.

Regards,

Dev

[Former Member]

I guess the query is not correct to insert data from one table to another Or trying to insert duplicate records.

First drop the table then try to insert using the below query.

Select * into tlda_log FROM TABLE ilda_log.

[Former Member]

Hi Anup

Mentioned query is a part of standard sap program which is being run when we run the report, so i believe that query is fine.

Regards,

Dev