Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

xtk:funcList could not be loaded

Marcel_Szimonisz
Community Advisor
Community Advisor

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

4 Replies
Amit_Kumar
Community Advisor
Community Advisor

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

Marcel_Szimonisz
Community Advisor
Community Advisor

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

Amit_Kumar
Community Advisor
Community Advisor

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

Marcel_Szimonisz
Community Advisor
Community Advisor

Hello Amit,

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

Marcel