Sunday, February 9, 2014

IP address change | could cause staleConnectionException wiith remote DB

If you guys have worked with DB2 from VM. This could happen from periodically. Just be vary to uncatalog and catalog with the new IP address.

[12:44:55:179 EDT] 0000000c SystemOut     O WC.TOOLKIT: Enterprise 7.0.0.6 /
[12:44:55:170 EDT] 0000000c SystemErr     R com.ibm.commerce.wc.appmanagement.exception.WCAppManagementException: com.ibm.websphere.ce.cm.StaleConnectionException: [jcc][t4][2055][11259][4.13.80] The database manager is not able to accept new requests, has terminated all requests in progress,
or has terminated this particular request due to unexpected error conditions detected at the target system.
ERRORCODE=-4499, SQLSTATE=58009DSRA0010E: SQL State = 58009, Error Code = -4,499
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.wc.version.ECDatabaseVersionInfo.readSiteTable(ECDatabaseVersionInfo.java:140)
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.wc.version.ECDatabaseVersionInfo.(ECDatabaseVersionInfo.java:84)
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.server.ProductInfo.getECDatabaseVersionInfo(ProductInfo.java:58)
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.server.ProductInfo.getECDBVersionInfo(ProductInfo.java:96)
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.server.ProductInfo.getProductVersion(ProductInfo.java:75)
[12:44:55:171 EDT] 0000000c SystemErr     R     at com.ibm.commerce.server.WcsApp.configInit(WcsApp.java:718)
[12:44:55:172 EDT] 0000000c SystemErr     R     at com.ibm.commerce.server.WcsApp.initialize(WcsApp.java:454)


Commands to uncatalog and catalog in DB2:

db2 UNCATALOG DATABASE
db2 UNCATALOG NODE
db2 catalog tcpip node remote 144.149.XX.X server 50000
db2 catalog database as at node
db2 terminate


2 comments:

  1. No es lo que buscaba en estos momentos, pero me he parado a leerlo y me ha interesado más de lo que me esperaba , muchísimas gracias.

    ReplyDelete
  2. Muy buen post, gracias por compartir esta información, sin duda seguiré esperando a que subas más contenido.

    ReplyDelete