[opencms-dev] Re: import workplace failed during setup

[Martin Koldovsky]

Finaly I was able to pass worklace import during setup procedure.

Possible root of problem:
I selected not to import workplace during first run of setup wizard. 
Later I just restarted wizard
and selected to import it - then I've received error message regarding 
duplicated key.

Resolution:
Delete OpenCms from Tomcat and start installation from scratch.

Now I've sucessfully done setup procedure via wizard. However when I got to
http://127.0.0.1:8080/opencms/opencms
I receive "Unable to connect to database" error message with hint
"Cannot parse XML file "null". org.xml.sax.SAXParseException: Premature 
end of file."

I am posting this as separate question to maillist.

Thanks
Martin

Martin Koldovsky napsal(a):

> Hi all,
> I am trying to evaluate OpenCms 5.0.1 in following enviroment:
> WinXP, MySQL 4.0.18, Tomcat 4.1.30
> It's my initial install to evaluate it.
>
> Unfortunately during workplace import phase I receive following error 
> message (see below).
> I am confused - I do not know system architecture yet to troubleshoot.
>
> I think that starting point is somewhere at "Duplicate entry '/' for 
> key 2" -
> however how did this situation happen?
> Db is created from scratch during the install.What entity is it 
> related to?  ;-)
>
> ===
> 93:        at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 92:        at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 91:        at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
> 90:        at java.lang.reflect.Method.invoke(Unknown Source)
> 89:        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
> Source)
> 88:        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> 87:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 86:        at com.opencms.core.CmsShell.commands(CmsShell.java:168)
> 85:        at 
> com.opencms.core.CmsShellCommands.<init>(CmsShellCommands.java:78)
> 84:    java.lang.NullPointerException
> 83:   82:    >>>    at 
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 81:    >>>    at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 80:    >>>    at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 79:    >>>    at java.lang.Class.newInstance(Unknown Source)
> 78:    >>>    at java.lang.Class.newInstance0(Unknown Source)
> 77:    >>>    at java.lang.reflect.Constructor.newInstance(Unknown 
> Source)
> 76:    >>>    at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> 75:    >>>    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> 74:    >>>    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 73:    >>>    at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 72:    >>>    at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 71:    >>>    at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> 70:    >>>    at 
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182) 
>
> 69:    >>>    at 
> com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62) 
>
> 68:    >>>    at 
> com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
> 67:    >>>    at 
> com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
> 66:    >>>    at 
> com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
> 65:    >>>    at 
> com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1163) 
>
> 64:    >>>    at 
> com.opencms.dbpool.CmsPreparedStatement.executeUpdate(CmsPreparedStatement.java:177) 
>
> 63:    >>>    at 
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1488) 
>
> 62:    >>>    at 
> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1602) 
>
> 61:    >>>    at com.mysql.jdbc.Connection.execSQL(Connection.java:1844)
> 60:    >>>    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:945)
> 59:    >>>    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:886)
> 58:    >>>    at 
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1626)
> 57:    >>>java.sql.SQLException: Invalid argument value,  message from 
> server: "Duplicate entry '/' for key 2"
> 56:    >>>Root cause:
> 55:    >>>-----------
> 54:    >>    at 
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 53:    >>    at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 52:    >>    at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 51:    >>    at java.lang.Class.newInstance(Unknown Source)
> 50:    >>    at java.lang.Class.newInstance0(Unknown Source)
> 49:    >>    at java.lang.reflect.Constructor.newInstance(Unknown Source)
> 48:    >>    at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> 47:    >>    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> 46:    >>    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 45:    >>    at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 44:    >>    at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 43:    >>    at com.opencms.file.CmsRbManager.init(CmsRbManager.java:88)
> 42:    >>    at 
> com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:4182) 
>
> 41:    >>    at 
> com.opencms.file.mySql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:62) 
>
> 40:    >>    at 
> com.opencms.file.mySql.CmsDbAccess.<init>(CmsDbAccess.java:125)
> 39:    >>    at 
> com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:300)
> 38:    >>    at 
> com.opencms.file.mySql.CmsDbAccess.fillDefaults(CmsDbAccess.java:603)
> 37:    >>    at 
> com.opencms.file.genericSql.CmsDbAccess.createFolder(CmsDbAccess.java:1165) 
>
> 36:    >>root cause was java.sql.SQLException: Invalid argument 
> value,  message from server: "Duplicate entry '/' for key 2"
> 35:    >>com.opencms.core.CmsException: 4 Sql exception. Detailed 
> error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument value,  
> message from server: "Duplicate entry '/' for key 2".
> 34:    >>Root cause:
> 33:    >>-----------
> 32:    >    at 
> com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 31:    >    at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 30:    >    at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 29:    >    at java.lang.Class.newInstance(Unknown Source)
> 28:    >    at java.lang.Class.newInstance0(Unknown Source)
> 27:    >    at java.lang.reflect.Constructor.newInstance(Unknown Source)
> 26:    >    at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> 25:    >    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> 24:    >    at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 23:    >    at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 22:    >    at com.opencms.core.OpenCms.<init>(OpenCms.java:255)
> 21:    >    at com.opencms.file.CmsRbManager.init(CmsRbManager.java:100)
> 20:    >root cause was java.sql.SQLException: Invalid argument value,  
> message from server: "Duplicate entry '/' for key 2"
> 19:    >root cause was com.opencms.core.CmsException: 4 Sql exception. 
> Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument 
> value,  message from server: "Duplicate entry '/' for key 2".
> 18:    >com.opencms.core.CmsException: 33 Resourcebroker-init error. 
> Detailed error: Critical error while loading resourcebroker.
> 17:    >Root cause:
> 16:    >-----------
> 15:        at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
> 14:        at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
> 13:        at com.opencms.boot.CmsMain.begin(CmsMain.java:155)
> 12:        at java.lang.Class.newInstance(Unknown Source)
> 11:        at java.lang.Class.newInstance0(Unknown Source)
> 10:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
> 9:        at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
> 8:        at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
> 7:        at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> 6:        at com.opencms.core.CmsShell.<init>(CmsShell.java:105)
> 5:        at com.opencms.core.OpenCms.<init>(OpenCms.java:259)
> 4:    root cause was java.sql.SQLException: Invalid argument value,  
> message from server: "Duplicate entry '/' for key 2"
> 3:    root cause was com.opencms.core.CmsException: 4 Sql exception. 
> Detailed error: [com.opencms.file.mySql.CmsDbAccess] Invalid argument 
> value,  message from server: "Duplicate entry '/' for key 2".
> 2:    root cause was com.opencms.core.CmsException: 33 
> Resourcebroker-init error. Detailed error: Critical error while 
> loading resourcebroker.
> 1:    com.opencms.core.CmsException: 33 Resourcebroker-init error. 
> Detailed error: Database init failed.
> 0:    %%% props: C:\Program Files\Apache Group\Tomcat 
> 4.1\webapps\opencms\WEB-INF\config/opencms.properties
> ===
>
> Martin
>