Error during the execution of Date Generation transform

Hi All

I was trying out the Date Generation transform in sap bods, but it ended up with the following error:-

What I felt was that, its related to SQL binding error, however the template table is present in the sql server and the date range which i took was:-

2016.06.22 to 2016.09.30? Any solution for this?