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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

X-APEX-FORWARD/X-ORDS-FORWARD: URL is not permitted because it lies outside the context path of

Rumburak 9000Aug 25 2020 — edited Aug 25 2020

Hello,

i wanted to redirect from an ords-POST-Request to another URL by setting the X-ORDS-FORWARD-Variable but I got an http-500:

SEVERE: Handler for: POST /ords/bla/blupp/import/test1 attempted to forward request to: http://server1/blabla which is not permitted because it lies outside the context path of: http://server1/ords/bla/

Aug 25, 2020 3:08:20 PM

SEVERE: null

InternalServerException [statusCode=500, reasons=[]]

        at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:137)

        at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

Is the redirect only possible for urls in the ords-context?

Bye,

Rumburak

This post has been answered by EJ-Egyed on Aug 25 2020
Jump to Answer

Comments

Francisco Amores

Hi,

Is your TNS correctly defined for the 32-bit?

Are you able to create a UDL (32 bit) and connect to FDM database?

I would suggest checking Doc ID 1556309.1, Doc ID 1324896.1, and Doc ID 1507666.1 ?

Regards

Martin.Xie

Hi,

Thanks for your suggestion but seems I can't create the UDL32 connection successfully.

Thanks,

Martin

Martin.Xie

I tried to create a UDL (32bit) file, like 'testconn.udl32'. But when I opened the file, I can't find "Oracle Provider for OLE DB" which I can see that in UDL (64bit) file.

Thanks

Francisco Amores

Did you follow Test a 32-bit OLEDB Connection With a UDL File on 64-bit Windows [ID 405743.1]?

You should also check 32-bit version of the provider is correctly installed.

You have a master note for troubleshooting OLEDB:

Master Note For The Oracle Provider for OLE DB (OLE DB) (Doc ID 1132946.1)

krikumar-Oracle

Make sure to update the TNSNAMES.ORA file with the proper database connect descriptor in the 32Bit Oracle Client\Network\Admin directory.

Martin.Xie

Sorry I have no access to Oracle Support now.

JeffJon

this error occurs when FDM is unable to connect to the Oracle Database:

Check the following:

a) the 32 bit oracle Client has been installed on the FDM application server

b) the 32 bit Oracle Client TNSNAMES.ORA file has a valid connect descriptor for the database you are entering into the Database Tab.  You can test this with a 32 bit UDL file as noted in KM

Test a 32-bit OLEDB Connection With a UDL File on 64-bit Windows (Doc ID 405743.1)

If you are not seeing the Oracle Provider for OLEDB in the 32 bit UDL, then the 32 bit provider has not been installed.  You need to make sure that the 32bit RUntime Client, Oracle Provider for OLEDB, Oracle Database Utilities, Oracle Objects for OLE, Oracle Data Provider for .NET and Oracle Providers for ASP.NET are all installed with the 32 bit client installer.

If you are positive that they are installed, you may need to register the oracle provider for OLEDB .dll in the Client\Bin directory with regsrv32    


1 - 7

Post Details

Added on Aug 25 2020
2 comments
1,527 views