Hello,
can anybody shed light into this error (high level) and if it can be prevented?
ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. SQLState: 37000
SQL statement 'SELECT E0.sNamespace, E0.sName, E0.sEntitySchema, E0.sImg, E0.sMd5, E0.sLabel, E0.iCreatedById, E0.iModifiedById, E0.tsCreated, E0.tsLastModified, IsNull(E0.sLabel, '') + ? + IsNull(E0.sNamespace, '') + ?, neolane..IsMemoNull(E0.mData), E0.mData FROM XtkEntity E0 WHERE' could not be executed.
Param(0)= (
Param(1)=)
Param(2)=xtk:funcList
Param(3)=xtk
Param(4)=funcList
An error occurred while loading the definition of functions
at com.neolane.fwk.xtk.JSPContext.initThreadForInstance(Native Method)
at com.neolane.fwk.xtk.JSPContext.<init
at com.neolane.fwk.xtk.JSPContext.<init
at org.apache.jsp.soaprouter_jsp._jspService(soaprouter_jsp.java:165)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.neolane.jssp.HttpHeaderFilter.doFilter(HttpHeaderFilter.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)'.
Regards,
Marcel
Hi Marcel,
https://support.microsoft.com/en-us/help/966722/statement-s-could-not-be-prepared-sql-error-37000
Seems like you have some incorrect code in your function list.
This error is caused when the client is asking the server to prepare a statement which has errors. For example, if there is a syntax error in the statement of your custom functions that is being attempted to be executed and SQLPrepare ODBC API is called on it, you will hit this problem.
look for formatting errors or did you added a new custom SQL function?
Regards,
Amit
Views
Replies
Total Likes
Hello Amit,
it is all OOTB. after restart it is fine again. can it be some error in loading like the file is not fully loaded and this there is this syntax error
Marcel
Hi Marcel,
it seems like that so now you know the cause and what to look for.
Hope it is not happening now, is it?
Regards,
Amit
Views
Replies
Total Likes
Hello Amit,
it happened 2 times since last september. So it is just really occasional.
Marcel
Views
Replies
Total Likes
Views
Like
Replies