Hyperion 11.1.1.3: Viewing Repository File Storage Locations via SQL Query

My Hyperion 11.1.1.3 Server was having problems running a migration script. With Oracle Tech Support’s help, we found that my old Hyperion server’s repository path had not been updated during one of the previous 5 upgrades. Everything has been working fine, but the Hyperion config files were looking at one location, while my repository was sitting somewhere else. Anyway, we found out that the Workspace repository’s database showed the correct path to the physical file location on disk. By running the following SQL, I was able to find where Workspace thought my files were located:

SELECT AGENT_UUID, HOST_UUID, SA_TYPE, NAME, PASSWORD, PORT_NUMBER, MAX_CONNECTIONS, KEEP_ALIVE_TIME, LOG_DIRECTORY, LOG_FILENAME, HOME_DIRECTORY, DESCRIPTION, DEBUG_LOGLEVEL, INFO_LOGLEVEL, WARNING_LOGLEVEL, ERROR_LOGLEVEL, REPOSITORY_UUID, JAVA_CLASS, ADMIN_FLAG, INST_JAVA_CLASS, LOGLEVEL, IS_HOLD FROM BIPLUS.V8_SERVICEAGENT

Realistically, I only needed the following returned:

SELECT AGENT_UUID, HOST_UUID, NAME, HOME_DIRECTORY, REPOSITORY_UUID, FROM BIPLUS.V8_SERVICEAGENT

[ad#ad-post]