| Carsten Scholling 2005-02-07, 7:48 am |
| 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
|