xtk:funcList could not be loaded

Avatar

Avatar

MarcelSzimonisz

MVP

Avatar

MarcelSzimonisz

MVP

MarcelSzimonisz
MVP

05-03-2018

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

Replies

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

09-03-2018

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

Avatar

Avatar

MarcelSzimonisz

MVP

Avatar

MarcelSzimonisz

MVP

MarcelSzimonisz
MVP

09-03-2018

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

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

12-03-2018

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

Avatar

Avatar

MarcelSzimonisz

MVP

Avatar

MarcelSzimonisz

MVP

MarcelSzimonisz
MVP

15-03-2018

Hello Amit,

it happened 2 times since last september. So it is just really occasional.

Marcel