Lucee 5.3.9.166 Error (database)
Message Σφάλμα μετατροπής τύπου δεδομένων nvarchar σε int.
Detail Parameter types passed (1): CF_SQL_VARCHAR
SQL { call BO_DISPLAY_ANAKOINOSI_ARTICLE_PUBLISHED_BY_ENTRYID(?) }
DatabaseName Microsoft SQL Server
DatabaseVersion 13.00.4224
DriverName Microsoft JDBC Driver 7.2 for SQL Server
DriverVersion 7.2.2.0
Datasource FOG_CF
Stacktrace The Error Occurred in
C:\ws\newmeteo\article_view.cfm: line 11
9: <cfprocparam type="IN" dbvarname="@entryID" value="#url.entryID#" cfsqltype="cf_sql_varchar">
10: <cfprocresult name="rsWNews">
11: </cfstoredproc>
12:
13: <!doctype html>
Java Stacktrace lucee.runtime.exp.DatabaseException: Σφάλμα μετατροπής τύπου δεδομένων nvarchar σε int.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
  at lucee.runtime.tag.StoredProc.doEndTag(StoredProc.java:627)
  at article_view_cfm$cf.call(/article_view.cfm:11)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1054)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:946)
  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:2490)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2476)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2447)
  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:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 28/5/2023 3:44:49 μμ EEST