Insert failure.Has no column...

5 posts, 0 answers
  1. Krasimir
    Krasimir avatar
    6 posts
    Member since:
    May 2009

    Posted 29 Mar 2011 Link to this post

    Hello,

      I am getting this exception when trying to save to a database an object graph:

    Insert of '1830272635-' failed: Telerik.OpenAccess.RT.sql.SQLException: SQLite error
    table Programs has no column named group_id2
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
       at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
    INSERT INTO [Programs] ([created], [device_type], [group_id], [last_edited], [group_id2], [program_name]) VALUES (?, ?, ?, ?, ?, ?)
    (set event logging to all to see parameter values) Telerik.OpenAccess.RT.sql.SQLException: SQLite error
    table Programs has no column named group_id2
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
       at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)

    Of course I don't have a column "group_id2" in Programs table, so this is somehow automatically generated. I have a primary key "id", set to autoincrement (in the ddl definition), and in Visual Designer I have Default as Identity Mechanism for that class, if that's relevant.

    Could you point me to where the problem might be?

  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 31 Mar 2011 Link to this post

    Hello Krasimir,

    It seems that you did not update the database schema with the changes from the domain model. You could use theUpdate Database from Model wizard in order to achieve that goal.
    Hope that helps. If any other questions arise, do not hesitate to contact us back.

    Greetings,
    Damyan Bogoev
    the Telerik team
  3. DevCraft banner
  4. G
    G avatar
    2 posts
    Member since:
    Apr 2011

    Posted 19 Apr 2011 Link to this post

    Hi, may I have a question regarding to insert failures: 
    We can see in the error message: "(set event logging to all to see parameter values)"
    It would be usefull if I could see the par. values, but I don't know where and how can I set this "event logging" to "all".
    Many thanks!
    N.G.
  5. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 20 Apr 2011 Link to this post

    Hi G,

     If you open the model settings ( right click in your domain model and choose show model settings) you will see a tab backend settings. If you select it there you will see another subtab Tracking and logging. This tab contains all the settings for our tracing functionality and form there you can alter them.

    Kind regards,
    Petar
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. G
    G avatar
    2 posts
    Member since:
    Apr 2011

    Posted 20 Apr 2011 Link to this post

    Thank you!
    N.G.
Back to Top
DevCraft banner