Hi,
I am using Oracle connector as source and using RCP. Job is failing with the following error.
Oracle_Connector_8: [IIS-CONN-ORA-001034] The connector could not validate the input schema. Specify at least one column in the input schema. (CC_OraRecordDataSetProducer::setDataSetDef, file CC_OraRecordDataSetProducer.cpp, line 1,809)
We cannot use RCP in Oracle connector? Anyone faced this type of issue?
Thanks,
Prashanth
Oracle Connector Stage issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Mon Jan 14, 2008 6:09 am
-
- Participant
- Posts: 23
- Joined: Mon Jan 14, 2008 6:09 am
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
Yes you could use RCP with the Oracle connector. Just keep in mind that when using RCP the connector:
- Matches columns in the select statement against the columns in the output link by name, NOT by position ( You might need use an alias to match the columns' names)
- Drop any output link columns not mapped
And a couple of others rules ....
- Matches columns in the select statement against the columns in the output link by name, NOT by position ( You might need use an alias to match the columns' names)
- Drop any output link columns not mapped
And a couple of others rules ....
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
-
- Participant
- Posts: 23
- Joined: Mon Jan 14, 2008 6:09 am
Hi JRodriguez,
i have a template job.
Oracle Connector --->Copy--->Oracle Connector
Both source and target tables having same structure in different databases. In job i am nowhere deriving any column.
we will just pass the tablename at runtime to load the data from one databse to another database using RCP.
Thanks,
Prashanth
i have a template job.
Oracle Connector --->Copy--->Oracle Connector
Both source and target tables having same structure in different databases. In job i am nowhere deriving any column.
we will just pass the tablename at runtime to load the data from one databse to another database using RCP.
Thanks,
Prashanth
Check to see if you have also applied the 3 rollup patches. I believe these came out after the fix pack. One of the 3 rollup patches was specifically for connectors.prashanth.spl wrote:updated with 8.1 fix pack recently in our AIX O/S.
Here's the patch description:
MikeRoll-up Patch 1 for Common Connectivity contains multiple fixes to the Common Connector Framework, ODBC Connector, WebSphere MQ Connector, Teradata Connector, DB2 Connector, Oracle Connector, and Connector Migration Tool components of Information Server Version 8.1, Fix Pack 1.