Weird error - Need kind advice

[Former Member]

Hi,

While attempting to import transport request into PRD, I notice SAP kept throwing this error:

SQL error -904 occured: Resource limit exceeded. MSGID= Job=023066/PRD01/R3TRANS

Now nothing can get transported and it is getting pretty urgent as we are at wits end. Anybody has any clue or even how to begin troubleshooting this?

Thanks heaps.

WT

[Former Member]

Hi,

Thanks for the link and response. Actually I was already aware on the full error description.

In any case, sap note 63037 gave me a clue (which is an indirect clue from 54028) and I read on IBM Redbook that restarting SAP will delete the SQL packages. Tried restarting the PRD and the problem goes away. Yet another lesson learnt.

Cheers,

WT

[Former Member]

WT,

You didn't state what OS level your machine is running but for V5R3, check this link:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzala/rzalafinder.htm

Input -904 in the first box, click GO and follow the subsequent link. The TYPE in the error message will determine how you will proceed.

Hope this helps,

Robert

P.S. There is a similar link for V5R4: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzala/rzalafinder.htm