Worksheet data can't be shown . Please contact a administrator to review system log files for details - ODPM-70016: Error loading query from Application Server (Doc ID 2056156.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version, Worksheet

When attempting to open any worksheet
the following error occurs.

ERROR
-----------------------
"Worksheet data can't be shown . Please contact a administrator to review system log files for details"

In collaborator.log file the following error occurs:

"

2015-09-15 04:24:45,727 IST [DataRunner_0] ERROR query.run: ODPM-70016: Error loading query from Application Server:java.lang.IllegalArgumentException: Core threads must have nonzero keep alive times
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.lang.IllegalArgumentException: Core threads must have nonzero keep alive times
    at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setQueryData(QueryDataHandler.java:292)
    at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setWorksheetData(QueryDataHandler.java:269)
    at com.demantra.applicationServer.services.queryrun.BaseQueryDataHandler.loadQueryData(BaseQueryDataHandler.java:140)
    at com.demantra.applicationServer.services.queryrun.QueryDataHandler.loadQueryData(QueryDataHandler.java:148)
    at com.demantra.applicationServer.services.queryrun.BaseDataRunner.loadQueryData(BaseDataRunner.java:85)
    at com.demantra.applicationServer.services.queryrun.BaseDataRunner.setData(BaseDataRunner.java:70)
    at com.demantra.applicationServer.services.queryrun.ExtendedDataRunner.run(ExtendedDataRunner.java:107)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Core threads must have nonzero keep alive times
    at java.util.concurrent.ThreadPoolExecutor.allowCoreThreadTimeOut(ThreadPoolExecutor.java:1645)
    at com.demantra.applicationServer.pools.thread.ThreadPoolFactory.createExecutor(ThreadPoolFactory.java:179)
    at com.demantra.applicationServer.pools.thread.ThreadPoolFactory.createExecutor(ThreadPoolFactory.java:146)
    at com.demantra.applicationServer.pools.thread.ThreadPoolFactory.createPool(ThreadPoolFactory.java:77)
    at com.demantra.applicationServer.pools.thread.ThreadPoolFacade.getExecutor(ThreadPoolFacade.java:82)
    at com.demantra.applicationServer.services.queryrun.BaseQueryDataHandler.getExecutor(BaseQueryDataHandler.java:100)
    at com.demantra.applicationServer.services.queryrun.QueryDataHandler.getDataLoader(QueryDataHandler.java:476)
    at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setQueryData(QueryDataHandler.java:284)
    ... 7 more
"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench
2. Try to open any worksheet.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms