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;" />
Did you find solution to fix error? I have the same error.
Andrii Yeletskyi,
Yes, I used Redis in docker. After running container, I always change default redis post into 6380 (instead 6379) and map it on 6380 host. After that inside container I run redis-server --port 6380. So, the workaround is to change default redis port.