Enhanced Query- Saviynt Upgrade to v23.11

[Dev]

Hello Team,

We are upgrading from v5.5SP3 to v23.11, 

Since custom query job is deprecated do we need to convert all existing custom queries to Enhanced query execution job.

Thanks

Deven Karande

[rushikeshvartak · Accepted solution]

• • You don't need to convert existing query (update) to enhanced Query (select)  
  • Existing queries will work as it is.
  • Any enhancement to existing custom query job can't be done and need to be create new enhanced query job

  Custom Query block for existing job will become readonly / gray out.

  

  • Enhanced Query Execution 

    • Introduced the Enhanced Query Execution job to improve the overall system stability in the Saviynt environment. See Enhanced Query Execution Job. in v23.7 Version

  • Enhanced Query Execution Job

    Introduced a new Enhanced Query Execution job to address potential security issues and improve the overall stability of the system in the Saviynt environment. The following changes have been implemented as part of this enhancement:

    • Discontinued the Execute Extension Queries (CUSTOMQUERYJOB): The existing job instances of Execute Extension Queries (CUSTOMQUERYJOB) continue to run. However, no new instances of this job can be created, and any attempt to modify the existing instances of the job are prevented by the system.

    • Supported Operations: The new Enhanced Query Execution job contains guardrails to limit updates on selected objects and support the INSERT and UPDATE operations.

      For more information, see Job Categories for Flat Job Control Panel in the Enterprise Identity Cloud Administration Guide.

  https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...