JDBC_07 Invalid column mapping from field [closed]

asked 2019-05-28 15:02:55 -0600

KeerthiS gravatar image

Trying to load data into RDBMS from file . Getting this error - JDBC_07 - Invalid column mapping from field

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by KeerthiS
close date 2019-06-04 08:33:34.349612


Check if the mapping fields and their data types are same or not.

Maithri gravatar imageMaithri ( 2019-05-28 23:51:35 -0600 )edit

the data types of the fields are matching. Removed the Field to column mapping details. now not getting any error but data not getting loaded to the DB

KeerthiS gravatar imageKeerthiS ( 2019-05-29 08:44:58 -0600 )edit

Can you edit your question and add the table schema and a screen shot of the record from preview? Also, the full stack trace from sdc.log.

metadaddy gravatar imagemetadaddy ( 2019-05-29 09:43:18 -0600 )edit

@Maithri and @metadaddy - was able to resolve this by adding Field to column mapping details. Is it necessary to add these details, even though the column names are identical ?

KeerthiS gravatar imageKeerthiS ( 2019-05-31 09:05:59 -0600 )edit