Skip to Main Content

APEX

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.

ords 404 error on static application files

mpatzwahlApr 7 2020 — edited Apr 9 2020

Hi,

i have APEX 19.2 and ORDS 19.4 in a 12.1.0.2. EE Database.

The Static Files are not able to read. I get a 404 Error (could not map a database ...)

I wrote a logon trigger, and i see logons from apex_public_user, ords_public_user and apex_rest_public_user.

But still no static app images.

How can i trace the real reason, what is (not) happening here ?

thanks, Marco

This post has been answered by mpatzwahl on Apr 9 2020
Jump to Answer

Comments

Pierre Yotti

Hi,

Did you upgrade APEX recently? Is ORDS_PubLic_user account expired?

Regards

Pierre Yotti

mpatzwahl

Hi pierre,

yes it is a upgrade from18.2, all accounts are open. The login trigger audit this.

i Thought, that the user apex_rest_public_user ist responsible for this rest feature.
how can i debug the real reason for ‚could not map a database‘

thanks , Marco

Pierre Yotti

Hi,

Than you need to valide ORDS

java -jar ords.war validate

Regards

Pierre

mpatzwahl

I Did this 3 times, also validate —database apex

all objects are Valid.

i Had this error many times, normally i found it by myself. But his time, i have no idea.

but it would be interessting how to debug this error.

thanks.

Marco

mpatzwahl

the full error is URLMappingNotFoundException [statusCode=404, reasons=[The request could not be mapped to any database. Check the request URL is correct

How can i Check if the url is correct ?

servicenbame is ok

port is ok

hostname is ok

i can connect to the db using easy connect with apex_public_user, ords_public_user, apex_rest_public_user

Any ideas ?

Thanks

Marco

bkmcdaniel

A while back, I had an issue on a few systems (oddly not all of them) where after an upgrade of ORDS & APEX the static files were not displayed.  It has been a while now so I forget what the exact error was, but more info was available from ORDS if we tried to hit the static file directly. At first, I thought maybe we had skipped the ords validate step, but running that again didn't resolve the issue.

The solution was to run the following (replace xxxx with whatever schema(s) is needed):

ORDS_ADMIN.ENABLE_SCHEMA(p_schema => 'xxxx');

Why this was needed on some systems and not others I cannot explain.

Hope this helps you.

mpatzwahl
Answer

Thanks to all i found it, grrrrrrmpf

The error message is really misleading !

My solution is .....

EXEC apex_instance_admin.set_parameter('RESTFUL_SERVICES_ENABLED','Y');

Marco

Marked as Answer by mpatzwahl · Sep 27 2020
1 - 7

Post Details

Added on Apr 7 2020
7 comments
794 views