Tomcat Deployment : The requested resource [/jri/] is not available #17

glenpalmer · Oct'20

1 #1

Hi,

I've tried a fresh install of JasperReportsIntegration using the latest version on the following build:

CentOS 7
Oracle XE 18c
Apex 20.1
Ords 19
Tomcat 9.0.39

And I get the following error message when trying to execute the webapp in step 2.5 of the installation guide. This is displayed when I navigate to [Host]:8080/jri

HTTP Status 404 – Not Found
Type Status Report
Message The requested resource [/jri/] is not available
Description The origin server did not find a current representation for the target resource or is not willing to disclose that one exists.

In my application.properties I have the parameter infoPageIsEnabled=true set which I believe is correct to see the configuration info page.

My Apex served by Ords through Tomcat works fine so I assume I've messed something on the deployment of JRI somewhere.

Any thoughts on trying to debug my mistake would be much appreciated.

Thanks in advance

1 Reply

replies 7
views 2.7K
likes 0

glenpalmer · Oct'20 Author

Hmmm, ok so a fresh install seems to have cleared the issue :-)

I did however slightly change how I defined the Environment Variable, this time I used the web.xml approach as defined in section:

2.2 Configure the setting in the web.xml file of the jri.war file

One other thing I had to change was the connection settings as documented in section:

2.3 Configure your database access

I'm using xe18c and have Apex and JRI installed in a pluggable database, so I altered the JDBC connection string to point to my PDB service name XEPDB1 using / instead of : in the string.

I changed the JDBC URL from:

url=jdbc:oracle:thin:@192.168.2.114:1521:XE

To:

url=jdbc:oracle:thin:@192.168.2.114:1521/XE

Thanks

sellexx-stephan · Apr'21

Hello,
as far as I understand there is a problem with SID and SERVICE_NAME. :... is a SID while /... is a service_name.
It might help to tell the listener to ignoere the difference: add a line in listener.ora: USE_SID_AS_SERVICE_listener=on where listener is to be replaced by the name of the listener (which is by default listener)

Dietmar Aust daust · Apr'21 Team

Hi @sellexx-stephan,

while this is correct and true, I would rather suggest to fully understand the proper syntax for Oracle jdbc urls: https://docs.oracle.com/en/database/oracle/oracle-database/19/jjdbc/data-sources-and-URLs.html#GUID-C4F2CA86-0F68-400C-95DA-30171C9FB8F0

Else, this specific setup might be confusing / non-transparent and not easy to share, because you also need to make the corresponding change in another file. And also, it is good to comprehend it fully ... you might need it in other places (e.g. sqlcl) as well :).

Cheers
~Dietmar.

Najeeb_Khan najeebalikhel · Sep 11

I am using win 2022
jri 2.10
apex 23.2
db 21c

but still I have this issues /jri/ not found as I configured in many systems it works fine there

Najeeb_Khan najeebalikhel · Sep 11

I am using JDK17

Najeeb_Khan najeebalikhel · Sep 11

@daust Please help me this
and your email to have short catch up in this

Dietmar Aust daust · Sep 16 Team

Hi @najeebalikhel ,

do you have a specific error message?

Please check the troubleshooting instructions: https://github.com/daust/JasperReportsIntegration?tab=readme-ov-file#faq that should give you more information.

Thank you, Dietmar.