Issue 1109 in tungsten-replicator: Provision generates diffrent column-count than a regular insert when chunks.csv contains columns

[tungsten-...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium FoundIn

New issue 1109 by krist...@dinabo.no: Provision generates diffrent
column-count than a regular insert when chunks.csv contains columns
https://code.google.com/p/tungsten-replicator/issues/detail?id=1109

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.




--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[tungsten-...@googlecode.com]

Updates:
Status: Invalid
Owner: stephane...@continuent.com

Comment #1 on issue 1109 by g.maxia: Provision generates diffrent

column-count than a regular insert when chunks.csv contains columns
https://code.google.com/p/tungsten-replicator/issues/detail?id=1109

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

[tungsten-...@googlecode.com]

Comment #2 on issue 1109 by krist...@dinabo.no: Provision generates

diffrent column-count than a regular insert when chunks.csv contains columns
https://code.google.com/p/tungsten-replicator/issues/detail?id=1109

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?

[tungsten-...@googlecode.com]

Comment #3 on issue 1109 by g.maxia: Provision generates diffrent

column-count than a regular insert when chunks.csv contains columns
https://code.google.com/p/tungsten-replicator/issues/detail?id=1109

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.