Search This Blog

Monday 12 March 2012

Saving iBots in OBIEE 10g

When we are trying to create the iBots in OBIEE 10g We couldnot save the iBots and we will get the error message like below screenshot.
How to resolve it? Yes. There is a small workaround to be needed to Create and save and schedule a saved request.

Run the cryptotools utility that will update credentialstore.xml file. We also need to update instanceconfig.xml file. These xml files are located under OracleBIData\web\config folder.

Run cryptotools:
Cryptotools utility is located under C:\OracleBI\web\bin folder. Launch
Command prompt by typing 'cmd' in Run.

Go to OracleBI\web\bin folder in command prompt by typing like below:
C:\> cd C:\oracleBI\web\bin

Type following command and hit enter:
C:\oracleBI\web\bin> cryptotools credstore -add -infile C:\OracleBIData\web\config\credentialstore.xml

Enter the following credentials in command prompt to update the credentialstore.xml after we hit enter wit the above command prompt:

Credential Alias: Admin
Username: Administrator
Password: Administrator
Do you want to encrypt the password? y/n (y): y
Passphrase for encryption: secret
Do you want to write the passphrase to the xml? y/n (n): y
Do you want to overwrite it? y/n (y): y

After successful updation of credentialstore.xml file we have to Update the instanceconfig.xml file for the corresponding the changes we did in command prompt.

Open the instanceconfig.xml file with the text editor from the location Drive:\OracleBIData\web\config and  add following line of code in the <ServerInstance> tag and save the file and close it.
<CredentialStorage type="file"
path="C:\OracleBIData\web\config\credentialstore.xml" passphrase="secret"/>
Now Start all the Oracle BI Services or restart all the BI services (OC4J, BI Server, Presentation server) if it is already running.

Services will be restarted. Now Login into the presentation services and go to the oracle BI Delivers and create the iBots and save the same. It will be saved successfully without any error. Now we can create iBots and schedule the same.

Happy blogging!

No comments:

Post a Comment

What is Oracle Database Link and How to create database link (DB Link)

Recent Posts