Fixing database errors

Hi everyone,
I ran Averify and it returned few errors; I searched for fixes by Oracle but for those error codes they aren’t available.
Is there a manual of the Oracle database explaining all the columns of all the tables?

Agile User Asked on March 23, 2016 in IT and Networking.
Add Comment
5 Answer(s)

Unfortunately doesn’t exist a documentation for the Agile database.
Oracle doesn’t support the database query directly but you can submit your averify result in OTN in order to find the related fix.

There are several question about perform searches using Agile Database here but you can ask about particular table or columns if necessary. maybe someone has found the means of a table/column before

Agile Angel Answered on March 23, 2016.
Add Comment

Refer to :Mandatory Process To Follow For Opening Averify SRs (Doc ID 1618697.1). Just in case, you missed.

Agile Angel Answered on March 23, 2016.
Add Comment

Thank you,
I suspected such a document wasn’t available 🙁
I opened a SR, hope they can help me.

Agile User Answered on March 23, 2016.
Add Comment

There is a general fix-it script named “adt_generic.sql” (look for adt_generic.zip on the support site). This script will check for and fix most (but not *all*) Averify errors, and it is occasionally updated to include fixes for new issues. Note that it will create backup tables as it fixes things, and so you might end up with a LOT of extra tables in the database. But you can remove those after things have been running for a month or 2 without problems. I wouldn’t be surprised at all that they send it to you in response to your SR.

 And no, there is virtually NO documentation on the Agile schema. Originally they didn’t want to “encourage” customers to try to modify/extract/add/delete data by any means other than the application itself. Given the complexity of the schema, it was a very good thing at the time. But now I think not so much.

 Oh, and look in Averifyscriptstestcases for the script that produced the error (AGIL-00025013 errors are generated by AGIL-00025013.sql). Sometimes (maybe ~30-40%) the script includes a comment on how to fix the issue, or has a remnant (see below) from when Averify could fix things (that is no longer possible because some/most issues are not that simple to fix).

if (:aFixErrors = 1) then  — AGIL-00025040
   aMessage := :aMessage || ‘ Subclass has been set to default ”User Subclass”. Verify this user”s subclass after restarting Agile.  ‘;
   update agileuser set subclass = 11610 where id = csr_rec.id;
end if;

 Then again, let the adt_generic script fix things unless you REALLY understand the error and what it means.

Agile Angel Answered on March 23, 2016.
Add Comment

Thank you very much for all the answers.
I already ran adt_generic.sql, but my errors don’t have fixes.
In the SR they asked me for partial dmp files and I sent them, will see if they’ll solve my issue 🙂

Agile User Answered on March 24, 2016.

Interesting.  Could you post the error codes that adt_generic didn’t fix???

on March 24, 2016.

Sure:
AGIL-00025090
AGIL-00025123
AGIL-00075062
AGIL-00075065

on April 6, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.