and more in a single search tool across platforms. Read the announcement here. |
01/19/2024 02:42 AM
We have one SAP system where the Application data import is failing. Log shows the following errors:
groovy.sql.Sql.withBatch Error during batch execution: Unknown column 'DE' in 'field list'"
groovy.sql.Sql.handleError Rolling back due to: Unknown column 'DE' in 'field list'"
The error seems to occur during import of table USR02. If I remove the table, the error disappears. We can also see that accounts are not imported. Entitlements are there though.
We have a number of other SAP systems with the same config, that work fine. That's why I suspect it to be a data issue on SAP side for this specific system. The "DE" is the language code for Germany, so it might be something in the language/localization area.
Does anyone maybe have any input on this?
Solved! Go to Solution.
01/20/2024 09:07 AM
Did you setup sap language
01/22/2024 05:09 AM
JCO_LANG is set to "EN" but I also tried "DE" already.
01/22/2024 05:16 AM
Set E
01/22/2024 05:31 AM - edited 01/22/2024 05:32 AM
JCO_LANG needs to be two letter code, right?
Do you maybe mean SAPTABLE_FILTER_LANG? It's set to "E". But this should only affect entitlement import.
01/22/2024 05:41 AM
Yes E only
https://forums.saviynt.com/t5/identity-governance/how-to-troubleshoot-sap-import-error/m-p/34298
01/22/2024 11:37 PM
In the thread you linked it says to use JCO_LANG = EN and SAPTABLE_FILTER_LANG = E, which already is exactly how we configured it.
01/23/2024 07:51 AM
Turns out this was a data issue. There were accounts in the target system containing characters | and [ in the account name. After they were removed, import was successful.