DX Unified Infrastructure Management

 View Only
  • 1.  sql_response undocumented error

    Posted 19 days ago

    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 14 days ago

    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