Local Reference Table

I am created a new reference table and ran the stored procedure

UP_POPULATE_REFTABLES_TABLE. I am able to see the table in the system tables but somehow when I try to add a record I get the following error.

A system Error has occured

please cint your system administrator and provide the following information:

windowmenu: w_ref_tbl

Obj: dw_sheet

objectevent:ue_insertrow

Line: 9

Errorcode:12

Error Test: Data Window Column Type doesnot match getitem type at line9 in ue_insert row event of object dw_sheet of w_ref_tbl.

I am unable to debug.

Any suggestions...

 

Parents
  • Hi Revanth – make sure that your table includes and id int column and that this column exists in t_reference_tables with the type value key.

     

    -M

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Revanth Anne
    Sent: Wednesday, October 28, 2009 4:19 PM
    To: Matt Cooper
    Subject: [Tessitura Technical Forum] Local Reference Table

     

    I am created a new reference table and ran the stored procedure

    UP_POPULATE_REFTABLES_TABLE. I am able to see the table in the system tables but somehow when I try to add a record I get the following error.

    A system Error has occured

    please cint your system administrator and provide the following information:

    windowmenu: w_ref_tbl

    Obj: dw_sheet

    objectevent:ue_insertrow

    Line: 9

    Errorcode:12

    Error Test: Data Window Column Type doesnot match getitem type at line9 in ue_insert row event of object dw_sheet of w_ref_tbl.

    I am unable to debug.

    Any suggestions...

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Hi Revanth – make sure that your table includes and id int column and that this column exists in t_reference_tables with the type value key.

     

    -M

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Revanth Anne
    Sent: Wednesday, October 28, 2009 4:19 PM
    To: Matt Cooper
    Subject: [Tessitura Technical Forum] Local Reference Table

     

    I am created a new reference table and ran the stored procedure

    UP_POPULATE_REFTABLES_TABLE. I am able to see the table in the system tables but somehow when I try to add a record I get the following error.

    A system Error has occured

    please cint your system administrator and provide the following information:

    windowmenu: w_ref_tbl

    Obj: dw_sheet

    objectevent:ue_insertrow

    Line: 9

    Errorcode:12

    Error Test: Data Window Column Type doesnot match getitem type at line9 in ue_insert row event of object dw_sheet of w_ref_tbl.

    I am unable to debug.

    Any suggestions...

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data