Error while running Generate New Database job

Error in submitting Generate New Database

You do not get to see this error everyday, but it can so happen that this error can catch you in crucial times and leave you bewildered. If you are stuck on such a day, here is the solution!

The Generate New Database job upon submission will throw this error :
SBL-GEN-0004: Error in Main function

When you examine the task logs you will see this error

DBCLog DBCLogError 1 000122bc4fc62d27:0 2012-05-30 18:07:37 [DataDirect][ODBC lib] Unicode converter buffer overflow GenericLog GenericError 1 000122bc4fc62d27:0 2012-05-30 18:07:37 SQL Message, S1000: [DataDirect][ODBC lib] Unicode converter buffer overflow DBCLog DBCLogError 1 000122bc4fc62d27:0 2012-05-30 18:07:42 SQL Warning, SQL State HY000, 0, [DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased.

Solution

Open the .odbc.ini file in siebsrvr/sys location and in the [ODBC] section there will be a first line Junk value like:

QEWSD=2456429

delete that and save the .odbc.ini file. Run the Generate New DB extract again, Presto!! It works!!