Question
Standard Charted
IN
Last activity: 30 Aug 2023 15:07 EDT
Getting Query created on Blob column from Obj-Open step of the Activity
Hi All,
Because of Obj-open step within one of the activities, we are getting fail exception in tracer.
Below mentioned queries getting created
Query1: select pzInsKey from tablename where "ASSGNMNTCREATEDATETIME" = ? and "ASSIGNMENTKEY" = ?
Query2: select pzPVStream from tablename where pzInsKey = ?
Otherthan this we didn't observe any exceptions in the tracer.
This is raised in production environment as users are experiencing slowness while accessing the reports from Worklist
Please suggest any idea regarding this, What I am thinking is as we are running query on Blob column in Query 2, user are experiencing this slowness.
Regards,
Surya