Message Boards

QXtend Test Harness return error mismatch collation

Chettaphong Meepom, modified 3 Years ago.

QXtend Test Harness return error mismatch collation

Post Date: 10/19/15 (Bronze, 16 Posts) Recent Posts

Hi Expert,

I found an error during run QXtend Test Harness function in production system with below message

ERROR: Mismatching collations between client and database.

Please advise How to fix it.

System Profile.

  • QXtend 1.8.6
  • QAD 2012EE
  • Progress 10.2B SP 05
  • OS AIX 6.1
  • JAVA 6
  • Tomcat 6

Remark,

I am also install QXtend 1.8.6 in Development and Test in same machine without any error during run Test Harness.

 

thumbnail
Sujit Gavhane, modified 10 Years ago.

Re: QXtend Test Harness return error mismatch collation

Post Date: 10/19/15 (Platinum, 317 Posts) Recent Posts
Hi,
There may be differences in codepage settings in client and the database (cpinternal, cpcollation ) in Production and Development/Test.

Review the UI connmgr script from Prodcution QXtend enviornment or the $prod/scripts/qxtend.pf and also check what's in $DLC/startup.pf that connect to the database for (cpinternal, cpcollation, -cpcoll ICU-UCA) parameter.

Also check qadsi_ *.pf file the qadsi_APi appserver is using for codepage.
Chettaphong Meepom, modified 10 Years ago.

Re: QXtend Test Harness return error mismatch collation

Post Date: 10/19/15 (Bronze, 16 Posts) Recent Posts
Thanks, I am checked them It is same as Development and Test that $DLC/startup.pf using iso8859-1 and Qxtend script use UTF-8. I am also test to remove UTF-8 from QXtend client script. But it is still return error. Do you have any idea ?
Chettaphong Meepom, modified 10 Years ago.

Re: QXtend Test Harness return error mismatch collation

Post Date: 10/19/15 (Bronze, 16 Posts) Recent Posts
Below is error return from Test Harness in xml format. - - urn:services-qad-com: urn:messages-qad-com:2015-10-19T09:17:52+0000 urn:messages-qad-com:2015-10-19T09:17:42+0000 - - error - - QAD domain - QAD scopeTransaction false - QAD version eB_1 - QAD mnemonicsRaw false - - 2015-10-19T09:17:52+0000 ERROR: Mismatching collations between client and database. 0 MfgProErrorMessage false error - 2015-10-19T09:17:52+0000 ERROR: Unable to initialize session. 1 MfgProErrorMessage false error - 2015-10-19T09:17:52+0000 ERROR:ERROR: Connection to http URL:is unavailable. 2 MfgProErrorMessage false error - 2015-10-19T09:17:52+0000 ERROR:ERROR: Connection to http server:portis unavailable. 3 MfgProErrorMessage false error - 2015-10-19T09:17:52+0000 ERROR: No response from MessageServlet for HTTPPost to get API User data 4 MfgProErrorMessage false error - FailureException: 1 Timeout on sending data. The current control message is com.qad.xmlengine.msg.ControlMessage@3a623a62 : Connection id: 1 : Last Error Msg: null at com.qad.xmlengine.process.ProcessAgent.checkSubmitFlag(Unknown Source) at com.qad.qxtend.process.APIProcessAgent.checkSubmitFlag(APIProcessAgent.java:878) at com.qad.xmlengine.process.ProcessAgent.sendWithAck(Unknown Source) at com.qad.qxtend.process.APIProcessAgent.sendEmptySubmitData(APIProcessAgent.java:392) at com.qad.qxtend.adapters.APIProcessor.sendEmptySubmitData(APIProcessor.java:622) at com.qad.qxtend.events.StartProgramEvent.handleEvent(StartProgramEvent.java:78) at com.qad.qxtend.adapters.APIProcessor.processAPI(APIProcessor.java:340) at com.qad.qxtend.adapters.QdocXMLAdapter.processTransaction(QdocXMLAdapter.java:58) at com.qad.common.transaction.Routing.processRoutingTask(Unknown Source) at com.qad.common.transaction.Routing.routeTransaction(Unknown Source) at com.qad.common.transaction.Transaction.processSynchronousTransaction(Unknown Source) at com.qad.common.transaction.TransactionManager.processSynchronousTransaction(Unknown Source) at com.qad.qxtend.qdocs.QdocWebService.processQdocMessage(QdocWebService.java:184) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at org.apache.axis.providers.java.MsgProvider.processMessage(MsgProvider.java:155) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:643) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:620) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:738) 2015-10-19T09:17:52+0000 Timeout on sending data 5 FailureExceptionex010 false error

Message place holder