|
Home > Archive > Commerce Server General > December 2004 > what is this erro
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Fadi Meqbel 2004-12-28, 5:49 pm |
|
How did this error appear and what can I do to solve the problem?
Thanks,
Fadi
Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 8192
Date: 12/28/2004
Time: 11:38:32 AM
User: N/A
Computer: ATLPRDECS02FDC
Description:
The CacheManager encountered an error during a refresh of the cache:
'Commerce.MarketingLoadDiscounts: Could not find stored procedure
'mktg_spRuntimeLoadDiscounts'.[42000]
Could not find stored procedure 'mktg_spRuntimeLoadDiscounts'.'
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
| |
| David Messner [MSFT] 2004-12-29, 5:52 pm |
| It seems that the database schema for the marketing system is missing some
sprocs.
The only reliable way to solve this would be to remove the resource and
recreate it. This would delete any existing discount data in your system.
1. In Commerce Manager, select the Marketing resource, right click and
delete.
2. Run Site Packager, select the FP1.PuP package, and Custom Unpack option
2.a. Select unpack only the Marketing resource
2.b Select the proper database.
I believe we also shipped the SQL script (mktg_schema.sql) (search for this
under %COMMERCE_SERVER_ROOT%) which you could run using SQL Query Analyzer
to blow away the old schema and recreate it.
Hope this helps
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
Thread-Topic: what is this erro
thread-index: AcTs/JOgKf7SckIkSbSP4vIXQ7JbBQ==
X-WBNR-Posting-Host: 66.147.172.2
From: "=?Utf-8?B?RmFkaSBNZXFiZWw=?=" <FadiMeqbel@discussions.microsoft.com>
Subject: what is this erro
Date: Tue, 28 Dec 2004 08:45:02 -0800
Lines: 25
Message-ID: <CDC62D54-52B3-455F-ABD6-68AFC0098EF3@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15321
X-Tomcat-NG: microsoft.public.commerceserver.general
How did this error appear and what can I do to solve the problem?
Thanks,
Fadi
Event Type: Error
Event Source: Commerce Server 2002
Event Category: None
Event ID: 8192
Date: 12/28/2004
Time: 11:38:32 AM
User: N/A
Computer: ATLPRDECS02FDC
Description:
The CacheManager encountered an error during a refresh of the cache:
'Commerce.MarketingLoadDiscounts: Could not find stored procedure
'mktg_spRuntimeLoadDiscounts'.[42000]
Could not find stored procedure 'mktg_spRuntimeLoadDiscounts'.'
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
|
|
|
|
|