Oracle Database Discussions

Hi Folks,

I'm trying to stabilize a generic (ODBC) connection from Oracle to a Pervasive SQL database.

I get the errors below on a very regular basis in my alert log, even when the query to the remote database is a select statement. The statements are being executed from within a 3rd party application, so I don't know what might precede or follow the statements that cause the errors.

I've created a HS_TRANSACTION_LOG table in the Pervasive database, but that doesn't seem to have helped. I don't even know if the gateway is attempting to use it or not. The traces themselves do not have any errors in them, which makes this all the more strange and hard to debug. Any suggestions or insight would be much appreciated.

Here's the errors I keep seeing in my alert log

Fri Oct 30 09:48:55 2009
Error 28500 trapped in 2PC on transaction 8.33.39220. Cleaning up.
Error stack returned to user:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Pervasive][ODBC Client Interface][Client LNA]Your connection to the server is no longer working. To continue, disconnect from the data source and re-connect again. Contact your system administrator if you still need assistance.
ORA-02063: preceding 2 lines from FOSOKCPROD

Here's an excerpt from a trace.

Oracle Corporation --- FRIDAY OCT 30 2009 09:56:51.638

Version 11.1.0.7.0

Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
Entered hgosdip
setting HS_OPEN_CURSORS to default of 50
HOSGIP returned value of "MASTER" for HS_FDS_RECOVERY_ACCOUNT
HOSGIP returned a value for HS_FDS_RECOVERY_PWD
setting HS_FDS_TRANSACTION_LOG to default of "HS_TRANSACTION_LOG"
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "AL32UTF8"
setting HS_FDS_TIMESTAMP_AS_DATE to default of "TRUE"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
setting HS_FDS_FETCH_ROWS to default of "100"
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
setting HS_FDS_CHARACTER_SEMANTICS to default of "FALSE"
setting HS_FDS_MAP_NCHAR to default of "TRUE"
setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
setting HS_FDS_QUERY_DRIVER to default of "TRUE"
HOSGIP returned value of "FALSE" for HS_FDS_SUPPORT_STATISTICS
Parameter HS_FDS_QUOTE_IDENTIFIER is not set

Thanks

-Adam vonNieda