Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS - 502 Web server received an invalid response

uservaMay 27 2021 — edited May 27 2021

We are using ORDS 20 deployed on a weblogic server (12c) and assigned a manager server as target. It is working fine as expected but very randomly for one of the endpoint in production we are getting below error and after sometime it works as expected. Not able to replicate the same error in lower instances
502 - Web server received an invalid response while acting as a gateway or proxy server.</h2>
There is a problem with the page you are looking for, and it cannot be displayed. When the Web server (while acting as a gateway or proxy) contacted the upstream content server, it received an invalid response from the content server.
Verified weblogic adminserver and managed server log, don't see any errors.
same exact endpoint call with same query parameters working fine after sometime. verified backend ords query in database as well, result comes in less than 2 seconds.
How to debug and find the root cause. Could someone please help, if anyone has faced the similar issue.

Comments

Rahul Kumar
hi anuradha,
you can use substitution variable in the grid and then display that in text via GetHeading function.

Hope this helps.

Regards,
Rahul
661221
Rahul,

I tried it but itz not displayed...

the sub var is not visible in any dim member selection tabs ..... so i cant getit in data col/row.......if i type & refer with getheading..itz not workin.....


how can we display it????????/


Thanks
Rahul Kumar
hi,

if substitution varible is defined correctly on the cube then it should definately be displayed on the some dimension member selection.

Please check that.
Once it is visible, just use it as a member in any hidden row/column. Then use GetHeading function to display it in a text box.

Regards,
Rahul
661221
Hi,

I have cross checked all dim's in FR...but could not find 'em in any dim's.......other sub variables which r related to dim's r visible under respective dim's(Ex:Year=$curyr)......

i could see it defined in the outline for this cube.

i fell that the data load sub var is not visible under any dim as itz not related to any of them.....

Is there a way to display it in FR.

Thnx
Rahul Kumar
hi,
yes to display a substitution variable, it has to be associated with one of the dimensions.
and then only you will be able to display it.

May be one other option might be to use LINKED OBJECT in FR. so that just updating the information in one text box of one report will do it in all reports.


You can also use substitution variable in that liked object.
1 - 5

Post Details

Added on May 27 2021
1 comment
908 views