Talend community forum / tFilterRow - Error running job from cmd on other server

ienax_ridens · 2012-05-18 10:29:51

Tags: [context, database, mssql, null pointer exception, positional file, tfilterrow]

Hi all,
I have a problem (for sure it is simple to solve) that is driving me crazy:

I've done a VERY simple job, that works perfectly on local server, running it from TOS. [Job_schema.png]

Instead when I run the job on the customer server I have the error "null pointer exception". I tried to put tLogRow (instead of tFileOutputExcel) to check where is the problem: as you can see, tLogRow is correctly populated with the right data and then I have the error on tFilterRow; using tFileOutputExcel data are not put into the file, but I have the same error. [run_from_cmd_customer_server.png]

Please help me...I'm loosing 2 days for a stupid error...

Uploaded Images

Last edited by ienax_ridens (2012-05-18 11:09:10)

pedro · 2012-05-18 10:37:13

Hi

Please show us the settings of tFilterRow and tMap.
The info from these two images is limited.

Regards,
Pedro

ienax_ridens · 2012-05-18 11:11:58

Ok, also tMap and tFilter setting attached.

Additional notes: I tried also to put tLogRow as tMap output and all is ok, input data are correct. And even putting tLogRow as tFilter output, using filtered rows (not discarded rows) the data output are ok, even if I hv the same error.

My doubts: could it be an error related to the context settings? Even if I think it is strange because the difference are that on local server I use network paths for files, insted in the context on customer server I put local paths.

Last edited by ienax_ridens (2012-05-18 11:15:05)

ienax_ridens · 2012-05-21 09:15:02

No ideas?

pedro · 2012-05-21 09:33:26

Hi

According to these images and your description, it seems everything is ok.
In fact, I created a job from your scenario and failed to reproduce this issue.

Only one thing is a little weird. That's the expression of 'Advanced mode' on tFilterRow.
Usually the code is input_row.columnName while yours is Filtro_PV.

Regards,
Pedro

ienax_ridens · 2012-05-21 09:46:10

Ok, thanks Pedro!

I thing the way I will try, will be to re-build the job from white sheet...it is not complex and it is possible I will resolve.

Thanks again

Announcement

Unanswered posts

#1 2012-05-18 10:29:51

tFilterRow - Error running job from cmd on other server

#2 2012-05-18 10:37:13

Re: tFilterRow - Error running job from cmd on other server

#3 2012-05-18 11:11:58

Re: tFilterRow - Error running job from cmd on other server

#4 2012-05-21 09:15:02

Re: tFilterRow - Error running job from cmd on other server

#5 2012-05-21 09:33:26

Re: tFilterRow - Error running job from cmd on other server

#6 2012-05-21 09:46:10

Re: tFilterRow - Error running job from cmd on other server

Board footer