"Failed to drop table errors in RapidAnalytics"

damianv

Hello there,

we are facing problems with the RapidAnalytics. I would like to explain those problems here while we hope, that anyone may have experienced the same issues and knows how to solve them.

To begin with, I saw that when copy-paste or create  some elements inside RapidAnalytics-Repository, it seems works fine, but in the JBOSS log I get:

12:20:01,006 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home
12:20:02,443 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home/username
12:20:04,693 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home/username/context
12:20:06,124 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home/username/context/Process
12:20:11,221 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home/username/context/Process/Process_name
12:20:29,136 INFO  [de.rapidanalytics.web.beans.RepositoryBean] Loading: /home/username/context/Process/Process_name
12:31:24,703 INFO  [de.rapidanalytics.entity.IOObjectVersion] Streaming es_170.
12:31:24,707 INFO  [com.rapidminer.example.db.ExampleSetToDB] No NEXT
12:32:43,233 INFO  [de.rapidanalytics.entity.IOObjectVersion] Streaming es_170.
12:32:43,235 INFO  [com.rapidminer.example.db.ExampleSetToDB] No NEXT
12:32:43,264 INFO  [de.rapidanalytics.web.servlet.AccessEntry] HTTP POST for location /home/username/context/InputData/Copy+of+test, user admin, principal org.springframework.security.authentication.UsernamePasswordAuthenticationToken@a1
f52353: Principal: org.springframework.security.core.userdetails.User@586034f: Username: admin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: admi
n,analyst,execute,report editor,report manager,report viewer,scheduler,service,users; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@0: RemoteIpAddress: 19
2.168.0.3; SessionId: null; Granted Authorities: admin, analyst, execute, report editor, report manager, report viewer, scheduler, service, users
12:32:43,266 INFO  [de.rapidanalytics.ejb.RepositoryStorageEJBImpl] admin submitted new object to /home/username/context/InputData/Copy+of+test.
12:32:43,283 INFO  [de.rapidanalytics.ejb.RepositoryEJBImpl] Creating recursively: home/username/context/InputData
12:32:43,374 INFO  [de.rapidanalytics.ejb.RepositoryEJBImpl] admin created entry '/home/username/context/InputData/Copy+of+test of type 'data'.
12:32:43,681 INFO  [com.rapidminer.example.db.ExampleSetToDB] Dropping data tables for es_171
12:32:43,682 INFO  [com.rapidminer.example.db.ExampleSetToDB] Cannot determine number of subtables. Probably tables already deleted: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'rapidanalytics.es_171_meta' doesn't ex
ist
12:32:43,682 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'es_171_meta'. (Ignoring)
12:32:43,682 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'es_171_nominal_mapping'. (Ignoring)
12:32:43,683 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'es_171_annotations'. (Ignoring)
12:33:09,256 INFO  [de.rapidanalytics.entity.IOObjectVersion] Streaming es_171.
12:33:09,258 INFO  [com.rapidminer.example.db.ExampleSetToDB] No NEXT
13:05:46,613 INFO  [org.apache.cxf.transport.servlet.AbstractCXFServlet] Servlet transport factory already registered
13:05:47,092 INFO  [org.apache.cxf.transport.servlet.AbstractCXFServlet] Servlet transport factory already registered


There is no error with this in the user interface, but our RA database stores and stores multiple new tables that seems can`t be deleted, for example:

es_104_annotations
es_104_data_1
es_104_meta
es_104_nominal_mapping
es_105_annotations
es_105_data_1
es_105_meta
es_105_nominal_mapping
es_106_annotations
es_106_data_1
es_106_meta
es_106_nominal_mapping
es_107_annotations
es_107_data_1
es_107_meta
es_107_nominal_mapping
es_115_annotations
es_115_data_1
es_115_meta
es_115_nominal_mapping
es_132_annotations
es_132_data_1
es_132_meta
es_132_nominal_mapping
es_158_annotations
es_158_data_1
es_158_meta
es_158_nominal_mapping
es_164_annotations
es_164_data_1
es_164_meta
es_164_nominal_mapping
es_166_annotations
es_166_data_1
es_166_meta
es_166_nominal_mapping
es_167_annotations
es_167_data_1
es_167_meta
es_167_nominal_mapping
es_170_annotations
es_170_data_1
es_170_meta
es_170_nominal_mapping
es_171_annotations
es_171_data_1
es_171_meta
es_171_nominal_mapping
....
....

What about this? is it a bug and what can we do to delete this entries?

Sistem settings:

JBossAS [6.0.0.Final "Neo"]
Java version: 1.6.0_45,Sun Microsystems Inc.
Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_45-b06)
Java VM: Java HotSpot(TM) Server VM 20.45-b01,Sun Microsystems Inc.
OS-System: Linux 2.6.32-279.2.1.el6.i686,i386