Write Database errors

dcubed

In the following, when the test window width > 1 and batch size for "Write Database" > 1, I get the following error.

Apr 19, 2012 9:43:33 AM SEVERE: Process failed: Database error occurred: Line 1: Incorrect syntax near ','.
Apr 19, 2012 9:43:33 AM SEVERE: Here:           Process[1] (Process)
           subprocess 'Main Process'
             +- Read CSV[1] (Read CSV)
             +- Filter Examples[1] (Filter Examples)
             +- Filter Example Range[1] (Filter Example Range)
             +- Set Label[1] (Set Role)
             +- Select Attributes[1] (Select Attributes)
             +- Discretize[1] (Discretize by User Specification)
             +- Nominal to Binominal[1] (Nominal to Binominal)
             +- Validation[1] (Sliding Window Validation)
           subprocess 'Training'
                |  +- Neural Net[1] (Neural Net)
           subprocess 'Testing'
                   +- Apply Model[1] (Apply Model)
                   +- Performance[1] (Performance (Classification))
       ==>         +- Write Database[1] (Write Database)

When the Batch Size = 1 I get the following errors instead:

Apr 19, 2012 9:46:50 AM SEVERE: Process failed: Database error occurred: Violation of PRIMARY KEY constraint 'PK__RapidMiner__76EBA2E9'. Cannot insert duplicate key in object 'RapidMiner'.
Apr 19, 2012 9:46:50 AM SEVERE: Here:           Process[1] (Process)
           subprocess 'Main Process'
             +- Read CSV[1] (Read CSV)
             +- Filter Examples[1] (Filter Examples)
             +- Filter Example Range[1] (Filter Example Range)
             +- Set Label[1] (Set Role)
             +- Select Attributes[1] (Select Attributes)
             +- Discretize[1] (Discretize by User Specification)
             +- Nominal to Binominal[1] (Nominal to Binominal)
             +- Validation[1] (Sliding Window Validation)
           subprocess 'Training'
                |  +- Neural Net[2] (Neural Net)
           subprocess 'Testing'
                   +- Apply Model[2] (Apply Model)
                   +- Performance[2] (Performance (Classification))
       ==>         +- Write Database[2] (Write Database)

Does anyone have any suggestions, work arounds, or bug fixes?

MariusHelf

That's probably because your windows contain overlapping data, and you try to write them to the database. Since the data is identical, it has identical primary keys, but for the database primary keys must be unique.

Best, Marius