Feedback: reorder CatalogCreate.sql

michael aird

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.

Max Akbar - MSFT

Did you execute the CatalogDrop.sql first

-Max

michael aird

Max,

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.

Max Akbar - MSFT

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

michael aird

Max,

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.

Max Akbar - MSFT

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