Forum Discussion

Debz's avatar
Debz
Contributor
9 years ago

HTTP/1.1 401 Unauthorized warning followed by ORA-00936 when building via Jenkins

Hi,   I encounter warnings and errors when creating a build with Jenkins but the test is running fine whenever I run it directly with SoapUI.   DEBUG [SoapUIMultiThreadedHttpConnectionManager$Soa...
nmrao's avatar
nmrao
Community Hero
9 years ago
No voice in maven.

Mainly I was asking for the query which is causing the failure.

It appears that Nastya_Khovrina already suggested you regarding oracle error message. Try it.
raiqee's avatar
raiqee
Occasional Contributor
9 years ago

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

  • nmrao's avatar
    nmrao
    Community Hero
    9 years ago

    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
    • raiqee's avatar
      raiqee
      Occasional Contributor
      9 years ago

      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 details

       

       

       

       

      • nmrao's avatar
        nmrao
        Community Hero
        9 years ago
        From log statement you can validate if the query is correct or not. Isn't it? Have you looked at it?