Flash (Alert)
Abstract
GSR0424E and GSR7003E errors in the temporary database used to capture data from WebSphere Service Registry and Repository during upgrade or export
Content
During an upgrade, promotion or export, you see the following errors:
[20/04/09 20:00:24:968 BST] 0000000a I UOW=null source=com.ibm.sr.upgrade.tool.UpgradeTool org=null prod=null component=null thread=[P=22968:O=0:CT]
> GSR7031I: Capturing bsrURI: e87fe9e8-79d0-40da.baac.fb598bfbac7d. Type: com.ibm.serviceregistry.sdo.impl.PolicyExpressionImpl, name: LTPA_RAMP_default_WSSecurity.
[20/04/09 20:00:25:078 BST] 0000000a I UOW=null source=com.ibm.sr.upgrade.tool.UpgradeTool org=null prod=null component=null thread=[P=22968:O=0:CT]
> GSR7002E: An exception occurred: GSR0424E: A Problem has occurred with the temporary database used to capture and load into WSRR
com.ibm.serviceregistry.exception.movedata.MoveDataSQLException: GSR0424E: A Problem has occurred with the temporary database used to capture and load into WSRR
at com.ibm.sr.api.impl.MoveDataDBImpl.addMetadata(MoveDataDBImpl.java:513)
at...
> GSR7003E: Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A truncation error was encountered trying to shrink VARCHAR ''<wsp:Policy Name="LTPA_RAMP_default_WSSecurity" xmlns:sp="ht&'' to length 4000.
ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '<wsp:Policy Name="LTPA_RAMP_default_WSSecurity" xmlns:sp="ht&' to length 4000.
.....
Solution
The solution is to apply APAR IZ49797, which is available in WebSphere Service Registry and Repository V6.2.0 Fix Pack 3.
This fix is recommended as preventive maintenance before upgrading from 6.2.0.x to 6.3.
Product Alias/Synonym
WSRR
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.