| Author |
Invalid Cast Exception With FP1 Catalog Expressions
|
|
| Jonathan Swartz 2004-06-02, 4:56 pm |
| When attempting to create a catalog expression using FP1, an invalid
cast exception is thrown. Has anyone else come across this?
Description:
An exception occurred in the 'MarketingWebService' Web service.
Exception details follow:
System.InvalidCastException: Specified cast is not valid.
at
Microsoft.CommerceServer.Internal.Marketing.ProfileDefinitionRetriever.GetProductDefinition()
at
Microsoft.CommerceServer.Internal.Marketing.ProfileDefinitionRetriever.GetDefinitions(String[]
definitionNames)
at
Microsoft.CommerceServer.Marketing.WebService.MarketingWebService.GetProfileDefinitions(String[]
profileNames)
| |
| Maria Quian [MSFT] 2004-06-03, 11:56 pm |
| Thank you for using Microsoft Newsgroups.
Try to import the adventureworks catalog and create an expression off that
one. If no error then try exporting your catalog to see if it catches any
validation errors. If errors, please let us know.
Maria Quian
Microsoft Technical Support
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
| |
| Jonathan Swartz 2004-06-08, 12:00 am |
| Did the import and had no errors so I exported my catalog, again with
no errors. I traced the DB and the last call before the exception is
EXEC dbo.ctlg_getproperties.
mquian@online.microsoft.com (Maria Quian [MSFT]) wrote in message news:<z1HZvRbSEHA.1900@cpmsftngxa10.phx.gbl>...
> Thank you for using Microsoft Newsgroups.
>
> Try to import the adventureworks catalog and create an expression off that
> one. If no error then try exporting your catalog to see if it catches any
> validation errors. If errors, please let us know.
>
> Maria Quian
> Microsoft Technical Support
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.
> --
| |
| Jonathan Swartz 2004-06-08, 12:00 am |
| Fixed the problem. There was a bit column in the CatalogAttributes
table that had several NULLs for values. Apparently the code in
Discount Manager blew up trying to convert it to a bool.
Problem solved.
|
|
|
|