Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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

  • 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.