IBM Support

PH30186: UNSUPPORTED FEATURE CALL FOR STORED PROCEDURE IN SNOWFLAKE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Vendor Solution.

Error description

  • Importing a Stored Procedure from Snowflake is successful using
a driver higher than 3.8.2. However validating or testing the
procedure fails with
SQLException (SQLstate:0A000, ErrorCode:2)
net.snowflake.client.jdbc.SnowflakeSQLException: Unsupported
feature 'CALL'.

Local fix

  • 



Problem summary


    

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • This is not a defect in Cognos Analytics. The root cause stems
from the following defect in the Snowflake:
SNOW-224719 - Support escape syntax that is supported by
java.sql.CallableStatement

    



APAR Information




    

  • APAR number
    PH30186
    • 

  • Reported component name
    COGNOS ANALYTIC
    • 

  • Reported component ID
    5724W12XX
    • 

  • Reported release
    B17
    • 

  • Status
    CLOSED  ISV
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-10-05
    • 

  • Closed date
    2020-12-22
    • 

  • Last modified date
    2020-12-22
    • 





    

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

    • 

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

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B17"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            23 December 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback