RDB Cube entry fails

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

Hi together,

 

i just created a table on a oracle database:

 

USERNAME (VARCHAR2(50))

KEYWORD (VARCHAR2(100))

 

I also created an RDB cube to edit the KEYWORD in board using a dataview (data entry allowed).

 

The changed KEYWORD wont be saved in the database and i just get the following error message in the SQL Log:

 

The object of type BoardDBConnection.BoardDbConnectionWrapper cannot be converted to type System.Data.Odbc.OdbcConnection.

 

Any hints or tips?

 

THX

Paul

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi,

     

    some questions from my side:

    - is Username defined as PrimaryKey in your SQL table?

    - is the connection configured as OleDB or ODBC, do you use Oralce as RDBMS

    - is the text you are entering smaller than 100 Bytes (BOARD is using UTF)? Cause varchar2(100) holds 100 BYTES. A string which is 100 CHARACTERS in UTF8 may be MUCH larger then 4000 BYTES. It could be 4000 BYTES.

     

    Regards

    Björn

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi Björn,

     

    my fault - i missed the primary key!

     

    Thx

    Paul

Categories