Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend studio 6.2.1 failed to read unix file

We started using talend studio with 6.2.1 version and job server running on Linux machine.

 

When we create small job as below

 

tFileinputdelimted  --> tLogRow   (while Filename in tFileinputdelimted   in "/tmp/test.dat" unix file)

While in Run --> Target Exec point to Linux server where above file reside.

We are able to run job successfully while pointing to local system but failed to build or run job with remote server. Please let us know how to validate unix connection or debug issue.

 

Issue:

Execution failed : java.lang.Exception: Job was not built successfully, please check the logs for more details

[Job was not built successfully, please check the logs for more details]

 

Java log:

 



To see the whole post, download it here
Labels (4)
1 Solution

Accepted Solutions
KB_Parpally
Contributor II
Contributor II

Hi Xdshi,

 

Thanks for your quick response,

 

i fond the issue and solved it,

 

  1. Goto Preferences >> Java >> Installed JRE's
  2. Click Add and browse to \Program Files\Java\jdk1.8.0_151
    1. In my case the "Location" variable for the jre did not change but the "Name" variable for the jre in this dialog box did.  I am not sure the impact of this but it is the only thing that appears to have changed.  Who knows, maybe "refreshing" this variable is the key.
  3. Click OK and then set the newly added jre as the default.  
  4. Click OK, say a small prayer and run a job.

For reference i have attached the log file 

 

thanks,

Advance Happy New year.


ATT31661.log

View solution in original post

14 Replies
bhagyarekha
Creator II
Creator II

 hi

the file name for tfileinputdelimited it should be .csv right

please can you explain me your query in detail

Anonymous
Not applicable
Author

Why only csv file?

cant we read .txt or .dat file using tfileinputdelimited?

My question is i am not able to run job when i point targetexec to unix server where job server is running.

i am successful read local file (on my windows) but same job when change the targetexec to unix in Run settings talendstudio the job run failed and also failed to build the job.

Thank you
cterenzi
Specialist
Specialist

The problem is not the file's extension. Your error message is non-specific and recommends checking a log file. I don't use job server, so I'm not sure which log file it means nor where to look for it.
Anonymous
Not applicable
Author

the error message mentioned in first post which i got when build the job.

not sure where to check for any other error or log messages?
Sid3
Contributor III
Contributor III

Hi Sree,

Please check the log file under you talend workspace,

<Workspacedir>/metadata/.log.

Please post the error log from above file. we will try to help you on this
Anonymous
Not applicable
Author

!SESSION 2017-04-28 10:02:55.422 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.8.0_102
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
Command-line arguments:  -os win32 -ws win32 -arch x86_64

This is a continuation of log file \\NAEAST.AD.JPMORGANCHASE.COM\AmerXBUS$\XBUS\NANJVDIHOME20\F064681\CDS\TALEND\TS\workspace\.metadata\.bak_0.log

Created Time: 2017-04-28 10:37:20.823

!ENTRY org.talend.platform.logging 1 0 2017-04-28 10:37:20.831
!MESSAGE 2017-04-28 10:37:20,756 INFO  org.talend.commons.exception.CommonExceptionHandler  - The download URL for spark-streaming-kinesis-asl-assembly_2.10-1.5.0.jar is not available


!ENTRY org.talend.platform.logging 1 0 2017-04-28 10:37:20.847
!MESSAGE 2017-04-28 10:37:20,837 INFO  org.talend.commons.exception.CommonExceptionHandler  - The download URL for fastutil-6.5.16.jar is not available

Anonymous
Not applicable
Author

sid

please check the log let me know
Anonymous
Not applicable
Author

Hi,

You cannot read your file(relative path) from your server by using tfiledelimited component? Is your server ok with you?

Would you mind posting your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

Anonymous
Not applicable
Author

yes server okay and job server is running. other able to read using tfiledelimited.

what job setting need to take?
window--peeference--talend--remote?

please let me know