Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect uaa.attributeid ,uaa.userid ,uad.firstname ,uad.lastname ,uad.avatar ,sa.subcategoryid ,sa.attrname ,sa.attrdescription ,sa.attrType ,uaa.description from user_memberships um left outer join user_account_details uad on um.userid = uad.userid left outer join user_account_attributes as uaa on um.userid = uaa.userid inner join sys_attribute sa on uaa.attributeid = sa.attributeid where um.objectid = '' and um.showcase=1 order by um.orderposition asc
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.2095
DriverName
stringMicrosoft JDBC Driver 7.2 for SQL Server
DriverVersion
string7.2.2.0
Datasource
stringpah.production
DataSource
stringpah.production
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringConversion failed when converting from a character string to uniqueidentifier.
NativeErrorCode
number8169
queryError
stringselect uaa.attributeid ,uaa.userid ,uad.firstname ,uad.lastname ,uad.avatar ,sa.subcategoryid ,sa.attrname ,sa.attrdescription ,sa.attrType ,uaa.description from user_memberships um left outer join user_account_details uad on um.userid = uad.userid left outer join user_account_attributes as uaa on um.userid = uaa.userid inner join sys_attribute sa on uaa.attributeid = sa.attributeid where um.objectid = '' and um.showcase=1 order by um.orderposition asc
Sql
stringselect uaa.attributeid ,uaa.userid ,uad.firstname ,uad.lastname ,uad.avatar ,sa.subcategoryid ,sa.attrname ,sa.attrdescription ,sa.attrType ,uaa.description from user_memberships um left outer join user_account_details uad on um.userid = uad.userid left outer join user_account_attributes as uaa on um.userid = uaa.userid inner join sys_attribute sa on uaa.attributeid = sa.attributeid where um.objectid = '' and um.showcase=1 order by um.orderposition asc
SQLState
stringS0002
StackTrace
stringlucee.runtime.exp.DatabaseException: Conversion failed when converting from a character string to uniqueidentifier. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:699) at lucee.runtime.tag.Query.doEndTag(Query.java:565) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86) at controllers.webproperty.c_profile_cfm92$cf$5v.call(/controllers/webproperty/c.profile.cfm:287) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:919) at controllers.c_controller_cfm92$cf.call(/controllers/c.controller.cfm:19) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2482) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2468) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2439) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string285: params={objectid:{type:'cf_sql_idstamp',value:'#request.data.webproperty.webpropertyid#'},<br> 286: showcase:{type:'cf_sql_boolean',value:1}}<br> <b>287: ,sql:&quot;select</b><br> 288: uaa.attributeid<br> 289: ,uaa.userid<br>
codePrintPlain
string285: params={objectid:{type:'cf_sql_idstamp',value:'#request.data.webproperty.webpropertyid#'}, 286: showcase:{type:'cf_sql_boolean',value:1}} 287: ,sql:"select 288: uaa.attributeid 289: ,uaa.userid
column
number0
id
string??
line
number287
Raw_Trace
stringcontrollers.webproperty.c_profile_cfm92$cf$5v.call(/controllers/webproperty/c.profile.cfm:287)
template
stringD:\Hosting\production\out_newpah\www\controllers\webproperty\c.profile.cfm
type
stringcfml
2
Struct
codePrintHTML
string17: <br> 18: try {<br> <b>19: include request.mvc.page.controller;</b><br> 20: if (request.ehcache.page.renderout) {<br> 21: getPageContext().getOut().clearBuffer();<br>
codePrintPlain
string17: 18: try { 19: include request.mvc.page.controller; 20: if (request.ehcache.page.renderout) { 21: getPageContext().getOut().clearBuffer();
column
number0
id
string??
line
number19
Raw_Trace
stringcontrollers.c_controller_cfm92$cf.call(/controllers/c.controller.cfm:19)
template
stringD:\Hosting\production\out_newpah\www\controllers\c.controller.cfm
type
stringcfml
type
stringdatabase
where
string