[opencms-dev] sap installation

[Jan von Bargen]

hi,

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.

[i put the errors at the end of this email]

software installed:
jdk 1.4.1_03
tomcat 4.1.24
sapdb 7.4.3.25

-> very actual versions

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.

any suggestions ?

regards,

jan


2550: >> at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
2549: >> at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
2548: >> at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
2547: >> at java.lang.reflect.Method.invoke(Method.java:324)
2546: >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2545: >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2544: >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2543: >> at com.opencms.core.CmsShell.commands(CmsShell.java:197)
2542: >> at com.opencms.core.CmsShell.call(CmsShell.java:156)
2541: >> at java.lang.reflect.Method.invoke(Method.java:324)
2540: >> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2539: >> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2538: >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2537: >> at com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)
2536: >> at com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)
2535: >> at com.opencms.file.CmsImport.importResources(CmsImport.java:221)
2534: >> at com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)
2533: >> at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)
2532: >> at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)
2531: >> at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)
2530: >> at com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)
2529: >> at com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12700)
2528: >> at com.opencms.dbpool.CmsConnection.prepareStatement(CmsConnection.java:267)
2527: >> at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:655)
2526: >> at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:79)
2525: >> at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:175)
2524: >> at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:224)
2523: >> at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
2522: >> at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1528)
2521: >> at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
2520: >> at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
2519: >> at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
2518: >>com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39): Missing delimiter: =
2517: >>Root cause:
2516: >>-----------
2515: > at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
2514: > at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
2513: > at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
2512: > at java.lang.reflect.Method.invoke(Method.java:324)
2511: > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2510: > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2509: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2508: > at com.opencms.core.CmsShell.commands(CmsShell.java:197)
2507: > at com.opencms.core.CmsShell.call(CmsShell.java:156)
2506: > at java.lang.reflect.Method.invoke(Method.java:324)
2505: > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2504: > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2503: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2502: > at com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)
2501: > at com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)
2500: > at com.opencms.file.CmsImport.importResources(CmsImport.java:221)
2499: > at com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)
2498: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)
2497: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)
2496: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)
2495: > at com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)
2494: > at com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12705)
2493: >root cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39): Missing delimiter: =
2492: >com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at 39): Missing delimiter: =. 
2491: >Root cause:
2490: >-----------
2489:  at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
2488:  at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
2487:  at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
2486:  at java.lang.reflect.Method.invoke(Method.java:324)
2485:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2484:  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2483:  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2482:  at com.opencms.core.CmsShell.commands(CmsShell.java:197)
2481:  at com.opencms.core.CmsShell.call(CmsShell.java:156)
2480:  at java.lang.reflect.Method.invoke(Method.java:324)
2479:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2478:  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2477:  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2476:  at com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)
2475:  at com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)
2474:  at com.opencms.file.CmsImport.importResources(CmsImport.java:221)
2473:  at com.opencms.file.CmsImport.importAllResources(CmsImport.java:802)
2472: root cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39): Missing delimiter: =
2471: root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at 39): Missing delimiter: =. 
2470: com.opencms.core.CmsException: 0 Unknown exception. Detailed error: CmsException ID: 0. 
2469: 
2468: > at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
2467: > at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
2466: > at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
2465: > at java.lang.reflect.Method.invoke(Method.java:324)
2464: > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2463: > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2462: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2461: > at com.opencms.core.CmsShell.commands(CmsShell.java:197)
2460: > at com.opencms.core.CmsShell.call(CmsShell.java:156)
2459: > at java.lang.reflect.Method.invoke(Method.java:324)
2458: > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2457: > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2456: > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2455: > at com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)
2454: > at com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)
2453: > at com.opencms.file.CmsImport.importResources(CmsImport.java:221)
2452: > at com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)
2451: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)
2450: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)
2449: > at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)
2448: > at com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)
2447: > at com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12700)
2446: > at com.opencms.dbpool.CmsConnection.prepareStatement(CmsConnection.java:267)
2445: > at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:655)
2444: > at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:79)
2443: > at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:175)
2442: > at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:224)
2441: > at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:723)
2440: > at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1528)
2439: > at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:429)
2438: > at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:763)
2437: > at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
2436: >com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39): Missing delimiter: =
2435: >Root cause:
2434: >-----------
2433:  at com.opencms.boot.CmsSetupThread.run(CmsSetupThread.java:83)
2432:  at com.opencms.boot.CmsMain.startSetup(CmsMain.java:120)
2431:  at com.opencms.boot.CmsMain.begin(CmsMain.java:164)
2430:  at java.lang.reflect.Method.invoke(Method.java:324)
2429:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2428:  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2427:  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2426:  at com.opencms.core.CmsShell.commands(CmsShell.java:197)
2425:  at com.opencms.core.CmsShell.call(CmsShell.java:156)
2424:  at java.lang.reflect.Method.invoke(Method.java:324)
2423:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2422:  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2421:  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2420:  at com.opencms.core.CmsShellCommands.importModuleFromDefault(CmsShellCommands.java:1929)
2419:  at com.opencms.file.CmsRegistry.importModule(CmsRegistry.java:1894)
2418:  at com.opencms.file.CmsImport.importResources(CmsImport.java:221)
2417:  at com.opencms.file.CmsImport.importAllResources(CmsImport.java:798)
2416:  at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4356)
2415:  at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4370)
2414:  at com.opencms.file.CmsObject.joinLinksToTargets(CmsObject.java:4395)
2413:  at com.opencms.file.genericSql.CmsResourceBroker.joinLinksToTargets(CmsResourceBroker.java:8498)
2412:  at com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags(CmsDbAccess.java:12705)
2411: root cause was com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 39): Missing delimiter: =
2410: com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at 39): Missing delimiter: =. 
2409:    !!! Exception com.opencms.core.CmsException: [com.opencms.file.genericSql.CmsDbAccess.updateAllResourceFlags()] [-5016] (at 39): Missing delimiter: =


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030703/cd925f3e/attachment.htm>