Error in exporter Sql Server to CSV File JasperSoft ETL

Posted on August 25, 2015 at 5:57am

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)

Jaspersoft® ETL
xandepir's picture
xandepir
20
Joined: Jul 30 2015 - 5:14am
Last seen: 7 years 9 months ago

Try export for Excel but other error:

xandepir - 7 years 9 months ago
add comment

4 Answers:

Posted on August 25, 2015 at 12:44pm

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

hozawa's picture
hozawa
177041
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on August 26, 2015 at 5:26am

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
xandepir
20
Joined: Jul 30 2015 - 5:14am
Last seen: 7 years 9 months ago
Posted on August 31, 2015 at 12:16am

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

hozawa's picture
hozawa
177041
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on August 31, 2015 at 8:16am

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
xandepir
20
Joined: Jul 30 2015 - 5:14am
Last seen: 7 years 9 months ago
Feedback
randomness