PRB: Catalog Import May Fail if the Property Definitions Contain Unusual Characters (327165)

SYMPTOMS

If you use the Commerce Server Catalog Import DTS task to import a catalog that contains unusual characters, the task might fail.

If the task fails, Commerce Server logs the Event IDs 32792, 32793, and 32794 in the Application event log. The descriptions for these events may contain the following information:

   HRESULT: -2147217900, Minor Code: 137, Source: , Description  

   SQL Error: 137, Description: 42000 

   Error state: 2, Severity: 15, Server: HRSQL, Line#: 25, msg: Must declare the variable '@CD'.

NOTE: The line number and the variable name that appear in this example will vary depending on your catalog schema.

CAUSE

This problem occurs because SQL does not permit you to use certain characters in a name for SQL identifiers. The DTS task tries to use Property Definitions that contain unusual characters as parameters to re-create the SPI_DfltPart_CatalogGlobal0_1 stored procedure.

WORKAROUND

To work around this problem, do not export these Property Definitions to the Data Warehouse. You can change this in the Catalog Designer module of BizDesk.

MORE INFORMATION

For more information about Identifiers, see the following topics in the SQL Books Online:

"Rules for Regular Identifiers" in the "Accessing and Changing Relational Data" section
"Using Identifiers" in the "Transact-SQL Reference"