nmrao wrote:
You mean it works well from SoapUI and only does not work from jenkins? what is query causing the issue?
Hi Rao,
We only encounter the said error in Jenkins if we used the non-active environment from our SoapUI project file.. but in our Pom file we defined another environment, please see below set-up.
<configuration>
<projectFile>C:\Git\soapui\BTS API.xml</projectFile>
<outputFolder>${project.basedir}/output/</outputFolder>
<junitReport>true</junitReport>
<testSuite>All Markets</testSuite>
<environment>ISBB-162</environment>
<exportwAll>true</exportwAll>
<printReport>true</printReport>
<testFailIgnore>true</testFailIgnore>
</configuration>the active environment in our project file is Vanilla and in this POM we want to run the ISBB-162 environment, but when jenkins execute the Pom file we are encountering below error,
10:29:56,850 ERROR [SoapUI] An error occurred [ORA-00936: missing expression ], see error log for details java.sql.SQLSyntaxErrorException: ORA-00936: missing expression at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.load(JdbcSubmit.java:206) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:174) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:147) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.<init>(JdbcSubmit.java:79) at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcRequest.submit(JdbcRequest.java:116) at com.eviware.soapui.impl.wsdl.teststeps.JdbcRequestTestStep.run(JdbcRequestTestStep.java:192) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:213) at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:47) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:139) at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47) at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:129) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
it works if we use the active environment, the solution we are doing right now to run the other environment is by changing the active environment.
We have the same issue from this post
Hi, I've already tried putting a tick to Preferences > HTTP Settings > Authenticate Preemptively > Adds authentication information to outgoing request. I still encountered the error. As for the Oracle issue, it is not encountered when running test directly from SoapUI. Raiquee's workaround works for our end at the moment. I will post a feature/fix request for this later since the related issue mentioned still remains open since 2015.
Here's the query
Select ${#Project#GP_DBName_1}.MARKETS.ID From ${#Project#GP_DBName_1}.MARKETS
where
${#Project#GP_DBName_1}.MARKETS.EVENTID = ${#TestCase#eventId}
And
(RTRIM(UPPER(${#Project#GP_DBName_1}.MARKETS.DESCRIPTION)) =
RTRIM(UPPER('${#TestCase#marketType}')) OR ${#Project#GP_DBName_1}.MARKETS.MARKETTYPEID = ${#TestCase#marketTypeId})Already tried the solution provided by Nastya but we still encountering the error
Please see if the below helps:
def queryTemplate = """Select ${#Project#GP_DBName_1}.MARKETS.ID From ${#Project#GP_DBName_1}.MARKETS
where
${#Project#GP_DBName_1}.MARKETS.EVENTID = ${#TestCase#eventId}
And
(RTRIM(UPPER(${#Project#GP_DBName_1}.MARKETS.DESCRIPTION)) =
RTRIM(UPPER(\'${#TestCase#marketType}\')) OR ${#Project#GP_DBName_1}.MARKETS.MARKETTYPEID = ${#TestCase#marketTypeId})"""
def query = context.expand(queryTemplate)
log.info "Final query is :\n $query"
//Now pass the above "query" object to sql to execute
