Frequently Asked Questions
- What are the different components that get installed during OFSAAI?
The different components of OFSAAI are illustrated in Components of OFSAAI.
- What are the different modes of OFSAAI installation?
OFSAAI can be installed only 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 are installed on a 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 the JDK (Java Development Kit) required during the installation of
OFSAA? Can it be uninstalled after the OFSAA installation?
JDK is not required during the installation of OFSAA and only a run-time is needed. For details, see Hardware and Software Requirements.
Only JRE (Java Runtime Environment) is required during the 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, web servers, and other
software versions that OFSAA supports?
See the Oracle Financial Services Analytical Applications 8.1.2.0.0 Technology Matrix.
- 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_InstallConfig.xml
privileges_config_user.sql
privileges_atomic_user.sql
- What should I do if I get
Execute Permission denied?
error message during installation?Check whether all the files provided for OFSAAI installation has execute permissions.
To give execute permissions, navigate to the directory path where the Installation files are extracted and execute the following command:
chmod –R 755 OFS_AAAI_PACK
- What should I do if I get
No Java virtual machine could be found from your PATH environment variable.
error message?Install a VM before running this program, then
- Check whether the "java path" is set in the PATH variable. See the Hardware and Software Requirements 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 the
setup.sh
file does not contain control line feed characters (^M).
- What should I do if I get
"Oracle Driver Files Not Found, Please Choose the Right Path To Continue"
error message during installation?Check whether the provided path for Oracle Driver files is correct and whether the user has permission to access the files.
- The installation of OFSAAI was completed successfully! What next?
Post the successful completion of the OFSAAI installation, one has to perform the Post Installation steps. See Post-installation.
- What is to be done when OFSAAI Installation is unsuccessful?
OFSAAI installer generates the log file
OFSAAInfrastructure_Install.log
in the Infrastructure Installation Directory. There are also other log files created in the directories:< directory path where the Installation files are extracted >/OFS_AAAI_PACK/logs
< directory path where the Installation files are extracted >/OFS_AAAI_PACK/OFS_AAI/logs
If the logs of any of these reported Warnings, Non Fatal Errors, Fatal Errors, or Exceptions, they must be brought to the notice of the OFSAAI My Oracle Support. 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 the Uninstall OFSAA Infrastructure section in this guide.
- Can OFSAAI config and atomic schemas be on different databases?
OFSAAI requires both config and atomic schema 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
privileges_atomic_user.sql
file available under the$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 the OFS Analytical Applications Infrastructure Administration Guide.
- 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"?- Log in 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 15000
- After saving the changes, log in as UNIX user with which OFSAAI
is getting installed and execute the command:
ulimit -n
- The command must return the value 15000.
- 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 My 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 the successful installation of the product.
- What should I do if there are any exceptions or errors in installation and how to
proceed?
- See the Verify the Log File Information section for log file information.
- Backup the installation logs.
- Share the backup logs with My Oracle Support.
- What should I do if I get the following error message during OFSAAI
installation on Solaris 11
system?
"Error: OFSAAI-1108 ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found"
Or
"Time zone cannot be set as null or 'localtime' "
This happens if the time zone is not set, that is NULL or it is set as ’localtime’. Set the environment variable TZ to a valid time zone region in the .profile file. For example,
TZ=Asia/Calcutta
export TZ
- What should I do if the installation process is abruptly terminated or aborted?
If the installation process is abruptly terminated, then the installation is incomplete. To recover from this, follow these steps:
- Drop the DB objects in the config and atomic schemas 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 and FTP Share directories created by the OFSAAI installer.
- Perform the OFSAAI installation again. See Pre-installation
- Does OFSAA support any other web server types, other than the ones stated in the
Oracle Financial Services Analytical Applications 8.1.2.0.0 Technology Matrix and
Installation Guide?
No, all the supported software and versions are stated in the Oracle Financial Services Analytical Applications 8.1.2.0.0 Technology Matrix
- What should I do if the database connection from the 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 must 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 can mostly happen due to the following reasons:
- When the installer is not extracted correctly or corrupted during the unzip utility process.
- setup.sh file which resides within the install archive is not transferred in ASCII or text mode, which can corrupt 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 thesetup.sh
file by following these steps:- Log in to the server where the installer is copied.
- Navigate to the directory
< directory path where the Installation files are extracted >/OFS_AAAI_PACK/bin.
- Open the setup.sh file in the vi editor using the command: vi setup.sh.
- 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. - Save the
setup.sh
file by typing:wq!
- 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 the
JAVA_BIN
environment variable path is set on the "UNIX user
" terminal from where thestartofsaai.sh
file is invoked. - Ensure that the
.profile
file, where the environment/ path settings are made, is executed successfully.
- Ensure the
- 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 during installation is correct. 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 the list of languages from Server. Please contact the system administrator"
. What should one do?Ensure OFSAAI servers are started and are running successfully. For details on startup parameter options, see Start the Infrastructure Services section.
For more details on the issue, refer to the logs under
$FIC_HOME /logs
directory. - 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 must never be revoked as the application makes use of these grants all the time.
- Can we have a 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 can be achieved with the distribution of services.
- Why do we need FTPSHARE on all the layers? Can we have ftpshare on another server
other than the server 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 directories for each Information Domain, with each Information Domain directories holding Erwin, log, and scripts directory. The transfer of data among the Web, Application, and Database servers in Infrastructure takes place through FTP/SFTP.
You must 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 as a common local storage mount point which can be mounted 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 the FTPSHARE directory, and the user must be able to independently log in to the UNIX server.
For more information, see the Configure OFSAAI_InstallConfig.xml File section.
- 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 (multi tier installation).
In the case of a single-tier installation, 770 permissions can be provided if the UNIX users of OFSAAI and web servers belong to the same UNIX group.
Additionally, any new file that is created in the FTPSHARE directory of any installation layer must be granted specific/explicit permission.
- How to modify the port number currently being used by the
Infrastructure application?
Port Changer utility can be used to have the Port number modified, which is currently being used by the Infrastructure application. For more information, refer to the Change IP/ Hostname, Ports, Deployed Paths of the OFSAA Instance section in the OFS Analytical Applications Infrastructure Administration User Guide.
- Are there any in-built system administration users within OFSAAI Application?
The two in-built system administration users are provided to configure and setup OFSAAI.
- SYSADMN
- SYSAUTH
- 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 must exist.
- What should I do if I get the following message during the startup of
the backend engine message server,
"ConnectToDatabase: FatalError, could not connect to the DB server"
?- Verify whether a connection to the Configuration Schema can be established through SQL*PLUS.
- Verify the Configuration Schema password is modified post-installation.
- Ensure Oracle Database Alias Name created for Oracle Instance and Oracle Service Name are the same.
- What should I do if I get the following message during the startup of
the backend engine message server,
"Fatal Error, failed to get the user ID from LibSmsConnect"
?Ensure the
Reveleus.SEC
file exists 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 a built-in backup facility. External Storage Infrastructure is recommended for back-up.
- What kind of security features does the OFSAAI provide?
See the Security Guide for more information.
- Does OFSAAI have the ability to enforce periodic password change?
OFSAAI provides configurable parameters to define the number of days after which the user password must expire and then the user is forced to change the password after the 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 alphanumeric strings.
- Which version of Erwin Data Modeller does OFSAAI support?
See the Hardware and Software Requirements section for more information.
- Does OFSAAI provide the mechanism to upload Business Data model?
OFSAAI provides two mechanisms for business data model upload:
- Easy to use GUI based Model upload mechanism to upload the Business Data Model through Data Model Management -->Data Model Maintenance --> Import 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 the Model Upload Utility section of the OFS Analytical Applications Infrastructure User Guide.
- How do I apply the incremental change to the existing model when the Business Data
model changes?
The modified data model can be uploaded into the system and OFSAAI can compare the changes within the data model concerning 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 the 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. For more information, see Modify OFSAAInfrastructure Config Schema Password.
- 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:
- Log in to OFSAA.
- Navigate to System Configuration > Database Details window. Select the appropriate connection, provide the modified password, and save.
- Based on the Web Server installed, follow the steps:
- If you are using Apache as Web server:
- Update the <Context> -> Resource tag
details in the
server.xml
file from the$CATALINA_HOME/conf
directory. (In case of Tomcat only Atomic <Resource> will exist).
- Update the <Context> -> Resource tag
details in the
- If you are using WebSphere as Web server:
- Log in to the WebSphere Administration Console from the left side menu.
- Navigate to Resources >JDBC > Data Sources. A list of data sources are populated on the right side.
- Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources must be modified).
- If you are using WebLogic as Web server:
- Log in to the WebLogic Administration Console from the left side menu.
- Under Domain Structure list box, expand the appropriate Domain and navigate to Services > JDBC >Data Sources. A list of data sources are populated on the right side.
- Select the appropriate Data Source and edit the connection details. (In this case, both Config and Atomic data sources must be modified).
- If you are using Apache as Web server:
- 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 the 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 My Oracle Support 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 the$FIC_HOME/conf
directory is continuously being updated/refreshed to cache metadata. This can be observed when you are starting startofsaai.sh and if any of the log files (For example, SMSService.log) in DynamicServices.xml is being continuously refreshed for a longer time.By default, the Metadata Logfile 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 1001st 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 the
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 the "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 the total measure reported in the log is 1022, increase the limit to 2000 (approximately).
- Restart Reveleus/OFSAAI servers (Web and APP) and check the issue.
- Generate the Log report by executing the following query in the
config schema.
- What should I do if I get OutOfMemoryError while deploying the EAR file
in the WebSphere application server?
The Java memory must be increased in the
ejbdeploy.sh
file which is present under<WebSphere Install directory>/AppServer/deploytool/itp
. For example,$JAVA_CMD \ -Xbootclasspath/a:$ejbd_bootpath \ Xms256m -Xmx1024m \
- What is the default memory setting configured by the installer?
During OFSAAI installation, the X_ARGS_APP parameter in the
.profile
file is set as given:X_ARGS_APP="-Xms200m -Xmx8g -XX:+UseAdaptiveSizePolicy - XX:MaxPermSize=1024M -XX:+UseParallelOldGC -XX:+DisableExplicitGC
During the application installation, if 10 times the data model size (data model size*10) is greater than the default Xmx value of 8g (8GB), the installer automatically updates the Xmx value to 10 times the data model size.
- What configurations should I ensure if my data model size is greater
than 2GB?
Ensure the Xmx value in the X_ARGS_APP parameter in the
.profile
file is set as 10 times the data model size.For example, if it is 2GB, set it as:X_ARGS_APP="-Xms200m –Xmx20g -XX:+UseAdaptiveSizePolicy - XX:MaxPermSize=1024M -XX:+UseParallelOldGC -XX:+DisableExplicitGC
Then execute the
.profile
file. - 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 is changed. This can occur in hierarchy maintenance, where you have moved a member to another hierarchy branch, and that member is explicitly selected in the Filter and is now a child of a node that is already selected in the Filter.
- 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 directory "STAGE" under the path mentioned as "Local Path" in the web server details window. This directory must 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. - 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).
- Update the same details in the table Aai_Dyn_Svcs_Params of Config Schema for the parameter CACHE_ON_STARTUP. Set the value as 0 and commit the change.
- Restart the OFSAAI Services (APP and WEB). For more information, refer to the Start the Infrastructure Services section.
Note:
This setting helps cache the Infodom metadata only for the infodoms that are accessed after the user login. Infodoms which are not accessed, are not 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 the browser and JRE Plugin are as mentioned in the Hardware and Software 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 must be opened for communication between the Web Server (Apache HTTP Server/ Oracle HTTP Server/ IBM HTTP Server) and the Web application server (WebSphere/ WebLogic/ Tomcat) for OFSAAI to operate properly?
The OFSAA Servlet port which is the same as the Web server port must be open. Also, the web application port must be open.
- Can I install an 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 a 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 must enter the Web Server IP Address/Hostname and Port details during OFSAA installation. Here the Servlet port must be the same as the Web Server port.
If Web Server is not configured, the Web application server's IP Address/ Hostname and Port are required during the installation process. Here the Servlet port must be the same as the Web application server port.
- Is "ReveleusAdminConsoleAgent" applicable for OFSAAI 8.1.2.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:
- Delete the
$FIC_HOME/conf/Reveleus.SEC
file. - Shutdown the OFSAAI App service:
cd $FIC_APP_ HOME/common/FICServer/bin ./stopofsaai.sh
- Start the Infrastructure Server in foreground directly on the server or through XWindows software using the command: ./startofsaai.sh
- Enter System Password.
- Enter the new Config schema password. The service starts and initializes if it can successfully connect to the DB and generates the Reveleus.SEC file.
- 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, changing the log file path,
and creating backups of the log files?
OFSAAI Log files created under
$FIC_APP_HOME/common/FICServer/logs
and<OFSAAI_DEPLOYED_AREA>/<CONTEXT.war>/logs
is configurable inRevLog4jConfig.xml
.The default size of the log files (MaxFileSize) is set to 5000kb and the number of maximum backup log files (MaxBackupIndex) retained is set to 5, both of which are configurable. Increasing these parameters to a higher value must depend on the server hardware configurations and may reduce the performance.
To configure the Logs file size on the OFSAA Application server, follow these steps:
- Navigate to
$FIC_HOME/conf
where OFSAA is installed. - Edit the following parameters in the RevLog4jConfig.xml file:
- param name="fileName" : Enter the path where the Logs are to be generated.
- param name="size" : Provide the required file size.
- param name="max" : Provide the required number of backup files to be created.
Example:
<RollingFile name="REVSERVERAPPENDER" fileName="<Path_exists>/logs/RevAppserver.log" filePattern="<Path_exists>/logs/RevAppserver-%i.log" > <PatternLayout> <Pattern> [%d{dd-MM-yy HH:mm:ss,SSS zzz aa}{GMT}] [%- 5level] [APP] [REVELEUS] %m%n</Pattern> </PatternLayout> <Policies> <SizeBasedTriggeringPolicy size="5000 KB" /> </Policies> <DefaultRolloverStrategy max="5"> <!-- number of backup files --> </DefaultRolloverStrategy> </RollingFile>
- Navigate to
$FIC_HOME/ficweb/webroot/conf
and configure the deployed area logs. Edit the following parameters in theRevLog4jConfig.xml
file:- param name="file": Do not change this value.
- param name="MaxFileSize" : Provide the required file size.
- param name="MaxBackupIndex" : Provide the required number of backup files to be created.
Example:
<RollingFile name="REVSERVERAPPENDER" fileName="${sys:LOG_HOME}/logs/RevAppserver.log" filePattern="${sys:LOG_HOME}/logs/RevAppserver-%i.log" > <PatternLayout> <Pattern> [%d{dd-MM-yy HH:mm:ss,SSS zzz aa}{GMT}] [%- 5level] [WEB] [REVELEUS] %m%n</Pattern> </PatternLayout> <Policies> <SizeBasedTriggeringPolicy size="5000 KB" /> </Policies> <DefaultRolloverStrategy max="5"> <!-- number of backup files --> </DefaultRolloverStrategy> </RollingFile>
To configure the deployed area log file path, modify the value in the LOG_HOME_PATH parameter in the aai_setup_props table.
- Navigate to
- 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 - $FIC_HOME/ficapp/icc/conf/WSMREService.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
- 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:"
- Log in 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 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:
- Set clock skew parameter on the server side (KDC) krb5.conf file and replace the same file in the HIVE_LIBRARY_PATH directory. Parameter value must be decided based on the time difference between the two machines.
- Get the epoch time on the two servers by firing “date +%s” on the command line.
- Clock skew param value must be chosen as a value sufficiently larger than the difference of the preceding two calculated values.
- Set “clock skew = <value>” in the /etc/krb5.conf on the KDC server.
- 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:30 3) at org.apache.hadoop.security.UserGroupInformation.initialize(UserGroupInf ormation.ja va:283) at org.apache.hadoop.security.UserGroupInformation.setConfiguration(UserGr oupInfor mation.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.<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="3000"/> <PARAMETER NAME="HIERARCHY_CACHE_SIZE" VALUE="2000"/> <PARAMETER NAME="DIMENSION_CACHE_SIZE" VALUE="2000"/> <PARAMETER NAME="CUBE_CACHE_SIZE" VALUE="1000"/> <PARAMETER NAME="BUSINESSPROCESSOR_CACHE_SIZE" VALUE="2000"/> <PARAMETER NAME="DERIVEDENTITY_CACHE_SIZE" VALUE="1000"/>
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 must import the certificate into the JDK/JVM used by Reveleus server in ficapp layer.
- How to relocate FTPSHARE directory, change IP HOST name, and deployed
area in OFSAA?
You can run the
PortC.jar
utility. For more details, refer Change IP/ Hostname, Ports, Deployed Paths of the OFSAA Instance section in the OFS Analytical Applications Infrastructure Administration Guide. - How do we identify the list of ports that are used by/configured in an OFSAA
environment?
- Navigate to
$FIC_HOME
directory on Target. - Refer to the
PortsDef.log
file.
- Navigate to
- 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 the V$parameter. This error does not occur due to sysdba or non sysdba privileges provided they have access/grants to the V$parameter. - What should I do when an entity containing many attributes (>100 columns) is
selected as a Source entity and the Data Mapping (T2T definition) save operation
takes longer than expected with the hourglass in the UI continuously rotating?
- 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 the OLAP component is not configured and the 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 the 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 ]multitier; 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 fi echo FATAL ERROR-Problem with OFSAA Service exit 1