Unable To Call String Type Series In Demantra Worksheet (Doc ID 1349529.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Apr-2017***

Symptoms


On : 7.3.0.1 version,

When attempting to open a worksheet with a String series, getting the below message
'Selected page item has no data' or
'Page loading was canceled'. After removing this series the worksheet is working perfectly.

In collaborator.log file
the following error occurs.

ERROR
-----------------------
[AJPRequestHandler-HTTPThreadGroup-5] ERROR tunnel.general: ODPM-70106: Task[55] encountered error in the facade code
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: com.demantra.applicationServer.appServerExceptions.InvalidValue: ODPM-10066: Value is incorrect.ODPM-70367: Invalid Loaded Value: expect Number for Number Expression Type.
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:141)
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:108)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.demantra.applicationServer.appServerExceptions.InvalidValue: ODPM-10066: Value is incorrect.ODPM-70367: Invalid Loaded Value: expect Number for Number Expression Type.
at com.demantra.applicationServer.metaDataObjects.query.queryData.AbstractSubCombData.validateNumber(AbstractSubCombData.java:426)
at com.demantra.applicationServer.metaDataObjects.query.queryData.AbstractSubCombData.addValue(AbstractSubCombData.java:78)
at com.demantra.applicationServer.services.queryrun.LoaderTask.addSeriesValues(LoaderTask.java:273)
at com.demantra.applicationServer.services.queryrun.LoaderTask.setData(LoaderTask.java:146)
at com.demantra.applicationServer.services.queryrun.LoaderTask.execute(LoaderTask.java:84)
at com.demantra.common.queue.QueueTask.run(QueueTask.java:55)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748)
... 1 more



In Java console output the following error occurs.

ERROR
-----------------------
[Get_Meta_Data_Thread] INFO dpweb.query.data :: ODPM-50008: Note: Query CRP2 - Extra Promotion Data Analysis loaded, contains 0
combinations
java.lang.NumberFormatException: For input string: "E30364"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)
at java.text.DigitList.getLong(Unknown Source)
at java.text.DecimalFormat.parse(Unknown Source)
at java.text.SimpleDateFormat.subParse(Unknown Source)
at java.text.SimpleDateFormat.parse(Unknown Source)
at java.text.DateFormat.parse(Unknown Source)
...

[AWT-EventQueue-0] ERROR collaborator.querywizard.wizard :: ODPM-70219: Error in loading Filters panel
java.lang.NumberFormatException: For input string: "E30364"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Long.parseLong(Unknown Source)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a series which has Alpha numeric values (ie, Data type is String) and it resides in Sales_data table
2. create a worksheet with this String series
3. got 'Selected page item has no data'
4. remove this series and the worksheet is working perfectly.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, none of the series which has string type can be called in worksheets

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