/
Error Creating tables on PostgreSQL
Error Creating tables on PostgreSQL
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
- Make sure that the
max_prepared_transactions
line in thepostgresql.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. - The PostgreSQL service must be restarted after this change has been made.
Related articles
, multiple selections available,
Related content
Reset lost PostgreSQL admin password
Reset lost PostgreSQL admin password
More like this
Can't delete PostgreSQL database
Can't delete PostgreSQL database
More like this
Installation of PostgreSQL Error
Installation of PostgreSQL Error
More like this
PostgreSQL Timeout
PostgreSQL Timeout
More like this
Error: The transaction has aborted.
Error: The transaction has aborted.
More like this
pgAdmin fails to run after installing newer version
pgAdmin fails to run after installing newer version
More like this
© 2023 Foray, LLC - All Rights Reserved