Re: SQL0904 - Resource limit type 18 exceeded with reason code 1088611284.

On 16-Apr-2015 11:38 -0500, Needles,Stephen J wrote:

Never have I seen this before. Type 18 isn't defined in the message.

This is happening on a new piece of production code.

I would be sure to try a fresh test, an invocation after a new signon, to be sure no issues with the compile\debug\actgrp activity in the same job might play any role in the origin for the error.

Here is a code snippet from the debugging session:


d SQLString s 500 inz('')
<<SNIP>>

It failed at the "prepare LogInsert from :SQLString"

SQLString = 'insert into remote_machine.local_db.local_table
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)'

<<SNIP>>

Is the actual LOG(4 0 *SECLVL) spooled joblog available, including from the request message that reveals the the program with the PREPARE of the dynamic SQL being invoked, up until the msgSQL0901 LT18 [RC18] with the [apparently uninitialized, with apparent string value " STU", and thus bogus\] unreasonable reason code value? Often times there will be an accompanying\previously-listed message, and even if not, the /context/ of a -904 condition might be more revealing than having no context from a spooled joblog; something might be inferred from the procedure+module+program names that issue the message or the program to which the message, though for the PREPARE all but the sending procedure might reveal nothing more than QSQPREP to confirm the failing statement.