OFSAAI FAQs

22.1.1 OFSAAI FAQs

What are the different components that get installed during OFSAAI?

The different components of OFSAAI are illustrated in Figure 1, "Components of OFSAAI".

What are the different modes of OFSAAI installation?

OFSAAI can be installed in Silent Mode.

Can the OFSAA Infrastructure components be installed on multi-tier?

No. OFSAA Infrastructure components (ficapp, ficweb, ficdb) cannot be installed on multi-tier. By default, they will be installed on single-tier. However, OFSAA Infrastructure can be deployed within the n-Tier architecture where the Database, Web Server and Web Application Server is installed on separate tiers.

Is JDK (Java Development Kit) required during installation of OFSAA? Can it be uninstalled after OFSAA installation?

JDK is not required during installation of OFSAA and only a run time is needed. For details, see Hardware and Software Requirements, Java Runtime Environment section.

Is JRE required during installation of OFSAA? Can it be uninstalled after OFSAAI installation?

Only JRE (Java Runtime Environment) is required during installation of OFSAA and cannot be uninstalled as the JRE is used by the OFSAA system to work.

How do I know what are the Operating system, webservers and other software versions that OFSAA supports?

Refer to OFSAA Technology Stack Matrices.

What are the different files required to install OFSAAI?

The following files are required:

setup.sh.
envCheck.sh
preinstallcheck.sh
VerInfo.txt
OFSAAInfrastructure.bin
validatedXMLinputs.jar
MyResources_en_US.properties
log4j.xml
OFSAAI_PostInstallConfig.xml
OFSAAI_InstallConfig.xml
privileges_config_user.sql
privileges_atomic_user.sql

What should I do if I get the following error message during installation:"Execute Permission denied"?

Check whether all the files provided for OFSAAI installation has execute permissions. To give execute permissions,

Navigate to the path OFSAAI_80200 and execute the command
chmod 755

"Graphical installers are not.."

If error resembles "Graphical installers are not supported by the VM. The console mode will be used instead..." then check whether any of the X-windows software has been installed.

Example: Hummingbird Exceed is started and configured to Graphical mode installation.

Note:

Type 'xclock' from prompt and this should display clock in graphical mode.

"No Java virtual machine could be…"

If the error message reads "No Java virtual machine could be found from your PATH environment variable. You must install a VM prior to running this program", then

Check whether "java path" is set in PATH variable. See " Prerequisite Information"section in this document.
Check whether sufficient temporary space is available.
Ensure that the movement of OFSAAI Installer text files to the target system is done in the Text mode so that setup.sh file does not contain control line feed characters (^M).

What should I do if I get the following error message during installation, "OracleDriver Files Not Found, Please Choose the Right Path To Continue"?

Check whether the provided path for Oracle Driver files is correct and whether the user has permissions to access the files.

What should I do if I get the following error message during installation, "User must have CREATE TABLE, CREATE VIEW, CREATE TRIGGER, CREATE INDEX, CREATE SEQUENCE, CREATE PROCEDURE" even though the oracle schema user created has the mentioned privileges?

OFSAAI installer validates the database details provided during installation, so ensure:

Whether the oracle schema user has the required set of privileges for successful installation.
Whether the oracle schema user has been created with quota privileges on tablespace to cre- ate database objects.

See the Prerequisite Information"section in this document.

Installation of OFSAAI was completed successfully! What next?

Post the successful completion of OFSAAI installation, one has to perform the Post Installation steps. See Post Installation Configurations.

What is to be done when OFSAAI Installation is unsuccessful?

OFSAAI installer generates log file OFSAAInfrastructure_Install.log in the Infrastructure Installation Directory. There is also another log file created in the path configured in Log4j.xml. If the logs of any of these reported Warnings, Non Fatal Errors, Fatal Errors or Exceptions, they should be brought to the notice of the OFSAAI Oracle Support Services. It is recommended not to proceed, until the reported problems are adequately addressed.

How do I completely uninstall OFSAAI?

OFSAAI can be completely uninstalled by performing the steps provided in Uninstalling OFSAA Infrastructure section in this guide.

Can OFSAAI config and atomic schemas be on different databases?

OFSAAI requires both config and atomic schemas to be present on the same database instance.

How do I grant privileges if a new information domain is created?

If you are creating a new information domain, provide a set of privileges (database permissions) to the new Atomic schema.

Log into the database as sys and connect as sysdba user.
Execute the file privileges_config_user.sql available under $FIC_HOME directory
Enter the database schema for which you want to grant privileges.

When should I run the MLS utility?

See the Multiple Language Support (MLS) Utility section in OFS AAI Administration Guide available on OTN.

Does OFSAAI support Oracle Linux versions other than 5.5?

