The column specified by the 'SYS_NC_OID$' column name and the '24' table id does not exist

View Blue Ink Issues Forum | Post Response | New Topic

Author	Message
sigdev Dec 12 2005 10:36 AM	An internal error has occurred in the Blue Ink application. The error message returned is: The column specified by the 'SYS_NC_OID$' column name and the '24' table id does not exist. System.Exception: The column specified by the 'SYS_NC_OID$' column name and the '24' table id does not exist. at BlueInk.BlueInkApp.Entities.BipDataSet.GetColumnDataRowByName(String sColumnName, Int32 iTableId, DataTable tblColumns) at BlueInk.BlueInkApp.Entities.BipDataSet.GetColumnDataRowByName(String sColumnName, Int32 iTableId) at BlueInk.BlueInkApp.Entities.BipDataSet.GetColumnId(String sColumnName, Int32 iTableId) at BlueInk.BlueInkApp.BusinessComponents.OleDbProject.AddIndexes(DataTable dtIndexes, String sTableName, Int32 iTableId) at BlueInk.BlueInkApp.BusinessComponents.OleDbProject.AddNewProject(String sConnectionString, Int32 iDbmsId, String sDatabaseName, String sBipName, String sBipDesc, Int32 iProjectTypeId) at BlueInk.BlueInkApp.BusinessComponents.OleDbProject.GetOleDbDatabase(String sConnectionString, Int32 iDbmsId, String sDatabaseName, String sBipName, String sBipDesc, Int32 iProjectTypeId) at BlueInk.BlueInkApp.BusinessComponents.PhysicalDbBr.GetDatabase(BipDataSet tdsBip, String sConnectionString, Int32 iDbmsId, String sDatabaseName, String strBipName, String strBipDesc, Int32 iProjectTypeId) at BlueInk.BlueInkApp.BusinessComponents.BipBr.CreateNewBip(BipDataSet& tdsBip, String strConnectionString, Int32 intDbmsId, String strDatabaseName, String strBipName, String strBipDesc, Int32 iProjectTypeId) at BlueInk.BlueInkApp.BusinessComponents.BipBr.CreateNewBipAndValidate(BipDataSet& tdsBip, SecurityToken objSecurityToken, String strConnectionString, Int32 intDbmsId, String strDatabaseName, String strBipName, String strBipDesc, Int32 intProjectTypeId) at BlueInk.BlueInkApp.BusinessComponents.ClientCacheBr.CreateNewBip(String strConnectionString, Int32 intDbmsId, String strDatabaseName, String strBipName, String strBipDesc, Int32 intProjectTypeId) at BlueInk.BlueInkApp.Connect.ConnectToDbGetTables() at BlueInk.BlueInkApp.Connect.cmdConnect_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at BlueInk.BlueInkApp.Controls.InheritedControls.BiaButton.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Lee Richardson (Admin) Dec 12 2005 11:27 AM	Chris, Thank you very much for reporting this error. I have logged it as a defect (#135), but will need some additional information to recreate it. Based on the stack trace I'm guessing this happened when you were connecting to a database, probably when you hit the next button from the connection information tab? What DBMS were you connecting to? Was it SQL Server? If so would you mind sending me your database schema or a database backup? I realize I may be asking a lot. If there is a security concern I certainly understand, but this is a vital module that I thought was solid, so I would greatly apprecate your help in resolving this defect ASAP. - Lee
sigdev Dec 12 2005 1:09 PM	Hi there, Sorry, I should have included a bit more to say what i was doing before the error occurred. Yes, i had just clicked the "next" button after setting the db connection up. I'm actually attempting to connect to an oracle 9.2 db - could this be the problem?
Lee Richardson (Admin) Dec 12 2005 5:11 PM	Chris, Yes, that would be a problem. Blue Ink has been tested with Oracle 8i and it should work, however the default set of templates only generate stored procedures and a data access tier that works with SQL Server. Updating the templates to work with Oracle 8i is the next priority, then updating Blue Ink to work with later versions of Oracle is after that. I'm sorry that Blue Ink may not be an option for you, but please keep it in mind for SQL Server projects or Oracle projects in the future. - Lee

View Blue Ink Issues Forum | Post Response | New Topic