Error in loading to table
Moderators: chulett, rschirm, roy
Error in loading to table
Hi guys ,,
i get the following error when i try to load to table using ORacle Enterprise stage. If i do Upsert it will load .i am using ODBC table definition here in the OE stages.
Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:112
can you guys help me.thanks in advance
i get the following error when i try to load to table using ORacle Enterprise stage. If i do Upsert it will load .i am using ODBC table definition here in the OE stages.
Error when checking composite operator: Caught parsing exception during wrapDescribeOperator(): Could not find type: oratype:112
can you guys help me.thanks in advance
Regards,
Deepu
Deepu
Re: Error in loading to table
Don't. They're not necessarily compatible. Import the metadata using one of the Oracle mechanisms, use that.deepu_n55 wrote:i am using ODBC table definition here in the OE stages.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Error in loading to table
I even tried to use the regular metadata for oracle . still doesnt work . may be problem with the datatype CLOB that i have for two of the fields in the Target table. if i do the upsert it works fine but takes long to load the table. any work around for this? thank you
Regards,
Deepu
Deepu
Re: Error in loading to table
There must be a problem with your schema. Check the tgt schema and table schema to which you are inserting data.
Also, make sure you have all non nullable fields populated.
Also, make sure you have all non nullable fields populated.
Re: Error in loading to table
Thank you Sandeep . I have taken care of all the non nullable fields and checked the schema for target. Its still throwing the same error. and if i do using UPSERT it will load but its gonna take years to load this couple of millions records into the target table .any suggestions guys.? i appreciate you all.
Regards,
Deepu
Deepu
-
- Premium Member
- Posts: 145
- Joined: Fri Sep 21, 2007 9:35 am
- Location: Boston
Re: Error in loading to table
Then I dont see any reason, why its failing. Try aruna's suggestion. Thats a good tip too. also, if its ok Try doing it for few records in sandbox first before handling millions of records.
Re: Error in loading to table
Thank you Aruna and Sandeep,
I tried using ODBC stage and use Insert as aruna suggested. but i get following error msg.
APT_CombinedOperatorController,0: Failure during execution of operator logic.
APT_CombinedOperatorController,0: Fatal Error: Not bounded length.
anyone could help me on this .. i really appreciate .
I tried using ODBC stage and use Insert as aruna suggested. but i get following error msg.
APT_CombinedOperatorController,0: Failure during execution of operator logic.
APT_CombinedOperatorController,0: Fatal Error: Not bounded length.
anyone could help me on this .. i really appreciate .
Regards,
Deepu
Deepu