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?
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
Refer to :Mandatory Process To Follow For Opening Averify SRs (Doc ID 1618697.1). Just in case, you missed.
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.
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 š