what is the back end data source you are connecting to is it stored procedure or any other
1 of 1 people found this helpful
Backend datasource is MySql workbench.I was not using any stored procedure.
I Forgot to mention that I was using a Extract connection.
So I have disabled the extract, shifted to live and took the Extract again. This helped and resolved the issue.