Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy

Hi Guys.

I've got an audit job that should be run periodically, but it failed yesterday and the only explanation i can think of its hit the maximum number of rows that are allowed in a holdfile

spent a while searching for the magic number but can't find anything out in the world of Google

Its not my program so can't amend the select, it selects the whole file and one of its functions is to record what was there, before it tidies up and deletes the records, i don't really need the holdfile, but the author thinks it useful

i manually assign a holdfile at the start of the job and its previously worked fine, the last time it ran it  had 1.3M rows went into the holdfile perfect well

yesterday the job stopped with  1541766 ROWS

I've asked the provider to add a date select into the job, but in the mean time if "collective" can let me know if i've hit  the limit for a holdfile, that would eliminate one possible cause of the failure

Many thanks

Andy