In Sage Intelligence, has anyone experienced the SQL Debug error ""The data was truncated while converting from one data type to another.[,,,,Name of function(if known),,]."" This error only shows when working in SI on the client's specific workstation, not when working in SI on their terminal server. The error occurs when trying to generate a report, and also when joining two tables in a container and running check/test on that container (we CAN successfully generate reports when the container has only one table).
We've checked on knowledgebase with no luck. Also contacted Sage support directly and they would not help! Any assistance will be greatly appreciated!!!
Thanks!