Online demo
Download
Contact

Because information matters

  • Instalación con Postgre

  • Problemas con la instalación de OpenKM? No problemo, la solución está más cerca de lo que piensas.
It is currently Mon Jun 16, 2025 9:26 pm

Instalación con Postgre

Problemas con la instalación de OpenKM? No problemo, la solución está más cerca de lo que piensas.
Forum rules: Por favor, antes de preguntar algo consulta el wiki de documentación o utiliza la función de búsqueda del foro. Recuerda que no tenemos una bola de cristal ni poderes mentales, o sea que que para informar sobre un error es necesario que nos indiques tanto la versión de OpenKM que usas como la del navegador y sistema operativo. Para más información consulta Cómo informar de fallos de forma efectiva.
 Reply

Instalación con Postgre

 #12545  by sorarluyx
 
Buenas tardes, en esta ocasión me dirijo a ustedes con una gran duda :( ; trabajo con la version OpenKM 5.1.7, estoy tratando de hacer la instalación con Postgre pero luego de realizar los respectivos cambios en OpenKM.cfg y correr el .bat, la aplicación me indica el siguiente error: java.lang.NullPointerException. No tengo muy en claro los pasos del Wiki, ya que indica se realiza los cambios en el OpenKM.cfg, se debe levantar el servicio del jboss e ingresar a la aplicación y adicionar dos columnas y me arroja el error nombrado anteriormente. No estoy segura si obvie algun paso de la instalación. Agradecida de toda la ayuda que me puedan brindar.

Les dejo el registro del J-Boss:
Code: Select all
job0_.REPEAT_ as REPEAT15_22_, job0_.TRANSITIONNAME_ as TRANSIT16_22_, job0_.A
CTION_ as ACTION17_22_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_22_, job0_.GRAPHELE
MENT_ as GRAPHEL19_22_, job0_.NODE_ as NODE20_22_, job0_.CLASS_ as CLASS2_22_ fr
om JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?) and job
0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>true order by job0_.
DUEDATE_ asc limit ?]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepar
eStatement(BaseWrapperManagedConnection.java:449)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:437)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:243)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
        at org.hibernate.loader.Loader.doQuery(Loader.java:717)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
        at org.hibernate.loader.Loader.doList(Loader.java:2449)
        ... 11 more
16:23:44,553 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:23:44,553 ERROR [JDBCExceptionReporter] Table not found in statement [/* name
d HQL query JobSession.getFirstAcquirableJob */ select job0_.ID_ as ID1_22_, job
0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as DUEDATE4_22_, job0_.PROCESSINSTAN
CE_ as PROCESSI5_22_, job0_.TOKEN_ as TOKEN6_22_, job0_.TASKINSTANCE_ as TASKINS
T7_22_, job0_.ISSUSPENDED_ as ISSUSPEN8_22_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_22_
, job0_.LOCKOWNER_ as LOCKOWNER10_22_, job0_.LOCKTIME_ as LOCKTIME11_22_, job0_.
EXCEPTION_ as EXCEPTION12_22_, job0_.RETRIES_ as RETRIES13_22_, job0_.NAME_ as N
AME14_22_, job0_.REPEAT_ as REPEAT15_22_, job0_.TRANSITIONNAME_ as TRANSIT16_22_
, job0_.ACTION_ as ACTION17_22_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_22_, job0_
.GRAPHELEMENT_ as GRAPHEL19_22_, job0_.NODE_ as NODE20_22_, job0_.CLASS_ as CLAS
S2_22_ from JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?
) and job0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>true order
by job0_.DUEDATE_ asc limit ?]
16:23:44,554 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou
ld not execute query
16:23:44,554 ERROR [JobExecutorThread] exception in job executor thread. waiting
 40000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:59)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54
)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2452)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
        at org.hibernate.loader.Loader.list(Loader.java:2187)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
ava:859)
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:55)
        ... 2 more
