FM test gets XQE-CON-0006 Unable to establish connection to XQE

[ricky_ru]

Env: cognos 10.1.1 with DB2 9.7 on different AIX 6.1 machine.

Problem: After importing the metadata from database, right click the query subject and click Test, then click Test sample in the dialog, get the XQE-CON-0006 Unable to establish connection to XQE error. And the function list is empty when creating the package. Please check attached image.

But I did not get the problem in my server with cognos 10.1.1 on Linux.
Checked the xqelog-130801-1046450061.xml file and spotted the following 2 types of error

------------------------first exception------------------------------
XQE-GEN-0002 发生意外异常。: java.lang.NullPointerException
=== JAVA STACK TRACE === XQE-GEN-0002 发生意外异常。 at com.cognos.xqe.cubingservices.V5QueryHandler.logThrowableAndBuildSOAPFault(V5QueryHandler.java:722) at com.cognos.xqe.cubingservices.V5QueryHandler.execute(V5QueryHandler.java:453) at com.ibm.cubeservices.mdx.v5.V5ProviderFacade.execute(V5ProviderFacade.java:109) at com.cognos.cubics.providers.cubingservices.CSStatement.execute(CSStatement.java:156) at com.ibm.cubeservices.mdx.v5.V5RequestHandler.handleRequest(V5RequestHandler.java:59) at com.ibm.cubeservices.mdx.comms.Servlet.processMessage(Servlet.java:128) at com.ibm.cubeservices.mdx.comms.ComWorker.processQueryInputMsg(ComWorker.java:347) at com.ibm.cubeservices.mdx.comms.ComWorker.processInput(ComWorker.java:252) at com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:162) at com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:64) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:678) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:703) at java.lang.Thread.run(Thread.java:811) Caused by: java.lang.NullPointerException at java.util.concurrent.ConcurrentHashMap.hash(ConcurrentHashMap.java:172) at java.util.concurrent.ConcurrentHashMap.get(ConcurrentHashMap.java:745) at com.cognos.xqe.data.providers.ProviderManager.getProviderInfo(ProviderManager.java:788) at com.cognos.xqe.data.providers.ProviderManager.getProvider(ProviderManager.java:910) at com.cognos.xqe.query.engine.QueryEngine.doTestConnection(QueryEngine.java:1008) at com.cognos.xqe.query.engine.QueryEngine.testDataSourceConnection(QueryEngine.java:1085) at com.cognos.xqe.bibushandler.TestDataSourceConnectionRequestAdapter.executeRequest(TestDataSourceConnectionRequestAdapter.java:84) at com.cognos.xqe.cubingservices.V5QueryHandler.executeRequestInSequence(V5QueryHandler.java:600) at com.cognos.xqe.cubingservices.V5QueryHandler.execute(V5QueryHandler.java:440) ... 13 more
=== END OF JAVA STACK TRACE ===
------------------------second exception------------------------------

Caught error in V5QueryHandler: XQE-DS-0006 Unable to logon to the data source.
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.interpretSQLException(JDBCConnection.java:882)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnect(JDBCConnection.java:514)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.connect(JDBCConnection.java:609)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:85)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCDataProvider.testConnection(JDBCDataProvider.java:120)
at com.cognos.xqe.data.providers.relational.TraceRelationalDataProvider.testConnection(TraceRelationalDataProvider.java:193)
at com.cognos.xqe.query.engine.QueryEngine.doTestConnection(QueryEngine.java:1038)
at com.cognos.xqe.query.engine.QueryEngine.testDataSourceConnection(QueryEngine.java:1085)
at com.cognos.xqe.bibushandler.TestDataSourceConnectionRequestAdapter.executeRequest(TestDataSourceConnectionRequestAdapter.java:84)
at com.cognos.xqe.cubingservices.V5QueryHandler.executeRequestInSequence(V5QueryHandler.java:600)
at com.cognos.xqe.cubingservices.V5QueryHandler.execute(V5QueryHandler.java:440)
at com.ibm.cubeservices.mdx.v5.V5ProviderFacade.execute(V5ProviderFacade.java:109)
at com.cognos.cubics.providers.cubingservices.CSStatement.execute(CSStatement.java:156)
at com.ibm.cubeservices.mdx.v5.V5RequestHandler.handleRequest(V5RequestHandler.java:59)
at com.ibm.cubeservices.mdx.comms.Servlet.processMessage(Servlet.java:128)
at com.ibm.cubeservices.mdx.comms.ComWorker.processQueryInputMsg(ComWorker.java:347)
at com.ibm.cubeservices.mdx.comms.ComWorker.processInput(ComWorker.java:252)
at com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:162)
at com.ibm.cubeservices.mdx.comms.ComWorker.call(ComWorker.java:64)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:678)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:703)
at java.lang.Thread.run(Thread.java:811)
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10205][11234][3.62.56] Null userid is not supported. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.fd.a(fd.java:676)
at com.ibm.db2.jcc.am.fd.a(fd.java:60)
at com.ibm.db2.jcc.am.fd.a(fd.java:103)
at com.ibm.db2.jcc.t4.b.E(b.java:1971)
at com.ibm.db2.jcc.t4.b.g(b.java:1978)
at com.ibm.db2.jcc.t4.b.c(b.java:716)
at com.ibm.db2.jcc.t4.b.b(b.java:703)
at com.ibm.db2.jcc.t4.b.a(b.java:389)
at com.ibm.db2.jcc.t4.b.<init>(b.java:318)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:460)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnect(JDBCConnection.java:510)

Thanks