[opencms-dev] Problem installing OpenCMS 5 on SQL Server

Cory L Hubert cory.hubert at ampagency.com
Wed Nov 26 01:57:02 CET 2003


	I was able to get OpenCMS 5 running smoothly on mysql. But my org uses
SQLServer.

	The only error i get during installation is below.  Seems like it's
attempting to insert duplicate keys for a record in CMS_BACKUP_RESOURCES.
Whatever it is.  It's critical to the point where the Explorer, Demo, login
(basically everything) doesn't work.
	Any help would be greatly appreciated.

2101:	[mssql.CmsDbAccess] Destroyed
2100:	[com.opencms.dbpool.CmsPool] mssql: destroyed
2099:	[com.opencms.dbpool.CmsPool] mssqlbackup: destroyed
2098:	[com.opencms.dbpool.CmsPool] mssqlonline: destroyed
2097:	[CmsCronScheduler] Destroyed
2096:	{Admin at Online}> exit
2095:	[FlexCache] Complete cache cleared - clear() called
2094:	------ .. filesystem link check finished
2093:	------ Checking filesystem links ...
2092:	[com.opencms.file.CmsObject.publishProject()/2] Vector was null or
empty
2091:	[com.opencms.file.CmsObject.publishProject()/2] User: [User]:Admin ,
Id=2 , flags=0 , type=0 :the admin-user
2090:	[com.opencms.file.CmsObject.publishProject()/2] Project:6 Time:Tue Nov
25 19:12:52 EST 2003
2089:	root cause was java.sql.SQLException: [CHUBERT-NY]Violation of UNIQUE
KEY constraint 'UQ__CMS_BACKUP_RESOU__1CF15040'. Cannot insert duplicate key
in object 'CMS_BACKUP_RESOURCES'.
2088:	[com.opencms.file.CmsObject.publishProject()/1] Exception:
com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mssql.CmsDbAccess] [CHUBERT-NY]Violation of UNIQUE KEY
constraint 'UQ__CMS_BACKUP_RESOU__1CF15040'. Cannot insert duplicate key in
object 'CMS_BACKUP_RESOURCES'..




More information about the opencms-dev mailing list