CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist

Downloaded CS2007-StarterSite-En.exe and installed successfully.

However, when I attempt to add a product to my cart, an unhandled exception occurs:

Component Execution failed for component[0x2] hr: 0x80131509
ProgID: Commerce.CheckInventory
The stored procedure 'dbo.inv_CheckInventory' 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: Component Execution failed for component[0x2] hr: 0x80131509
ProgID: Commerce.CheckInventory
The stored procedure 'dbo.inv_CheckInventory' doesn't exist.

Source Error:

Line 152: }
Line 153:
Line 154: this.basketHelper.RunBasketPipeline();
Line 155: }
Line 156:

I can view the pipeline component responsible, but it doesn't offer any clue to where the stored procedure is located. I've checked the stored procs via SQL 2005 in the StarterSite_productcatalog database, and confirmed that 'dbo.inv_CheckInventory' DOES exist.

Is there some other database this stored procedure is missing from Or, any other ideas to resolve this issue

Thanks

Answer this question

CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist

ReneeC
I didn't perform SQL trace as suggested, but this would have been my next step.

I was able to see what user was involved via Event Viewer. The error always involved 'RunTimeUser' (not Inventory_RuntimeRole). I experimented and gave execute permissions for the stored procedure to 'RunTimeUser' and now the problem seems fixed.

Thanks all for the input. Hopefully this helps someone else.
MisterMoon
It seems that you have the inventory resource in the site but the schema is missing for some reason.

If this is a test environment you can try removing the inventory resource and additng it back again. This will recreate the inventory schema.
Sotham
Thanks for everyone's feedback.

I will investigate this and post back if successful.
Kimo9909
If you haven't already launch SQL Profiler to monitor the resource activity.

Filter out all unrelated SQL activity by adding a value in the Application Name parameter of the Inventory resource connection string. The option is located under the All tab in the connection string properties. In SQL Server Profiler you can then apply a filter where Application Name matches the value you set.

Once you have the trace you should see the call to inv_CheckInventory and what identity it ran under. Taking that information check the rights of the user and try to reproduce the call in Query Analyzer.

Cheers,
Colin
mussle66

Check the connection string on the inventory resource in Commerce Server Manager. If it is correct can you run SQL Profiler to see where the call is failing, under which identify it is running, and try to reproduce in query analyzer

Cheers,
Colin
Rory Cahill
Performed suggested procedure:

1.) Launched Commerce Server Manger

2.) Deleted Inventory resource for my CS site

3.) Restored Inventory resouce sucessfully

After iisreset, I tried adding Adventure Works product to my cart. Now it says product is out-of-stock, so I thought maybe things were working. However, after clicking "Save for later" button, same error occurred:

Component Execution failed for component[0x2] hr: 0x80131509
ProgID: Commerce.CheckInventory
The stored procedure 'dbo.inv_CheckInventory' doesn't exist.

I was hopeful there for a sec
MarceloCouto
Inventory_RuntimeRole in SQL is correctly assigned
cdemez

Perhaps you forgot to add the appropriate permissions to the ApplicationPool Identity in SQL as described in the install guide Specifically, this account needs to be in the Inventory_RuntimeRole in SQL, which might be the reason you're seeing this error.
CS 2007 Starter Site - stored procedure 'dbo.inv_CheckInventory' doesn't exist

Answer this question