raiqee
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: HTTP/1.1 401 Unauthorized warning followed by ORA-00936 when building via Jenkins
Hi Rao, We tried the solution you provided but we encountered a new error, tried running it on soapui Thu May 04 15:45:21 CST 2017:ERROR:An error occurred [ORA-00942: table or view does not exist ], see error log for details5.7KViews0likes1CommentRe: HTTP/1.1 401 Unauthorized warning followed by ORA-00936 when building via Jenkins
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 error5.8KViews0likes3CommentsRe: HTTP/1.1 401 Unauthorized warning followed by ORA-00936 when building via Jenkins
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 https://community.smartbear.com/t5/SoapUI-NG/Maven-SoapUi-how-to-parametrized-environment-endpoint/td-p/956605.7KViews1like6CommentsHow to run an specific test case in the selected environment?
I have multiple Environment and a lot of test cases, but not all test cases are needed to be run in all environment. Is there a way to run only an specific test cases from a test suite based on the selected Environment. For Example If I select Environment1, it will run the following test cases TC0001 TC0002 TC0003 TC0004 TC0005 If I select Environment2, it will run only the following test cases TC0001 TC0003 TC00051.8KViews0likes3Comments