Oracle Database Discussions

at my wits end, this setup works great going from 64bit oracle to a separate 32bit oracle server with 32bit sybase drivers. We are trying to shut down running that server, and move everything onto one machine.

Now going from the same 64bit server, to it's own 64bit HS to 64bit sybase sqlanywhere driver, it tests fine both in the odbc driver, and the public database link, but when I attempt to pull down records it disconnects after ~45 seconds, I've attempted varius init variables, the log reflects the current init posted below.

Dsn names changed for security, the query was select Facility_Name from sybase.table

If I do select * from table it works, but if I scroll through about 250 records in sql developer it'll trigger the error, if I do select "Facility_Name" from the table it gives this error every time

I think there's a problem with nulls or some of the data, when I used the HS_LANGUAGE option I did not ever see it picked up with a HOSGIP entry

dg4odbc init
HS_FDS_CONNECT_INFO=localcon
HS_FDS_TRACE_LEVEL=DEBUG
HS_FDS_FETCH_ROWS=1
HS_FDS_SUPPORT_STATISTICS=FALSE
#HS_LANGUAGE=AMERICAN_AMERICA.EE8MSWIN1250
#HS_NLS_NCHAR=American_America.we8mswin1252
#HS_FDS_REPORT_REAL_AS_DOUBLE=TRUE
#HS_FDS_QUOTE_IDENTIFIER=FALSE
#HS_FDS_SQLLEN_INTERPRETATION=32
#HS_FDS_TIMESTAMP_MAPPING=DATE



sybase odbc driver log

Sun Sep 11 2011 09:05:58
09:05:58 Attempting to connect using:
UID=user;PWD=********;DBN=WS;ENG=WSrv;CON=SQL_DBC_70fa060;ASTOP=NO;INT=NO;CBSIZE=500;DBG=YES;ENC='tls{trusted_certificates=C:\CERT\PublicCertificate.pem;tls_type=rsa;fips=1}';LTO=220;LOG=e:\matt\sybaselog.txt;
09:05:58 Attempting to connect to a running server...
09:05:58 Trying to start TCPIP link ...
09:05:58 TCP using Winsock version 2.2
09:05:58 My IP address is x.x.x.x
09:05:58 My IP address is ::1
09:05:58 My IP address is 127.0.0.1
09:05:58 TCPIP link started successfully
09:05:58 Attempting TCPIP connection (address x.x.x.x:2638 found in sasrv.ini cache)
09:05:58 Trying to find server at cached address x.x.x.x:2638 without broadcasting
09:05:58 Found server, verifying server name
09:05:58 Found database server at address x.x.x.x
09:05:58 Found database server ws on TCPIP link
09:05:58 Connected using client address x.x.x.x:52214
09:05:58 Connected to server over TCPIP at address x.x.x.x:2638
09:05:58 Connected to SQL Anywhere Server version 11.0.1.2606
09:05:58 Application information:
09:05:58 IP=1.x.x.x;HOST=BM;OSUSER=SYSTEM;OS='Windows 2008 Build 6002 Service Pack 2';EXE=e:\oracle\product\11.2.0\dbhome_1\bin\dg4odbc.exe;PID=0x2bbc;THREAD=0x24b4;VERSION=11.0.1.2652;API=ODBC;TIMEZONEADJUSTMENT=-240
09:05:58 Connected to the server, attempting to connect to a running database...
09:05:59 [ 222] Connected to database successfully
09:09:44 [ 222] Client disconnected

oracle HS trace


