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.

Related articles

The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.



Related issues