The following query is generating an Internal Server Error
The select as such is OK in sqlplus. This is an Oracle 11.2.0.3 DB.
This is run on the Build: 2013-07-02 04:03:11 GMT
The columns sizeb, usedb and freeb ayre all NUMBERS so not sure
<cfquery name"qSANstorage" datasource="OTR_SYSMAN">
select s.name name, s.sizeb/1024/1024 size_mb, s.usedb/1024/1024
used_mb, s.freeb/1024/1024 free_mb
from sysman.mgmt$storage_report_data s, sysman.mgmt$target t
where t.target_name = 'hostname.mycompany.com'
and s.name = '/oradata/mySID/dbf'
and s.target_guid = t.target_guid
</cfquery>
Source
66: </cfif>
67:
68: <!--- --->
69: <cfquery name"qSANstorage" datasource="OTR_SYSMAN">
70: select s.name name, s.sizeb size_mb, s.usedb used_mb, s.freeb free_mb
^ Snippet from underlying CFML source
Stack Trace
java.lang.ClassCastException: com.naryx.tagfusion.cfm.engine.cfBooleanData
cannot be cast to com.naryx.tagfusion.cfm.parser.cfLData
at com.naryx.tagfusion.cfm.engine.cfSession.setData(Unknown Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.executeStatement(Unknown Source)
at com.naryx.tagfusion.cfm.sql.platform.java.cfQueryImplSQL.render(Unknown
Source)
at com.naryx.tagfusion.cfm.sql.cfQUERY.render(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source)
at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source)
at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source)
at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source)
at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359)
at com.newatlanta.filters.SearchEngineFriendlyURLFilter.doFilter(Unknown
Source)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:483)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:345)
at
org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
at
org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:919)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:582)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:218)
at
org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:51)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
at
org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
at java.lang.Thread.run(Thread.java:662)
Any idea what could go wrong here?
/Mats/
--
--
online documentation: http://openbd.org/manual/
http://groups.google.com/group/openbd?hl=en
---
You received this message because you are subscribed to the Google Groups "Open
BlueDragon" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