OFSAAI supports the Oracle Linux versions from 5.5 up to 5.10 and also from 6.0 and above.

What should I do if I get the following error message on the UNIX System terminal while executing ./setup.sh, "Insert New Media. Please insert Disk1 or type its location"?

Login as root user on the Unix machine where OFSAAI is getting installed.
Navigate to the path /etc/security/.
Edit the file limits.conf to add/edit a row for the unix user installing OFSAA:
<Unix User> soft nofile 9216
After saving the changes, log in as unix user with which OFSAAI is getting installed and execute the command:
ulimit -n

The command should return the value 9216.

How do I verify if the system environment is ready for OFSAAI installation?

To verify the system environment meets the minimum requirements for the installation, a Pre- Install Check utility is available within the Install Kit archive file. This utility can also be obtained separately by contacting Oracle Support.

See Verifying System Environment section for additional information.

How do I know if the installation is completed successfully?

The OFSAA Infrastructure installation performs a post install health check automatically on successful installation of the product. To rerun the post install verification at a later time, perform the following steps:

Navigate to the path $FIC_HOME (Product Installation Directory).
Execute the command:
./piverify.sh

What should I do if there are any exceptions or errors in installation and how to proceed?

Please backup the installation logs.
Share the backup logs with Oracle Support Services.

What should I do if the installation process is abruptly terminated or aborted?

If the installation process is abruptly terminated, then the installation will be incomplete. To recover from this, follow these steps:

Drop the DB objects in the config schema created by OFSAAI installation.
Open the .profile and remove the entries made by the OFSAAI installation which are made between the comment statements, #Beginning of entries by OFSAA Infrastructure installation and #End of entries by OFSAA Infrastructure installation.
Delete the OFSAA install directory created by the OFSAAI installer.
Perform the OFSAAI installation again.

Does OFSAA support any other web server types, other than the ones stated in Tech Matrix and Installation Guide?

No, all the supported softwares and versions are stated in the OFSAA Technology Stack Matrices.

What should I do if the database connection from connection pool displays the following error message, "java.sql.SQLRecoverableException: IO Error: Connection reset"?

This happens while running several database intensive tasks in parallel. To correct this error, add the line securerandom.source=file:/dev/./urandom in the java.security configuration file available in $JAVA_HOME/jre/lib/security/ path.

Note:

This needs to be configured on all the machines or VMs where the OFSAAI components are installed.

If the issue is not resolved even with the preceding settings, check the MTU(Maximum Transmission Unit) settings on the linux box. For details on MTU settings and updating them, contact your system Administrator.

What should I do when I get syntax errors/file not found error messages while invoking setup.sh file from my install archive?

This could mostly happen:

When installer was not unzipped rightly or corrupted during unzip.
setup.sh file which resides within the install archive was not transferred in ASCII or text mode, which could have corrupted the file.

To correct this, follow the steps:

Copy the installer (in BINARY mode) to the system on which the OFSAA Infrastructure components will be installed.
Unzip the installer using the command:
unzip <OFSAAI_Installer>.zip
The corrupted setup.sh file would have introduced certain ^M characters into the file. You can remove ^M characters from setup.sh file by following these steps:
1. Login to the server where the installer is copied.
2. Navigate to the directory OFSAAI_80200.
3. Open the setup.sh file in the vi editor using the command: vi setup.sh.
4. Inside vi editor in Esc mode, type: %s/^M//g
  
  Note:
  To enter ^M, hold the CTRL key then press V and M in succession.
5. Save the setup.sh file by typing: wq!

Does OFSAA support Oracle DB 11g Standard edition?

The OCI client and the jdbc driver does not change depending on whether it is a standard or enterprise edition. So, OFSAAI will work with standard edition as well.

We do not recommend standard edition because it will not scale and does not support partition pack, database security vault, or advanced analytics.

What should I do if I get the following error message while executing ./startofsaai.sh file on the UNIX System terminal "./startofsaai.sh: /java: Execute permission denied"?

Ensure JAVA_BIN environment variable path is set on the "unix user" terminal from where the startofsaai.sh file is invoked.
- Ensure the .profile where the environment/ path settings are made has been executed successfully.

What should I do if the OFSAAI Application Server does not proceed even after providing the system password?

Ensure that, the System Password provided when prompted is "password0" provided during installation. Also check whether the connection to the "configuration schema" can be established through sqlplus.

Although the OFSAAI installation has completed successfully, when OFSAAI servers are started, and the application URL is accessed, it gives an error message "the page cannot be found or displayed" or "Could not retrieve list of languages from Server. Please contact the system administrator". What should one do?

Ensure OFSAAI servers have been started and are running successfully. For details on start up parameters options, see Starting Infrastructure Services section.