Oracle Corporation --- SUNDAY SEP 11 2011 09:05:58.637
Heterogeneous Agent Release
11.2.0.1.0
Oracle Corporation --- SUNDAY SEP 11 2011 09:05:58.637
Version 11.2.0.1.0
Entered hgogprd
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "DEBUG"
Entered hgosdip
setting HS_OPEN_CURSORS to default of 50
setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
setting HS_FDS_RECOVERY_PWD to default value
setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
setting HS_IDLE_TIMEOUT to default of 0
setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
setting HS_NLS_NCHAR to default of "UCS2"
setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
setting HS_FDS_DATE_MAPPING to default of "DATE"
setting HS_RPC_FETCH_REBLOCKING to default of "ON"
HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS
setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
setting HS_FDS_RSET_RETURN_ROWCOUNT 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
setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
setting HS_FDS_DELAYED_OPEN to default of "TRUE"
setting HS_FDS_WORKAROUNDS to default of "0"
Exiting hgosdip, rc=0
ORACLE_SID is "local"
Product-Info:
Port Rls/Upd:1/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:11.2.0.1.0_0008, Instance:local
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=178
HOCXU_DRV_NCHAR=1000
HOCXU_DB_CSET=178
HOCXU_SEM_VER=112000
Entered hgolofn at 2011/09/11-09:05:58
Exiting hgolofn, rc=0 at 2011/09/11-09:05:58
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
treat_SQLLEN_as_compiled = 1
Exiting hgoinit, rc=0 at 2011/09/11-09:05:58
Entered hgolgon at 2011/09/11-09:05:58
reco:0, name:user, tflag:0
Entered hgosuec at 2011/09/11-09:05:58
Exiting hgosuec, rc=0 at 2011/09/11-09:05:58
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using user as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
Entered hgocont at 2011/09/11-09:05:58
HS_FDS_CONNECT_INFO = "local"
RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
Entered hgogenconstr at 2011/09/11-09:05:58
dsn:localcon, name:user
optn:
Entered hgocip at 2011/09/11-09:05:58
dsn:localcon
Exiting hgocip, rc=0 at 2011/09/11-09:05:58
Exiting hgogenconstr, rc=0 at 2011/09/11-09:05:58
Entered hgolosf at 2011/09/11-09:05:59
Exiting hgolosf, rc=0 at 2011/09/11-09:05:59
DriverName:DBODBC11.DLL, DriverVer:11.00.0001
DBMS Name:SQL Anywhere, DBMS Version:11.00.0001
Exiting hgocont, rc=0 at 2011/09/11-09:05:59
SQLGetInfo returns N for SQL_CATALOG_NAME
Exiting hgolgon, rc=0 at 2011/09/11-09:05:59
Entered hgoulcp at 2011/09/11-09:05:59
Entered hgowlst at 2011/09/11-09:05:59
Exiting hgowlst, rc=0 at 2011/09/11-09:05:59
SQLGetInfo returns 0x1f for SQL_OWNER_USAGE
TXN Capable:3, Isolation Option:0xf
SQLGetInfo returns 128 for SQL_MAX_SCHEMA_NAME_LEN
SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
SQLGetInfo returns 128 for SQL_MAX_PROCEDURE_NAME_LEN
SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR
SQLGetInfo returns Y for SQL_COLUMN_ALIAS
3 instance capabilities will be uploaded
capno:1989, context:0x00000000, add-info: 0
capno:1991, context:0x0001ffff, add-info: 0
capno:1992, context:0x0001ffff, add-info: 0
Exiting hgoulcp, rc=0 at 2011/09/11-09:05:59
Entered hgouldt at 2011/09/11-09:05:59
NO instance DD translations were uploaded
Exiting hgouldt, rc=0 at 2011/09/11-09:05:59
Entered hgobegn at 2011/09/11-09:05:59
tflag:0 , initial:1
hoi:0x12ee28, ttid (len 23) is ...
00: 4E433150 2E613162 66396364 632E362E [NP.a1bf9cdc.6.]
10: 372E3131 383832 [7.11882]
tbid (len 20) is ...
00: 4E433150 5B362E37 2E313138 38325D5B [NP[6.7.11882][]
10: 312E335D [1.3]]
Exiting hgobegn, rc=0 at 2011/09/11-09:05:59
Entered hgodtab at 2011/09/11-09:05:59
count:1
table: xxxx.STATUS
Allocate hoada[0] @ 000000000648F460
Entered hgopcda at 2011/09/11-09:05:59
Column:1(Facility): dtype:4 (INTEGER), prc/scl:10/0, nullbl:0, octet:0, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:05:59
Entered hgopcda at 2011/09/11-09:05:59
Column:2(Facility_Name): dtype:12 (VARCHAR), prc/scl:50/0, nullbl:1, octet:50, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:05:59
Entered hgopcda at 2011/09/11-09:05:59
Column:3(RIC): dtype:12 (VARCHAR), prc/scl:3/0, nullbl:1, octet:3, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
Entered hgopcda at 2011/09/11-09:06:00
Column:4(Document_No): dtype:12 (VARCHAR), prc/scl:30/0, nullbl:0, octet:30, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
Entered hgopcda at 2011/09/11-09:06:00
Column:5(NIIN): dtype:12 (VARCHAR), prc/scl:30/0, nullbl:1, octet:30, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
Entered hgopcda at 2011/09/11-09:06:00
Column:6(Qty_Ordered): dtype:4 (INTEGER), prc/scl:10/0, nullbl:1, octet:30, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
Entered hgopcda at 2011/09/11-09:06:00
Column:7(TCN): dtype:12 (VARCHAR), prc/scl:30/0, nullbl:1, octet:30, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
Entered hgopcda at 2011/09/11-09:06:00
Column:8(Processed_Date): dtype:93 (TIMESTAMP), prc/scl:26/6, nullbl:1, octet:30, sign:1, radix:10
Exiting hgopcda, rc=0 at 2011/09/11-09:06:00
The hoada for table xxxx.xxxx_STATUS follows...
hgodtab, line 904: Printing hoada @ 000000000648F460
MAX:8, ACTUAL:8, BRC:1, WHT=6 (TABLE_DESCRIBE)
hoadaMOD bit-values found (0x200:TREAT_AS_CHAR)
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
4 INTEGER N 4 4 0/ 0 0 0 0 Facility
12 VARCHAR Y 50 50 0/ 0 0 0 200 Facility_Name
12 VARCHAR Y 3 3 0/ 0 0 0 200 RIC
12 VARCHAR N 30 30 0/ 0 0 0 200 Document_No
12 VARCHAR Y 30 30 0/ 0 0 0 200 NIIN
4 INTEGER Y 4 4 0/ 0 0 0 0 Qty_Ordered
12 VARCHAR Y 30 30 0/ 0 0 0 200 TCN
91 DATE Y 16 16 0/ 0 0 0 0 Processed_Date
Exiting hgodtab, rc=0 at 2011/09/11-09:06:00
Entered hgodafr, cursor id 0 at 2011/09/11-09:06:00
Free hoada @ 000000000648F460
Exiting hgodafr, rc=0 at 2011/09/11-09:06:00
HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: Read error.
Entered hgoroll at 2011/09/11-09:09:44
tflag:0 , cmt(38):Unexpected EOF from Oracle - Rollback
hoi:0x63ed9f0, ttid (len 23) is ...
00: 4E433150 2E613162 66396364 632E362E [NP.a1bf9cdc.6.]
10: 372E3131 383832 [7.11882]
tbid (len 20) is ...
00: 4E433150 5B362E37 2E313138 38325D5B [NP[6.7.11882][]
10: 312E335D [1.3]]
Entered hgocpctx at 2011/09/11-09:09:44
Exiting hgocpctx, rc=0 at 2011/09/11-09:09:44
Exiting hgoroll, rc=0 at 2011/09/11-09:09:44
Entered hgolgof at 2011/09/11-09:09:44
tflag:0
Exiting hgolgof, rc=0 at 2011/09/11-09:09:44
Entered hgoexit at 2011/09/11-09:09:44
Exiting hgoexit, rc=0

Edited by: 884617 on Sep 12, 2011 7:26 AM