DX Unified Infrastructure Management

 View Only
  • 1.  sql_response undocumented error

    Posted Jun 27, 2024 10:38 AM

    Recently while using sql_response 1.81-HF1 to query an MSSQL SERVER 15 database, i've come across this error message:

    The problem was with one column of type bigint. casting the column to NVARCHAR made the error go away and I received the correct results. is this known? couldn't find anything anywhere about this. btw other bigint-type columns seemed to work fine (though their values were not actually in the bigint range)



    ------------------------------
    Sivan Gazit
    ------------------------------


  • 2.  RE: sql_response undocumented error

    Broadcom Employee
    Posted Jul 02, 2024 12:53 PM

    Hi Sivan,

    Thank you for sharing the issue details. It looks probe using incorrect type to retrieve the column value. We will verify this issue and create an internal defect to track it and fix in future release. 

    Rgds,

    Rajesh B