SAP Knowledge Base Article - Preview

3378760 - Source IQ/AIX server crashes during BLOB insert into location to target IQ/linux -SAP IQ


  • On Target IQ/Linux database, executed insert location to copy BLOB data from IQ on AIX.
  • Running "select * from "owner"."table_name" directly on source IQ database, works normally
  • In the middle of the data copy via insert/location using same select statement, the source IQ server crashes with error and stacktrace:
    ***   SAP IQ Abort:
     ***      From:  /home/iqabuild/views/links/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76
     ***      Rethrown from:  oslib/hos_throw.cxx:316
    ***      PID: ****
    ***      Exception Location: ***
    ***      Error ID: 529,  Exception Type: hos_lockexception
    ***      Thread: ***  (TID: ***, Original TID: **)
    ***      Error #: 0,  O/S Error #: 45
    ***      Argument:
    -- (/IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h 76)
     ***      Argument:  45
    Stacktrace requested from /IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76 on thread *** (TID 264) start stacktrace
      **  Error from IQ connection:  SA connHandle: **  SA connID: **  IQ connID: ***  User:***
      **  IQ Version:  SAP IQ/16.1.050/12790/P/SP05.08
      **  OS info:  IQ built on: RS6000MP/AIX 7.1,  Executed on: AIX/dssapsrvu027/2/7/00C2C62E4C00
      **  Command status when error occurred:  NO COMMAND OR CURSOR ACTIVE
    I. 09/12 16:57:59. 0000005756     **  Parser command text:
    select * from "owner"."table_name"
       **  Dump all thread stacks at /IQhome/r16.1.0_sp05_nbld_aix_64/gitsrc/cm/iqa/include/hos_RecursRwLock_inline.h:76 for PID: *****
    ***************** This is the STACKTRACE ***************
    .FetchValueInCursor .df_OmniRowScan::FillRowBuffer



SAP IQ 16.1

  • Source Platform/OS: AIX
  • Target Platform/OS: Linux


SAP IQ 16.1


CR828426, CR#828426, 828426, sybase , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Product Enhancement

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.