ODI-1227 & ORA-00936: missing expression
ankistJan 6 2012 — edited Jan 6 2012Hi,
I created an interface from Oracle to Essbase. But there was a error at Loading step.
I prefered staging area as Sunopsis Memory Engine, LKM SQL to SQL , IKM SQL to Essbase (data)
ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection <ServerName>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
At the problem setp Code was as below,
Source Code
select
from ODISTAGE.*****TEMP ********TEMP
where (1=1)
Target Code
insert into "C$_0****_*****Data"
(
)
values
(
)
Do you have any suggestions? Thanks...
ankist