Error received in the Archive Log Tab and the Server log files when creating archive sets.
"Could not unbind managedConnectionFactory"
Connections are lost with the PeopleSoft databases.
WORKAROUND1:
Restart the Stat Agent whenever the error is received to force the connections to be re-established.
WORKAROUND2:
Run the Stat Agent using the run.bat, instead of running the Agent as a Windows Service.
WORKAROUND3:
This fix needs to be put into place manually whenever a change is made in the Stat Web Configuration Tool (http://server:8280/stat-config/setup.jsp).
1. Access the stat-config webpage (http://hostname:port/stat-config/setup.jsp) from an authorized computer.
2. Make the desired configuration changes and click the "Save" button to store the change(s).
3. Stop the Stat Agent.
4. Once the Stat Agent has been successfully stopped, use Notepad (or desired file editor) to Open and Edit $STAT_HOME/app/server/default/deploy/stat-ds.xml file.
5. Add the following line of code from the example below to your stat-ds.xml file after the line that reads "<password>stat</password>".
<!-- SQL to call on an existing pooled connection when it is obtained from pool --> <!-- If the sql fails, the connection is closed and new ones created -->
<check-valid-connection-sql>SELECT STAT_DB_VERSION FROM SYSTEM_TBL</check-valid-connection-sql>
6. Save the changes to the file.
7. Re-start the Stat Agent.
STATUS:
This issue was fixed in Stat 5.2.1. The latest version of Stat can be downloaded at: http://support.quest.com/support_download/Downloads.asp.
Solution applies to Stat 5.1.x and 5.2.0
