Hello,
I'm having trouble creatng a new Static re****t for BizDesk.
This is on a CS2000 installation with separate Web and DB servers.
I've created the stored procedure, which takes no parameters. It
returns some registered user information including Email, LastName,
FirstName, etc.
I've created the entry in the Re****t table and defined the columns in
the Re****tDimension table.
But when I run the re****t, the re****t fails and the following entry
is logged in the event log.
Why wouldn't the Renderer find the column (FirstName). Do I need to
define the columns in some other table? Do I need to restart IIS? or
does the renderer run entirely on the DB server?
Needless to say, this is my first re****t. All help is appreciated!
-tomas
Event Log Error message.
----------------------------------
Event Type: Error
Event Source: Commerce Server 2000
Event Category: None
Event ID: 40979
Date: 9/17/2006
Time: 10:40:04 AM
User: N/A
Computer: COMPNAME
Description:
Calculation renderer : Please check the SQL connection information.
Provider=SQLOLEDB.1;Password=****;User ID=Username;Initial
Catalog=Retail_dw;Data Source=COMPNAME;Use Procedure for
Prepare=1;Auto Translate=True;Packet Size=4096;Workstation
ID=COMPNAME;Use Encryption for Data=False;Tag with column collation
when possible=False Invalid column name 'FirstName'.
----------------------------------
/*-------------------------------
* Tomas Vera
* tomas (at) sbcglobal (dot) net
*-------------------------------
*/
