DB Error - Logicaldoc 7.2.1 Community - Postgres

We tried to make LogicalDOC as intuitive as possible, but an advice is always welcome.

Moderator: car031

bhyatm01
Posts: 7
Joined: Fri Sep 08, 2017 5:47 pm

DB Error - Logicaldoc 7.2.1 Community - Postgres

Thu Oct 10, 2019 2:58 pm

Hi,

We use the webservice API to upload documents to LogicalDOc running on Postgres db

when I upload I get the following error

2019-10-10 15:39:51,378 [5] ERROR LogicDoc [(null)] - There was an error Processing
System.Web.Services.Protocols.SoapException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.hibernate.exception.GenericJDBCException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

Any suggestions on how to resolve this ?

Thanks
agaspa
Posts: 714
Joined: Tue Apr 20, 2010 8:24 am

Re: DB Error - Logicaldoc 7.2.1 Community - Postgres

Thu Oct 17, 2019 11:21 am

I suppose there is an error in the SQL statement used for this operation, perhaps the database script for PostgreSQL schema creation has some missing columns in some table.

You should investigate the error by consulting the dms.log file
/LogicalDOC/repository/logs

Return to “Usage”

Who is online

Users browsing this forum: No registered users and 19 guests