[opencms-dev] (6b3) Parameter index out of bounds

[Jorge González]

Hi list, i've got an exception in the setup process, listed here:

The system seems to work ok, but i can't sleep at night so please help me...

centos 3
jboss 3.2.7
psql (PostgreSQL) 7.3.9-RH ( Could be because i use 7.3.x instead of 7.4.x
?? )

Thanks


----------------
15:39:20,033 INFO  [CmsFlexCache] Complete FlexCache cleared - clear()
called
15:39:20,041 ERROR [CmsSqlException]
[org.opencms.db.postgresql.CmsVfsDriver] where:
org.opencms.db.generic.CmsVfsDriver.readResourcesWithProperty(CmsVfsDriver.j
ava:1497), why: org.postgresql.util.PSQLException: Parameter index out of
range.query: SELECT DISTINCT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_ONLIN
E_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLINE_ST
RUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_RESOURCES
.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RESOURC
E_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CREATE
D,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREATED,C
MS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIF
IED AS
LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCES.SI
BLING_COUNT,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED FROM
((CMS_ONLINE_STRUCTURE INNER JOIN CMS_ONLINE_RESOURCES ON
CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID) INNER
JOIN CMS_ONLINE_PROPERTIES ON
(CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID=CMS_ONLINE_STRUCTURE.STRUCTURE_ID
OR
CMS_ONLINE_PROPERTIES.PROPERTY_MAPPING_ID=CMS_ONLINE_STRUCTURE.RESOURCE_ID )
) WHERE
CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID='aa544e6b-be3b-11d9-b9e4-93a9bb63a469'
ORDER BY CMS_ONLINE_STRUCTURE.RESOURCE_PATH DESC SQL Exception
org.postgresql.util.PSQLException: Parameter index out of range.
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.bind(AbstractJdbc1Statement.java
:2090)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.setString(AbstractJdbc1Statement
.java:1135)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.setString(AbstractJdbc1Statement
.java:1116)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPrep
aredStatement.java:131)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPrep
aredStatement.java:131)
        at
org.opencms.db.generic.CmsVfsDriver.readResourcesWithProperty(CmsVfsDriver.j
ava:1497)
        at
org.opencms.db.CmsDriverManager.readResourcesWithProperty(CmsDriverManager.j
ava:5587)
        at
org.opencms.db.CmsSecurityManager.readResourcesWithProperty(CmsSecurityManag
er.java:3577)
        at
org.opencms.file.CmsObject.readResourcesWithProperty(CmsObject.java:2593)
        at
org.opencms.staticexport.CmsStaticExportManager.setExportnames(CmsStaticExpo
rtManager.java:1974)
        at
org.opencms.staticexport.CmsStaticExportManager.clearCaches(CmsStaticExportM
anager.java:1634)
        at
org.opencms.staticexport.CmsStaticExportManager.cmsEvent(CmsStaticExportMana
ger.java:277)
        at
org.opencms.main.OpenCmsCore.fireCmsEventHandler(OpenCmsCore.java:1763)
        at org.opencms.main.OpenCmsCore.fireCmsEvent(OpenCmsCore.java:353)
        at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:125)
        at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:422)
        at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:127
2)
        at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
748)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:237)
        at org.opencms.main.CmsShell.executeCommand(CmsShell.java:637)
        at org.opencms.main.CmsShell.executeCommands(CmsShell.java:707)
        at org.opencms.main.CmsShell.start(CmsShell.java:491)
        at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:167)
15:39:20,451 INFO  [CmsModuleManager] Creating new module
'com.alkacon.documentation.howto_multisite'
15:39:20,467 INFO  [CmsConfigurationManager] Successfully updated XML
configuration file
/opt/jboss-3.2.7/server/default/deploy/cms.war/WEB-INF/config/opencms-module
s.xml for class 'org.opencms.configuration.CmsModuleConfiguration'
15:39:20,468 INFO  [init] . Resource type init   : starting
15:39:20,468 INFO  [init] . Resource type init   : adding 14 resource types
from file opencms-vfs.xml
... continues ok
------------------