Thread: [Rainbowportal-devel] =?iso-8859-1?Q?Re:[Rainbowportal-devel]_Discussion_SQL_script_is_wrong?=
Brought to you by:
danijel_kecman,
manudea
From: <if...@li...> - 2003-07-18 09:58:05
|
> Other errors in SQL script 1727=0D=0A=0D=0AOoops, SQL error is differen= t! I don't understand what happens in that stored procedure.=0D=0A=0D=0AR= unning discussion component I obtain:=0D=0A=0D=0AInvalid object name 'rb_= Discussion'. =0D=0ADescription: An unhandled exception occurred during th= e execution of the current web request. Please review the stack trace for= more information about the error and where it originated in the code. =0D= =0A=0D=0AException Details: System.Data.SqlClient.SqlException: Invalid o= bject name 'rb_Discussion'.=0D=0A=0D=0ASource Error: =0D=0A=0D=0AAn unhan= dled exception was generated during the execution of the current web requ= est. Information regarding the origin and location of the exception can b= e identified using the exception stack trace below. =0D=0A=0D=0AStack Tr= ace: =0D=0A=0D=0A=0D=0A[SqlException: Invalid object name 'rb_Discussion'= .]=0D=0A System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior= cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +643=0D=0A = System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)= +9=0D=0A Rainbow.DesktopModules.DiscussionDB.GetTopLevelMessages(Int32= moduleId)=0D=0A Rainbow.DesktopModules.Discussion.BindList()=0D=0A R= ainbow.DesktopModules.Discussion.Page_Load(Object sender, EventArgs e)=0D= =0A System.Web.UI.Control.OnLoad(EventArgs e) +67=0D=0A Rainbow.UI.We= bControls.PortalModuleControl.OnLoad(EventArgs e)=0D=0A System.Web.UI.C= ontrol.LoadRecursive() +29=0D=0A System.Web.UI.Control.LoadRecursive() = +92=0D=0A System.Web.UI.Control.LoadRecursive() +92=0D=0A System.Web.= UI.Control.AddedControl(Control control, Int32 index) +305=0D=0A System= .Web.UI.ControlCollection.Add(Control child) +153=0D=0A System.Web.UI.W= ebControls.RowControlCollection.Add(Control child) +33=0D=0A DUEMETRI.U= I.WebControls.DesktopPanes.CreateControlHierarchy() +1129=0D=0A DUEMETR= I.UI.WebControls.DesktopPanes.CreateChildControls() +27=0D=0A System.We= b.UI.Control.EnsureChildControls() +100=0D=0A System.Web.UI.Control.Pre= RenderRecursiveInternal() +38=0D=0A System.Web.UI.Control.PreRenderRecu= rsiveInternal() +125=0D=0A System.Web.UI.Control.PreRenderRecursiveInte= rnal() +125=0D=0A System.Web.UI.Control.PreRenderRecursiveInternal() +1= 25=0D=0A System.Web.UI.Control.PreRenderRecursiveInternal() +125=0D=0A = System.Web.UI.Control.PreRenderRecursiveInternal() +125=0D=0A System.= Web.UI.Page.ProcessRequestMain() +1470=0D=0A=0D=0A =0D=0A=0D=0ASame error= if I run stored proc in Sql Query analyzer!=0D=0A=0D=0Aexec rb_Discussio= nGetTopLevelMessages 10243=0D=0A=0D=0AServer: Msg 208, Level 16, State 1,= Procedure rb_DiscussionGetTopLevelMessages, Line 10=0D=0AInvalid object = name 'rb_Discussion'.=0D=0AServer: Msg 208, Level 16, State 1, Procedure = rb_DiscussionGetTopLevelMessages, Line 10=0D=0AInvalid object name 'rb_Di= scussion'.=0D=0AServer: Msg 208, Level 16, State 1, Procedure rb_Discussi= onGetTopLevelMessages, Line 10=0D=0AInvalid object name 'rb_Discussion'.=0D= =0A |
From: manu <ma...@du...> - 2003-07-18 10:09:57
|
Can be a owner problem. I suggest you run the change owner script against your db to be sure all object have the same owner. Dbo -> sql auth Aspnet -> integrated security.... Mixing things it is not recommended. http://www.rainbowportal.net/Rainbow/DesktopModules/ArticlesView.aspx?Ite= mID =3D36&mid=3D10440 ------------------------------------ Emmanuele De Andreis Technical Manager DUEMETRI Internet Solutions Provider RAINBOW PORTAL Main portal - http://www.rainbowportal.net Sourceforge CVS - http://sourceforge.net/projects/rainbowportal/ Support Forums - http://www.rainbowportal.net/ASPNetForums Bug Tracker - = http://sourceforge.net/tracker/?group_id=3D66837&atid=3D515929 -----Messaggio originale----- Da: rai...@li... [mailto:rai...@li...] Per conto di Federico Dal Maso Inviato: venerd=EC 18 luglio 2003 11.58 A: rainbowportal-devel Oggetto: [Rainbowportal-devel] Re:[Rainbowportal-devel] Discussion SQL script is wrong > Other errors in SQL script 1727 Ooops, SQL error is different! I don't understand what happens in that stored procedure. Running discussion component I obtain: Invalid object name 'rb_Discussion'.=20 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.=20 Exception Details: System.Data.SqlClient.SqlException: Invalid object = name 'rb_Discussion'. Source Error:=20 An unhandled exception was generated during the execution of the current = web request. Information regarding the origin and location of the exception = can be identified using the exception stack trace below. =20 Stack Trace:=20 [SqlException: Invalid object name 'rb_Discussion'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +643 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior = behavior) +9 Rainbow.DesktopModules.DiscussionDB.GetTopLevelMessages(Int32 = moduleId) Rainbow.DesktopModules.Discussion.BindList() Rainbow.DesktopModules.Discussion.Page_Load(Object sender, EventArgs = e) System.Web.UI.Control.OnLoad(EventArgs e) +67 Rainbow.UI.WebControls.PortalModuleControl.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() +29 System.Web.UI.Control.LoadRecursive() +92 System.Web.UI.Control.LoadRecursive() +92 System.Web.UI.Control.AddedControl(Control control, Int32 index) +305 System.Web.UI.ControlCollection.Add(Control child) +153 System.Web.UI.WebControls.RowControlCollection.Add(Control child) +33 DUEMETRI.UI.WebControls.DesktopPanes.CreateControlHierarchy() +1129 DUEMETRI.UI.WebControls.DesktopPanes.CreateChildControls() +27 System.Web.UI.Control.EnsureChildControls() +100 System.Web.UI.Control.PreRenderRecursiveInternal() +38 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Control.PreRenderRecursiveInternal() +125 System.Web.UI.Page.ProcessRequestMain() +1470 =20 Same error if I run stored proc in Sql Query analyzer! exec rb_DiscussionGetTopLevelMessages 10243 Server: Msg 208, Level 16, State 1, Procedure rb_DiscussionGetTopLevelMessages, Line 10 Invalid object name 'rb_Discussion'. Server: Msg 208, Level 16, State 1, Procedure rb_DiscussionGetTopLevelMessages, Line 10 Invalid object name 'rb_Discussion'. Server: Msg 208, Level 16, State 1, Procedure rb_DiscussionGetTopLevelMessages, Line 10 Invalid object name 'rb_Discussion'. ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ Rainbowportal-devel mailing list Rai...@li... https://lists.sourceforge.net/lists/listinfo/rainbowportal-devel - - |