For more details on the issue, refer to the Revappserver log in $FIC_APP_ HOME/common/ FICServer/logs directory or the Web Server log files.

Is it necessary to provide the specified grants to the Oracle schema user before installation? If yes, can it be revoked after completing the installation?

The "Oracle schema" user requires the necessary grants specified before, during, and after the installation process. Grants provided should never be revoked as the application makes use of these grants all the time.

Can we have distributed OFSAAI Application Server for load balancing?

OFSAAI Application server can be scaled out/distributed across different JVM's (machines) based on the various services and Information Domains, in other words, Load balancing could be achieved with distribution of services.

Why do we need FTPSHARE on all the layers? Can we have ftpshare on another machine other than the machines where OFSAAI is installed?

FTPSHARE is a Metadata Repository directory. All the metadata related files used in Infrastructure are stored in the FTPSHARE directory. The ftpshare contains folders for each Information Domain, with each Information Domain folders holding Erwin, log, and scripts folder. The transfer of data among the Web, Application, and Database servers in Infrastructure takes place through FTP/SFTP.

You need to configure FTP/SFTP and enable communication between the servers by providing App server's FTP/SFTP credentials to the Web server and DB server users.

Yes, you can have FTPSHARE on another machine other than the machines where OFSAAI is installed.

Is it mandatory to provide the FTP/SFTP password?

Yes, OFSAAI needs credentials of the user who has complete permissions on FTPSHARE directory, and the user should be able to independently login to the unix server.

What are the permissions required for FTPSHARE and when should I give them?

It is recommended to provide permissions on FTPSHARE in case of installations done across different machines or VMs (multitier installation).

In case of single tier installation, 770 permissions can be provided if the Unix users of OFSAAI and web server belong to the same Unix group.

Additionally, any new file that is created in the FTPSHARE folder of any installation layer should be granted specific/explicit permission.

Port Change utility can be used to have the Port number modified, which are currently being used by the Infrastructure application. For more information, refer Changing IP/ Hostname, Ports, Deployed Paths of the OFSAA Instance section in OFS Analytical Applications Infrastructure Administration User Guide in OTN.

Are there any in-built system administration users within OFSAAI Application?

The three in-built system administration users are provided to configure and setup OFSAAI.

SYSADMN
SYSAUTH
GUEST

Does OFSAAI Application support both FTP and SFTP?

OFSAAI supports both FTP and SFTP configuration.

Is it necessary to enable the FTP/SFTP services to use the OFSAAI?

Yes, enabling of FTP/SFTP services and its ports is a pre-requisite step towards using the OFSAAI.

OFSAAI Configuration: Unable to save the server details?

Ensure the input User ID, Password, and Share Name are correct.
Ensure FTP/SFTP services are enabled.
Have a test FTP/SFTP connection made and confirm if they are successful.

What should I do if I get the following message while creating Information Domain, "Please create a database and then create the information domain"?

Information Domain is mapped to only one Database; and thus before the creation of Information Domain, at least one database details should exist.

What should I do if I get the following message during the startup of backend engine message server, "ConnectToDatabase: FatalError, could not connect to the DB server"?

Verify whether connection to the Configuration Schema can be established through SQL*PLUS.
Verify Configuration Schema password is modified post installation.
Ensure Oracle Database Alias Name created for Oracle Instance and Oracle Service Name are same.
On a multi tier installation mode, ensure TNSNAME and SID are same in both the Application and Database Layers.

What should I do if I get the following message during the startup of backend engine message server, "Fatal Error, failed to get user ID from LibSmsConnect"?

Ensure Reveleus.sec file exist under the $FIC_HOME/conf directory where the Database components are installed.

Does OFSAAI Application support LDAP authentication?

OFSAAI supports LDAP configuration and authentication.

Does OFSAAI support multiple languages?

Yes, OFSAAI supports multiple languages.

Does OFSAAI provide any data back-up features?

OFSAAI does not have built-in back up facility. External Storage Infrastructure is recommended for back-up.

What kind of security features does the OFSAAI provide?

OFSAAI provides security at:

Segment Level - Users can access only the segment they are mapped to.
Application Level - Users can perform an operation only if mapped to appropriate role and functions.

Does OFSAAI have the ability to enforce periodic password change?

OFSAAI provides configurable parameters to define number of days after which the user password would expire and then the user is forced to change the password after expiration period.

What is the password policy followed in OFSAAI?

OFSAAI enforces a minimum password length with a combination of Upper and Lower case characters and alpha-numeric strings.

Which version of Erwin Data Modeller does OFSAAI support?

OFSAAI now supports ERwin version 9.2 and 9.5 generated xmls in addition to ERwin 4.1, ERwin 7.1, ERwin 7.3 and ERwin 9.0 formats.

Does OFSAAI provide the mechanism to upload Business Data model?

