Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved ORA-25412 - transaction replay disabled by call to OCIStmtPrepare occuring during live switch to standby database server

  1. Issue
0
Votes
Undo
  1. Jeff Novak
    Jeff Novak
  2. PowerBuilder
  3. Tuesday, 23 April 2024 15:47 PM UTC

Our DBA team tested Oracle’s Transparent Application Continuity (TAC) which allows a live switch of the database from one server to another without losing the Oracle connections to the database.  When the test was performed against our PowerBuilder application, an "ORA-25412 - transaction replay disabled by call to OCIStmtPrepare" error occurred (refer to screenshot in file attachment).

According to Oracle documentation, the OCIStmtPrepare() has been deprecated with Oracle 12c Release and should be replaced with OCIStmtPrepare2().  No references to OCIStmtPrepare exist in the PB source code. 

Does anyone know how the call to OCIStmtPrepare is made or how it can be replaced with OCIStmtPrepare2 in PowerBuilder?

 

PB Version: 2022

Oracle version: 19c (19.17.0.0.0)

Attachments (1)
ORA-25412-Error.jpg ORA-25412-Error.jpg
  1. Oracle
  2. PowerBuilder (Appeon)
SyntaxfromSQL migration issue
RestClient caused application to hang
Responses (2)
Jeff Novak
Jeff Novak Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 16:52 PM UTC
  2. PowerBuilder
  3. # 1

We are using:

DBMS=Ora Oracle

Comment
John Fauss
  1. John Fauss
  2. Tuesday, 23 April 2024 17:50 PM UTC
The error suggests the issue is within the PB/Oracle database driver. I did a search for "OCIStmtPrepare" for any release of PowerBuilder, with no results.

I suggest you open a free support ticket to have Appeon investigate this issue: https://www.appeon.com/standardsupport/newbug
  1. Helpful 2
Jeff Novak
  1. Jeff Novak
  2. Tuesday, 23 April 2024 18:13 PM UTC
Thank you for your response. Much appreciated.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 23 April 2024 15:53 PM UTC
  2. PowerBuilder
  3. # 2

What Oracle database driver (SQLCA.DBMS="???") does your PB application use?

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.