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>

 

1 REPLY
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.