INSTALLATION DOCUMENTS BY RAVI

Sunday, August 12, 2018

Steps for uploading rpd in Oracle Analytics Cloud























Go to console





















Click on Snapshot






















Click on replace the data model





















Browse the rpd and provide the password and click ok





















After getting successful upload message,
Login to the analytics page.
Under Administration tab click on reload files and metadata.


















Steps for migration obiee 11117 to Oracle Analytics cloud (bundle migration)

Generate migration-too-.jar file in OAC environment

./migration-tool.sh package bi-migration-tool.jar













Copy the generated jar file to obiee 11.1.1.7.0 environment.






Export the bundle in obiee 11.1.1.7.0 environment as below:


















After the migration got to succeed, 
Copy the exported bundle file to OAC environment





Import the bundle file as below:



























Restart the OAC suit as below:
Stopping:





















Starting:






































Thursday, July 26, 2018

Apache superset installation and configuration

Installing prerequisites:


Python:





Cryptography:












Virtualenv:


















Setting virtualenv environment:







Activating virtualenv:




Upgrading setup tools:







Installing superset:

















Creating admin user for superset:












Getting error “no module named pandas.core”

Upgrading pandas to resolve the issue:

































Again try to create the admin user:








Upgrading the superset database:










Getting error “ImportError: cannot import name ‘ExtDeprecationWarning”

To resolve this install the prerequisites in the Requirements.txt file as below:

Note: If the file is not there create the file and add the below requisites in it.

Requirements.txt
bleach==2.1.2
boto3==1.4.7
botocore==1.7.48
celery==4.2.0
colorama==0.3.9
cryptography==1.9
flask==0.12.2
flask-appbuilder==1.10.0
flask-caching==1.4.0
flask-compress==1.4.0
flask-migrate==2.1.1
flask-testing==0.7.1
flask-wtf==0.14.2
flower==0.9.2
future==0.16.0
geopy==1.11.0
gunicorn==19.8.0
humanize==0.5.1
idna==2.6
isodate==0.6.0
markdown==2.6.11
pandas==0.23.1
parsedatetime==2.0.0
pathlib2==2.3.0
polyline==1.3.2
pydruid==0.4.4
pyhive==0.5.1
python-dateutil==2.6.1
python-geohash==0.8.5
pyyaml==3.12
requests==2.18.4
simplejson==3.15.0
six==1.11.0
sqlalchemy==1.2.2
sqlalchemy-utils==0.32.21
sqlparse==0.2.4
tableschema==1.1.0
thrift==0.11.0
thrift-sasl==0.3.0
unicodecsv==0.14.1
unidecode==1.0.22
contextlib2==0.5.5

















After the requirements installed successfully upgrade superset database again































Loading the default examples:


















Initializing the superset:














Starting the superset server:














Accessing superset console:














































The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

When trying to login essl time tracker getting below error
















Resolution:

Open command as administrator and navigate to C:\Windows\Microsoft.NET\Framework64\v2.0.50727






Run the below command
idr64.exe setwow








Try to login Essl again























Wednesday, July 25, 2018

ORA-01031 INSUFFICIENT PRIVILEGES

When trying to connect to the database as sys from command prompt getting the below error







The issue is due to the password file got corrupted
Creating a new password file will resolve the issue
Back up the password file under ORACLE_HOME/database (PWDorcl.ora)









Create new password file with the command below:

Note: set the ORACLE_HOME, ORACLE_SID and PATH variables 
before running the below command



Try to connect again







  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...