Deleted product information persisting

I am getting an error when attempting to add a new product: "A Product named 1234 already exists."

I had added a product with the same properties before, along with discounts associated with the product. I then deleted the product and the discounts associated with it. The product can no longer be found in the catalog manager by searching or browsing. I've also looked through the productcatalog database, and found no entries for that product. The discounts have remained in the system and are visible in the Marketing Manager as Deleted Items.

What do I need to do to add this product again?

Thanks :)

[643 byte] By [MichaelMcBryde] at [2007-12-28]
# 1

Michael,

Just out of curioisity can you cycle the application pool on the web services? I'm curious if it is getting caught in cache somewhere.

Cheers,
Colin

ColinBowern at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 2

Colin -

The error still occurs after I cycle the application pool and after I reset IIS.

Thanks,

Mike

MichaelMcBryde at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 3
Mike,

Can you do run a SQL Profiler trace to see what is happening at the SQL level? If the catalog system is reporting the product as still existing it must be there somewhere. I am assuming this is a base catalog and not a virtual catalog.

Cheers,
Colin

ColinBowern at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 4
Also change you Check the <CatalogName>_CatalogDeletedProducts table in your ProductCatalog DB and check if an entry for Product "1234" is present?
SudhaRaghavan-MSFT at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2007...
# 5
You should try purging the deleted items from the catalog and creating the product again.
VinayakTadas-MSFT at 2007-9-4 > top of Msdn Tech,Commerce Server,Commerce Server 2007...