ERROR: "prepared statement "PRSTMT..." does not exit"

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
timbeach
Posts: 3
Joined: Mon 26 Feb 2018 01:49

ERROR: "prepared statement "PRSTMT..." does not exit"

Post by timbeach » Mon 26 Feb 2018 01:55

I'm getting this ERROR:
"prepared statement "PRSTMT..." does not exit"

I found another thread from 2010 or 2011 referencing the error, but this seems different.

My database connections test as okay, but then when I try to do the comparison, I get that error.

I'm using the current version of dbForge for PostgreSQL and my database servers are running postgres 9.3.

Pls help!

Thanks,
Tim Beach

alexa

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by alexa » Tue 27 Feb 2018 09:49

We will investigate this issue and will answer you as soon as possible.

alexa

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by alexa » Tue 27 Feb 2018 11:04

You could try creating empty databases and compare with each other. Is the error still present?

Also, please let us know what server versions you are using and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce the error and send us the *.log file with the latest date from the directory:
%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Data Compare for PostgreSQL\

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

timbeach
Posts: 3
Joined: Mon 26 Feb 2018 01:49

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by timbeach » Thu 01 Mar 2018 16:14

Great. Thank you. I will do that and send to support and also follow back up with this post.

timbeach
Posts: 3
Joined: Mon 26 Feb 2018 01:49

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by timbeach » Tue 06 Mar 2018 12:19

I sent an email as instructed. I'm also pasting the log contents here:

Logging started at 03/06/2018 06:03:00
3/6/2018 6:03:02 AM | info | InitializeComponent complete
3/6/2018 6:03:02 AM | info | Form state loaded
datacompare.exe Information: 0 : 6:03 AM: dbForge Data Compare for PostgreSQL: Start: 3/6/2018 6:03:02 AM
3/6/2018 6:03:11 AM | info | RegisterInternal component=CategoryImageProvider, service=Devart.Shell.ICategoryImageProvider, true
3/6/2018 6:03:11 AM | info | RegisterInternal component=StudioDockingManager, service=Devart.Shell.IDockingManager, true
3/6/2018 6:03:11 AM | info | RegisterInternal component=FindReplaceController, service=Devart.Shell.IFindReplaceController, true
3/6/2018 6:03:12 AM | info | Output: Application started at 3/6/2018 6:03:12 AM
3/6/2018 6:03:15 AM | info | HttpHandler: GetLatestVersionAsync = http://devart.com/FileUpdateHandler.axd ... 24.0&cpid=
3/6/2018 6:03:29 AM | info | DataComparisonWizard: Create.
3/6/2018 6:03:29 AM | info | Comparison: Create data comparison.
3/6/2018 6:03:30 AM | info | DataComparisonWizard: Set property 'Comparison' = Devart.DbForge.Compare.PostgreSql.PgSqlDataComparison.
3/6/2018 6:03:30 AM | info | DataComparisonWizard: Set property 'Comparison' = Devart.DbForge.Compare.PostgreSql.PgSqlDataComparison.
3/6/2018 6:03:31 AM | info | ConnectionsPage: Create.
3/6/2018 6:03:31 AM | info | ConnectionsPage: Load state, reload = True.
3/6/2018 6:03:39 AM | info | ConnectionsPage: Save state.
3/6/2018 6:03:39 AM | info | ConnectionsPage: Create metadata provider, type = Database
3/6/2018 6:03:39 AM | info | ConnectionsPage: Create metadata provider, type = Database
3/6/2018 6:03:39 AM | info | Output: Connection '<db-name>.<private-IP>:<port-number>' was connected.
3/6/2018 6:03:40 AM | info | Output: Connection '<db-name>.<private-IP>:<port-number>' was connected.
3/6/2018 6:03:40 AM | info | OptionsPage: Create page.
3/6/2018 6:04:19 AM | info | DataComparisonWizard: Set property 'PageComparisonMapping' = Devart.DbForge.Compare.Wizards.PostgreSql.PgSqlDataComparisonMappingPage.
3/6/2018 6:04:19 AM | info | DataComparisonWizard: Set property 'PageComparisonMapping' = Devart.DbForge.Compare.Wizards.PostgreSql.PgSqlDataComparisonMappingPage.
3/6/2018 6:04:19 AM | info | MappingPage: Load state, reload = True.
3/6/2018 6:04:19 AM | info | MappingPage: Start mapping.
3/6/2018 6:04:19 AM | 7 | info | : Start comparison work.
Operation type: MapObjectsWithDescribe
Source provider type: Database
Source provider encoding: System.Text.UTF8Encoding
Source server version: 9030010
Target provider type: Database
Target provider encoding: System.Text.UTF8Encoding
Target server version: 9030010
Options snapshot:
3/6/2018 6:04:19 AM | 7 | info | : Start describing.
3/6/2018 6:04:19 AM | 7 | info | DataComparisonDescriber: Group names = Table,View,Trigger.
3/6/2018 6:04:19 AM | info | : Cancel operation requested.
3/6/2018 6:04:19 AM | info | Cancel async operation
3/6/2018 6:04:19 AM | info | : Describing done.
Exception:
Type = Devart.Shell.MessageException
Message = prepared statement "PRSTMT688128661893667" does not exist