OFSAAI also provides a model upload utility "upload.sh" for uploading the business data model through the command line parameter by executing this shell script file under the path <FIC_HOME>/ficapp/common/FICServer/bin.
For more details, see Configuration for Model Upload Utility section of the OFS Analytical Applications Infrastructure User Guide available on OTN.

How do I apply incremental change to the existing model when the Business Data model undergoes a change?

Modified data model can be uploaded into the system and OFSAAI has the ability to compare the changes within the data model with respect to the one already present in the system and enables propagation of incremental changes in a consistent manner.

What are the different types of uploading a business data Model?

OFSAAI supports uploading of business data model from client desktop and also by picking up the data model from the server location.

Can the OFSAAI Configuration Schema password be modified post installation?

The OFSAAI Configuration Schema password can be modified post installation. OFSAAI application stores the password in the database and few configuration files, thus any changes to the Configuration Schema password will require updating in those files. Contact Oracle Support Services for more details.

Can the OFSAAI Atomic Schema password be modified?

The OFSAAI Atomic Schema password can be modified. OFSAAI application stores the atomic schema password in the database and few configuration files, thus any change to the atomic schema password will require updating those files.

To change the Atomic Schema password, follow the steps:

Login to OFSAA.
Navigate to System Configuration > Database Details window. Select the appropriate connection, provide the modified password and save.
For the WebLogic Web server, follow the steps:
1. Login to the WebLogic Administration Console from the left side menu.
2. Under Domain Structure list box, expand the appropriate Domain and navigate to Services > JDBC >Data Sources. A list of data sources will be populated on the right side.
3. Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources need to be modified).
Restart the OFSAAI services.

Note:

If the modified passwords are not updated, OFSAAI logs display the message ORA-28000: the account is locked.

Does the upload of Business Data model depend on Java Memory?

Business data model upload through OFSAAI depends on the Java memory settings on the client and server machines. Java memory setting varies with the data model size and the available RAM. Contact Oracle Support Services for more details.

Why do the Business Metadata Management screens (Business Processors screen) in User Interface, take more time to load than other screens?

The Log file in DynamicServices.xml which resides in $FIC_HOME/conf is continuously being updated/refreshed to cache metadata. This can be observed when you are starting startofsaai.sh and if any of the log file (For example, SMSService.log) in DynamicServices.xml is being continuously refreshed for longer time.

By default, the Metadata Log file cache size is set to 1000. If in case the log is being updated beyond this limit, retrospectively the preceding entries are overwritten. For example, the 1001th entry is overwritten by deleting the first entry. This results in the application window taking a longer time to load.

Increase the cache size limit in Dynamicservices.xml located at <FIC_HOME>/conf, depending on the currently logged count for the specific metadata.

Generate the Log report by executing the following query in config schema.
select count(1), t.metadata_name, m.dsn_id from metadata_master m, metadata_type_master t where m.metadata_type = t.metadata_type

group by t.metadata_name, m.dsn_id
The preceding query returns a list of codes with their respective metadata count. You can refer to "metadata_type_master" table to identify the metadata name.
View the log report to identify the metadata which is being updated/refreshed beyond the specified cache size limit. Accordingly increase the cache size limit in Dynamicservices.xml depending on the currently logged count for the specific metadata.
For example, if the "MEASURE_CACHE_SIZE" is set to 1000 and total measure reported in log is 1022, increase the limit to 2000 (approximately).
Restart Reveleus/OFSAAI servers (Web and APP) and check the issue.

What configurations should I ensure if my data model size is greater than 2GB?

In order to upload data model of size greater than 2GB from OFSAAI Data Model Management -->Data Model Maintenance--> Import Model, you need to configure the required model size instruts.xml file available in the path $FIC_WEB_HOME/webroot/WEB-INF/classes.

Note:

The size requirements have to be always specified in bytes.

For example, if you need to configure for model size of 2.5GB, then you can approximately set the max size to 3GB (3221225472 bytes) as follows, in order to avoid size constraints during model upload.

After configuring struts.xml file, generate the application EAR/WAR file and redeploy the application onto your configured web application server. For more information on generating and deploying EAR / WAR file, refer Appendix 11.

What should I do if my Hierarchy filter is not reflecting correctly after I make changes to the underlying Hierarchy?

In some cases, the Hierarchy Filters do not save the edits correctly if the underlying Hierarchy has been changed. This can occur in hierarchy maintenance, where you have moved a member to another hierarchy branch, and that member was explicitly selected in the Filter and is now a child of a node which is already selected in the Filter. Refer Support Note for the workaround.

Can I install an Application Pack on an existing Atomic schema/ Information Domain created manually?

