Posting this for Microsoft's and others' benefit who may have had this
problem.

Because of the way our organization is set up, we have a sql server
account that acts as an "owner" of the database that commerce server
runs under.

When you unpack the marketing resource, it automatically creates the
new marketing tables under this account, such as:

company.mktg_expression

However, the text in the stored procedures tries to access the
mktg_expression table using "dbo.mktg_expression". As there is no
dbo.mktg_expression table (the table is owned by "company") it causes
the marketing resource to throw an error and exit with errors.

The marketing resources is still added and the Discoung Manager
application still works but with major errors I've detailed before in
this forum.

Perhaps it might be better to reference the table using just the table
name in the stored procedures instead of the [owner].[table_name].

Hope this helps!
Jason

[ Post a follow-up to this message ]

Commerce Server has several dependencies on the fact that the ownership of
the Commerce related tables lies with "dbo".
This dependency is not only applies to the new Marketing resource, but also
to the original Commerce Server 2002 objects.
We do not encourage or support use of custom "owners".
Can you provide some details as to why you are using custom owners?
If this is for security purposes, the same can be achieved by configuring
access roles to the tables (as is detailed in the Secure Deployment Guide).
If the idea is to have multiple instances of the marketing (or any other)
resource, this can be achieved by using separate databases for each
resource.

Thanks,

Madhur Joshi

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.
--------------------
From: jasonsirota@gmail.com (Jason Sirota)
Newsgroups: microsoft.public.commerceserver.general
Subject: DBOwner Issue with Unpacking Marketing Resource FP1 - causes major
errors
Date: 14 Jun 2004 10:39:07 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <12e66dac.0406140939.7dcf85ab@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 1087234747 12259 127.0.0.1 (14 Jun 2004
17:39:07 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 14 Jun 2004 17:39:07 +0000 (UTC)
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!postnews1.google.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13988
X-Tomcat-NG: microsoft.public.commerceserver.general

Posting this for Microsoft's and others' benefit who may have had this
problem.

Because of the way our organization is set up, we have a sql server
account that acts as an "owner" of the database that commerce server
runs under.

When you unpack the marketing resource, it automatically creates the
new marketing tables under this account, such as:

company.mktg_expression

However, the text in the stored procedures tries to access the
mktg_expression table using "dbo.mktg_expression". As there is no
dbo.mktg_expression table (the table is owned by "company") it causes
the marketing resource to throw an error and exit with errors.

The marketing resources is still added and the Discoung Manager
application still works but with major errors I've detailed before in
this forum.

Perhaps it might be better to reference the table using just the table
name in the stored procedures instead of the [owner].[table_name].

Hope this helps!
Jason

[ Post a follow-up to this message ]