-
Title
Error in blob select or update -
Description
I am getting the following error during migration:
14558 2445295 2/7/2011 14:35:34 -2 [.Error] - Error in blob select or update, the select: SELECT PROGTXT FROM ST_PSPCMPROG_8L WHERE ( SD_CD = 'PS9' AND CSR_ID = 4 AND SWAT_ID = 3 AND PS_DATABASE = 'ERPFNDEV' ) AND ( OBJECTID1 = ? ) AND ( OBJECTVALUE1 = ? ) AND ( OBJECTID2 = ? ) AND ( OBJECTVALUE2 = ? ) AND ( OBJECTID3 = ? ) AND ( OBJECTVALUE3 = ? ) AND ( OBJECTID4 = ? ) AND ( OBJECTVALUE4 = ? ) AND ( OBJECTID5 = ? ) AND ( OBJECTVALUE5 = ? ) AND ( OBJECTID6 = ? ) AND ( OBJECTVALUE6 = ? ) AND ( PROGSEQ = ? )
-
Cause
PS_VERSION was set to 8.50+ instead of 8.51+
-
Resolution
1. Go to Maintenance | General | Peoplesoft connect
2. Locate the source db | look for PS_VERSION column. Make sure that PS_VERSION is set to the correct peopletools version. For example, if you are running peopletools 8.51 then PS_VERSION need to be set to 8.51+
3. Shutdown the stat agent
4. Go to Maintenance | General | Update PS Object Mover Instructions
5. Restart the stat agent
6. Clear out the ps local cache and try the migration again