No, you cannot install an Application Pack on existing Atomic schema/Information Domain created manually. Application Packs can be installed only on Atomic Schemas/Information Domain created using schema creator utility and/ or the Application Pack installer.

What should I do if I get the following exception while trying to view the model outputs in Model Outputs screen, "Exception ->Local Path/STAGE/Output file name (No such file or directory)"?

Ensure you have created a folder "STAGE" under the path mentioned as "Local Path" in the web server details window. This folder needs to be created under the local path on every node, in case of web application server clustering.

What should I do if I get the following exception during OFSAA services startup, "Exception in thread "main" java.lang.UnsatisfiedLinkError: net (Not a directory)"?

Ensure the JRE referred in .profile is not a symbolic link. Correct the path reference to point to a physical JRE installed.

What is the optimized memory settings required for "New" model upload?

The following table lists the optimized memory settings required for "New" model upload.

Table 0–1 Optimized Memory Settings for New Model Upload

Table 22-1 Optimized Memory Settings for New Model Upload

-	-	-
Pick from Server	106 MB	"-Xms1024m - Xmx1024m
	36 MB	"-Xms2048m - Xmx2048m
	815 MB	"-Xms4096m - Xmx4096m
	1243 MB	"-Xms6144m - Xmx6144m
Model Upload Utility	106 MB	"-Xms1024m - Xmx1024m"- Xms2048m - Xmx2048m
	336 MB	"-Xms4096m - Xmx4096m
	815 MB	"-Xms4096m - Xmx4096m
	1243 MB	"-Xms6144m - Xmx6144m
Save New Erwin File In Server	106 MB	"-Xms1024m - Xmx1024m
	336 MB	"-Xms2048m - Xmx2048m
		"-Xms4096m - Xmx4096m
		"-Xms6144m - Xmx6144m

What should I do if I get the following error message, "ORA 01792 maximum number of columns in a table or view is 1000 during T2T execution"?

You should apply the following patch set from Oracle. Applicable only for 12c. https://support.oracle.com/epmos/faces/DocumentDisplay?id=1937782.1

I did not enable OFS Inline Processing Engine Application license during the installation. However, I have enabled it post installation, using the Manage OFSAA Product License(s) in the Admin UI. Are there any other additional configurations that I need to do?

Yes. Follow the instructions explained in the OFS Inline Processing Engine Configuration Guide available on OTN.

I get an error when I try to build an Oracle OLAP cube. What should I do?

Execute the following grant on the appropriate ATOMIC schema grant olap_user to &database_username

How do you turn off unused Information Domains (Infodoms) from caching?

Follow these steps to turn off unused infodoms from caching:

Navigate to $FIC_HOME/conf in the APP layer of your OFSAAI installation.
In the DynamicServices.xml file, identify the section for <Service code="20">.
Modify the value of parameter CACHE_ON_STARTUP to 0 (default is 1).
Repeat the same in the WEB layer too. Generate the application EAR/WAR file and redeploy the application onto your configured web application server. For more information on generating and deploying EAR / WAR file, refer to the Appendix 11 section.
Restart the OFSAAI Services (APP and WEB). For more information, refer to the Starting Infrastructure Services section.

Note:

This setting will cache the Infodom metadata only for the infodoms that get accessed upon user login. Infodoms which do not get accessed, will not be cached.

Sample code is as follows:

<SERVICE CODE="20"
CLASS="com.iflex.fic.metadata.services.MetadataServiceProvider" NAME="BMD"
SERVERID="DEFAULT" PATH=" " LOGGERNAME="UMMLOGGER" LOGGERLEVEL="10">
<PARAMETERS>
<PARAMETER NAME="CACHE_ON_STARTUP" VALUE="0" />
<PARAMETER NAME="BACKUP_XML" VALUE="1" />
<PARAMETER NAME="MAX_BACKUP_XML" VALUE="2" />
<PARAMETER NAME="PC_NONBI_BI_SWITCH" VALUE="2048" />
<PARAMETER NAME="HIERARCHY_NODE_LIMIT" VALUE="2000" />
<PARAMETER NAME="ALIAS_CACHE_SIZE" VALUE="1000" />
<PARAMETER NAME="DATASET_CACHE_SIZE" VALUE="2000" />
<PARAMETER NAME="MEASURE_CACHE_SIZE" VALUE="2000" />
<PARAMETER NAME="HIERARCHY_CACHE_SIZE" VALUE="2000" />
<PARAMETER NAME="DIMENSION_CACHE_SIZE" VALUE="2000" />
<PARAMETER NAME="HIERARCHYATTRIBUTE_CACHE_SIZE" VALUE="1000" />
<PARAMETER NAME="CUBE_CACHE_SIZE" VALUE="1000" />
<PARAMETER NAME="RDM_CACHE_SIZE" VALUE="1000" />
<PARAMETER NAME="BUSINESSPROCESSOR_CACHE_SIZE" VALUE="2000" />
<PARAMETER NAME="DERIVEDENTITY_CACHE_SIZE" VALUE="1000" />
<PARAMETER NAME="LOG_GET_METADATA" VALUE="false" />
<PARAMETER NAME="METADATA_PARALLEL_CACHING" VALUE="0" />
</PARAMETERS>
</SERVICE>

