Groovy Warning in S/4 Import

[VicyB]

Hello everybody,

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?

Thank you!

[RakeshMG]

Could you please confirm, what is set for "accountnotinfileaction" in your configuration.

[VicyB]

Hello @RakeshMG ,

I looked in the connection for this field but didn't find it. Could you point me to the proper place in SAV to look for this configuration? Thank you!

[VicyB]

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. 

[VicyB]

Hello Saviynt-Team,

any advice on this topic?

Thanks!

[VicyB · Accepted solution]

Hello everybody,

via SME we received the feedback that the warning doesn't have a critical impact (is not a "special" warning, just a standard groovy warning) and can be ignored 👍