Question
Capgemini
MX
Last activity: 25 Jul 2022 14:34 EDT
Report definition error, Java not installed
An error occured on executing the query for the report definition - There was a problem getting a list: code: 29538 SQLState: 99999 Message: ORA-29538: Java not installed DatabaseException caused by prior exception: java.sql.SQLException: ORA-29538: Java not installed | SQL
Does anyone know why this error occurs when executing a report definition? Java is installed on the computer
***Edited by Moderator Marije to add Capability tags***
Updated: 24 Jul 2022 8:30 EDT
Infosys Limited
IN
I think this report might execute the UDF functions where java is needed for it. UDFs can be used for report definition rules to retrieve data for properties that are not exposed.
For the Oracle, DB2, and PostgreSQL databases, the UDFs are implemented in Java.
You must have Java enabled on your Oracle database. To verify this, run the following SQL query as SYSDBA.
select comp_name, version, status from dba_registry where upper(comp_name) like '%JAVA%';
Please find the below article for more information.
https://docs-previous.pega.com/understanding-user-defined-functions
https://support.pega.com/question/installing-pega-85-postgresql-96-issue-pljava
Capgemini
MX
@P.Siva.Praveen Where can I make that query? We work in a remote environment and I don't see any SQL clients installed on this computer.
Infosys Limited
IN
You can run select queries in dev studio with the query runner option. Please find the below video on how to enable the query runner
Capgemini
MX
@P.Siva.Praveen I added the role in my access group as the video says and I get the following error:
