Missing ws_Offer_GetCountForProductList?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
7/28/2008 2:03:23 PM
ango888
Gravatar
Total Posts 11
View Posts

Missing ws_Offer_GetCountForProductList?

Hi,

I just install new version 2.2.6.5, the setup going well, but when click on HomeSite link and got exception:

(Not sure I missing something or what? - Thanks for the response.)

The stored procedure 'ws_Offer_GetCountForProductList' doesn't exist.
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.

Exception Details: System.InvalidOperationException: The stored procedure 'ws_Offer_GetCountForProductList' doesn't exist.

Source Error:


Line 2511:
Line 2512: connection.Open();
Line 2513: SqlCommandBuilder.DeriveParameters(cmd);
Line 2514: connection.Close();
Line 2515:
 

Source File: C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLHelper.cs Line: 2513

Stack Trace:


[InvalidOperationException: The stored procedure 'ws_Offer_GetCountForProductList' doesn't exist.]
System.Data.SqlClient.SqlCommand.DeriveParameters() +883612
System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
mojoPortal.Data.SqlHelperParameterCache.DiscoverSPParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLHelper.cs:2513
mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLHelper.cs:2685
mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLHelper.cs:2629
mojoPortal.Data.SqlHelperParameterCache.GetSPParameterSet(String connectionString, String spName) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLHelper.cs:2609
mojoPortal.Data.SqlParameterHelper.InitializeArray() in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:63
mojoPortal.Data.SqlParameterHelper.BeginDefineSqlParameters() in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:51
mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:86
mojoPortal.Data.SqlParameterHelper..ctor(String connectionString, String commandText, Int32 paramCnt) in C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs:43
WebStore.Data.DBOffer.GetCountForProductList(Guid storeGuid) +65
WebStore.Data.DBOffer.GetPageForProductList(Guid storeGuid, Guid languageGuid, Guid currencyGuid, Int32 pageNumber, Int32 pageSize, Int32& totalPages) +97
WebStore.Business.Offer.GetPageForProductList(Guid storeGuid, Guid languageGuid, Guid currencyGuid, Int32 pageNumber, Int32 pageSize, Int32& totalPages) +119
WebStore.UI.WebStoreModule.PopulateOfferList() +186
WebStore.UI.WebStoreModule.PopulateControls() +377
WebStore.UI.WebStoreModule.Page_Load(Object sender, EventArgs e) +47
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131


 

7/28/2008 2:41:18 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing ws_Offer_GetCountForProductList?

Hi,

Thanks so much for buying me a beer! Much appreciated.

It looks like maybe not all the files got uploaded for your installation. I just checked and the stored procedure does exist in the script so I'm thinkiing the script did not get uploaded.

Can you look in the folder /Setup/applications/webstore/SchemaUpgradeScripts/mssql

You should see scripts incremented up to  0.0.1.5.config, 0.0.1.4.config is the one that has ws_Offer_GetCountForProductList in it. Is that file there? It should be 9KB in size. Maybe there was an upload error and the file didn't make it.

I have received another bug report about the store that has a different error. I'm going to package up a new release with the fix for that one by tomorrow sometime. I'll post again when a new download is ready.

Best,

Joe

7/28/2008 5:19:25 PM
ango888
Gravatar
Total Posts 11
View Posts

Re: Missing ws_Offer_GetCountForProductList?

Thanks Joe,

Some how the script was not run completely.  I manual run it on query analyzer and I got pass the error. Now I got Assertion Failed:

parameter's name doesn't match cached parameters

C:\Projects\mjportal\mojoPortal.Data.MSSQL\SQLParameterHelper.cs(91)

at DBOffer.GetCountProductList(Guid storeGuid)

I will try to update again tomorrow, hope fully everything will work OK. 

Thanks again, The beer is on me.

An

 

 

 

7/29/2008 7:47:27 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing ws_Offer_GetCountForProductList?

I've just released mojoPortal 2.2.6.6 which should fix the WebStore errors.

Best,

Joe

7/29/2008 1:26:23 PM
ango888
Gravatar
Total Posts 11
View Posts

Re: Missing ws_Offer_GetCountForProductList?

Hi Joe,

Some how my revision 4007 have this:

Line 234: sph.DefineSqlParameter("Store@Guid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
Line 273: SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ws_Offer_SelectPageForProductList", 4);
 

I changed to:

Line 234: sph.DefineSqlParameter("@StoreGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, storeGuid);
Line 273: SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "ws_Offer_SelectPageForProductList", 5);
 

Now everything back to normal.

Thanks,

An

 

7/29/2008 1:33:58 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Missing ws_Offer_GetCountForProductList?

You are right. I'm making the same fix here. I did not catch this because my site is using MySql. Thanks for buying me another beer! Maybe I should buy one for you for finding this issue.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.