Group by load problem – General Script Error

[#1]

I have an application which should be quite simple and which works without problems with debug load but fails on full load with General Script Error after group by. There are no synthetic keys.

In short I have a qvd load (TabTmp_COMMENTS2_ALL)

Then a resident from the qvd (TabTmp_COMMENTS2_ALL) and drop the qvd (Tab_COMMENTS_ALL)

And then a Load …. resident from Tab_COMMENTS_ALL with a max and group by (Comments_all)

It is the 2. resident (Comments_all) with group by that fails on full load but have no problem doing a debug load (I have run debug on up to 1.000.000 records without problems - the table in full is 8,7 mill). I use version 8.5.

In the log with full load it states:

22-01-2010 16:08:18: 0118 group by "Key","action_number"

22-01-2010 16:09:32: General Script Error

22-01-2010 16:09:32: Execution Failed

22-01-2010 16:09:32: Execution finished.

In Comments_all I have a statement: max(num(Year("Co_Comments_Date"))) as Co_CommentsYear and I group by key and action_number. There is a date for each key and action_number, some action_numbers are null and some of the dates are in the future.

I have tried everything and can't get it to work on full load only on debug load. Any ideas ?

[#2 · Accepted solution]

There must have been something wrong with some of the data because when I stipulated that key should equal key in another table there was no problem and I can now load without problems.