IBM Support

JR64989: DATADIRECT ODBC DRIVER FOR SYBASE IGNORES LEGITIMATE ERROR FROM DATABASE AND JUST HANGS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • DataStage job with ODBC cc stage receives valid error from
Sysbase database but just hangs versus abort.

10:23:47.043 DBMS SYBASE_DW_PROD -- Number (512) Severity (16)
State (9) Server (SYBASE_DW_PROD) Subquery returned more than 1
value. This is illegal when the subquery follows =, !=, <, <= ,
>, >=, or when the subquery is used as an expression.

Information Server provided DataDirect ODBC driver is ignoring
the error and the job just hangs forever.


Tried to to click the stop execution button in DataStage
Director several times to get it to finally abort.

Database server version of Sybase issue encountered:

Adaptive Server Enterprise/16.0 SP04 GA/EBF 29650
SMP/P/x86_64/SLES 12.4/asecorona/3202/64-bit/FBO/Wed Nov 18
09:12:58 2020

Database client running on the DataStage  per "isql -v" command
is:

SAP CTISQL Utility/16.0 SP04
PL01/P-EBF29892/DRV.16.0.04.01/Linux x86_64/Linux
4.12.14-95.71-default x86_64/BUILD1600-027/64bit/OPT/Fri Jun 25
00:54:59 2021

Local fix

  • 



Problem summary


    

  •  Datadirect odbc driver for sybase ignores legitimate error
database and just hangs.

    



Problem conclusion


    

  • Fixed: Issue got fixed in the driver code and after installing
the latest patch the job abort with proper driver message,

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR64989
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    B70
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-05-26
    • 

  • Closed date
    2022-05-29
    • 

  • Last modified date
    2022-05-29
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Modules/Macros


    

  •    ODBC-Dri

    



Fix information


    

  • Fixed component name
    WIS DATASTAGE
    • 

  • Fixed component ID
    5724Q36DS
    • 



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 June 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback