Hello all.
I am attempting to output data into an Oracle table. I have successfully connected to the database and I can view my data using tLogRow, but I'm getting an error message when attempting to use tOracleOutput to add rows to an existing table in our database.
connecting to socket on port 4065
connected
Exception in component tOracleOutput_1
java.lang.NullPointerException
at local_project.mbrsepmstr_0_1.mbrsepmstr.tFileInputDelimited_1Process(mbrsepmstr.java:8797)
at local_project.mbrsepmstr_0_1.mbrsepmstr.runJobInTOS(mbrsepmstr.java:16667)
at local_project.mbrsepmstr_0_1.mbrsepmstr.main(mbrsepmstr.java:16501)
: local_project.mbrsepmstr_0_1.mbrsepmstr - tOracleOutput_1 null
disconnected
From the error, I gather that something is Null that should not be, but I can not figure out what it is. Our database setup does not allow null values in the particular table being written, but when I look at the data in tLogRow, I do not see any null values.
Any tips on how to figure out what is causing the error would be appreciated.
Thanks.
Got this working. Not sure what the problem was, but I solved it by deleting the tOracleOutput and re-creating it. I must have had a setting wrong in it. Thanks.
