I have now fixed the error by doing the following:
1. Generate all the pages using data asssit
2. before using ecart delete the wada recordset and recreate it
3. then ecart works correctly
I am asuming there is an error being created when creating the recordset.
Is there any way we can fix this so that I do not have to delete the recordset every time and recreate everytime.