While creating an Excel Mapping, after specifying the excel worksheet, the target table, and mapping each column in the worksheet to a target table, I click Save and nothing happens. But when I click Cancel, a message pops up informing me that all changes will be discarded", what is to be done.

Check if the version of Internet Explorer and JRE Plugin are as mentioned in the Desktop Requirements section of this manual. If not, use the qualified versions as mentioned.

Can multiple OFSAA Infrastructure instances share the same Config Schema?

No, only one OFSAA environment can be installed using one Config Schema.

Can Atomic Schema be shared?

Yes, it can be shared between two OFSAA instances.

While setting a firewall, which ports should be opened for communication between the Oracle HTTP Web Server and the WebLogic Application Server for OFSAAI to operate properly?

The OFSAA Servlet port which is same as Web server port should be open. Also the web application port should be open.

Can I modify the NLS_LENGTH_SEMANTICS to BYTE from CHAR for the Database where older versions of OFSAA is Installed?

Yes, NLS_LENGTH_SEMANTICS can be modified to BYTE from CHAR if you are not intending to use multi language support.

Can I install already installed application in a different infodom?

No, it is not possible to install the same application in two different infodoms.

How can I configure the OFSAA application for High Availability?

OFSAA can have active-passive high availability. For more details, refer Configuration for High Availability- Best Practices Guide.

During OFSAA installation should I provide web application server's IP /Hostname and port or web server's IP/Hostname and port, if the Apache HTTP Server/ Oracle HTTP Server/ IBM HTTP Server are configured?

In case the web server is configured, you should enter the Web Server IP Address/Hostname and Port details during OFSAA installation. Here the Servlet port should be same as the Web Server port.

If Web Server is not configured, the Web Application Server's IP Address/ Hostname and Port is required during the installation process. Here the Servlet port should be same as the Web application Server port.

Is "ReveleusAdminConsoleAgent" applicable for OFSAAI 8.0.0.0.0 and higher versions?

No, ReveleusAdminConsoleAgent is not applicable starting OFSAAI 7.3.3.0.0. There is a change in the way agentservers are managed through AGENTSTARTUP.SH and AGENTSHUTDOWN.SH.

What should I do when the message server process does not open and I get the following error message, "CI18NProvider::CI18NProvider, Error, unable to connect to the config database"?

This error is displayed due to the following reasons:

The Config Schema password is already expired.
If the Config Schema password is going to expire soon and the message like "ORA-28002: the password will expire within 6 days" displays while connecting to Config Schema through SQLPlus.
The Config Schema password is modified.
To resolve the error, re-set the Config Schema password to the old password. Else, if the Config Schema password is modified to something else then follow these steps:
1. Delete the $FIC_HOME/conf/Reveleus.SEC file.
2. Shutdown the OFSAAI App service: cd $FIC_APP_HOME/common/FICServer/bin ./stopofsaai.sh
3. Shutdown the OFSAAI App service: cd $FIC_APP_HOME/common/FICServer/bin ./stopofsaai.sh
4. Start the Infrastructure Server in foreground directly on the server or through XWindows software using the command: ./startofsaai.sh
5. Enter System Password.
6. Enter the new Config schema password. The service starts and initializes if it is able to successfully connect to the DB and generates the Reveleus.SEC file.
7. Post successful startup of the service, if required, the Infrastructure server may be shut down and restarted in the background using nohup mode.

What is the mechanism of Log File sizing and backup?

OFSAAI Log files created under $FIC_APP_HOME/common/FICServer/logs &<OFSAAI_DEPLOYED_AREA>/<CONTEXT.war>/logs is configurable in RevLog4jConfig.xml.

The default size of the log files (MaxFileSize) is set to 5000kb and number of maximum backup log files (MaxBackupIndex) retained is set to 5, both of which are configurable. Increasing these parameters to a higher value should depend on the server hardware configurations and may reduce the performance.

To configure the Logs file size on OFSAA Application server, follow these steps:

Navigate to $FIC_HOME/conf where OFSAA is installed.
Edit the following parameters in the file RevLog4jConfig.xml
- param name="file" : Enter the path where the Logs are to be generated.
- param name="MaxFileSize" : Provide the required file size.
- param name="MaxBackupIndex" : Provide the required number of backup files to be created.

Example:

</layout>

</appender>

