Error message help needed.

I am running the attached template (it should work against the target ledger table you have from early on). I am getting the following error: #23000Duplicate entry '70000' for key 'PRIMARY'. When I read that message I assume that there is already a value of 70000 in the primary key field, ledgerid. However, I do not know where that message is coming from. There is no data in the target table. I am inserting a Sequence into the ledgerid field. I am starting with 0 for the first transformation / writer. Each additional transformation / writer starts at 10,000 above the previous transformation / writer. I have a total of 9633 source records that I am processing so I am not anywhere near the 10000 records that the sequence configuration I am using would be setting the ledgerid to.

Your help in figuring out where this breaks is appreciated.

I have deleted all the data from the ledger table

Than I run the transformation without any problems

truncate table `ledger`

Than I run it again and I have received exactly same message

Mike

I would also recommend giving Transformations/Validations and writers names.

That helps resolving problems

Mike

Information 26/02/2013 22:32:03 Starting Transformation...
Information 26/02/2013 22:32:03 Map Name: Ledger
Information 26/02/2013 22:32:03 Author:
Information 26/02/2013 22:32:03 Version:
Information 26/02/2013 22:32:03 Description:
Information 26/02/2013 22:32:03 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:03 Connection Type is: MySql
Information 26/02/2013 22:32:03 Source Select Statement: Select
orders.Ro,
orders.CUSTID,
IfNull(orders.TOW, 0) As Tow,
IfNull(orders.Parts, 0) As Parts,
IfNull(orders.Labor, 0) As Labor,
IfNull(orders.Tax, 0) As Tax,
IfNull(orders.Total, 0) As Total,
orders.Paid,
IfNull(orders.PartsCost, 0) As PartsCost,
IfNull(orders.BALANCE, 0) As Balance
From
orders
Information 26/02/2013 22:32:03 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:03 Records/Lines/Messages per second: 30983.3
Information 26/02/2013 22:32:03 Time Taken: 00:00:00
Information 26/02/2013 22:32:03 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:03 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:03 Connection Type is: MySql
Information 26/02/2013 22:32:03 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:03 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:03 Records/Lines/Messages per second: 31086.94
Information 26/02/2013 22:32:03 Time Taken: 00:00:00
Information 26/02/2013 22:32:03 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:03 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:03 Connection Type is: MySql
Information 26/02/2013 22:32:03 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:04 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:04 Records/Lines/Messages per second: 31086.94
Information 26/02/2013 22:32:04 Time Taken: 00:00:00
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:04 Connection Type is: MySql
Information 26/02/2013 22:32:04 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:04 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:04 Records/Lines/Messages per second: 31087.01
Information 26/02/2013 22:32:04 Time Taken: 00:00:00
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:04 Connection Type is: MySql
Information 26/02/2013 22:32:04 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:04 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:04 Records/Lines/Messages per second: 31296.32
Information 26/02/2013 22:32:04 Time Taken: 00:00:00
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:04 Connection Type is: MySql
Information 26/02/2013 22:32:04 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:04 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:04 Records/Lines/Messages per second: 31191.28
Information 26/02/2013 22:32:04 Time Taken: 00:00:00
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:04 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:04 Connection Type is: MySql
Information 26/02/2013 22:32:04 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:05 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:05 Records/Lines/Messages per second: 30983.37
Information 26/02/2013 22:32:05 Time Taken: 00:00:00
Information 26/02/2013 22:32:05 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:05 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:05 Connection Type is: MySql
Information 26/02/2013 22:32:05 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:05 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:05 Records/Lines/Messages per second: 31087.01
Information 26/02/2013 22:32:05 Time Taken: 00:00:00
Information 26/02/2013 22:32:05 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:05 Transformation:{} Lookup: Lookup from Orders - Loading List of Values
Information 26/02/2013 22:32:05 Connection Type is: MySql
Information 26/02/2013 22:32:05 Source Select Statement: SELECT
orders.Ro,
orders.CUSTID,
IFNULL(orders.TOW,0) AS Tow,
IFNULL(orders.Parts,0) AS Parts,
IFNULL(orders.Labor,0) AS Labor,
IFNULL(orders.Tax,0) AS Tax,
IFNULL(orders.Total,0) AS Total,
orders.Paid,
IFNULL(orders.PartsCost, 0) AS PartsCost,
IFNULL(orders.BALANCE,0) AS Balance
FROM
orders
Information 26/02/2013 22:32:05 Read: 9295 Records/Lines/Messages (in total)
Information 26/02/2013 22:32:05 Records/Lines/Messages per second: 30880.41
Information 26/02/2013 22:32:05 Time Taken: 00:00:00
Information 26/02/2013 22:32:05 Transformation:{} Lookup: Lookup from Orders - List of Values is loaded
Information 26/02/2013 22:32:05 Preparing Writers...
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:05 Writer: {}, [`ledger`] Connection Type is: MySql
Information 26/02/2013 22:32:06 Writer: {}, [`ledger`] Writer { } Is Ready
Information 26/02/2013 22:32:06 All Writers are Ready
Information 26/02/2013 22:32:06 Processing Data...
Information 26/02/2013 22:32:06 Reader:{Orders} Connection Type is: MySql
Information 26/02/2013 22:32:06 Reader:{Orders} Source Select Statement: Select
paylog.PaylogID,
Unix_Timestamp(paylog.CLOSE) As Close,
paylog.RO,
Unix_Timestamp(paylog.PAYDATE) As PayDate,
paylog.AMOUNT,
paylog.PAYTYPE,
paylog.CashID,
paylog.REM,
paylog.Exported,
paylog.`By`
From
paylog
Information 26/02/2013 22:32:06 Reader:{Orders} Data Source has: 9633 Record(s)