Record List to Excel error: Could not assign
I have created advanced SQL and a structure for it, then I use the record list to Excel to create an Excel file and save it to SFTP.
I tried to debug it in UAT but there is no error. It only occurs in PRD.
Any idea for this?
Regards,
Ruru
Hi Ruru,
It can be the data issue. When the input can reach the data with issue, the error occurs or conversion going wrong. If you have an Integer in your Structure, and the database column is Text .
thanks
cv
Hello Chandra,
My problem is on the record list to Excel not on the Advance SQL. Tried copying the data from PRD to DEV environment to check but unfortunately I still can't replicate the error
It looks your SQL query throwing the error. There is mismatch between the data type what your query is returning vs what your output structure expect.
For example Error : Could not assign '' to 'AutoReport.ModeOfPayment'....
it looks your query is returning empty string but output structure's attribute 'ModeOfPayment' is type of integer or identifier type. so in that case it won't able to assign the text and will throw an error.
Please recheck your query with output structure.
ThanksPankaj
I already checked my structure including the data types for all columns and all are good, also tried to run the advance SQL, (test execute) and found no errors.
Could you please share your oml to troubleshoot it in depth what's the issue.