Skip to Content
Former Member
Sep 08, 2010 at 11:55 AM

PI 7.11 - SXI_CACHE Issue - SQL0904 - Resource limit exceeded


Hi IBM I Gurus,

We are having the SXI_CACHE issue in our PI 7.11 SPS04 system. When we try to do the delta cache refresh through SXI_CACHE, it is returning the error SQL 0904 - Resource limit exceeded. When we try to do the full cache refresh, it is getting the issue 'Application issue during request processing'.

We have cleaned up the SQL Packages with DLTR3PKG command, which did not resolve the issue. We recently performed a system copy to build the QA instance and I observed that the adapter engine cache for the development is presented in the QA instance and removed that cache from there.

I am not seeing the adapter engine connection data cache in our PI system. The adapter engine cache is working fine.

All the caches are working fine from the PI Administration page. The cache connectivity test is failing with the same error as I mentioned for the SXI_CACHE.

Please let me know if you have encountered any issue like this on IBM I 6.1 Platform.

Your help is highly appreciated.