Support Article
Data Adapter Error
SA-11897
Summary
The makeDecision request to RTDS fails and following exception is reported in the logs-
PropertyColum E com.kiq.omega.ods.core.PropertyColumnEvaluator fillDCSColumns Data adapter error.
com.chordiant.dm.ddc.DataAdapterException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Error Messages
PropertyColum E com.kiq.omega.ods.core.PropertyColumnEvaluator fillDCSColumns Data adapter error.
com.chordiant.dm.ddc.DataAdapterException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Steps to Reproduce
Perform makeDecision() request and ORA-00942: table or view does not exist error observed.
Root Cause
The database grant priviliges was not given to the table(s) which are configured in Data Contract Service(DCS) file.
Resolution
Necessary privileges granted to the required table(s) configured in the DCS file.
Published July 8, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.