Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Agent processing fails in the destination server

SA-8490

Summary



You have a scheduled agent that runs and fetches data from the source database and then places it in the destination server as a file.
The file is generated in the right place, but contains no data, and there are related errors in the logs.


Error Messages



There was a problem committing a transaction on database PegaRULES 0 Connection is not associated with a managed your_ser[email protected]527e6f35
From: (B1F3201E50B7D947CBFD59B0E0A876748)
Caused by SQL Problems.
Problem #1, SQLState null, Error code 0: java.sql.SQLException: Connection is not associated with a managed
your_server[email protected]6f35

Steps to Reproduce



Not Applicable

Root Cause



The root cause of this problem is defect or misconfiguration in the operating environment.
As per the error message, jdbc connection that was given to Pega application is stale. There is no information in the activity rule execution about the failure.


Resolution



This issue is resolved by making the following change to the operating environment:
  1. Enable the pre-test jdbc connection feature at JBOSS data source level using ‘<check-valid-connection-sql>’.
  2. Add an additional diagnostic by the application to understand the stages of the agent processing. 

Note: While processing this activity, add steps that write status of the processing. For instance, if the filter criteria for the data being collected, collect information like "how many records collected for this run and whether successfully completed the task or not".
These information helps if the problem reoccurs in the future.

 
Suggest Edit

Published November 6, 2015 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us