Problem while uploading files (with special characters)

[ralph-wgt]

Hello there,

we are facing various 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 tried to upload a csv-File with special characters (swedish, which should be possible with UTF-8, as well as ISO-8859-1 and Windows-1552). Well, in RapidMiner there is no problem with this.
But when copy-paste the imported file from the local to the RapidAnalytics-Repository (home-directory), the upload goes well in the first place. But when I try to open the file (for example double-click) from the Analytics-Repository, I get:

"Message: Cannot parse I/O-Object: com.rapidminer.repository.RepositoryException: Cannot download IOObject: 500: Internal Server Error"

The server at this time states the following:
"13:52:14,438 INFO  [de.rapidanalytics.ejb.RepositoryStorageEJBImpl] admin submitted new object to /home/hoepken/data/OverallBookings_Ausschnitt1.
13:52:14,463 INFO  [de.rapidanalytics.ejb.RepositoryEJBImpl] Creating recursively: home/hoepken/data
13:52:14,467 INFO  [de.rapidanalytics.ejb.RepositoryEJBImpl] admin created entry '/home/hoepken/data/OverallBookings_Ausschnitt1 of type 'data'.
13:52:14,482 INFO  [com.rapidminer.example.db.ExampleSetToDB] Dropping data tables for es_65
13:52:14,504 INFO  [com.rapidminer.example.db.ExampleSetToDB] Cannot determine number of subtables. Probably tables already deleted: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

13:52:14,512 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
. (Ignoring)
13:52:14,520 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
. (Ignoring)
13:52:14,528 INFO  [com.rapidminer.example.db.ExampleSetToDB] Failed to drop table: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
. (Ignoring)
13:52:14,865 WARNING [de.rapidanalytics.entity.IOObjectVersion] Cannot store example set: java.sql.SQLException: ORA-12899: value too large for column "RAPIDANALYTICS"."es_65_meta"."attributeName" (actual: 22, maximum: 21)
: java.sql.SQLException: ORA-12899: value too large for column "RAPIDANALYTICS"."es_65_meta"."attributeName" (actual: 22, maximum: 21)"

---

The first Infos ("failed to drop table") I get with every Database (in the past days I tried MySQL, PostgreSQL and Oracle as well).


Obviously, the problem is not the file size, as I also tried to cut the csv-file to only some rows, so that the file is only 72kb.


I would be very very glad if anyone is able to help. If you need any more information or log files, please let me know. I will send them immediately.
Thanks in advance!

Ralph-J. Andris
University of Applied Sciences Ravensburg-Weingarten

[ralph-wgt]

More information to the system:

OS: Windows Server 2008 64-bit
RA-Version: 1.1 Bundle (automatic installer)
Database: Oracle 11g Express Edition (also tried by MySQL and Postgre)

Fresh installation of RA. No problems discovered during installation.
We piped the StdOut to a textfile and went through it, finding no obvious problems (except for this "duplicate bug" :-))

[Simon Fischer]

Hi,

something does not fit here. The error message is a bout storing and you are talking about downloading.

Did you configure your database to use UTF8 in all places? Database, connection, etc? You can edit server/default/deploy/rapidanalytics-ds,xml to add necessary parametrs to the connection URL if that is required.

Best,
Simon

[ralph-wgt]

Hello Mr. Fischer,

thanks for your reply.
I still think the problem is the uploading of the file, not the downloading. I just used this example to help on localized the problem.

If I uploaded the file, I do not even get the metadata for the uploaded object, nor can I download it.
The error messages that I posted already occur on uploading the file.

The database is configured to UTF8 and the connection works well.

Thanks for your time!

Best,
Ralph

[Simon Fischer]

Hi,

when you get a 500, there must be an exception in the logs. Can you identify that in the server.log?

Best,
Simon