known issue ? Adding ecom groups fails 50%

Posted on 09/02/2011 00:30:20

Does anyone knows this issue (V19.2.0.4) and how to fix it.
Adding a new ecom group fails with a server error. The next attempt succeeds.
Ok i can add the groups but adding them twice becomes anoying.
I've done some analysis to this issue. When it fails the system is trying to write an empty record into the EcomGroups table with only a GroupID. At the second attempt a fully specified record is inserted.
To know what the system does i created a record in the EcomLanguage table with an empty LanguageID. Then adding a new group will result in two records, one empty one and one correct record. Without any error message. The empty records are not linked to any group.
This is the error message when it fails: The INSERT statement conflicted with the FOREIGN KEY constraint "EcomGroups$EcomLanguagesEcomGroups". The conflict occurred in database "Dynamicweb-Bedrijfsopleidingen", table "dbo.EcomLanguages", column 'LanguageID'.
The statement has been terminated.

Replies

Posted on 09/02/2011 09:00:06

Hi there,

Are you by any chance running this on a custom Dynamicweb solution with its own web.config file? Or maybe IIS is running in .NET 4 mode?

Imar

Posted on 09/02/2011 10:00:35

IIS application pool is in .Net 2.0 Classic mode.

The DW application is running with its own web.config file. Is there anything i can reconfigure to resolve this issue ?

Posted on 09/02/2011 10:49:03

Hi Ben,

Does your web.config contain the follow key:

<httpCookies httpOnlyCookies="true" />

If so, remove it and see of that fixes the problem.

Cheers,

Imar

Posted on 10/02/2011 23:26:14

There isn't. The weird thing is a have compared it to another project which is running the same version and runs correct with the exact same web.config.

Ben

Posted on 10/02/2011 23:47:58

It seems that somehow DW drops the language ID from the UI so it can't send it to the datatabase. I have seen a similar issue when saving shops where the settings in web.config were the culprit.

I think you should report this as a case in the Support system.

Cheers.

Imar

Posted on 17/02/2011 14:58:29

Thanx. I will drop an issue in the support system.

Posted on 15/03/2011 12:18:43

Hi there,

I'm also experiencing the same problem as you have been describing. In my case changing the hostheader from something like http://localhost/ to somthing like www.test.nl solved the problem. Optional also in combination with upgrading to version 19.2.1.3. and removing old groups from the database.

Dynamicweb doesn't seem to support default hostheaders or http://intranet/ at this time.

Lucas

Posted on 08/04/2011 11:01:26

Did anyone find a solution to this problem? Removing old groups is not an option for me.

/Lars

Posted on 12/04/2011 10:28:12

In our case the issue was caused by records in the EcomShopGroupRelation table which referred to non existing GroupIDs in the EcomGroups table.

Removing the invalid relation records solved the issue. Many thanx to Morten for helping us analyse this issue.

Why the record where in the database is still unclear.

You must be logged in to post in the forum

Developer forum

known issue ? Adding ecom groups fails 50%

Replies