DB Error - Logicaldoc 7.2.1 Community - Postgres

[bhyatm01]

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]

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