<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>i have a problem while installing opencms. the
installation works fine, but when the installer starts to import the default
project errors appear. the admin runs - so i tried to import modules manually -
with the same errors (missing delimiter) occuring.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[i put the errors at the end of this
email]</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>software installed:</FONT></DIV>
<DIV><FONT face=Arial size=2>jdk 1.4.1_03</FONT></DIV>
<DIV><FONT face=Arial size=2>tomcat 4.1.24</FONT></DIV>
<DIV><FONT face=Arial size=2>sapdb 7.4.3.25</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>-> very actual versions</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>first i tried it with an older version of sapdb,
but i received many errors - it seems that in older versions constraints have to
be named (by the way) - but after fixing that i also received errors like these.
i also had a look at query.properties, but these seem to be ok.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>any suggestions ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>jan</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>2550: >> at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>2549: >> at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>2548: >> at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)<BR>2547: >> at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2546: >> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2545: >> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2544: >> at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2543: >> at
com.opencms.core.CmsShell.commands(CmsShell.java:197)<BR>2542: >> at
com.opencms.core.CmsShell.call(CmsShell.java:156)<BR>2541: >> at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2540: >> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2539: >> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2538: >> at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2537: >> at
com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)<BR>2536: >> at
com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)<BR>2535: >> at
com.opencms.file.CmsImport.importResources(CmsImport.java:221)<BR>2534: >> at
com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)<BR>2533: >> at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)<BR>2532: >> at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)<BR>2531: >> at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)<BR>2530: >> at
com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)<BR>2529: >> at
com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12700)<BR>2528: >> at
com.opencms.dbpool.CmsConnection.prepareStatement(CmsConnection.java:267)<BR>2527: >> at
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:655)<BR>2526: >> at
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:79)<BR>2525: >> at
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:175)<BR>2524: >> at
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:224)<BR>2523: >> at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)<BR>2522: >> at
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1528)<BR>2521: >> at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)<BR>2520: >> at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)<BR>2519: >> at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)<BR>2518: >>com.sap.dbtech.jdbc.exceptions.DatabaseException:
[-5016] (at 39): Missing delimiter: =<BR>2517: >>Root
cause:<BR>2516: >>-----------<BR>2515: > at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>2514: > at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>2513: > at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)<BR>2512: > at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2511: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2510: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2509: > at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2508: > at
com.opencms.core.CmsShell.commands(CmsShell.java:197)<BR>2507: > at
com.opencms.core.CmsShell.call(CmsShell.java:156)<BR>2506: > at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2505: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2504: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2503: > at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2502: > at
com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)<BR>2501: > at
com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)<BR>2500: > at
com.opencms.file.CmsImport.importResources(CmsImport.java:221)<BR>2499: > at
com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)<BR>2498: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)<BR>2497: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)<BR>2496: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)<BR>2495: > at
com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)<BR>2494: > at
com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12705)<BR>2493: >root
cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39):
Missing delimiter: =<BR>2492: >com.opencms.core.CmsException: 4 Sql
exception. Detailed error:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at
39): Missing delimiter: =. <BR>2491: >Root
cause:<BR>2490: >-----------<BR>2489: at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>2488: at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>2487: at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)<BR>2486: at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2485: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2484: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2483: at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2482: at
com.opencms.core.CmsShell.commands(CmsShell.java:197)<BR>2481: at
com.opencms.core.CmsShell.call(CmsShell.java:156)<BR>2480: at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2479: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2478: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2477: at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2476: at
com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)<BR>2475: at
com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)<BR>2474: at
com.opencms.file.CmsImport.importResources(CmsImport.java:221)<BR>2473: at
com.opencms.file.CmsImport.importAllResources(CmsImport.java:802)<BR>2472: root
cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39):
Missing delimiter: =<BR>2471: root cause was com.opencms.core.CmsException:
4 Sql exception. Detailed error:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at
39): Missing delimiter: =. <BR>2470: com.opencms.core.CmsException: 0
Unknown exception. Detailed error: CmsException ID: 0.
<BR>2469: <BR>2468: > at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>2467: > at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>2466: > at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)<BR>2465: > at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2464: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2463: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2462: > at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2461: > at
com.opencms.core.CmsShell.commands(CmsShell.java:197)<BR>2460: > at
com.opencms.core.CmsShell.call(CmsShell.java:156)<BR>2459: > at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2458: > at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2457: > at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2456: > at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2455: > at
com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)<BR>2454: > at
com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)<BR>2453: > at
com.opencms.file.CmsImport.importResources(CmsImport.java:221)<BR>2452: > at
com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)<BR>2451: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)<BR>2450: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)<BR>2449: > at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)<BR>2448: > at
com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)<BR>2447: > at
com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12700)<BR>2446: > at
com.opencms.dbpool.CmsConnection.prepareStatement(CmsConnection.java:267)<BR>2445: > at
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:655)<BR>2444: > at
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:79)<BR>2443: > at
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:175)<BR>2442: > at
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:224)<BR>2441: > at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)<BR>2440: > at
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1528)<BR>2439: > at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)<BR>2438: > at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)<BR>2437: > at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)<BR>2436: >com.sap.dbtech.jdbc.exceptions.DatabaseException:
[-5016] (at 39): Missing delimiter: =<BR>2435: >Root
cause:<BR>2434: >-----------<BR>2433: at
com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)<BR>2432: at
com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)<BR>2431: at
com.opencms.boot.CmsMain.begin(CmsMain.java:164)<BR>2430: at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2429: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2428: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2427: at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2426: at
com.opencms.core.CmsShell.commands(CmsShell.java:197)<BR>2425: at
com.opencms.core.CmsShell.call(CmsShell.java:156)<BR>2424: at
java.lang.reflect.Method.invoke(Method.java:324)<BR>2423: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>2422: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>2421: at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)<BR>2420: at
com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)<BR>2419: at
com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)<BR>2418: at
com.opencms.file.CmsImport.importResources(CmsImport.java:221)<BR>2417: at
com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)<BR>2416: at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)<BR>2415: at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)<BR>2414: at
com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)<BR>2413: at
com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)<BR>2412: at
com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12705)<BR>2411: root
cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39):
Missing delimiter: =<BR>2410: com.opencms.core.CmsException: 4 Sql
exception. Detailed error:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at
39): Missing delimiter: =. <BR>2409: !!! Exception
com.opencms.core.CmsException:
[com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at
39): Missing delimiter: =<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>