Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Missing Parameter Exception

783453Dec 30 2010 — edited Dec 30 2010

Hi,
I have customized CKM and the commands are as follows:
Source:

select ROW_ID row_id from <%=odiRef.getTable("L","ERR_NAME", "W")%> where CONS_TYPE='FK'
and Session_id='#PVN_SESSION_ID'

Target:

insert into odi_stage.xxodi_error_details
(
ROW_ID,
SESSION_ID,
INTERFACE_NAME,
CONSTRAINT_NAME,
ERROR_CODE,
ERROR_MESSAGE

)
values
(
:row_id,
'#PVN_SESSION_ID',
'#PVV_INTERFACE_ALIAS',
'<%=odiRef.getFK("FK_NAME")%>',
'FK-001',
'<%=odiRef.getFK("MESS")%>'
)

When I execute it, it throws:
com.sunopsis.sql.SnpsMissingParametersException: Missing parameter

at com.sunopsis.sql.SnpsQuery.completeHostVariable(SnpsQuery.java)

at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)

at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
Any pointers will be appreciated.

Thanks,
Ritika

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2011

Added on Dec 30 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

2 comments

232 views