RCP job unable to read from oracle

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

RCP job unable to read from oracle

Post by jerome_rajan »

I have a RCP enabled job that reads from an Oracle table and loads a dataset. I have not defined any columns in the connector metadata but have RCP enabled. I get the error:

Code: Select all

The connector could not validate the input schema. Specify at least one column in the input schema
What could the reason be?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
jerome_rajan
Premium Member
Premium Member
Posts: 376
Joined: Sat Jan 07, 2012 12:25 pm
Location: Piscataway

Post by jerome_rajan »

Anyone? :roll:

Could this be an issue with the connector or am I doing something wrong?
Jerome
Data Integration Consultant at AWS
Connect With Me On LinkedIn

Life is really simple, but we insist on making it complicated.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It certainly could be an issue with the connector but you would need to involve your official support provider to verify. Out of curiosity, what version are you running? Are you current on your patches?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply