Microsoft KB Archive/327165

= PRB: Catalog Import May Fail if the Property Definitions Contain Unusual Characters =

Article ID: 327165

Article Last Modified on 10/24/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q327165



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:
 * &quot;Rules for Regular Identifiers&quot; in the &quot;Accessing and Changing Relational Data&quot; section
 * &quot;Using Identifiers&quot; in the &quot;Transact-SQL Reference&quot;

Keywords: kberrmsg kbprb KB327165

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.