Options

Write Database errors

dcubeddcubed Member Posts: 6 Contributor II
edited June 2019 in Help
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?
Tagged:

Answers

  • Options
    MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    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
Sign In or Register to comment.