tJasperReportExec Unknown Column Name error

Five Stars

tJasperReportExec Unknown Column Name error

Hello,

 

I'm struggling with a jasper report, It runs just fine in jasper studio, but it fails in Talend. The report takes in a CSV file that is generated from an Oracle query. 

 

I've read several threads which seem to suggest that my jdbc driver versions are out of sync but I have no idea how to confirm or deny that this is the case.

 

The message I get is:

 

Exception in component tJasperReportExec_1 (Report_output_exec)
net.sf.jasperreports.engine.JRException: Unknown column name: OBJECT_NAME......

 

Could someone please guide me in determining the jdbc versions that I am using?

 

Thanks!

Tags (1)

Accepted Solutions
Five Stars

Re: tJasperReportExec Unknown Column Name error

I was able to fix this by adding column headers to my CSV file and then checking the checkbox on the tJasperReportExec object to use the header line for column names.

 

report_fix.png


All Replies
Five Stars

Re: tJasperReportExec Unknown Column Name error

I was able to fix this by adding column headers to my CSV file and then checking the checkbox on the tJasperReportExec object to use the header line for column names.

 

report_fix.png

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read