Provision generates diffrent column-count than a regular insert when chunks.csv contains columns

[GoogleCodeExporter]

What steps will reproduce the problem?

Setup "normal" Oracle to Mysql replication.

1. Initial config

chunks.csv
DBO,BUSINESS,1000,BU_ID, PGRP_ID, BU_PGRP_LEVEL, BU_CUR_NAME, BU_NAME, 
BU_LOCATION, BU_ADDRESS1, BU_ADDRESS2, BU_VISIT_ADDRESS, 
BU_OUR_CUSTOMER_CONTACT, BU_EMAIL, BU_COMPANY_NUMBER, BU_VAT_NUMBER, 
BU_DUE_DAYS, BU_CATEGORY, BU_PHONE, BU_FAX, BU_VISIT_POST_ID, BU_MAIN_OFFICE, 
BU_SEND_BILLS_TO, BU_EAN_NUMBER, BU_OWNER_CO, BU_ACCOUNTING_ID, BU_STATUS, 
BU_POST_ID, BU_CUST_OWNER, BU_SUBSIDIARY_OF, BU_LANG_NAME, BU_EMAIL_CARRIER, 
BU_BANK_ACCOUNT, BU_POST_ACCOUNT, BU_NEXT_INVOICE_ID, 
BU_CONSTELLATION_NUMBER,BU_INSTALLATION_NUMBER, BU_SALES_REP, BU_PROVIDER_CODE, 
BU_DISCPLAN_ID, BU_COMMENT, BU_INV_DAY, BU_SAME_DISCOUNT_AS, 
BU_ACCUMULATE_ABOVE_SEND_BILLS, BU_INVOICING_CURRENCY, BU_INVOICE_FORM_NAME, 
BU_INVOICE_TO_CFS, BU_OVERDUE_INTEREST_RATE, BU_TAX_ID,BU_ADVANCE_INVOICING, 
BU_INVOICE_INTERVAL, BU_CONF_EMAIL_FORM_NAME, BU_CONF_EMAIL_FROM_ADDRESS, 
BU_EXTERNAL_BU_ID, BU_SEND_BILLS_FROM, BU_SHORT_NAME, BU_SHORT_NAME2, 
BU_ADR_ID, BU_ABCD, BU_SALESSEGMENT, BU_SALESORGANISATION, BU_SALESCHANNEL, 
BU_INVOICE_MEDIA_TYPE,BU_HOLD_INVOICING, BU_HIDE_ADDRESS, BU_IBAN, BU_SWIFT, 
BU_FIRST_NAME, BU_MIDDLE_NAME, BU_LAST_NAME, BU_DATE_OF_BIRTH, BU_INV_MONTH, 
BU_COMMISSION_GROUP_ID, BU_INVOICE_PAYMENT_METHOD, BU_PRIORITY

2. trepctl online -provision <scn>

3. Wathc THL-logs

What is the expected output?

Expected THL:
SEQ# = 19 / FRAG# = 0
- TIME = 2015-03-19 09:40:38.0
- EPOCH# = 16
- EVENTID = ora:55432174381
- SOURCEID = 10.15.9.125
- METADATA = [service=dinabocdc;shard=DBO]
- TYPE = com.continuent.tungsten.replicator.event.ReplDBMSEvent
- SQL(0) =
 - ACTION = INSERT
 - SCHEMA = DBO
 - TABLE = BUSINESS
 - ROW# = 0
  - COL(1: BU_ID) = 258444
  - COL(2: PGRP_ID) = NULL
  - COL(3: BU_PGRP_LEVEL) = Standard
  - COL(4: BU_CUR_NAME) = NULL
  - COL(5: BU_NAME) = test
  - COL(6: BU_LOCATION) = NULL
  - COL(7: BU_ADDRESS1) = NULL
  - COL(8: BU_ADDRESS2) = NULL
  - COL(9: BU_VISIT_ADDRESS) = NULL
  - COL(10: BU_OUR_CUSTOMER_CONTACT) = NULL
  - COL(11: BU_EMAIL) = NULL
  - COL(12: BU_COMPANY_NUMBER) = NULL
  - COL(13: BU_VAT_NUMBER) = NULL
  - COL(14: BU_DUE_DAYS) = 15
  - COL(15: BU_CATEGORY) = SMB
  - COL(16: BU_PHONE) = NULL
  - COL(17: BU_FAX) = NULL
  - COL(18: BU_VISIT_POST_ID) = NULL

What do you see instead?

SEQ# = 1 / FRAG# = 0 (last frag)
- TIME = 2015-03-19 09:38:35.723
- EPOCH# = 1
- EVENTID = ora:55428430030
- SOURCEID = 10.15.9.125
- METADATA = 
[schema=DBO;table=BUSINESS;nbBlocks=137;service=dinabocdc;shard=DBO]
- TYPE = com.continuent.tungsten.replicator.event.ReplDBMSEvent
- SCHEMA = DBO
- SQL(0) = TRUNCATE TABLE BUSINESS
- SQL(1) =
 - ACTION = INSERT
 - SCHEMA = DBO
 - TABLE = BUSINESS
 - ROW# = 0
  - COL(1: BU_ID) = 2000000048
  - COL(2: PGRP_ID) = NULL
  - COL(3: BU_PGRP_LEVEL) = Standard
  - COL(4: BU_CUR_NAME) = NULL
  - COL(5: BU_NAME) = Ventelo Distribusjon
  - COL(6: BU_LOCATION) = NULL
  - COL(7: BU_ADDRESS1) = Fernanda Nissens gate 3
  - COL(8: BU_ADDRESS2) = NULL
  - COL(9: BU_VISIT_ADDRESS) = NULL
  - COL(10: BU_OUR_CUSTOMER_CONTACT) = NULL
  - COL(11: BU_EMAIL) = NULL
  - COL(12: BU_COMPANY_NUMBER) = 987421533
  - COL(13: BU_VAT_NUMBER) = NULL
  - COL(14: BU_DUE_DAYS) = 31
  - COL(15: BU_CATEGORY) = Forhandler <---------------- JUMPS FROM 15 to 17
  - COL(17: BU_PHONE) = NULL
  - COL(18: BU_FAX) = NULL
  - COL(19: BU_VISIT_POST_ID) = NULL

This result in every column shift right after the jump from 15 to 17.

What version of the product are you using?

2.2.1-312

On what operating system?

Ubuntu 12.04

Please provide any additional information below.

Original issue reported on code.google.com by krist...@dinabo.no on 19 Mar 2015 at 8:47

[GoogleCodeExporter]

You are using an old version of Tungsten Replicator. Please try with the latest 
version, which contains many bug fixes.
https://code.google.com/p/tungsten-replicator/wiki/Downloads?tm=2

Original comment by g.maxia on 19 Mar 2015 at 1:02

• Changed state: Invalid

[GoogleCodeExporter]

Wouldnt this be fixed in another version, rather than an invalid bug?

Is your answer to try a newer version and see if its fixed there?

I made a filter to fix the issue myself - which wasnt that hard. And I can't be 
the only one with this issue?

Original comment by krist...@dinabo.no on 19 Mar 2015 at 1:07

[GoogleCodeExporter]

This problem should be fixed in recent versions.
Please try it using a recent build. If the issue is still present, we will 
change the status.

Original comment by g.maxia on 19 Mar 2015 at 3:18