Report Definition Error
Hi All,
When I'm trying to run the Report Definition I got the following error :
"An error occured on executing the query for the report definition - caught exception during autocommit check"
Please help If anyone have any idea.
Regards,
Rohit
Pegasystems Inc.
IN
Could you check if below PDN solutions are useful in your scenario?
https://community.pega.com/support/support-articles/database-schema-not-loading
JK Technosoft Limited
IN
Hi,
Thanks for the quick reply
But I don't think so that above url are of any use in my case.
As 1st url set a parameter enable_hashjoin=1; which in my RD i don't know how to set as I manually run the RD then also this error occurs.
2nd url is for some web-logic server which also I don't use.
Regards,
Rohit
Pegasystems Inc.
US
HI Rohit,
Are you getting the error for running all Report Definition rules in your application or only one or two rules?
Can you run/collect the tracer log when you run the Report Definition?
You will notice the place where the error comes up. The tracer log will give you a hint what is wrong in your report definition.
Also, since you receive "caught exception during autocommit check" exception, the Pega log will also provide you the stack trace.
Thanks,
Susan
Pegasystems Inc.
IN
Added with what Susan suggested, I would also like to ask you to check the generated SQL query and see the result by directly firing it in DB.
VirtusaPolaris
LK
Hi Rohit,
I have encountered the same issue. Did you find a solution for it. If so, could you please help me to resolve the issue
Thanks and Regards
Riyaz
Pegasystems Inc.
IN
Hi Riyaz,
To get more visibility for your question, we suggest you to create a new post by clicking Write a post button available on the top left pane. Do let us know the link to the new post in case you decide to create one!
Thank you,
VirtusaPolaris
LK
Hi Lochana,
Thank you for the feedback. Please find the new post i have created for this query below.
Thank you
Riyaz