Knowledgebase: Server
Error Creating tables on PostgreSQL
Posted by Mont Rothstein on 18 July 2012 11:07 PM

Error Creating tables on PostgreSQL

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.
Fix: Make sure that the max_prepared_transactions line in the 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.
---------------------------
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
---------------------------

Comments (0)