Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL0904 - Resource limit exceeded

Posted on 2003-11-28
3
Medium Priority
?
4,365 Views
Last Modified: 2007-12-19
Have been using MS SQL to retrieve data from our AS/400 quite successfully. Yesterday for no apparent reason the retrieval started failing on some records with the following error message; Microsoft OLE DB Provider for SQL Server error '80040e14' [OLE/DB provider returned message: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0904 - Resource limit exceeded.] /qnative/order1.asp, line 149. The AS/400 information for MSGID SQL0904 shows “type 7 maximum size of prepared statement has been reached”. Can anyone advise a fix or suggest where I look next please?
0
Comment
Question by:stevespicer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 500 total points
ID: 9838924
Have you added any more tables or fields to the query?  Has someone change the governor options on the AS400???
0
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 9839410
0
 

Author Comment

by:stevespicer
ID: 9848673
The problem was the SQLPKG size that is created on teh AS/400 each time an SQL query is run. It grew too large and stopped. Merely deleting teh package caused it to be recraeted next run. So housekeep the AS/400 objects *SQLPKG.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question