A New Integration Interface Profile Errors When Importing Data - Failed To Load Proportions java.sql.SQLException: Invalid column name

(Doc ID 461782.1)

Last updated on OCTOBER 22, 2012

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Feb-2011***


Symptoms

On 7.1.1 in Test:
Users created an Import Integration Profile called Load Cust Fcst:
Presentation type = Code
Integration type = Import
Series = Cust Fcst
Load Option = Override
Purge Option = No Purge
Time Scale = Month
Time Filter = Relative
From Date = 10/01/2007
To Date = 10/01/2009

They've chosen several item/location levels. No filters are selected.
Import to Forecast = Insert New Combinations
Split Proportions = Matrix Combinations
Table name = BIIO_Load_Cust_Fcst

They created a single Workflow Transfer Step with Type = Import

They execute the workflow, but it does not complete successfully and shows an error message in the
Collaborator Workbench. The Collaborator.log shows the error information in detail as follows:

2007-10-01 12:10:05,621 [Update_1] ERROR appserver.update.process :: Failed to load proportions.
Update Data: Id: 1, User: dm, WS: 480, Update Table: SALES_DATA, Combination:
L424M24L510M1792L488M1L13M1L425M1L497M1L426M1L22M1L19M1
SELECT SUM(GLOB_PROP) AS GLOB_PROP
,SUM((CASE WHEN SALES_DATE <= ? THEN GLOB_PROP ELSE NULL END)) AS GLOB_PROP_HIST
,SUM((CASE WHEN SALES_DATE > ? THEN GLOB_PROP ELSE NULL END)) AS GLOB_PROP_FORE
,COUNT(1) AS COUNT
,COUNT((CASE WHEN SALES_DATE <= ? THEN 1 ELSE NULL END)) AS COUNT_HIST
,COUNT((CASE WHEN SALES_DATE > ? THEN 1 ELSE NULL END)) AS COUNT_FORE
FROM T_UPDATE_387_1191262165396
WHERE SALES_DATE >= ?
AND SALES_DATE <= ?
2007-10-01 12:10:05,621 [Update_1] ERROR appserver.update.process ::
java.sql.SQLException: Invalid column name (there is more below this but this appears to be the
pertinent informaiton

STEPS
The issue can be reproduced at will with the following steps:
1. Create an import integration profile
2. Create a Transfer Step Workflow to run the import integration profile
3. Run the workflow
4. Review the error message in the Collaborator Workbench and collaborator.log

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