Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/10/2023 11:19 AM
We are having an issue where 3 of our 9 SAP instances fail when trying to do application data import jobs. The error in the logs is: {log":"com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: Data was lost while copying a value. (Remote shortdump: SAPSQL_DATA_LOSS in system FVC|FBSNWGC1)\n"
The job shows: error status Failed to import one or more object types due to
multiple errors. Check the Job Log Details page
for more information.
Looking at the job details it appears it imported some accounts and tcodes:
How do we troubleshoot or locate the record that caused the sqldataloss? I don't see an option to limit the number of objects which are imported on the default SAP connector? Should I remove some of the tables we are trying to import? USR02,TSTC,TSTCT,AGR_AGRS,AGR_TEXTS,AGR_DEFINE,AGR_USERS,USORG,AGR_1252,AGR_1251
Solved! Go to Solution.
05/10/2023 01:57 PM
@pj5233 Can you please check and see at which tables import you get this error?
05/10/2023 02:34 PM
Would it be the last table that was written in the logs? (TSTCT) Here is what I see in the logs:
05/16/2023 07:43 AM
I removed the TSTCT table from import and ran it again. It got further and failed on AGR_TEXTS. So I removed it and then ran again and it completed successfully. So it appears to be something in those two tables. How can I narrow down what record it is breaking on?
05/16/2023 08:59 AM
Hi @pj5233,
SAP has enhanced its function module RFC_READ_TABLE by implementing protection against SQL injections. RFC_READ_TABLE only accepts type-conforming WHERE conditions. In older DBI versions, tolerated errors such as LANGU = 'DE' or SPRAS = 'EN' now generate the runtime error SAPSQL_DATA_LOSS. The correct notation for the given example is SPRAS = 'E' or LANGU = 'D'.
I had the same problem and was able to solve it by configuring the Connections field SAPTABLE_FILTER_LANG.
The possible values "E" and "EN" both work for SAP ABAP versions < 750, and only the value "E" works for SAP ABAP versions > 750
05/16/2023 09:02 AM
Thanks @aro
Yes that’s correct. Please try setting SAPTABLE_FILTER_LANG to E and run the import again.
05/16/2023 10:01 AM
That seems to have worked. Do I leave the JCO_LANG set to EN or should I change it to E as well?
05/16/2023 10:09 AM
I left JCO_LANG on EN
05/16/2023 02:40 PM
Combination of JCO_LANG as EN and SAPTABLE_FILTER_LANG as E should work.