The following error occur in the username.log when trying to migrate a peoplesoft record
1111 96994 8/20/2012 17:07:46 -2 [.Error] - Error in blob select or update, the update: UPDATE PSDBFIELD SET DESCRLONG = ? WHERE ( FIELDNAME = ? )
1111 96995 8/20/2012 17:07:46 -2 [.Error] - Transaction TransactionImple < ac, BasicAction: a921c95:6a3:5032c3a2:7132 status: ActionStatus.ABORTING > cannot proceed STATUS_ROLLING_BACK; - nested throwable: (javax.transaction.RollbackException: Transaction TransactionImple < ac, BasicAction: a921c95:6a3:5032c3a2:7132 status: ActionStatus.ABORTING > cannot proceed STATUS_ROLLING_BACK)
1111 96996 8/20/2012 17:07:46 -2 [FIN.154..Error] - Transaction rolled back
Staging process is timing out due to the large record in peoplesoft
1. Logon to the stat agent machine and navigate to app\server\default\deploy
2. Locate a file called transaction-jboss-beans.xml and edit this file
3. Do a search for transactiontimeout and you will see this entry:
<property name="transactionTimeout">300</property>
<property name="objectStoreDir">${jboss.server.data.dir}/tx-object-store</property>
<property name="mbeanServer"><inject bean="JMXKernel" property="mbeanServer"/></property>
4. Change from 300 to 1200. 300 represents 5 minutes, whereas 1200 represents 20 minutes.
5. Save the changes to the file
6. Shutdown the stat agent
7. Delete the tmp and work folder from app\server\default
8. Restart the stat agent