To configure the Deployed area logs file, follow these steps:

Navigate to <EAR/WAR Deploy area>/conf folder.
Repeat step 2 from the preceding section.

Can we modify the Log file path?

Yes, Log file path is configurable, it can be configured in RevLog4jConfig.xml file. The default log file path (file) is set by the installer. This can be configured to another path.

Can I point the environment with HTTP enabled to HTTPS after installation and vice versa?

Follow these steps:

Create SSL related certificates and import to respective servers.
Enable SSL on a desired Port (example 9443) on your existing and already deployed web application servers.
Replace the protocol as https and new ssl port (FIC_SERVLET_PORT) configured and in all the URLs specified on the following files:
- $FIC_HOME/ficapp/common/FICServer/conf/FICWeb.cfg and $FIC_HOME/ficweb/webroot/ conf/FICWeb.cfg
- $FIC_HOME/ficapp/icc/conf/WSMREService.properties
- $FIC_HOME/ficweb/webroot/conf/ModelExecution.properties
- $FIC_HOME/ficdb/conf/MDBPublishExecution.properties
- $FIC_HOME/ficdb/conf/ObjAppMap.properties
- $FIC_HOME/utility/Migration/conf/WSMigration.properties
- $FIC_HOME/utility/WSExecution/conf/WSExecution.properties
- $FIC_HOME/EXEWebService/weblogic/ROOT/WEB-INF/wsdl/EXEWebServiceImpl.wsdl
Replace XML attribute/Node values as specified on the following files:
- $FIC_HOME/ficweb/webroot/WEB-INF/web.xml
- FIC_WEBSERVER_PORT=9443
- FIC_WEBPROTOCOL=https
- $FIC_HOME/conf/LookUpServices.xml and $FIC_HOME/ficweb/webroot/conf/ LookUpServices.xml
- PORT="9443" PROTOCOL="https:"
Login to Config Schema and execute the following SQL command to replace protocol and SSL port.
SQL> update configuration cn set cn.paramvalue='9443' where cn.paramname='SERVLET_ENGINE_PORT'; SQL>update configuration cn set cn.paramvalue=replace(cn.paramvalue,'http:','https:') where cn.paramname='FormsManagerCacheReload'; SQL>update web_server_info ws set ws.servletport='9443',ws.servletprotocol='https';
Create EAR/WAR file and Re-Deploy.

What should I do if my HIVE connection fails with the following exception: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: [Cloudera][HiveJDBCDriver](500168) Unable to connect to server: GSS initiate failed.

com.ibm.security.krb5.KrbException, status code: 37

message: PROCESS_TGS at com.ibm.security.krb5.KrbTgsRep.<init>(KrbTgsRep.java:20)

This happens if there is a clock skew between the client and the KDC server. To resolve this, there are two solutions:

Solution 1:
Synchronize the clocks between the servers. For more information, refer http://docs.oracle.com/ cd/E19253-01/816-4557/setup-192/index.html
Solution 2:
1. Set clockskew parameter on the server side (KDC) krb5.conf file and replace the same file in HIVE_LIBRARY_PATH
  folder. Parameter value should be decided on the basis of the time difference between the two machines.
2. Get the epoch time on the two servers by firing “date +%s” on the command line.
3. Clockskew param value should be chosen as a value sufficiently larger than the difference of the preceding two calculated values.
4. Set “clockskew = <value>” in the /etc/krb5.conf on the KDC server.
5. Restart Kerberos services.

What should I do if my schema creator log has the following exception: Failed to detect a valid hadoop home directory java.io.IOException: HADOOP_HOME or hadoop.home.dir are not set.

at org.apache.hadoop.util.Shell.checkHadoopHome(Shell.java:302)

at org.apache.hadoop.util.Shell.<clinit>(Shell.java:327)

at org.apache.hadoop.util.StringUtils.<clinit>(StringUtils.java:79) at org.apache.hadoop.security.Groups.parseStaticMapping(Groups.java:130)

at org.apache.hadoop.security.Groups.<init>(Groups.java:94) at org.apache.hadoop.security.Groups.<init>(Groups.java:74)

at org.apache.hadoop.security.Groups.getUserToGroupsMappingService(Groups.java:303)

at org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInformation.java:283) at

org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGroupInformation.java:311)

at HdfsDbUtil.connect(HdfsDbUtil.java:162)

at SchemaParserUtil.validateHiveConnection(SchemaParserUtil.java:1359) at SchemaParserUtil.checkAllPreChecks(SchemaParserUtil.java:1011)

at Main.execute(Main.java:317)

at Main.main(Main.java:145)

This occurs when HADOOP_HOME environment variable is not set. You can ignore this exception since we do not mandate to install HIVE where OFSAA is installed.

What should I do if the sliced data model upload takes a long time to complete?

