Automic Continuous Delivery Automation

 View Only
  • 1.  Error during DB reorganization

    Posted Aug 20, 2018 04:03 PM

    In preparation for our upgrade from 12.0.2 to 12.2, we have been walking through the steps in our DEV installation.

     

    During the DB reorg process, we get this error:

    20180820/142323.990 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '1:054.808.629'
    20180820/142323.990 - U00003525 UCUDB: ===> 'delete from AH where AH_idnr in (select DIVDB_PK from DIVDB)'
    20180820/142325.910 - Error: occurred when deleting table 'RH'.
    20180820/142326.424 - U00037107 Error during reorganization of table 'AH'. Program exits with error.
    20180820/142348.619 - U00037022 ABORTING due to error.

    Restart the program when the error cause has been removed.
    20180820/142352.320 - U00037056 Error occurred when exporting tables.
    Please check your Log/Trace file for more details.

     

    I have no idea where to begin troubleshooting this.

     

    Is it really trying to delete the RH table? We had only set the reorg flags on client 0 and have not gotten to the other 3 live clients that on in this installation. It doesn't seem likely that it's actually trying to delete the RH table.

     

    Has anyone seen this error before?

     

    Thanks in advance,

    Bryan



  • 2.  Re: Error during DB reorganization

    Posted Aug 21, 2018 01:32 PM

    Hi BryanKoen608569,

     

    I normally see the delete done during the unload portion...Is that the content in your description from the DB reorg utility logs?  The information there doesn't have a lot of information... One thing you can do is to enable trace for that utility... (Database=4)  as it may give you a little more info. 

     

    I did a search on:

    U00003525 UCUDB: ===> 'delete from AH where AH_idnr in (select DIVDB_PK from DIVDB)'
    U00037107 Error during reorganization of table 'AH'

    and found this Knowledge Article:  ucybdbun: U0037107 Error during reorganization of - CA Knowledge 

     

    Not exactly the same but very seem similar (maybe with traces on, it may give you some other error message... or if you take a look at your current utility logs, see if there any message for integrity constraint or any other error message).



  • 3.  Re: Error during DB reorganization
    Best Answer

    Posted Aug 21, 2018 01:42 PM

    In doing some further investigation within SQL Studio, it seems that one of the preceding transactions had timed out. This caused a problem with the reference constraint on one of the foreign keys:

     

    The DELETE statement conflicted with the REFERENCE constraint "FK_RH_AH". The conflict occurred in database "Automic_AE11", table "dbo.RH", column 'RH_AH_Idnr'

     

    We re-ran the two previous deletes and it has cleared the problem up. We will look at tweaking some of the ini file settings to allow for a longer sleep time and adjust the chunk of records in each pass.

     

    Another question:

    Can the 12.0.5HF2 ucybdbre utility run against the 12.0.2 database, just in case this is a bug in the 12.0.2 version of the utility?



  • 4.  Re: Error during DB reorganization

    Posted Aug 21, 2018 03:59 PM

    Hi BryanKoen608569,

     

    Awesome to hear that you were able to get past the original error.

     

    Normally it is recommended to use the same version utility as the AE - As for using 12.0.5HF2 with AE 12.0.2, I myself have not try that combination but considering that they are both still 12.0.XX version, it should be ok (and I have seen other users run a higher service pack version utility with an older AE and it had worked for them).  Though, I do still recommend giving it a go on a test system in case of any unexpected/unforeseen errors.