Error in exporter Sql Server to CSV File JasperSoft ETL

0

Hi, I´m trying export table from Sql Server to CSV File in JasperReport ETL

My error:

 

Failed to generate code.Preview error. Some settings must be changed.Note: Preview errors are generally due to a wrong encoding setting. org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(Unknown Source)org.talend.repository.ui.utils.ShadowProcessHelper.getCsvArray(Unknown Source)org.talend.repository.ui.wizards.metadata.connection.files.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(Unknown Source)org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(Unknown Source)

xandepir's picture
Joined: Jul 30 2015 - 5:14am
Last seen: 4 years 5 months ago

Try export for Excel but other error:

xandepir - 4 years 5 months ago

4 Answers:

0

Try outputting to tLogRow to check if MS SQL Input is reading data.

hozawa's picture
57670
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
0

Hi hozawa,  thks for help me ok! I try with tLogRow but nothing the error :

xecution failed : Failed to generate code.
[JET initialisation Time Out]
Job teste ended at 09:23 26/08/2015. [exit code=0]
 
Obs.: Sorry I don´t speak and write english, rsrsrs, I am Brazilian.
 
thks.

 

xandepir's picture
Joined: Jul 30 2015 - 5:14am
Last seen: 4 years 5 months ago
0

That means you have an error is SQL Server setting. I'm not sure how you've set it.

hozawa's picture
57670
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
0

Hi Hozawa, thanks very much for help me, I removed Java 8 and install Java 7 and now all it´s ok! 

thks.

 

xandepir's picture
Joined: Jul 30 2015 - 5:14am
Last seen: 4 years 5 months ago
Feedback