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

[cterenzi]

This usually indicates that a variable in a setting or expression is null when the job is expecting a value. This can happen for a number of reasons. Examine the settings of the component identified in the exception, and make sure that any variables used are spelled correctly and are properly initialized with values before that component executes.

[Anonymous · Accepted solution]

Hi,

Did you use tOracleConnection compomnent in your work flow? If so, is there any connector(onsubjobok or oncomponentOk) between tOracleConnection and tOracleOutput component?

Screenshots will be helpful for us to address your issue.

Best regards

Sabrina

[vidya821]

Thanks,

i feel the issue is with the field values having values as null during the insert. because i checked with some fields having values and it worked.

could you please let me know what expression to be used in tMap to avoid this error.

[vidya821]

Hi,

Thanks, but i think issue is with the null value in some of the fields during insert.
Below is the error
Exception in component tOracleOutput_1 (import_product)
java.lang.NullPointerException
at sun_project.import_product_0_1.import_product.tFileInputDelimited_1Process(import_product.java:959)
at sun_project.import_product_0_1.import_product.runJobInTOS(import_product.java:1996)
at sun_project.import_product_0_1.import_product.main(import_product.java:1762)

and code at line 959 is
java.sql.PreparedStatement pstmt_tOracleOutput_1 = conn_tOracleOutput_1
.prepareStatement(insert_tOracleOutput_1);

[cterenzi]

@xdshi was on the mark, it appears your connection isn't initialized properly. If you're using a tOracleConnection component to set up the database connection, you need to ensure that component executes first.

[Anonymous]

Hi vidya821,

Would you mind posting your job setting screenshots into forum which will be helpful for us to address your issue quickly.

Best regards

Sabrina

[vidya821]

Yes it worked, Thanks so much

[Anonymous]

Hi,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina

[Anonymous]

Hi,

Hi , 

I am facing an issue while transfering data from mongoDB to oracle. The error message is as follows -

Exception in component tOracleOutput_1
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

I am getting this error in toracleoutput component.

Could you please where i am doing wrong.

Thanks,

Ravi