Just a bit of feedback here.
When i execute \Program Files\Microsoft Commerce Server 2007\CatalogCreate.sql it throws a bunch of warnings along the lines of
"Cannot add rows to sysdepends for the current object becuase it depends on the missing object 'dbo.ctlg_GrantPermissionIfExists'. The object will still be created."
When I check the db after the script has completed, the missing object is there, it just needs to be moved to an early position in the script so these warnings aren't thrown.
Michael.
Feedback: reorder CatalogCreate.sql
Hot Topic
- Refresh Site Cache
- asp.net 2.0 application with Master Page does not display properly under ie7
- "Unable to display preview." on network share results
- Searching for decimal numbers
- I can't type in the IE address bar
- Instant Messages
- Maximum document size for WDS 3.0
- ActiveX Modal Dialogs do not work in IE7
- Sessions in IE7
- Create Word Documents from IE
IE Development
- Yes i'm working on my site looking for new and exciting ideas
- true
- IE7 HP Director Problem--- I had the same problem,and H P gave me a temporary fix until they release a patch Download this
- Enabling script debugging in IE7
- Creating a new game engine. Anyone want to join me?
- #msntb_toolbar_full_name#
- IE7 and missing WebView in Namespace Extension
- Free Lists - Just a Q & D app I needed.
- 3rd Party Payment
- Accessing Addresses in Total pipeline
Feedback: reorder CatalogCreate.sql
AlexBB
Did you execute the CatalogDrop.sql first
-Max
Holm76
This was on creating a new DB from scratch. The only command executed before this was
CREATE DATABASE XYZ_productcatalog;
Should I execute CatalogDrop.sql on a blank DB
Michael.
Thymen
Yup, you are right I had cleaned out an existing database
. I would not worry about these errors. Some stored procedures are created before others so that's why you get this.
-Max
I.You
When i execute that script on a blank database it runs successfully but i get all of these messages:
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissionIfExists'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissionIfExists'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_CreateCatalogSystem_LanguageView'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_CreateCatalogSystem_LanguageView'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_EnsurePropTableMapExists'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_AddColumnsToRelationships'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_CreateCatalogLanguageView'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_VC_IsVirtualCatalog'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissions_OneCatalogObjects'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissions_OneCatalogObjects'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_AlterClassTypesToProduct'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissions_OneCatalogObjects'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_VC_AddOrRemoveVirtualProperty'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissions_OneCatalogObjects'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_AlterPropertyDataType'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GetProductCategoryVariantUniqueId'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_VC_ValidateCatalogRule'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_VC_ValidateCatalogRule'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_FillCategoryDescendants'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.ctlg_GrantPermissions_OneCatalogObjects'. The object will still be created.
The script seems to be from build 6.0.3724.0. Do you not get these messages when you run the script
Thanks,
Michael.
Robin Debreuil
Are you saying that you created a blank database then executed the catalogcreate.sql If so then you shoud not have any issues. I just tried it and I see no errors.
-Max