SAP Knowledge Base Article - Preview

2432417 - jConnect: Connection to IQ receives SybSQLException: TDS: internal error 2 - SDK for SAP ASE

Symptom

  • Running ASE jdbc driver to IQ database causes error message "randomly":
    • Nested exception 
      com.sybase.jdbc4.jdbc.SybSQLException: TDS: internal error 2       
      com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4117)       
      com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3207)       
      com.sybase.jdbc4.tds.Tds.readCommandResults(Tds.java:4431)       
      com.sybase.jdbc4.tds.Tds.doCommand(Tds.java:4416)       
      com.sybase.jdbc4.tds.Tds.endTransaction(Tds.java:2553)       
      com.sybase.jdbc4.jdbc.SybConnection.commit(SybConnection.java:1815)
  • Note: TDS: internal error 2 can be seen at different locations in the code:
    • Error finally committing com.sybase.jdbc4.jdbc.SybSQLException: TDS: internal error 2
      ExceptionHandler : Reason: Error in GateKeeper, gate is closed, aggregations status changed to ERROR->SQLError=21, Message=TDS: internal error 2
      ExceptionHandler : Message: Cannot execute action.->SQLError=21, Message=TDS: internal error 2
      ExceptionHandler : Message: Cannot connec to DB: jdbc:sybase:Tds:host:port?SQLINITSTRING=SET TEMPORARY OPTION MAX_HASH_ROWS=18000000 user: dc->DBAccess Err:TDS: internal error 2


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16.0
  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 ( is version JDBC 7.07 )

Product

SAP Adaptive Server Enterprise SDK 16.0 ; SAP IQ 16.0 ; SAP IQ 16.1 ; Sybase SDK 12.5 ; Sybase SDK 15.0 ; Sybase SDK 15.5 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

jdbc, jConnect, jconn4.jar, jconn3.jar, client, sdk, crash, dump, exception, , KBA , BC-SYB-SDK , SDK , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.