🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Write Database errors

User: "dcubed"
New Altair Community Member
Updated by Jocelyn
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?

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "MariusHelf"
    New Altair Community Member
    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