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.
Hello!
Please change the number in the db parameter to any other number (that is not already in use in the database), up to 15.
For example, if you currently have:
add name="redis" connectionString="host=localhost; db=1;
Please change it to db=3.
After making this change, restart the application and try to log in.
Regards,
Orkhan
Unfortunately, I get same error. I changed my connection string to <add name="redis" connectionString="host=localhost;db=3;port=6379;" />