Hello,Based on the error message a number was expected but string was found.It happened at column BaseRef of table INV1.In the internal select statement it was converted to INT but it seems there are some values in that column that cannot be converte...
Try to specify different data type for calculated column WEEK_TEST.Now it is specified as DATE.Check if it shows the expected values if INTEGER is selected.Best Regards,Zsolt
Hello Abel,Try to format the date to YYYY-MM-DD format and check if that helps.You can find examples here:WEEK Function (Datetime)Please also check Datetime Data Types.Best Regards,Zsolt
Hello Daniel,Historical information about uncommitted write transactions can be found in indexserver or indexserver_alert traces.E.g: long running uncommitted write transaction detected: CONNECTION ID =...Please refer to the following documents for m...