Highlighted

xtk:funcList could not be loaded

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

Highlighted

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

Highlighted

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

Highlighted

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