tOracleOutput java.lang.NullPointerException

[vidya821]

Hi,

i am facing the below issue while loading the table with input file

Exception in component tOracleOutput_1 (import_contract)

java.lang.NullPointerException

at sun_project.import_contract_0_1.import_contract.tFileInputDelimited_1Process(import_contract.java:1489)

at sun_project.import_contract_0_1.import_contract.runJobInTOS(import_contract.java:2937)

at sun_project.import_contract_0_1.import_contract.main(import_contract.java:2703)

Can someone give any pointers to check the issue

Thanks

[vidya821]

Hi,

My issue was wrt to oracle connection, the tOracleOutput_1 component was not connected to a DB,
however your issue seems to be with the incorrect syntax, the issue might not be with the tOracleOutput component as per the détails you provided.
The exception is caused in the tOracleOutput component due to issues in some other component.
Also check if the data type for some of the data sent from MongoDB to Oracle DB might differ.
share the screenshot if possible to work it out.
Thanks

[Anonymous]

Find Snap of component  and run tab-

Let me know what is issue here.

Thanks,

[vidya821]

1) tOracleOutput should be connected to a database connection tOracleConnection.
2) use tMap component to map the data between two connections, this way u will be sure that the data types is matched between tables
Thanks

[Anonymous]

Thank you vidya. Its really helpful

Regards,

Ravi

[Anonymous]

Thanks so much