invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT39262 Status: Closed

WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS
$INDEXSTATS

product:
DB2 CONNECT / DB2CONNCT / B50 - DB2
Problem description:
WireListener throws exception when aggregate pipeline contains
$indexStats as in below command:

db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$indexSta
ts":{}}],"cursor":{"batchSize":1000}})

For above command, wire listener logs below exception message:

An exception has been thrown: java.lang.RuntimeException :
CDJSN0101E Execution failed in the following expression:
"$indexStats"
at
com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQueryAna
lyzer.java:126)
at
com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQuery
Analyzer.java:58)
at
com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuilder.
java:269)
at
com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggregate.
java:189)
at com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278)
at
com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.java:
4537)
at
com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(DB2Ag
gregationHelper.java:90)
at
com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java:468)
at com.ibm.nosql.driver.opMessage.Message(opMessage.java:183)
at
com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage(NoSQ
LInboundLink.java:430)
at
com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQLInbo
undLink.java:196)
at
com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestComplete(
WorkQueueManager.java:551)
at
com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQu
eueManager.java:601)
at
com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(WorkQu
eueManager.java:948)
at
com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQ
ueueManager.java:1027)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
utor.java:1156)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
cutor.java:626)
at
com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThreadPoo
l.java:282)
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* When mongo clients communicate with IBM JSON/NoSQL Wire      *
* Listener.                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* WireListener throws exception when aggregate pipeline        *
* contains                                                     *
* $indexStats as in below command:                             *
*                                                              *
* db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$inde *
* xSta                                                         *
* ts":{}}],"cursor":{"batchSize":1000}})                       *
*                                                              *
* For above command, wire listener logs below exception        *
* message:                                                     *
*                                                              *
* An exception has been thrown: java.lang.RuntimeException :   *
* CDJSN0101E Execution failed in the following expression:     *
* "$indexStats"                                                *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQuer *
* yAna                                                         *
* lyzer.java:126)                                              *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQ *
* uery                                                         *
* Analyzer.java:58)                                            *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuil *
* der.                                                         *
* java:269)                                                    *
* at                                                           *
* com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggreg *
* ate.                                                         *
* java:189)                                                    *
* at                                                           *
* com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278)   *
* at                                                           *
* com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.j *
* ava:                                                         *
* 4537)                                                        *
* at                                                           *
* com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(D *
* B2Ag                                                         *
* gregationHelper.java:90)                                     *
* at                                                           *
* com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java: *
* 468)                                                         *
* at                                                           *
* com.ibm.nosql.driver.opMessage.Message(opMessage.java:183)   *
* at                                                           *
* com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage( *
* NoSQ                                                         *
* LInboundLink.java:430)                                       *
* at                                                           *
* com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQL *
* Inbo                                                         *
* undLink.java:196)                                            *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestCompl *
* ete(                                                         *
* WorkQueueManager.java:551)                                   *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(Wo *
* rkQu                                                         *
* eueManager.java:601)                                         *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(Wo *
* rkQu                                                         *
* eueManager.java:948)                                         *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(W *
* orkQ                                                         *
* ueueManager.java:1027)                                       *
* at                                                           *
* java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool *
* Exec                                                         *
* utor.java:1156)                                              *
* at                                                           *
* java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo *
* lExe                                                         *
* cutor.java:626)                                              *
* at                                                           *
* com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThrea *
* dPoo                                                         *
* l.java:282)                                                  *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 version 11.5.7.1 or later versions.           *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* When mongo clients communicate with IBM JSON/NoSQL Wire      *
* Listener.                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* WireListener throws exception when aggregate pipeline        *
* contains                                                     *
* $indexStats as in below command:                             *
*                                                              *
* db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$inde *
* xSta                                                         *
* ts":{}}],"cursor":{"batchSize":1000}})                       *
*                                                              *
* For above command, wire listener logs below exception        *
* message:                                                     *
*                                                              *
* An exception has been thrown: java.lang.RuntimeException :   *
* CDJSN0101E Execution failed in the following expression:     *
* "$indexStats"                                                *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQuer *
* yAna                                                         *
* lyzer.java:126)                                              *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQ *
* uery                                                         *
* Analyzer.java:58)                                            *
* at                                                           *
* com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuil *
* der.                                                         *
* java:269)                                                    *
* at                                                           *
* com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggreg *
* ate.                                                         *
* java:189)                                                    *
* at                                                           *
* com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278)   *
* at                                                           *
* com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.j *
* ava:                                                         *
* 4537)                                                        *
* at                                                           *
* com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(D *
* B2Ag                                                         *
* gregationHelper.java:90)                                     *
* at                                                           *
* com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java: *
* 468)                                                         *
* at                                                           *
* com.ibm.nosql.driver.opMessage.Message(opMessage.java:183)   *
* at                                                           *
* com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage( *
* NoSQ                                                         *
* LInboundLink.java:430)                                       *
* at                                                           *
* com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQL *
* Inbo                                                         *
* undLink.java:196)                                            *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestCompl *
* ete(                                                         *
* WorkQueueManager.java:551)                                   *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(Wo *
* rkQu                                                         *
* eueManager.java:601)                                         *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(Wo *
* rkQu                                                         *
* eueManager.java:948)                                         *
* at                                                           *
* com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(W *
* orkQ                                                         *
* ueueManager.java:1027)                                       *
* at                                                           *
* java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool *
* Exec                                                         *
* utor.java:1156)                                              *
* at                                                           *
* java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo *
* lExe                                                         *
* cutor.java:626)                                              *
* at                                                           *
* com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThrea *
* dPoo                                                         *
* l.java:282)                                                  *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 version 11.5.7.1 or later versions.           *
****************************************************************
Comment
db2_v11571 contains fix of this issue. After the fix, error no
longer exist.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.11.2021
15.12.2021
15.12.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10