Windows Server

Carsten Scholling · Guest

Hi there!

We are in the processof developing a new site in ASP (not .NET) with
Commerce Server 2002 FP1 on Windows Server 2003. All worked fine, but
after this weekend, we recognized some strange errors when users loggin in.

First problem occured was "Wrong login information" on the site. Ok, i
checked that and found this event log entry:

Commerce Server: Warning: The table 'CTLG_PropertyTableMap' has been
created but its maximum row size (8933) exceeds the maximum number of
bytes per row (8060). INSERT or UPDATE of a row in this table will fail
if the resulting row length exceeds 8060 bytes.

The next event log message makes it all fully clear ;-)

Commerce Server: Invalid column name 'Description'.

No idea what database, table...

This is not the first time this error occurs.

I made a small test which now hangs in the Initialize() function and
produces a timeout after we saved a new global.asa. Before saving
global.asa it stopped after the GetProfile() with an Exception. Also
other profile functions are affected.

Set oAuthManager = Server.CreateObject("Commerce.AuthManager")
oAuthManager.Initialize("TEST")

Set oProfileService = Server.CreateObject("Commerce.ProfileService")
Call oProfileService.Initialize("Provider=CSOLEDB;Data
Source=SERVER;Initial Catalog=TEST_commerce;Integrated Security=SSPI;",
"Profile Definitions")
Set oProfile = oProfileService.GetProfile("TEST5555", "UserObject", False)

No idea what happens. An IIS restart fixes the problem, but that is not
acceptable later in production...

Hope anyone has an idea or a solution.

Thx in advance,
Carsten

Carsten Scholling · Guest

Carsten Scholling wrote:

Ok, just 15 minutes after writing the message, we got rid of the
Description error problem. It has nothing to do with the general login
problem and was caused by another developer which has changed one
catalog function :)

This means, we only have that Exception error in GetProfile() and other
ProfileService related functions like stated at the end of my last post.

Sorry for that mistake,
Carsten

GetProfile() exception in ASP when logging into Commerce Ser

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1