<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m having some difficulties with an API call following an upgrade to 2.3.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The API call in question is system.listUngroupedSystems. I’ve checked the logs and there is an exception in rhn_web_api.log, but there is nothing in the PostgreSQL logs as to why the query could not be executed. Thoughts? Error below.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[2015-07-03 08:44:35,802] INFO - REQUESTED FROM: 192.168.184.21 CALL: auth.login(apiuser, ********) CALLER: (none) TIME: 3.022 seconds<o:p></o:p></p>
<p class="MsoNormal">[2015-07-03 08:44:36,142] ERROR - REQUESTED FROM: 192.168.184.21 CALL: system.listUngroupedSystems(apiuser) CALLER: (apiuser) TIME: 0.2 seconds<o:p></o:p></p>
<p class="MsoNormal">redstone.xmlrpc.XmlRpcFault: unhandled internal exception: could not execute query<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.xmlrpc.BaseHandler.invoke(BaseHandler.java:208)<o:p></o:p></p>
<p class="MsoNormal"> at redstone.xmlrpc.XmlRpcDispatcher.dispatch(XmlRpcDispatcher.java:123)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.xmlrpc.RhnXmlRpcServer.execute(RhnXmlRpcServer.java:54)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.xmlrpc.XmlRpcServlet.doPost(XmlRpcServlet.java:162)<o:p></o:p></p>
<p class="MsoNormal"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)<o:p></o:p></p>
<p class="MsoNormal"> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)<o:p></o:p></p>
<p class="MsoNormal"> at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:100)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)<o:p></o:p></p>
<p class="MsoNormal"> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)<o:p></o:p></p>
<p class="MsoNormal"> at java.lang.Thread.run(Thread.java:701)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;color:maroon;mso-fareast-language:EN-GB">Alex Dacre</span><span style="font-size:12.0pt;font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">Systems Engineer</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB"> </span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:maroon;mso-fareast-language:EN-GB">Aridhia Informatics Ltd.</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">Hobart House</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">80 Hanover Street</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">Edinburgh</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">EH2 1EL</span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB"> </span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">+44 131 560 1466</span><span style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB"><br>
</span><span style="color:#282828;mso-fareast-language:EN-GB"><a href="http://www.aridhia.com/" target="_blank"><span style="font-size:10.0pt;color:blue">www.aridhia.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Cambria",serif;color:gray;mso-fareast-language:EN-GB"> </span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;color:gray;mso-fareast-language:EN-GB">Keep up to date with all the latest news by following us on Twitter </span><span style="color:#282828;mso-fareast-language:EN-GB"><a href="http://twitter.com/aridhia" target="_blank"><span style="font-size:10.0pt;color:blue">@aridhia</span></a></span><span style="font-family:"Segoe UI",sans-serif;color:#282828;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>