The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
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.