[
https://issues.apache.org/jira/browse/AIRAVATA-142?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Patanachai Tangchaisin closed AIRAVATA-142.
-------------------------------------------
Resolution: Fixed
Done by increase VARCHAR size in data base
> Cannot execute a workflow in XBaya when MessageBox is deployed on other
> machine
> -------------------------------------------------------------------------------
>
> Key: AIRAVATA-142
> URL: https://issues.apache.org/jira/browse/AIRAVATA-142
> Project: Airavata
> Issue Type: Bug
> Components: WS-Messenger
> Reporter: Patanachai Tangchaisin
> Fix For: 0.1-INCUBATING
>
>
> 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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
