Extraordinarily Long SQL Request to TDV causes Parser to Throw a StackOverflowError
Article ID: KB0079234
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
An extraordinarily long SQL text that is submitted to CIS throws a parser error in the form of a stack overflow.
java.lang.StackOverflowError
at com.compositesw.cdms.services.parser.QuestionLiteralBetweenCommandVisitor$1.visitBinaryWhereNode(QuestionLiteralBetweenCommandVisitor.java:42)
at com.compositesw.cdms.services.parser.BinaryWhereNode.accept(BinaryWhereNode.java:156)
at com.compositesw.cdms.services.parser.WhereNodeVisitor.visit(WhereNodeVisitor.java:8)
at com.compositesw.cdms.services.parser.QuestionLiteralBetweenCommandVisitor$1.visitBinaryWhereNode(QuestionLiteralBetweenCommandVisitor.java:71)
at com.compositesw.cdms.services.parser.BinaryWhereNode.accept(BinaryWhereNode.java:156)
at com.compositesw.cdms.services.parser.WhereNodeVisitor.visit(WhereNodeVisitor.java:8)
... removed 338 times 3 rows...
at com.compositesw.cdms.services.parser.QuestionLiteralBetweenCommandVisitor$1.visitBinaryWhereNode(QuestionLiteralBetweenCommandVisitor.java:71)
at com.compositesw.cdms.services.parser.BinaryWhereNode.accept(BinaryWhereNode.java:156)
at com.compositesw.cdms.services.parser.WhereNodeVisitor.visit(WhereNodeVisitor.java:8)
com.compositesw.cdms.services.parser.QuestionLiteralBetweenCommandVisitor$1.visitBinaryWhereNode(QuestionLiteralBetweenCommandVisitor.java:71)
[jdbc-1906510]
Resolution
Use this JVM directive to increase as needed: -Xss4m
You will make the edits in this file: INSTALL_DIR/conf/script_env.sh
Complete instructions for modifying the jvm is documented in the Administration Guide, under the heading "Customizing the CIS Server Startup Scripts on <your os>"
This JVM topic is also discussed in the Studio online help.
CIS Installation and Upgrade Guide > Installing Cisco Information Server, Studio, and Drivers > Tips from an Expert if the Server Does Not Start
About script_env :
CIS Administration Guide > Basic CIS Administration Tasks > Starting CIS Processes on UNIX > Customizing the CIS Server Startup Scripts on UNIX
Issue/Introduction
Feedback
