java.lang.NullPointerException while runnig the job through batch job

Four Stars

java.lang.NullPointerException while runnig the job through batch job

Hi ,

 

I have designed the job in Talend 6.3 Open source , job is running successfully through Open source , but same job I have used to build the job option and run the job through windows batch file as the below error is encountered.Hence, please do needful me further processing.

 

C:\PROD\Ext_SOFT_Location_Master>java -Xms256M -Xmx1024M -cp .;../lib/routines.jar;../lib/log4j-1.2.16.jar;../lib/ojdbc6.jar;../lib/dom4j-1.6.1.jar;../lib/mysql-connector-java-5.1.
30-bin.jar;../lib/tns.jar;../lib/talend-oracle-timestamptz.jar;ext_soft_location_master_0_1.jar; eat_bi.ext_soft_location_master_0_1.Ext_SOFT_Location_Master --context=PRODUCTION
--context_param MSSQLHostName= --context_param MSSQLPassword= --context_param MSSQLPortNumber= --context_param MSSQLSchema= --context_param MSSQLUserName= --context_param mysql_end
_date=2017-01-02 --context_param mysql_start_date=2017-01-02 --context_param MySqlDatabase=slkbi_prd --context_param MySqlHostName=127.0.0.1 --context_param MySqlPassword=Talend@12
3 --context_param MySqlPortNumber=3306 --context_param MySqlSchema=slkbi_prd --context_param MySqlUserName=TALEND_BI --context_param Oracle_end_date=31-JAN-2017 --context_param Ora
cle_start_date=1-JAN-2017 --context_param OracleDatabase=PROD --context_param OracleHostName=erpoda1.slksoft.com --context_param OraclePassword=Nuc13usA99s --context_param OraclePo
rtNumber=1528 --context_param OracleSchema=apps --context_param OracleUserName=apps
Exception in component tMysqlOutput_1
java.lang.NullPointerException
        at eat_bi.ext_soft_location_master_0_1.Ext_SOFT_Location_Master.tOracleInput_1Process(Ext_SOFT_Location_Master.java:1215)
        at eat_bi.ext_soft_location_master_0_1.Ext_SOFT_Location_Master.tOracleConnection_1Process(Ext_SOFT_Location_Master.java:720)
        at eat_bi.ext_soft_location_master_0_1.Ext_SOFT_Location_Master.runJobInTOS(Ext_SOFT_Location_Master.java:2336)
        at eat_bi.ext_soft_location_master_0_1.Ext_SOFT_Location_Master.main(Ext_SOFT_Location_Master.java:2025)

C:\PROD\Ext_SOFT_Location_Master>

 

Ten Stars

Re: java.lang.NullPointerException while runnig the job through batch job

If that's not a scrubbed command line, you're setting context variables to null that are likely used to connect to a database. Without a database connection, any components relying on the connection component will throw a null pointer exception.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now