|
Home > Archive > Commerce Server General > June 2004 > Creating a New Discount receives "error" in Discount Manager - FP1
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]
| Author |
Creating a New Discount receives "error" in Discount Manager - FP1
|
|
| Jason Sirota 2004-06-09, 8:29 am |
| I'm getting an error when trying to create a New Discountin the
Discount Manager of Feature Pack 1. Here is the text of the error:
--
Error Creating Discount (dialog box header)
Error Summary:
Discount Creation Error:
The does not exist in the system.
--
This occurs for any discount I try to create. I assume something's
supposed to go into the " " area but it doesn't say what it is.
Is there anywhere to get a more detailed error? Any ideas on what
causes this?
Jason
| |
| Andy Xu[MSFT] 2004-06-20, 11:04 pm |
| Jason,
Have you checked the event log? any error messages there?
And do you deploy the Marketing web service in a different machine? If so, any error messages in that machine's event log?
Thanks,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
From: jasonsirota@hotmail.com (Jason Sirota)
Newsgroups: microsoft.public.commerceserver.general
Subject: Creating a New Discount receives "error" in Discount Manager - FP1
Date: 8 Jun 2004 17:49:40 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <303cc8d2.0406081649.3d3c996f@posting.google.com>
NNTP-Posting-Host: 216.103.134.129
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1086742180 9499 127.0.0.1 (9 Jun 2004 00:49:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 9 Jun 2004 00:49:40 +0000 (UTC)
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news.glorb.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13929
X-Tomcat-NG: microsoft.public.commerceserver.general
I'm getting an error when trying to create a New Discountin the
Discount Manager of Feature Pack 1. Here is the text of the error:
--
Error Creating Discount (dialog box header)
Error Summary:
Discount Creation Error:
The does not exist in the system.
--
This occurs for any discount I try to create. I assume something's
supposed to go into the " " area but it doesn't say what it is.
Is there anywhere to get a more detailed error? Any ideas on what
causes this?
Jason
| |
| Jason Sirota 2004-06-26, 10:49 am |
| It had to do with a Marketing Resource unpacking problem.. which I
believe I posted elsewhere as well:
we had a dbowner that was NOT dbo (acc we'll call it) and objects were
being created in the db as acc.object. Commerce Server was trying
access the object as "dbo.object" which was failing.
Once the unpacking failed, nothing else really worked either.
Jason
| |
| Andy Xu[MSFT] 2004-06-26, 10:49 am |
| Jason,
That's an interesting scenario. because the marketing system management API does need to call dbo.<object_name>.
However, I am curious how you get into this situation. I mean, the marketing resource sql file explictily creates object as dbo.<object_name>. And based on Sql server documentation
(http://msdn.microsoft.com/library/d...curity_9qyh.asp), dbo should exist in all databases and can't be deleted.
Can you take a look at your marketing database can see whether dbo user exists? And marketing database schema sql scripts are shipped in FP1, they are under
<Commerce_Server_Root_Direcotory>\FP1\SDK\samples\SiteCreate. This can serve as a temporary solution as well -- you can re-generate marketing schema by manually running
mktg_schema_drop.sql, mktg_db_roles_drop.sql, mktg_schema.sql, mktg_config_data.sql and mktg_db_roles.sql in this specific order. And see whether those marketing db objects
are belonging to dbo or not. If yes, running Discount Manager should work.
Like I said, I am interested in how exactly it takes you to get into the status that db objects not belonging to dbo. And we will fix the problem if we find any.
Thanks for using Commerce Server newsgroup.
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
From: jasonsirota@gmail.com (Jason Sirota)
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: Creating a New Discount receives "error" in Discount Manager - FP1
Date: 22 Jun 2004 14:26:52 -0700
Organization: http://groups.google.com
Lines: 10
Message-ID: <12e66dac.0406221326.20e4cf65@posting.google.com>
References: <303cc8d2.0406081649.3d3c996f@posting.google.com> <8DqVo9rUEHA.3468@cpmsftngxa10.phx.gbl>
NNTP-Posting-Host: 216.103.134.129
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1087939624 18018 127.0.0.1 (22 Jun 2004 21:27:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 22 Jun 2004 21:27:04 +0000 (UTC)
Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!news.glorb.com!
postnews2.google.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:14056
X-Tomcat-NG: microsoft.public.commerceserver.general
It had to do with a Marketing Resource unpacking problem.. which I
believe I posted elsewhere as well:
we had a dbowner that was NOT dbo (acc we'll call it) and objects were
being created in the db as acc.object. Commerce Server was trying
access the object as "dbo.object" which was failing.
Once the unpacking failed, nothing else really worked either.
Jason
|
|
|
|
|