[resolved] Exception in component tMSSqlOutput_1 - java.lang.NullPointerException

[Anonymous]

Hi,
All my columns are nullable. I am trying to insert the stats into a SQL table where it is throwing me off.
Exception in component tMSSqlOutput_1
java.lang.NullPointerException
 at vbps.batch_0_1.Batch.tStatCatcher_1Process(Batch.java:2024)
 at vbps.batch_0_1.Batch.runJobInTOS(Batch.java:2729)
 at vbps.batch_0_1.Batch.main(Batch.java:2519)
Exception in component tMSSqlOutput_1
java.lang.NullPointerException
 at vbps.batch_0_1.Batch.tStatCatcher_1Process(Batch.java:2024)
 at vbps.batch_0_1.Batch.tMSSqlConnection_1Process(Batch.java:509)
 at vbps.batch_0_1.Batch.runJobInTOS(Batch.java:2738)
 at vbps.batch_0_1.Batch.main(Batch.java:2519)
Exception in component tMSSqlOutput_1
java.lang.NullPointerException
 at vbps.batch_0_1.Batch.tStatCatcher_1Process(Batch.java:2024)
 at vbps.batch_0_1.Batch.runJobInTOS(Batch.java:2766)
 at vbps.batch_0_1.Batch.main(Batch.java:2519)

Can you please help me understand what I am doing incorrectly?
Regards,
Namrata

[Anonymous · Accepted solution]

I had tried with a new SQL connection that connects to the MSSQLOutput using the Use existing connection, but it had still failed.
What worked is, using the Repository connection and getting all connection components in the form of contexts (instead of use existing connection). Now it works fine.
Thanks for all your help.
Regards,
Namrata

[Anonymous]

Hi Namrata,
Thanks for your feedback. Can we consider this topic as resolved?
Best regards
Sabrina