Source =
StackTrace =
3/6/2018 6:06:09 AM | info | DataComparisonWizard: Abort.
3/6/2018 6:06:11 AM | info | : Cancel operation requested.
3/6/2018 6:07:08 AM | info | DataComparisonWizard: Create.
3/6/2018 6:07:08 AM | info | Comparison: Create data comparison.
3/6/2018 6:07:08 AM | info | DataComparisonWizard: Set property 'Comparison' = Devart.DbForge.Compare.PostgreSql.PgSqlDataComparison.
3/6/2018 6:07:08 AM | info | DataComparisonWizard: Set property 'Comparison' = Devart.DbForge.Compare.PostgreSql.PgSqlDataComparison.
3/6/2018 6:07:08 AM | info | ConnectionsPage: Create.
3/6/2018 6:07:08 AM | info | ConnectionsPage: Load state, reload = True.
3/6/2018 6:07:17 AM | info | ConnectionsPage: Save state.
3/6/2018 6:07:17 AM | info | ConnectionsPage: Create metadata provider, type = Database
3/6/2018 6:07:17 AM | info | ConnectionsPage: Create metadata provider, type = Database
3/6/2018 6:07:18 AM | info | Output: SET datestyle=ISO ; SET client_encoding='UTF8'

3/6/2018 6:07:18 AM | info | Output: Execution time: -1 second(s)
3/6/2018 6:07:18 AM | info | Output: SELECT ''
prepared statement "PRSTMT21002787571072444" does not exist
3/6/2018 6:07:18 AM | info | Output: ROLLBACK
prepared statement "PRSTMT3849714321072584" does not exist
Exception:
Type = Devart.Data.PostgreSql.PgSqlException
Message = prepared statement "PRSTMT21002787571072444" does not exist
Source = Devart.DbForge.Data.PostgreSql
StackTrace =
at Devart.Data.PostgreSql.PgSqlDataReader.c(Int32 A_0)

at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)

at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)

at Devart.Common.DbCommandBase.ExecuteNonQuery()

at Devart.DbForge.Utils.QueryHelper.ExecuteNonQuery(IDataConnectionSupport support, String commandText)

at Devart.DbForge.DataConnectionSupport.ExecuteNonQuery(String commandText)

at Devart.DbForge.PostgreSql.PgSqlDataConnectionSupport.Ping()

at Devart.DbForge.Compare.DatabaseMetadataProvider.Open()

at Devart.DbForge.Compare.Wizards.DataComparisonWizardController.IsPageValid(String pageId)

alexa

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by alexa » Tue 06 Mar 2018 12:59

Thank you for the reply.

We will investigate this issue and will answer you as soon as possible.

alexa

Re: ERROR: "prepared statement "PRSTMT..." does not exit"

Post by alexa » Wed 14 Mar 2018 14:34

Unfortunately, we were not able to reproduce this issue.

Could you please provide us the CREATE definitions for the Source and Target tables?

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

Post Reply