Hi Guys ,

I am facing issue on Report definition in UAT.

Actually, in Dev report is working fine when we search with contains and we can use full search it's showing the data.

coming to UAT, when we click full search that columns showing blank, but when use filter it's showing data in Ui.

i am the save database table in Dev and UAT. but it not working.

In Clipboard i saw below error 

There is 1 error

• An error occured on executing the query for the report definition - There was a problem getting a list: code: 6522 SQLState: S0001 Message: A .NET Framework error occurred during execution of user-defined routine or aggregate "pr_read_decimal_from_stream":
• System.FormatException: The input wasn't in a correct format.
• System.FormatException:
• at System.Data.SqlTypes.SqlDecimal.Parse(String s)
• at com.pega.pegarules.data.udf.directstreamreader.UserDefinedFunctions.pr_read_decimal_from_stream(String aProperty, String aInsKey, SqlBinary aBlob)
• .
• DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: A .NET Framework error occurred during execution of user-defined routine or aggregate "pr_read_decimal_from_stream":
• | SQL Code: 6522 | SQL State: S0001

I ever see this type error, please help me 

Thanks in Advance.