Error during the execution of Date Generation transform

[former_member188628]

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?

[Former Member · Accepted solution]

Please check the below forum post.In your Taget tables do you have DATE Columns? If you have one then change it to DATETIME

http://www.forumtopics.com/busobj/viewtopic.php?t=182600&start=0&postdays=0&postorder=asc&sid=24bc0b...

[former_member188628 · Accepted solution]

Hi

  I tried changing the datatype, this time the job is running fine without any errors, however, the contents of the target table ain't getting displayed :-

[Former Member · Accepted solution]

Can you check if the data store connection is fine and also check the columns names in your source and target.

[former_member198401 · Accepted solution]

Are you using the function week_in_month() and week_in_year() to populate the columns. It will return an integer.

Regards

Arun Sasi

[former_member187605 · Accepted solution]

There's kind of a non-printable character in your WeekInYear column name. The database client doesn't like that.

Get rid of that right-arrow and try again.

[former_member188628]

Hi All

     Thanks a lot, for all your responses.There was an error "->" unidentified error in the database column, I am still wondering how did that happen!!As pointed specifically by Dirk, I tried deleting the column from both SQL Server and BODS and then added again and it worked

Thanks

Regards