Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Rohit Sharma (RohitS22)
JK Technosoft Limited
Software Engineer
JK Technosoft Limited
IN
RohitS22 Member since 2014 12 posts
JK Technosoft Limited
Posted: Jul 6, 2017
Last activity: Aug 8, 2017
Posted: 6 Jul 2017 13:25 EDT
Last activity: 8 Aug 2017 9:42 EDT
Closed

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

To see attachments, please log in.
Dev/Designer Studio
Reporting

Posted: 8 years ago
Posted: 6 Jul 2017 14:11 EDT
Pankaj Rawal (rawap)
PEGA
Fellow, Software Architect, Platform Engineering
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

https://community.pega.com/support/support-articles/prruntimeexception-caught-exception-during-autocommit-check

To see attachments, please log in.
Posted: 8 years ago
Posted: 6 Jul 2017 15:35 EDT
Rohit Sharma (RohitS22)
JK Technosoft Limited
Software Engineer
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

 

To see attachments, please log in.
Posted: 8 years ago
Posted: 6 Jul 2017 19:54 EDT
Susan Liu (SusanLiu_GCS) Senior Principal Engineer, Technical Support, Runtime Engine
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

 

To see attachments, please log in.
Posted: 8 years ago
Posted: 7 Jul 2017 0:32 EDT
Santanu Bhattacherjee (Santanu) Senior Manager, Cloud Engineering, Management Plane Services
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.

To see attachments, please log in.
Posted: 8 years ago
Posted: 4 Aug 2017 11:49 EDT
Riyaz Mohamed (RiyazM03) Consultant Technology
OCBC Bank
MY

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

To see attachments, please log in.
Posted: 8 years ago
Posted: 7 Aug 2017 6:31 EDT
Lochana Durgada Vijayakumar (Lochan_DV)
PEGA
Senior Manager, Knowledge Management
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,

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice