Upgrading the PATRIOT database
10
PATRIOTcompliance Starter Kit
❖
Adding the PATRIOTdbConnection
1
Connect to Jaguar Manager as
jagadmin
.
2
Expand Jaguar Manager | Connection Caches.
3
Right-click PATRIOTdbConnection, choose Connection Cache
Properties.
When the Connection Cache Properties sheet appears, the General tab is
in focus.
4
In the User Name box, change the sa user name to patriotlogin.
5
In the Password box, type password.
6
Click Refresh, then click Ping to test the connection.
7
Click OK to return to Jaguar Manager.
❖
Adding the PortalInterfaceCache connection
1
Right-click PortalInterfaceCache, choose Connection Cache
Properties.
The Connection Cache Properties panel appears.
2
In the User Name box, change the sa user name to portaliflogin.
3
In the Password box, type password.
4
Click Refresh, then click Ping to test the connection.
5
Click OK to return to Jaguar Manager.
❖
Adding the epSearchCache connection
1
Right-click epSearchCache and select Connection Cache Properties.
2
In the User Name box, change the sa user name to epsearchlogin.
3
In the Password box, type password.
4
Click Refresh, then click Ping to test the connection.
5
Click OK to return to Jaguar Manager.
6
Shut down and restart Jaguar Server.
Known issue
Non-sa user connection caches to the PATRIOT database lack the appropriate
authority to retrieve data from ASE sybsecurity database. Granting system
security officer role (sso_role) to the user of patriot database connection
resolves this issue. You must run the following procedure for the Pat Audit
Trail portlet to work properly.
