Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

xtk:funcList could not be loaded

Avatar

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

Avatar

Level 10

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

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

Avatar

Level 10

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

Community Advisor

Hello Amit,

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

Marcel