Caused by: java.sql.SQLException: Table not found in statement [/* named HQL que
ry JobSession.getFirstAcquirableJob */ select job0_.ID_ as ID1_22_, job0_.VERSIO
N_ as VERSION3_22_, job0_.DUEDATE_ as DUEDATE4_22_, job0_.PROCESSINSTANCE_ as PR
OCESSI5_22_, job0_.TOKEN_ as TOKEN6_22_, job0_.TASKINSTANCE_ as TASKINST7_22_, j
ob0_.ISSUSPENDED_ as ISSUSPEN8_22_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_22_, job0_.L
OCKOWNER_ as LOCKOWNER10_22_, job0_.LOCKTIME_ as LOCKTIME11_22_, job0_.EXCEPTION
_ as EXCEPTION12_22_, job0_.RETRIES_ as RETRIES13_22_, job0_.NAME_ as NAME14_22_
, job0_.REPEAT_ as REPEAT15_22_, job0_.TRANSITIONNAME_ as TRANSIT16_22_, job0_.A
CTION_ as ACTION17_22_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_22_, job0_.GRAPHELE
MENT_ as GRAPHEL19_22_, job0_.NODE_ as NODE20_22_, job0_.CLASS_ as CLASS2_22_ fr
om JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?) and job
0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>true order by job0_.
DUEDATE_ asc limit ?]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepar
eStatement(BaseWrapperManagedConnection.java:449)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:437)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:243)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
        at org.hibernate.loader.Loader.doQuery(Loader.java:717)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
        at org.hibernate.loader.Loader.doList(Loader.java:2449)
        ... 11 more
16:24:00,011 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:24:00,011 ERROR [JDBCExceptionReporter] Table not found in statement [/* from
 CronTab ct order by ct.id */ select crontab0_.CT_ID as CT1_38_, crontab0_.CT_NA
ME as CT2_38_, crontab0_.CT_EXPRESSION as CT3_38_, crontab0_.CT_FILE_CONTENT as
CT4_38_, crontab0_.CT_FILE_NAME as CT5_38_, crontab0_.CT_FILE_MIME as CT6_38_, c
rontab0_.CT_MAIL as CT7_38_, crontab0_.CT_ACTIVE as CT8_38_, crontab0_.CT_LAST_B
EGIN as CT9_38_, crontab0_.CT_LAST_END as CT10_38_ from OKM_CRON_TAB crontab0_ o
rder by crontab0_.CT_ID]
16:24:00,012 ERROR [Cron] could not execute query
com.openkm.core.DatabaseException: could not execute query
        at com.openkm.dao.CronTabDAO.findAll(CronTabDAO.java:163)
        at com.openkm.core.Cron.run(Cron.java:48)
        at java.util.TimerThread.mainLoop(Unknown Source)
        at java.util.TimerThread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2452)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
        at org.hibernate.loader.Loader.list(Loader.java:2187)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.openkm.dao.CronTabDAO.findAll(CronTabDAO.java:159)
        ... 3 more
Caused by: java.sql.SQLException: Table not found in statement [/* from CronTab
ct order by ct.id */ select crontab0_.CT_ID as CT1_38_, crontab0_.CT_NAME as CT2
_38_, crontab0_.CT_EXPRESSION as CT3_38_, crontab0_.CT_FILE_CONTENT as CT4_38_,
crontab0_.CT_FILE_NAME as CT5_38_, crontab0_.CT_FILE_MIME as CT6_38_, crontab0_.
CT_MAIL as CT7_38_, crontab0_.CT_ACTIVE as CT8_38_, crontab0_.CT_LAST_BEGIN as C
T9_38_, crontab0_.CT_LAST_END as CT10_38_ from OKM_CRON_TAB crontab0_ order by c
rontab0_.CT_ID]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepar
eStatement(BaseWrapperManagedConnection.java:449)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:437)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:243)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
        at org.hibernate.loader.Loader.doQuery(Loader.java:717)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
        at org.hibernate.loader.Loader.doList(Loader.java:2449)
        ... 11 more
