Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Oracle Reports RAD cannot connect to database

Current environment:
FMW 12.2.1.4 Forms & Reports
Oracle Access Manager 12.2.1.4
Oracle Internet Directory 12.2.1.4
Oracle Forms with SSO:
We use the schema OPSS in the repository database to store the RAD. Users are authenticated by OAM against Active Directory.
SSO works with the Forms application.
Oracle Reports with SSO
We have stored the same RAD also in OID under cn=Extended Properties , cn=oraclecontext, dc=xxxx, dc=de.
When I run a report using a secured reports server I get:
rwserver-diagnostig.log
REP-50125 : oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = xxxxx [[
oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = xxxxx
at oracle.ldap.util.User.resolve(User.java:1034)
at oracle.ldap.util.User.getExtendedProperties(User.java:409)
at oracle.reports.server.OIDReader$Resource.getResourceAttributes(OIDReader.java:272)
The strange thing is that although there is an error with the reports server the job is forwarded to the engine.
rwEng-0_diagnostic.log
[2020-03-24T14:02:05.098+01:00] [reports] [ERROR] [] [oracle.reports.engine] [tid: 11] [ecid: 02e888e3-7526-4c06-9469-15273acf77c6-00000003,0] [EngineName: rwEng-0] C Engine Job ID = 1232773297 ERR REP-0501: Eine Verbindung zur angegebenen Datenbank kann nicht hergestellt werden.[[
ORA-12545: CONNECT nicht erfolgreich, da Ziel-Host oder -Objekt nicht vorhanden
]]
[2020-03-24T14:02:05.106+01:00] [reports] [INCIDENT_ERROR] [REP-501] [oracle.reports.engine] [tid: 11] [ecid: 02e888e3-7526-4c06-9469-15273acf77c6-00000003,0] [EngineName: rwEng-0] REP-501 : Eine Verbindung zur angegebenen Datenbank kann nicht hergestellt werden. [[
For me it looks like that the RAD cannot be used because the user is not known to OID.
But the user (xxxxx) is already authenticated by OAM and also known to the reports server (command showenv).
When we add the user xxxxx to the branch in OID the report runs succesfully.
My questions are:
- Do we have to store also the users in OID to run the reports?
- Is there a way to access the RAD when we run a report without adding all users to OID ?
- Is there a way to get the user identity for reports from Active Directory ?
Thanks
Juergen
Answers
-
Hi,
Reports only knows about OID. If you have OAM integrated with AD and the users are in AD, then Reports will not find them. You will also need to integrate and sync AD with OID.
Regards,
Dan