Article ID: 256242
Article Last Modified on 6/24/2004
APPLIES TO
- Microsoft Site Server 3.0 Commerce Edition
This article was previously published under Q256242
SYMPTOMS
The Advertiser Report is a downloadable add-on to the release of Ad Server from Microsoft Site Server 3.0, Commerce Edition. This self-extracting program provides an additional feature that allows you to create login accounts so that your advertisers can view performance reports in real time. After you install the Advertiser Report and you click either Customer in Ad Manager (http://localhost/admanager/customer_list.asp) or Submit in the Advertiser Performance Report (http://localhost/adreport/), the following error message may occur:
CAUSE
Advertiser Report Setup creates a table named as_login in the Ad Server database. The script that creates this table fails if the Ad Server table (as_customer) does not have customer_id set as the primary key. If the as_customer table does not have customer_id set as the primary key, attempts to manually run this script (\wwwroot\adreport\config\schema.sql) generate the following error message:
WORKAROUND
The best workaround at this point is to disable the Advertiser Report add-in to return Ad Manager functionality. To do this, locate the customer_funcs.asp file in the AdManager\Include directory and replace it with the Customer_funcs.asp.bak file from the same directory.
Keywords: kbprb kbpending KB256242