16:24:24,557 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:24:24,558 ERROR [JDBCExceptionReporter] Table not found in statement [/* name
d HQL query JobSession.getFirstAcquirableJob */ select job0_.ID_ as ID1_22_, job
0_.VERSION_ as VERSION3_22_, job0_.DUEDATE_ as DUEDATE4_22_, job0_.PROCESSINSTAN
CE_ as PROCESSI5_22_, job0_.TOKEN_ as TOKEN6_22_, job0_.TASKINSTANCE_ as TASKINS
T7_22_, job0_.ISSUSPENDED_ as ISSUSPEN8_22_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_22_
, job0_.LOCKOWNER_ as LOCKOWNER10_22_, job0_.LOCKTIME_ as LOCKTIME11_22_, job0_.
EXCEPTION_ as EXCEPTION12_22_, job0_.RETRIES_ as RETRIES13_22_, job0_.NAME_ as N
AME14_22_, job0_.REPEAT_ as REPEAT15_22_, job0_.TRANSITIONNAME_ as TRANSIT16_22_
, job0_.ACTION_ as ACTION17_22_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_22_, job0_
.GRAPHELEMENT_ as GRAPHEL19_22_, job0_.NODE_ as NODE20_22_, job0_.CLASS_ as CLAS
S2_22_ from JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?
) and job0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>true order
by job0_.DUEDATE_ asc limit ?]
16:24:24,558 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: cou
ld not execute query
16:24:24,558 ERROR [JobExecutorThread] exception in job executor thread. waiting
 80000 milliseconds
org.jbpm.JbpmException: couldn't get acquirable jobs
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:59)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread
.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:54
)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2452)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
        at org.hibernate.loader.Loader.list(Loader.java:2187)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.j
ava:859)
        at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:55)
        ... 2 more
Caused by: java.sql.SQLException: Table not found in statement [/* named HQL que
ry JobSession.getFirstAcquirableJob */ select job0_.ID_ as ID1_22_, job0_.VERSIO
N_ as VERSION3_22_, job0_.DUEDATE_ as DUEDATE4_22_, job0_.PROCESSINSTANCE_ as PR
OCESSI5_22_, job0_.TOKEN_ as TOKEN6_22_, job0_.TASKINSTANCE_ as TASKINST7_22_, j
ob0_.ISSUSPENDED_ as ISSUSPEN8_22_, job0_.ISEXCLUSIVE_ as ISEXCLUS9_22_, job0_.L
OCKOWNER_ as LOCKOWNER10_22_, job0_.LOCKTIME_ as LOCKTIME11_22_, job0_.EXCEPTION
_ as EXCEPTION12_22_, job0_.RETRIES_ as RETRIES13_22_, job0_.NAME_ as NAME14_22_
, job0_.REPEAT_ as REPEAT15_22_, job0_.TRANSITIONNAME_ as TRANSIT16_22_, job0_.A
CTION_ as ACTION17_22_, job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_22_, job0_.GRAPHELE
MENT_ as GRAPHEL19_22_, job0_.NODE_ as NODE20_22_, job0_.CLASS_ as CLASS2_22_ fr
om JBPM_JOB job0_ where (job0_.LOCKOWNER_ is null or job0_.LOCKOWNER_=?) and job
0_.RETRIES_>0 and job0_.DUEDATE_<=? and job0_.ISSUSPENDED_<>true order by job0_.
DUEDATE_ asc limit ?]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepar
eStatement(BaseWrapperManagedConnection.java:449)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:437)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:243)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
        at org.hibernate.loader.Loader.doQuery(Loader.java:717)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
        at org.hibernate.loader.Loader.doList(Loader.java:2449)
        ... 11 more
16:25:00,003 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:25:00,005 ERROR [JDBCExceptionReporter] Table not found in statement [/* from
 CronTab ct order by ct.id */ select crontab0_.CT_ID as CT1_38_, crontab0_.CT_NA
ME as CT2_38_, crontab0_.CT_EXPRESSION as CT3_38_, crontab0_.CT_FILE_CONTENT as
CT4_38_, crontab0_.CT_FILE_NAME as CT5_38_, crontab0_.CT_FILE_MIME as CT6_38_, c
rontab0_.CT_MAIL as CT7_38_, crontab0_.CT_ACTIVE as CT8_38_, crontab0_.CT_LAST_B
EGIN as CT9_38_, crontab0_.CT_LAST_END as CT10_38_ from OKM_CRON_TAB crontab0_ o
rder by crontab0_.CT_ID]
16:25:00,013 ERROR [Cron] could not execute query
com.openkm.core.DatabaseException: could not execute query
        at com.openkm.dao.CronTabDAO.findAll(CronTabDAO.java:163)
        at com.openkm.core.Cron.run(Cron.java:48)
        at java.util.TimerThread.mainLoop(Unknown Source)
        at java.util.TimerThread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:92)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:66)
        at org.hibernate.loader.Loader.doList(Loader.java:2452)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)
        at org.hibernate.loader.Loader.list(Loader.java:2187)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja
