Error Creating tables on PostgreSQL

Owned by Diane Hancock
Last updated: Apr 15, 2019

Problem

The below error or something similar may appear when creating the tables on a PostgreSQL database. This will be after entering the Central Config parameters and clicking save.

---------------------------
Error
---------------------------
An error has occurred. Please type Ctrl-C to copy the contents of this window, paste it into an email, and send it to support@foray.com

7/18/2012 12:11:58 PM - Foray Configure Adams 4.0.12.2

DB Transaction Failed.
Command = CREATE INDEX asset_folder_ts_idx ON asset_folder USING gin(to_tsvector('english', coalesce(agency_id, '') || ' ' || coalesce(crime, '') || ' ' || coalesce(folder_number, '') || ' ' || coalesce(notes, '') || ' ' || coalesce(owner, '') || ' ' || coalesce(type, '') || ' ' || coalesce(status, '')))

at Foray.Adams.DatabaseManager.DatabaseCommunicationError(String message, Exception e, DateTime retryStartTime)
at Foray.Adams.DatabaseManager.WriteCommandToDatabase(IDbTransaction transaction, String commandText, Int32 timeout)
at Foray.Adams.DatabaseManager.CreateTextSearchIndexSQLForEntity(Entity entity)
at Foray.Adams.DatabaseManager.CreateSchema()
at Foray.Adams.DatabaseManager.CreateDatabaseIfNecessary()
at Foray.Adams.Configure.MainWindow.CreateNewDatabaseTables(DatabaseManager dbManager)
at Foray.Adams.Configure.MainWindow.ProcessElevatedActions(Arguments args)
at Foray.Adams.Configure.MainWindow..ctor(Arguments args)
at Foray.Adams.Configure.Program.Main(String[] args)

Inner Exception
relation "asset_folder" does not exist

at Devart.Data.PostgreSql.PgSqlDataReader.e(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Devart.Common.DbCommandBase.ExecuteNonQuery()
at Foray.Adams.DatabaseManager.WriteCommandToDatabase(IDbTransaction transaction, String commandText, Int32 timeout)

---------------------------
OK
---------------------------

Solution

  1. Make sure that the max_prepared_transactions line in the postgresql.conf (e.g. C:\Program Files\PostgreSQL\9.5\data\postgresql.conf) file is uncommented (no # at the beginning) and has a value of 100. 
  2. The PostgreSQL service must be restarted after this change has been made.



© 2023 Foray, LLC - All Rights Reserved