Hi,
I am having problems compiling and distributing my current module! The funny thing is that it is working on my local machine were I developed the module!
I compiled the module created a install package and installed it on our test server but when i try to open the page I get following error (Event Viewer):
Message: DotNetNuke.Services.Exceptions.PageLoadException: 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.GetMoistureSensitiveItems_All' 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 DotNetNuke.Modules.MoistureSensitiveItems.SqlDataProvider.GetMoistureSensitiveItems_All(Int32 PortalID, Int32 BagID, String Item, String Status) at DotNetNuke.Modules.MoistureSensitiveItems.MoistureSensitiveItemsController.GetMoistureSensitiveItems_All(Int32 PortalId, String p_sortExpression, String p_sortDirection, Int32 BagID,
For some reason it does not see the stored procedures! Ichecked on the server but they all exist and I can execute them.
Any Idea what causes this behavior?