in our import from the S/4 HANA (we import accounts, roles, profiles and tcodes), we have good insights in the logs for the first 10mins of the job, then there is a warning in the logs which repeats until the job is finished:
WARNING [quartzScheduler_Worker-7] groovy.sql.Sql.asSql In Groovy SQL please do not use quotes around dynamic expressions (which start with $) as this means we cannot use a JDBC PreparedStatement and so is a security hole. Groovy has worked around your mistake but the security hole is still there. The expression so far is: Select ?, ENTITLEMENT_VALUEKEY from ENTITLEMENT_VALUES
Can you advise on what is going on that this warning is clogging the logs?
Solved! Go to Solution.
Hello @RakeshMG ,
we searched for the accountnotinfileaction parameter more broadly and found it in the SAV documentation as parameter of a generic DB connection: https://docs.saviyntcloud.com/bundle/Database-v2022x/page/Content/Configuring-the-Integration-for-Im....
Interestingly, we don't have a generic DB connection in our SAV instance.
Based on the warning, we assume that SAV poses internal queries that include quotes. It is possible, that SAV can't handle the import of data fields whose data contain quotes? We checked the data we imported from S4, some fields actually do include quotes, e.g. some description fields.