Pages: [1]
  Print  
Author Topic: DatabaseExampleSetWriter error  (Read 1862 times)
keith
Full Member
***
Posts: 160


« on: November 20, 2008, 10:44:23 PM »

When I have  DatabaseExampleSetWriter with overwrite_mode set to "overwrite" it works correctly.  However, if I have overwrite_mode set to "append" or "overwrite first, append then", I get the following error:

Code:
PatternSyntaxException caught:
Unclosed character class near index0
[
^

Is this a bug, or user error?

UPDATE: This actually doesn't appear to be related to appen/overwrite, but rather writing nominal values to a database.

This causes an error:

Code:
<operator name="Root" class="Process" expanded="yes">
    <operator name="NominalExampleSetGenerator" class="NominalExampleSetGenerator">
        <parameter key="number_of_attributes" value="1"/>
        <parameter key="number_of_values" value="3"/>
    </operator>
    <operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
        <parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/>
        <parameter key="database_url" value="jdbc:sqlserver:xxxxxx"/>
        <parameter key="overwrite_mode" value="overwrite"/>
        <parameter key="password" value="xxxxxx"/>
        <parameter key="table_name" value="rm_test"/>
        <parameter key="username" value="xxxxxx"/>
    </operator>
</operator>

This one doesn't.  The only change is now I'm using ExampleSetGenerator to produce all numeric data.

Code:
<operator name="Root" class="Process" expanded="yes">
    <operator name="ExampleSetGenerator" class="ExampleSetGenerator">
        <parameter key="target_function" value="sum"/>
    </operator>
    <operator name="DatabaseExampleSetWriter" class="DatabaseExampleSetWriter">
        <parameter key="database_system" value="Microsoft SQL Server (Microsoft)"/>
        <parameter key="database_url" value="jdbc:sqlserver:xxxxx"/>
        <parameter key="overwrite_mode" value="overwrite"/>
        <parameter key="password" value="xxxxx"/>
        <parameter key="table_name" value="rm_test"/>
        <parameter key="username" value="xxxxx"/>
    </operator>
</operator>

Thanks,
Keith
« Last Edit: November 20, 2008, 11:13:12 PM by keith » Logged
Sebastian Land
Administrator
Hero Member
*****
Posts: 2426


« Reply #1 on: November 25, 2008, 05:06:23 PM »

Hi Keith,
this seems to be a quoting problem to me. Does one of your nominal values include some strange character?
And could you please post the version and type of your Microsoft SQL Server?

Greetings,
  Sebastian
Logged
keith
Full Member
***
Posts: 160


« Reply #2 on: November 25, 2008, 05:36:51 PM »

The example I posted uses only the nominal values that are automatically generated: positive, negative, value0, value1, value2.  So it's unlikely to be just a quoting problem in my data.

The database server is running SQL Server 2005 standard edition, version 9.0.3042
Logged
Jason
Guest
« Reply #3 on: December 15, 2008, 03:40:54 PM »

I seem to be having the same problem as Keith -- a classification routine and model applier feed into a DatabaseExampleSetWriter, which throws an identical error. The SQL server settings are set to the same parameters as in the initial DatabaseExampleSource operator, and this procedure worked before upgrading to 4.3.  The values produced are all numerical, except for the nominal label value. Is there a chance that something was broken in the version change?

It's SQL Server2005 (standard), 9.0.3042

Thanks,
Jason
Logged
Sebastian Land
Administrator
Hero Member
*****
Posts: 2426


« Reply #4 on: December 15, 2008, 04:15:05 PM »

Hi guys,
good news! We have found the bug. The correct version is now available in cvs developer branch or with the next regular update for the enterprise edition which will be published in around a week.

Greetings,
  Sebastian
Logged
haddock
Hero Member
*****
Posts: 853



WWW
« Reply #5 on: January 06, 2009, 05:20:04 PM »

Hi Sebastian,

I'm on RM Enterprise 4.3.000 with MS SQL 2005 and am bumping into exactly the same problem. Any idea when the fix will be published? Soon would be great  Grin
Logged

Where is the wisdom we have lost in knowledge?
Where is the knowledge we have lost in information?

T.S.Eliot ~ Choruses from the Rock 1934
Pages: [1]
  Print  
 
Jump to: