[opencms-dev] OpenCMS 5.0 and SQL Server 2000 problem

[Michael Goodwin]

This is to follow up my last email. The 'import workspace' infact does log
an error. Judging by the history log someone else had this same identical
problem about one month ago, but it didn't appear to be resolved.

The last few lines of the log are:


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
Dec 30 14:57:13 CET 2003
2089:        root cause was java.sql.SQLException: [Microsoft][SQLServer
2000
Driver for JDBC][SQLServer]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] [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Violation of UNIQUE KEY constraint
'UQ__CMS_BACKUP_RESOU__1CF15040'. Cannot insert duplicate key in object
'CMS_BACKUP_RESOURCES'..
2087:        [com.opencms.file.CmsObject.publishProject()/1] User:
[User]:Admin ,
Id=2 , flags=0 , type=0 :the admin-user
2086:        [com.opencms.file.CmsObject.publishProject()/1] Project:6
Time:Tue
Dec 30 14:57:13 CET 2003
2085:        Publishing /system/bodies/release/
2084:        Publishing /system/bodies/release/
2083:        Publishing /release/



>I'm a new user trying to install opencms:
>system:
>     win 2000 server
>     MS SQL server
>     tomcat 5.0
>
>Having overcome all the problems listed below (with solutions) the setup
completes and points to ..../index.jsp,  which doesn't seem to exist.
>
>Mike.
>
>
> It's been a little bit of a nightmare so far (this is probably familiar
to some)
>1.fix character encoding ,
>- under startmenu Tomcat->configure->JVM tag add in line
"-Dfile.encoding=ISO-8859-1"
>2.get microsoft jdbc driver (from ms website)
> -put the 3 jars in %tomcat%\webapps\web-inf\lib
> -modify all occurances merant in the opencms.properties file , like
below.
>     "merant.datadirect"->"microsoft"
>               "merant"->"microsoft"
>3.change lost 'sa' password.
>     a) logon as local admin
>     b) open a cmd promt
>     c) osql -E -Q "sp_password NULL,password,sa"
>4.stop/start everything lots of times/ faf around in the SQL Server
enterprise manager/reimport, reinstall...