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.
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.
***Edited by Moderator Marije to change type from Pega Academy to Product***
Can you please check if all properties that are exposed in dev are also exposed in Stage? Seems like some input format is different from what is expected. Also please check if you use any function alias
Posted: 11 months ago
Posted: 21 Dec 2022 1:24 EST
keerthi yachamaneni (kirti)