What's causing ODBC error?

I'm a newbie to Scribe.

 

My source is Dynamics365. Destination is iSeries (AS400) DB2. The destination table was created with DDS, not SQL and has no default values assigned. I did not map all columns in the destination file. The connector is the latest ODBC driver supplied by IBM. When I try to run my (very simple) script I get the ODBC error below. One of my coworkers suggested the SQL syntax under the covers might be the culprit - but we can't figure out how to display that in the debugger. Any suggestions would be appreciated.

 

RECORD FAILURE DETAILS

===============================

Run started at Thu Apr 19 2018

Solution Instance Name: CRM to AS400 test

Map Name:        Hello World

Source Entity:      contact

Error title:       Error in calling Operation Y2K_MEP190ROUpdateInsert

Error description:    Operation failed. Label: Update/Insert Y2K_MEP190RO, Name: Y2K_MEP190ROUpdateInsert, Message: ERROR [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token DEFAULT was not valid. Valid tokens: : <INTEGER>.: Error in calling Operation Y2K_MEP190ROUpdateInsert  at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
  at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
  at Scribe.Connector.Ado.DataAccess.AdoDataAccess.ExecuteInsertInternal(String query, Dictionary`2 rowData)
  at Scribe.Connector.Ado.DataAccess.AdoDataAccess.ExecuteInsert(String query, Dictionary`2 rowData)
  at Scribe.Connector.Ado.Operations.InsertOperation.Execute(OperationInput operationInput)________________________________

 

Source Record ID:    131241006426240201

Process Execution ID:  14caeadc-9701-4b7f-a526-4b84a2285899

Record ID:        131241006426240201

 

=============================== Source Data ==============================

 

Entity:                 contact

 

Field                  Value

bpt_memberid              1000039

acbl_unitidname             109 - Richmond Bridge Association

address1_city              Richmond

address1_stateorprovince        VA

acbl_districtidname           6

address1_postalcode           232345546

contactid                960ae598-a5c7-e711-a950-000d3a11ec14

address1_country            US

address1_line1             3911 Meadowdale Blvd

 

(1) Answer

Login