Marking more than 50K rows to run on demand table throws the exception "Failed to execute data query".

The following error is seen in the log file.  

"org.apache.cxf.interceptor.Fault: Unmarshalling Error: Maximum Number of Child Elements limit (50000) Exceeded"

This error is coming from the third party org.apache.cxf.stax.maxChildElements being set to 50000 and the comparison expression for more than 50000 values will contain more than 50000 child elements.

All Supported OS

To resolve this issue:

1). Goto location C:\tibco\tss\X.X.X\tomcat\bin on Spotfire Server machine.

2). Edit the service.bat file. 

3). At the end of file, under the JVM options add -Dorg.apache.cxf.stax.maxChildElements=1000000 as shown below. See the attached file (Filename: service.bat) for reference.

    --JvmOptions "-Dcatalina.home=%CATALINA_HOME%;-Dcatalina.base=%CATALINA_BASE%;-Djava.endorsed.dirs=%CATALINA_HOME%\endorsed;-Djava.io.tmpdir=%CATALINA_BASE%\temp;-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager;-Djava.util.logging.config.file=%CATALINA_BASE%\conf\logging.properties;-XX:+DisableExplicitGC;-Dcom.sun.management.jmxremote;-Dorg.apache.catalina.session.StandardSession.ACTIVITY_CHECK=true;-Dorg.apache.cxf.stax.maxChildElements=1000000" ^

4). Open a command prompt as Administrator and run the following commands.

     a).  <installation dir>/tomcat/bin/service.bat remove
     b).  <installation dir>/tomcat/bin/service.bat install
 
      Restart the Spotfire service. 

5). Login into client and run the on demand again by marking 50 K rows.

Marking more than 50K rows to run on demand table throws the exception "Failed to execute data query".