va:363)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java
:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.openkm.dao.CronTabDAO.findAll(CronTabDAO.java:159)
        ... 3 more
Caused by: java.sql.SQLException: Table not found in statement [/* from CronTab
ct order by ct.id */ select crontab0_.CT_ID as CT1_38_, crontab0_.CT_NAME as CT2
_38_, crontab0_.CT_EXPRESSION as CT3_38_, crontab0_.CT_FILE_CONTENT as CT4_38_,
crontab0_.CT_FILE_NAME as CT5_38_, crontab0_.CT_FILE_MIME as CT6_38_, crontab0_.
CT_MAIL as CT7_38_, crontab0_.CT_ACTIVE as CT8_38_, crontab0_.CT_LAST_BEGIN as C
T9_38_, crontab0_.CT_LAST_END as CT10_38_ from OKM_CRON_TAB crontab0_ order by c
rontab0_.CT_ID]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepar
eStatement(BaseWrapperManagedConnection.java:449)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:437)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:243)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1616)
        at org.hibernate.loader.Loader.doQuery(Loader.java:717)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo
ader.java:270)
        at org.hibernate.loader.Loader.doList(Loader.java:2449)
        ... 11 more
Saludos

Re: Instalación con Postgre

 #12579  by jllort
 
Varias cosas: que versión postgresql estas utilizando. También sería interesante conocer la versión de java y el sistema operativo.

Que tablas te esta creando ? te ha creado alguna verdad ? tanto en okm_repo como en okm_app ?

De momento te aconsejo lo siguiente:
1- Borra el directorio repository ( dentro de jboss )
2- Asegúrate que con el usuario / password puedes conectar con la base de datos
3- Comprueba la version del driver de postgresql, a veces los problemas pueden proceder del driver.
4- Te aconsejo que pruebes con la versión de integration.openkm.com ( 5.1.x ), trae correcciones respecto la 5.1.7 ( en especial para oracle, pero puede ser que también algunas cosas que detectamos en oracle también afecten la postgresql ).

Ya nos vas informando, a ver si esto te soluciona el problema.

Re: Instalación con Postgre

 #12615  by sorarluyx
 
hola Jllort,

Gracias por tu pronta respuesta, primeramente si fue un problema de versión del postgre con respecto al driver, adicionalmente mi lectura de la explicación de la creción de las tablas (en el wiki) fue erronea, como no las habia creado en postgre obviamente no levantaba la herramienta. El dia de hoy la herramienta levanto seguire haciendo pruebas y te seguire contando. Gracias por la explicación y la ayuda :D

Re: Instalación con Postgre

 #12637  by sorarluyx
 
hola jllort,

1.- Primeramente te doy un pequeño recuento, las pruebas han resultado positivas ya logre vincular la BD :D ahora estoy probando con los backup

2.- Ahora me queda una duda, los ficheros de archivos quedan registrados en el repository, seria posible que los ficheros se guarden en la BD y no en el repository?

3.- Para realizar una migración o quizas actualización del servidor se debe respaldar toda la carpeta del OpenKM y la BD en postgreSQL? O bien se podria realizar una instalación limpia y luego restaurar la BD y el Repository?

De antemano muchas gracias :D

Re: Instalación con Postgre

 #12664  by pavila
 
Para la copia de seguridad debes guardar tanto las bases de datos como el fichero $JBOSS_HOME/repository.xml y el directorio $JBOSS_HOME/repository.

Re: Instalación con Postgre

 #14020  by sorarluyx
 
Hola, disculpa la tardanza.

He realizado los procedimientos recomendados los cuales han sido satisfactorios.

Gracias por todo el apoyo brindado :D
 Reply
 Return to “Instalación”

Favorites

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.

Powered By phpBB -
 ©OpenKM 2021
 - All times are UTC -