[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]

Hi Namrata,
Could you please show us your job design screenshots which will be helpful for us to diagnose your issue.
Best regards
Sabrina

[Anonymous]

Hi ndhanawade,
Can you upload your screenshot into forum? In this way, we can check it easily.
You can use "UPLOAD" or "Drop files here to attach them" option to achieve it.
Make sure your screenshot file is not bigger than 2MB.
Best regards
Sabrina

[Anonymous]

I id try that. Not sure what img extension is supported. When I upload and check back, this file cant be seen.



                                                

[Anonymous]

Hi,
Did you use tMysqlConnection component in your job? There is an error in your tMySqlOutput component.  Did you select  "Use an existing connection"? Could you please show us tMySqlOutput component setting screenshot?
Best regards
Sabrina

[Anonymous]

Here ..



Regards,
Namrata                                                                           
 

[Anonymous]

Hi,
Another piece of information that may help you with a solution --
When I used tFileOutputExcel instead of the tMSSQLOutput, I got an "advanced condition failed" in my execution window.
Like this --
Starting job TestNama at 22:02 22/04/2015.
connecting to socket on port 3908
connected
1|1|0|0|advanced condition failed
disconnected
Job TestNama ended at 22:02 22/04/2015.

[Anonymous]

hi all,
'bizarre' error ...
Advanced could be something about advanced setting perhaps.
Can you show us advanced setting of your component ?
For DB output, did you try without 'existing connection' ?

regards
laurent

[Anonymous]

Hi ndhanawade,
Is there any update for your issue?
If you are using "Use an existing connection" in tMySqlOutPut, there must be a connector(OnsubjobOk or OnComponentOK) between your tMySqlOutPut and tMySqlConnection.
Best regards
Sabrina