Cannot read system catalog (systables). key value
Posted in 2009
The application is pointing me to the link below which discusses update
statistics. Is it normal that we should perform stats on the catalog
database(s). I've never thought to do that nor have I not seen it done.
Should I perform a low, medium, or high?
APPLICATION:
I found a post on the web that refers to this error and how someone
fixed it.
I recommend you schedule update statistics processes to whole database
tables using criteria levels recommended by Informix and also run update
statistics for its procedures, but you should take off the tables from
you
daily update statistics process which are being referenced inside stored
procedures.
Here is the post.
http://www.iiug.org/forums/ids/index.cgi/noframes/read/1566
It looks like this is an Informix bug (bug # 173595) that has been fixed
in Informix 10.00.xC9E.
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/co
m.ibm.relnotes.doc/xc9E/idse_defects_10.0.html
[9/8/09 9:46:50:738 CDT] 7a565769 SystemOut U [2009-09-08
09:46:50,736] [log(LogWriterLog4JImpl:?] ERROR -
com.sears.storeswb.utils.PortalCategoryUtils Error getting content query
SELECT DISTINCT
cnt.OID,DM_TITLE,c.SR_DOC_NEWS_ALERT,SR_DOC_NEWS_START,DM_CREATION_TIME,
DM_LAST_MOD_TIME,DM_DOC_TYPE,u.USER_ID FROM SR_DOC_CATEGORY_MAP cnt
,outer SR_USER_CNT_LOG u, SR_DOC_NEWS_CH c WHERE path_name like'/fls/news/%' and fmt_dept='fls-store ' and dm_doc_type=
'sr_portal_news' and cnt.oid=c.oid and cnt.oid=u.content_id and
(current >= c.sr_doc_news_start and c.sr_doc_news_end >= current) and
u.store_id=102 and u.content_type_id=1011 and u.user_id=8632 ORDER BY
c.SR_DOC_NEWS_ALERT desc, DM_CREATION_TIME descjava.sql.SQLException:
Cannot read system catalog (systables).
at com.informix.jdbc.IfxSqli.a(IfxSqli.java(Compiled Code))
at com.informix.jdbc.IfxSqli.E(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java(Compiled Code))
at
com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java(Compi
led Code))
at
com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java(
Compiled Code))
at
com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java(Inlined Compiled
Code))
at
com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java(Co
mpiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.reallyPrepareStatement(StatementCach
e.java(Compiled Code))
at
com.ibm.ejs.cm.cache.StatementCache.prepareStatement(StatementCache.java
(Compiled Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Compiled
Code))
at
com.ibm.ejs.cm.pool.ConnectO.prepareStatement(ConnectO.java(Inlined
Compiled Code))
at
com.ibm.ejs.cm.proxy.ConnectionProxy.prepareStatement(ConnectionProxy.ja
va(Compiled Code))
at
com.sears.storeswb.utils.PortalCategoryUtils.getItemsFromDB(Unknown
Source)(Compiled Code)
at
com.sears.storeswb.utils.PortalCategoryUtils.getPortalContentArrayList(U
nknown Source)(Inlined Compiled Code)
at
com.sears.storeswb.action.news.NewsLinksAction.perform(Unknown
Source)(Compiled Code)
at
org.apache.struts.action.ActionServlet.processActionPerform(ActionServle
t.java(Inlined Compiled Code))
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java(Compil
ed Code))
at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheProxyServlet.service(CacheProxyServlet.ja
va(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.include(WebAppRequ
estDispatcher.java(Compiled Code))
at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java(C
ompiled Code))
at
portal.news._newsBody_jsp_1._jspService(_newsBody_jsp_1.java(Compiled
Code))
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.dynacache.CacheHook.handleFragment(CacheHook.java(Compil
ed Code))
at
com.ibm.servlet.dynacache.CacheHook.handleServlet(CacheHook.java(Compile
d Code))
at
com.ibm.servlet.dynacache.CacheManager.handleServlet(CacheManager.java(I
nlined Compiled Code))
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServle
t.java(Compiled Code))
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java(Comp
iled Code))
at
org.apache.jasper.runtime.JspServlet.service(JspServlet.java(Compiled
Code))
at
javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecy
cleServlet.java(Compiled Code))
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java(Inlined Compiled Code))
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a(Compiled Code))
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java(Compiled Code))
at
com.ibm.servlet