changing the default data type of number formats

to change the default format used by the Oracle BI EE 11g the following configuration file needs to be changed:

/home/oracle/Middleware/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/root/system/metadata

image
E.g. for two digits behind the number separator:

<dataFormat minDigits="2" maxDigits="2" commas="true" 
negativeType="minus" xsi:type="saw:number";

After saving and restarting the BI Server, the numbers are displayed with two digits behind the number separator.

Oracle BI 12c: fixing wlst.sh installation issue

While trying to install Oracle BI 12c we were facing an Issue during the Configuration of the Oracle BI Domain on the Weblogic Server. This is typically the last step of the Installation where the Domain is configured and started.

During the Installation we received the following Error Message:

BI Configuration
Error
Config Action BI Configuration failed

Configure BI Failed with Execution of [/opt/biee/oracle_common/common
/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.configassistant/
complete_domain.py,
/opt/biee, /opt/biee/user_projects/domains/bi, weblogic, Expanded,
serverhostname.lasg, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, DEV,
jdbc:oracle:thin:@//hostname:1521/DBservice.world, ]
failed with exit value 1

When checking the detailed log files at the following location:

/home/Linuxuser/oraInventory/logs/config2017-03-06_03-26-26PM/biee.log

The log file also didn’t reveal much more:

Failed single shot step: Complete domain with: Execution of [/opt/
biee/oracle_common/common/bin/wlst.sh, /opt/biee/bi/modules/oracle.bi.
configassistant/complete_domain.py, /opt/biee, /opt/biee/user_project
s/domains/bi, weblogic, Expanded, serverhostname.lasg, 9502, 9503,
ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//hostname:1530/
DBservice.world, DEV, jdbc:oracle:thin:@//hostname:1530/DBservice.
world, ] failed with exit value 1

After verifying that the ports are not blocked by the firewall we found some similar Issue with the Oracle BI 12c Installation. By adding the following Parameter to the wlst.sh file we were able to fix this Issue, too.

JVM_ARGS="<strong>-Djava.security.egd=file:///dev/urandom</strong>
${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}"

<span style="font-family: Courier New;">if [ -d "${JAVA_HOME}" ]; then
eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'
else
exit 1
fi

image

After deleting the Domain Installation files within the User Project (Domain Folder):

e.g. /opt/biee/user_projects/domains/bi

And dropping the Internal Repository Tables using the RCU routine the Domain Installation step “Configure Domain” succeeded without the above error.

image