Error during install 8.2.3.1351_SalesEnterprise_Softkey_PostgreSQL_ENU locally on IIS
After local deploy on IIS, next request (http://localhost:82/) return An item with the same key has already been added. Could you explain pls how can I fix it ?
Like
Hello!
Could you provide a bit more detail for clarification — does the issue occur when opening the site or only after logging in?
If it happens after logging in, please check whether you have duplicate schemas — this can occur if you restore the system from a backup that contains duplicates, which can lead to a compilation error:
SELECT [ss1].[SchemaNameInMetaData],
[ss1].[ManagerName]
FROM ( SELECT [ss0].[ManagerName],
SUBSTRING(
[ss0].[MetaDataStr],
[ss0].[nameStartIndex] + 20,
CHARINDEX('"', [ss0].[MetaDataStr], [ss0].[nameStartIndex] + 20) - [ss0].[nameStartIndex] - 20) AS [SchemaNameInMetaData]
FROM ( SELECT [Name] AS [SchemaName],
[ManagerName],
CAST([MetaData] AS VARCHAR(MAX)) AS [MetaDataStr],
PATINDEX('%MetaData.Schema.A2%', CAST([MetaData] AS VARCHAR(MAX))) AS [nameStartIndex]
FROM [dbo].[SysSchema]) AS [ss0]
WHERE [ss0].[nameStartIndex] <> 0) AS [ss1]
GROUP BY [ss1].[SchemaNameInMetaData],
[ss1].[ManagerName]
HAVING COUNT(*) > 1;
If possible, please share a screenshot that would help us localize the issue more accurately and provide you with more targeted recommendations.
