Database Error

dhctvien3dhctvien3 Member Posts: 1 Contributor I
edited December 2018 in Help

Hi all, while trying to stream data from an Oracle DB I get the following error message: ORA-00904: "RM_INDEX": invalid identifier. (details below)




The underlying table doesn't have a column named RM_INDEX. I guess this is a RapidMiner-generated column which would be used as PK and index as described in the operator documentation. The thing is, there already is a column, let's call it LOG_ID, constrained as PK and index. The values of that column do not start with 0 as indexes usually do. It's merely an integer defined column containing ID values for the objects in my table which are being deleted after a certain time. This leads to discontinuities in the numerical series of the 'index' - which means the values therein are not continuous. They actually start with '6136805'.

The recreate index parameter isn't ticked. That's why I absolutely cannot affiliate to that error message.

My priviledges contain all system privs needed to add the missing RM_INDEX column as described in the operator documentation. 


Can someone help me with this? Would be appreciated..




  • Options
    Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    Would you please just upload the image into the post via the photos thread? This way we don't have to sign up for image shack. Thanks.

  • Options
    sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager

    hello @dhctvien3 - welcome to the community.  Yes please just attach screenshots with the Photos button rather than hyperlinking outside the forum.  It's much easier for everyone.  And please also post your XML process here in the thread so we can see exactly what you're doing (see #2 of "READ BEFORE POSTING" on the right hand side, which of course you've read :smileyhappy:   )



Sign In or Register to comment.