Engine Error - DB_Command::Execute threw an exception; ORA-00936: missing expression (Doc ID 1065157.1)

Last updated on SEPTEMBER 25, 2013

Applies to:

Oracle Demantra Demand Management - Version 7.2 to 7.2 [Release 7.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2013***

Symptoms


On 7.2 in Test:

When attempting to run the Batch Engine
it fails with the following error:

ERROR
-----------------------
ERROR   DB_Command::Execute threw an exception:
ERROR   SELECT min(sales_date) datett, round(NVL (sum(nvl(ncr_ind_sad_over, ncr_ind_sad)),sum(FORE_4)),6) sales,  round(safe_devision(NVL (sum(nvl(ncr_ind_sad_over, ncr_ind_sad)),sum(FORE_4)),  , 0 ),6) price1,  round(sum(nvl(item_price,0)),6) ,  round(sum(nvl(item_price,0)),6) ,  round(sum(nvl(item_price,0)),6) , sqrt(avg (power (nvl (decode(obs_error_std,0,1,obs_error_std),1),2))), nvl(sum(nvl(UP_TIME,1)),1)
FROM SDE_1
WHERE t_ep_ncr_prod_rge_EP_ID = ? AND t_ep_ls3_EP_ID = ?
GROUP BY sales_date
ORDER BY 1
ERROR   - ErrorDescription: ORA-00936: missing expression

ERROR   - ErrorNumber: 0x80040e14 - Undefined Error.
ERROR   - NativeErrorNumber: 936
ERROR   - ErrorDescription: One or more errors occurred during processing of command.
ERROR   - ErrorNumber: 0x80040e14 - Undefined Error.
ERROR   - NativeErrorNumber: 0
ERROR   Parameter 0 :  1
ERROR   Parameter 1 :  5
ERROR Tree Iterator Failed! BranchID=2. Node [4,1,5]
ERROR Engine on machine LOCALHOST failed to execute successfully. HRESULT=0x80004005 - Unspecified error

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Demantra.
2. Run the Batch Engine

BUSINESS IMPACT
-----------------------
Cannot run the Engine.

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