pramod chavan
Registered Users
Nuke Super Newbie
Posts:19
 |
| 12/13/2006 10:03 PM |
|
i;m devloping a module which will have grid and data will be populated from database.i used stored proc
but it shows error. i'm very new to DNN. plz help me
Error: spimodule is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The stored procedure 'dbo.YourCompany_YourCompany_spimodule_GetAll' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at YourCompany.Modules.spimodule.SqlDataProvider.YourCompany_spimodule_GetAll(Int32 ModuleId) in C:\Inetpub\wwwroot\spi1\App_Code\spimodule\SqlDataProvider.vb:line 148 at YourCompany.Modules.spimodule.spimoduleController.spimodule_GetAll(Int32 ModuleId) in C:\Inetpub\wwwroot\spi1\App_Code\spimodule\spimoduleController.vb:line 59 --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at System.Web.UI.WebControls.GridView.DataBind() at YourCompany.Modules.spimodule.Viewspimodule.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\spi1\DesktopModules\spimodule\Viewspimodule.ascx.vb:line 33 --- End of inner exception stack trace --- |
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 12/13/2006 10:13 PM |
|
| It looks like the stored procedure doesn't exist in the database? |
|
Scott McCulloch
Site Administrator |
|
|
pramod chavan
Registered Users
Nuke Super Newbie
Posts:19
|
| 12/13/2006 11:31 PM |
|
thanks Scott McCulloch for reply
but i checked my database and stored procedure is existing there.
Actually what happens is that i'm using VS2005, i dropped gridview and objdatasourse and configured for gridview. before that there was no error a simple module with other controls was working, but after configuring gridview to objdatasource error occours.
i'm very new and not very clear abt DNN architecture, so unable to findout problem. if u can suggest something please!
thanks
|
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 12/14/2006 4:55 AM |
|
| How about putting a break point on the data call to make sure your connection string is OK (might be wrong if the procedure does actually exist) |
|
Scott McCulloch
Site Administrator |
|
|
pramod chavan
Registered Users
Nuke Super Newbie
Posts:19
|
| 12/14/2006 8:35 AM |
|
i used following function for getting ModuleId. i put breakpoint and after F5 it gave error, but different :: An error has occurred.
An error has occurred.
i'm really struggling.plz one more help.
Protected Sub SetModuleID(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceSelectingEventArgs) Handles ObjectDataSource_Tasks.Selecting
e.InputParameters("ModuleId") = ModuleId.ToString
End Sub |
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 12/14/2006 3:34 PM |
|
| What does it say in admin -> log viewer for the error message? |
|
Scott McCulloch
Site Administrator |
|
|
pramod chavan
Registered Users
Nuke Super Newbie
Posts:19
|
| 12/15/2006 2:51 AM |
|
i logged as admin and clicked on log viewer, got error
An error has occurred.
Error: Log Viewer is currently unavailable.[b] [/b] |
|
|
|
|
pramod chavan
Registered Users
Nuke Super Newbie
Posts:19
|
| 12/15/2006 7:59 AM |
|
thanks Scott McCulloch for help
i created same project from start on another system and is working fine!!!!!!!!
and still that proj is having same error!! anyway i'm happy with new one.
many thanks!!!!!!!! |
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 12/16/2006 3:52 AM |
|
| Glad it's working -- sometimes it's difficult to see what the issue is (without seeing the environment) |
|
Scott McCulloch
Site Administrator |
|
|