Error with Mapping component

One Star

Error with Mapping component

Hello -

I'm a newbie with the Talend product. I was learning by using a simple ETL data transformation from some delimited file to an MSSQL 2008 database.

I keep getting the following issue, only after I add a mapping component and the DB out component. If I output from the ReplaceList to a logrow, it works without error and my data looks correct.

My row1 output does not, nor never has had a Manufacturer column. It does have one called MFR, but that is getting mapped to Manufacturer in the database.

I appreciate the help -

Error:
[statistics] connecting to socket on port 4224
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
row1.Manufacturer cannot be resolved or is not a field
inputFlow_tReplaceList_1_Manufacturer cannot be resolved
Type mismatch: cannot convert from String to Integer
Type mismatch: cannot convert from Character to String
Type mismatch: cannot convert from BigDecimal to Short
Type mismatch: cannot convert from Character to String

at mg_vendor_pricing.mal_import_pricelist_0_1.MAL_Import_pricelist.tFileInputDelimited_1Process(MAL_Import_pricelist.java:2643)
[statistics] connected
at mg_vendor_pricing.mal_import_pricelist_0_1.MAL_Import_pricelist.runJobInTOS(MAL_Import_pricelist.java:4204)
at mg_vendor_pricing.mal_import_pricelist_0_1.MAL_Import_pricelist.main(MAL_Import_pricelist.java:4097)
Job MAL_Import_pricelist ended at 15:33 01/03/2010. [exit code=0]
Community Manager

Re: Error with Mapping component

Hello guy
Exception in thread "main" java.lang.Error: Unresolved compilation problems:

There is a compilation error in the generated code, open the 'Code' tag, you will see there is a red 'x' on the left side of the error line. You need correct the compilation error first.

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER 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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog