Forum Discussion

Debz's avatar
Debz
Contributor
8 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
8 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
8 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
    8 years ago
    From log statement you can validate if the query is correct or not. Isn't it? Have you looked at it?