View Source

The Connector depends on the u.achieve daemon to provide Degree Audits.

There are two database connections required to successfully produce degree audits for u.select through the Connector via u.achieve, namely:

u.achieve daemon (java program)
Connector

Keep these in mind to minimize degree audit troubleshooting when installing the Connector:

The Connector must interact with the same JOB_QUEUE_xxx tables as the u.achieve daemon.
Degree audits for u.select don't use the STU_xxx tables and therefore those tables don't need to be accessible by the u.achieve daemon and Connector.
For u.achieve audits, you must specify daversion=uachieve in the cas4.properties file.

The database user for the u.achieve daemon (java program) must have:

Select, insert, update and delete on the CURRENT_JOBS and JOB_QUEUE_xxx tables

Select permission on these u.achieve tables

CHART_CATEGORIES
COM
CRS_CONVERT
DPROG
DPROG_REQ
GMASTER
INCLUDE_TEXT
MASTREF
MASTREF_ADDRESS
MASTREF_SEG
REPEAT
REQ_MAIN
REQ_TEXT
REQ_XY
STRING
STRING_CRSE
SUB_REQ
SUB_REQ_AR
SUB_REQ_TEXT
TCA_MASTER
TCA_RULE
TCA_SOURCE
TCA_TARGET

Isolating the Connector from your existing u.achieve audit data

Some schools want to prevent the Connector from accessing the audit data contained in the JOB_QUEUE_xxx tables used by their existing u.achieve server. This is accomplished by:

Creating new JOB_QUEUE_xxx tables
Creating a new u.achieve daemon
Make sure the database user for the Connector has select insert, update and delete on the newly created JOB_QUEUE_xxx tables.
Make sure the database user for the u.achieve daemon has select, insert, update and delete on the newly created JOB_QUEUE_xxx tables as well as select permission on the tables show above.