This content has been marked as final. Show 1 reply
It seems like you didnt setup the Administrator user for Saved Result Sets as it mentioned in the Marketing Segmentation Guide.
Here is an extract from the guide:
Setting Up the Web Administrator for Managing Cache and Saved Result Sets
Some queries issued by the segmentation engine require the use of the Execute Physical stored
procedure. These queries include delete statements on the cache, delete statements on the saved
result sets, and insert statements for the cache and saved result set. The Execute Physical stored
procedure must be run by a user with administrator privileges. The administrator user is set up in
the instanceconfig.xml file.
NOTE: The BI Administrator password and login parameters are case sensitive.
To set up the administrative user in the instanceconfig.xml file
1 Open a command shell and navigate to the <OracleBI>/web/bin, where <OracleBI> represents
the root directory of the installation.
2 Execute the following command:
cryptotools credstore -add -infile <OracleBIData>/web/config/credentialstore.xml
3 When prompted, enter the following values:
Credential Alias: admin
Password: <enter Admin password here>
Do you want to encrypt the password? y
Passphrase for encryption: <password >
Do you want to write the passphrase to the xml? n
File "<OracleBIData>/web/config/credentialstore.xml" exists. Do you want to overwrite it? y
4 Open the credentialstore.xml file and verify that the following section has been created:
<sawcs:credential type="usernamePassword" alias=“admin">
<sawcs:username> Administrator </sawcs:username>