[opencms-dev] import workplace failed during setup

[Martin Koldovsky]

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