Developer forum

Forum » CMS - Standard features » [Named Item List] - "Something went wrong!"

[Named Item List] - "Something went wrong!"

Ricardo Pereira
Ricardo Pereira
Reply

Hi All,

I created a new named item list, but when I try to add a new item to the same item list the following message is showed: "Something went wrong!". It's a ambiguous message, so I don't know what is wrong.
I can create a list but I can't create items in that list.
Has anyone run into the same problem?

The DW version is 8.9.1.9.


Thank you,

Ricardo Pereira

 

Capture.JPG

Replies

 
Nuno Aguiar
Reply

Hi,

 

Can anyone reproduce the problem? We need to get this feature done soon

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

I tested on 2 different versions: 8.8.1.32 and 8.9.1.13 and could not reproduce it.

Maybe there is something wrong with the ItemType you selected for the list?

Maybe permissions?

Adrian

 
Nuno Aguiar
Reply

Hi Adrian,

 

Not sure what happened, but it's working now. We indeed refreshed that database (although we kept the same DW version). 

 

Thank you for confirming.

Nuno Aguiar

 
António Ramos
António Ramos
Reply

Hi guys,

After the go live this is happening again. Anyone reproduced this?

Any way to debug this to understand why it happens?

BR,

António Ramos

 
António Ramos
António Ramos
Reply

Good morning,

Spend some time debuging and saw the error returned:

"System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__ItemType__3214EC07EF2E4728'. Cannot insert duplicate key in object 'dbo.ItemType_Thesaurus'. The duplicate key value is (8).<br>The statement has been terminated."

These itemtype (named item list) were inserted by a SQL Script from a temporary table to the itemtype structure. When inserting a new value... Bump this error.

How can we solve this? How to make the new inserts be from the last entry? Many Thanks,

BR,

António Ramos

 
Nicolai Pedersen
Reply
This post has been marked as an answer

If you insert data in item tables your self, you have to make sure to update the [ItemTypeId] table.

Votes for this answer: 1
 
António Ramos
António Ramos
Reply

Great help. Thanks Nicolai!

 

 

You must be logged in to post in the forum