If the metadata cache size is set to a lower value than the actual count of each metadata type (hierarchy, dataset, dimension etc), then it gets into performance degrade issues. We have to increase the cache size for each metadata type according to the count in the environment.

Following are the parameters in DynamicServices.xml to be configured depends on the metadata count in your environment.

Metadata count can be derived based on the following queries:

select count(1) from metadata_master where metadata_version=0 --- for all metadata select count(1) from metadata_master where metadata_version=0 and metadata_type=1

--- for measure

select count(1) from metadata_master where metadata_version=0 and metadata_type=2

--- for Dimension

select count(1) from metadata_master where metadata_version=0 and metadata_type=3

--- for HCY

select count(1) from metadata_master where metadata_version=0 and metadata_type=4

--- for DATASET

select count(1) from metadata_master where metadata_version=0 and metadata_type=59

--- for BP's

select count(1) from metadata_master where metadata_version=0 and metadata_type=54

--- for Alias

select count(1) from metadata_master where metadata_version=0 and metadata_type=5

--- for CUBES

select count(1) from metadata_master where metadata_version=0 and metadata_type=856 --- for Derived Entity

For LDAP authentication, which server connects with the LDAP server, the Application server (where ofsaai is installed), or Web Application server (where EAR is deployed)?

For LDAP authentication, the Application server (ficapp) connects with the LDAP server.

The LDAP server in the setup listens on secure protocol ldaps (port 636). I have the root certificate of the LDAP server for SSL, and would like to know where to offload this certificate?

You need to import the certificate into the JDK/JVM used by Reveleus server in ficapp layer.

How to relocate FTPSHARE folder?

You can run the PortC.jar utility. For more details, refer Changing IP/ Hostname, Ports, Deployed Paths of the OFSAA Instance section in the OFSAAI Admin Guide available on OTN.

How do we identify the list of ports that are used by/configured in an OFSAA environment?

Navigate to $FIC_HOME folder on Target.
Run the PortC.jar utility using the command:
java -jarPortC.jar DMP

A file with the name DefaultPorts.properties will be created under $FIC_HOME directory which will contain the ports. For more information, refer Changing IP/ Hostname, Ports, Deployed Paths of the OFSAA Instance section in the OFSAAI Admin Guide available on OTN.

Note:

This feature is available only after applying 7.3.5.2.0 Minor Release patch.

What should I do if I get the following error message, "Error while fetching open cursor value Status : FAIL"?

This error occurs while executing envCheck.sh because the user does not have access to V$parameter. This error does not occur due to sysdba or non sysdba privileges provided they have access/grants to V$parameter.

What should I do when an entity containing many attributes (>100 columns) is selected as Source entity and the Data Mapping (T2T definition) save operation takes longer than expected with the hourglass in the UI continuously rotating?

The workaround is:

Locate the webserver deployed area webroot/conf/excludeURLList.cfg file.
Modify the following entries:
- [SQLIA]./dataIntegrator/ to [ALL]./dataIntegrator/
- [SQLIA]./ETLExtractionServlet to [ALL]./ETLExtractionServlet
Save the changes and restart the webserver.
Resave the definition.

What should I do if I get the following error message when I try to start the OLAP server:

./olapdataserver: error while loading shared libraries: libessapinu.so: cannot open shared object file: No such file or directory

FATAL ERROR:- OLAP DATA SERVER start up failed.

This error occurs when OLAP component is not configured and OLAP feature in OFSAA is not used. However, this error can be ignored.

What should I do if I get the error "FATAL ERROR-Problem with OFSAA Service" during OFS_AAAI_PACK installation?

Increase the sleep counter (default value is 80) to a higher value in the following section of the OFS_AAAI_PACK/OFSAAIUpdate.sh file:

if [ $count -eq 0 ] ; then sleep 80;

count=` grep -i "FICServer Initialization Complete"

$FIC_HOME/ficapp/common/FICServer/bin/nohup.out|wc -l ` fi

if [[ $count -gt 0 ]] ; then echo OFSAA Service - OK else

echo FATAL ERROR-Problem with OFSAA Service

exit 1 fi

How do I upgrade to Oracle Database 12c Release 1 or 2, if my previous database versions are Release 11.2.0.2+, 12.1.0.1 or 12.1.0.2?

If you are upgrading the Database Server from the previous versions to the current versions mentioned in the following table:

Table 22-2 Database Server

-	-	-
1.	11.2.0.2+ or 12.1.0.1	12c Release 1 (12.1.0.2)
2.	11.2.0.3+, 12.1.0.1 or 12.1.0.2	12c Release 2 (12.2.0.1)

Perform the instructions mentioned in the following MOS documents:

Doc ID 2412630.1
Doc ID 2075401.1