[AIRAVATA-142] Cannot execute a workflow in XBaya when MessageBox is deployed on other machine

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.1-INCUBATING
• Component/s: WS-Messenger
• Assignee: Unassigned
• Reporter: Patanachai Tangchaisin
• Created: 13/Oct/11 17:03
• Updated: 16/Oct/11 20:09
• Resolved: 16/Oct/11 20:09

Description

12:59:49.633 [HttpConnection-8080-42] ERROR o.a.a.w.c.s.WsmgPersistantStorage - sql exception occured
java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'http://156.56.179.101:8080/axis2/services/MsgBoxService/clie&' to length 100.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.airavata.wsmg.commons.storage.JdbcStorage.executeUpdateAndClose(JdbcStorage.java:117) ~[axis26588635929476400528airavata-messenger-commons-0.0.1-SNAPSHOT.jar:na]
at org.apache.airavata.wsmg.commons.storage.WsmgPersistantStorage.insert(WsmgPersistantStorage.java:235) ~[axis29012731011551654190airavata-messagebroker-0.0.1-SNAPSHOT.aar:na]
at org.apache.airavata.wsmg.broker.subscription.SubscriptionManager.createSubscription(SubscriptionManager.java:195) [axis29012731011551654190airavata-messagebroker-0.0.1-SNAPSHOT.aar:na]
at org.apache.airavata.wsmg.broker.subscription.SubscriptionManager.subscribe(SubscriptionManager.java:128) [axis29012731011551654190airavata-messagebroker-0.0.1-SNAPSHOT.aar:na]
at org.apache.airavata.wsmg.broker.wseventing.WSEventingMsgReceiver.process(WSEventingMsgReceiver.java:56) [axis29012731011551654190airavata-messagebroker-0.0.1-SNAPSHOT.aar:na]
at org.apache.airavata.wsmg.broker.AbstractBrokerMsgReceiver.invokeBusinessLogic(AbstractBrokerMsgReceiver.java:44) [axis29012731011551654190airavata-messagebroker-0.0.1-SNAPSHOT.aar:na]
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114) [axis2-kernel-1.5.1.jar:na]
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:173) [axis2-kernel-1.5.1.jar:na]
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:167) [axis2-transport-http-1.5.1.jar:na]
at org.apache.axis2.transport.http.HTTPWorker.service(HTTPWorker.java:266) [axis2-transport-http-1.5.1.jar:na]
at org.apache.axis2.transport.http.server.AxisHttpService.doService(AxisHttpService.java:281) [axis2-transport-http-1.5.1.jar:na]
at org.apache.axis2.transport.http.server.AxisHttpService.handleRequest(AxisHttpService.java:187) [axis2-transport-http-1.5.1.jar:na]
at org.apache.axis2.transport.http.server.HttpServiceProcessor.run(HttpServiceProcessor.java:82) [axis2-transport-http-1.5.1.jar:na]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26]
at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26]
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A truncation error was encountered trying to shrink VARCHAR 'http://156.56.179.101:8080/axis2/services/MsgBoxService/clie&' to length 100.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.7.1.1.jar:na]
... 25 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: A truncation error was encountered trying to shrink VARCHAR 'http://156.56.179.101:8080/axis2/services/MsgBoxService/clie&' to length 100.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.7.1.1.jar:na]
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.7.1.1.jar:na]
... 19 common frames omitted