Common Errors and FAQs
Common Error: Table or Object Not Found
You might encounter an error like:
- "Phase Group for HQ Company X not found!"
- "Job not on file!"
This typically happens when syncing a specific record (e.g., a Subcontract or Job).
Context
The error occurs because a Security Group is restricting access to the table or view required for the sync operation. These restrictions are often in place to protect sensitive data.
Agave relies on stored procedures (e.g., to update Subcontracts or create AP Invoices) during data syncs. These procedures need access to specific tables/views, such as HQCO and bJob. If the SQL user created for the integration lacks permission to access these resources, the stored procedure fails, resulting in an error.
Solution
To resolve this issue, add the SQL user created for the integration (e.g., "Agave-User") to the Security Group that has access to the required tables:
- bJob
- bPMCO
- bHQCO
- bJCCM
To implement the foregoing:
- Open VA Data Security Setup and press Grid. Note the “Default Security Group” applied to the datatypes “bHQCO” and “bJob”:
- Go to Viewpoint Administration → VA User Profile:
- Search for the System User you added (note, this would be the user you created for authenticating; e.g. “Agave-User-Application”):
- Go to the Security Groups tab and add this user to the Security Group with the appropriate permissions:
- Press Save:
