MSSQL table creation problem

[garynhs]

Hi,

I configured the openKM to run on MSSQL 2005. An exception is thrown when I run the system first time:

"Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert explicit value for identity column in table 'OKM_PROFILE' when IDENTITY_INSERT is set to OFF."

Are there anything I missed to configure? Thanks a lot!

Gary

[jllort]

I think you're using version 5.1.5 no ? there's a bug that's it's solved in 5.1.6. The problem is on tables that has default values with the startup sql script.
This week we'll release the new version in sourceforge, probably on thursday or friday.


Meanwhile if you want to solve you might execute the creation script directly to dbms ( you can open OpenKM.war file with winrar - for example - and the script is on WEB-INF/import.sql
The idea is take that script and :
1- execute SET IDENTITY_INSERT dbo.OKM_PROFILE ON
2- execute from OKM_PROFILE
3- execute SET IDENTITY_INSERT dbo.OKM_PROFILE OFF

I think there's two tables that has problems okm_profile and other ... simply the script will stop when will find next inserts with problems, make the same operation.