Automic Workload Automation

 View Only
Expand all | Collapse all

Bug in AWI 12.3.2.hf2 using SQL Jobs

  • 1.  Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 10, 2020 09:17 AM
    Hi all,

    JFYI: a user reported a possible bug in AWI

    there seems to be a bug in latest AWI Version 12.3.2.hf2 - if you edit SQL Jobs using forms view in process tab - this may mismatch the order of commands within SQL Job.

    If you save the jobs its broken, editing only (without save) does no harm.

    KR Wolfgang


    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------


  • 2.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 10, 2020 09:46 AM
    Wolfgang, long time friend​,

    do you know: can the user at least revert to an old version if that happens?

    Thanks!


  • 3.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 10, 2020 10:11 AM
    Hoi Carsten,

    sry - we did not test this - just reverted to 12.3.1 AWI....

    cheers, Wolfgang

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------



  • 4.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 10, 2020 10:56 AM
    managed to open a ticket at support :-)

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------



  • 5.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 10, 2020 11:20 AM
    ​The opening is rarely the issue ;)


  • 6.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 04:52 AM
    Edited by Michael A. Lowry Jun 11, 2020 04:52 AM

    According to the fix list, AWI 12.3.2 HF2 includes only one change:

    20260457 - Objects remain opened/locked after pressing "Discard & Close"
    A problem has been solved where, after opening and editing an object BUT rejecting the changes by pressing the "Discard & Close" option, the object still remained as opened and locked.

    We would appreciate it if someone from Broadcom would provide details on the SQL job bug as soon as possible. In particular, we need to know if AWI 12.3.2 is also impacted by this bug.




  • 7.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 09:35 AM
    Edited by Michael A. Lowry Jun 11, 2020 10:11 AM
    We will open a support ticket for this. Without a hotfix for this, we may have to postpone our upgrade.


  • 8.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 10:25 AM
    Edited by Michael A. Lowry Jun 15, 2020 05:16 AM
    We just opened support case 32019255 about this bug. We will ask for a hotfix for v12.3.2.


  • 9.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 10:16 AM
    If you're specifically talking about the SQL or PeopleSoft job bugs of it being out of order, yes, the AWI v12.3.2.hf2 still has the bug.  We downgraded a sandbox AWI to v12.3.1 so that our PeopleSoft group is able still develop their processes.


  • 10.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 06:26 AM
    We were made aware of this just days before we upgraded our production system this past Sunday.  This impacts PeopleSoft and I believe SAP jobs too, though we only have SQL and PeopleSoft in our environment.  While I went forward with the upgrade since our non-production system was already upgraded, we are working around this for the few impacted by having a separate v12.3.1 AWI.  The rest are still using the v12.3.2 AWI since there are some other annoying bugs in the older AWI.


  • 11.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 10:13 AM
    Edited by Franz Zalubil Jun 11, 2020 10:13 AM

    Correct. SAP Jobs are efected in AWI 12.3.2 with same issue too. 
    Repsonse to my support case 31892023 was, the issue with SAP Job Forms will be fixed with next SP 12.3.3, what is expected for end of June or early of July.



    ------------------------------
    Managing Consultant EMEA - Enterprise Studio
    HCL Technologies Austria GmbH
    ------------------------------



  • 12.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 11, 2020 10:40 AM
    Edited by Michael A. Lowry Jun 15, 2020 05:28 AM
    I thought we might be able to use the Java User Interface to work around this bug, but unfortunately this will not be possible. Because of another bug related to custom DOCU tabs, it is not possible to save changed objects in the Java User Interface


  • 13.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 15, 2020 03:02 AM
    Hi

    Latest info: Fix version is AWI 12.3.3 (planned release date : 29/06/2020)
    Workaround: use AWI 12.3.1


    not hotfix planned for AWi.

    KB article: https://knowledge.broadcom.com/external/article?articleId=191507

    KR Wolfgang

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------



  • 14.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 15, 2020 04:20 AM
    Edited by Michael A. Lowry Jun 15, 2020 04:33 AM
    This bug is a showstopper for us. There's no practical way we can prevent users from accidentally accidentally and irreversibly corrupting their jobs. I see three options:

    1. Get a hotfix for this bug in 12.3.2.
    2. Use AWI 12.3.1 with AE 12.3.2.
    3. Wait for 12.3.3.

    If it is feasible obviously option #1 would be preferable. There are bug fixes in 12.3.2 that we don't want to do without.

    If option #2 is viable, that might be the next-best option. It would allow us to benefit from other bug fixes in AE 12.3.2 without exposing ourselves to this bug.

    Option #3 is our least-preferred option because it would significantly shorten the amount of time we have for testing before the upgrade.​​​ A shortened testing period increases the likelihood that a new bug would go into production undetected.


  • 15.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 15, 2020 06:52 AM
    Edited by Carsten Schmitz Jun 15, 2020 06:53 AM
    We have 12.3.2 in our test/staging environent and I just replicated the problem, too. The environment is being used for functional verification of jobs ("Abnahmetests") and failures of it can delay projects, so people in management get rather irrate about these things.

    Should we have a true test environment that nobody cries over? Maybe. There's other considerations at play.

    So I just had to write an email and tell everyone to stop editing SAP and SQL jobs.

    The only good news is, version restoration can recover jobs that are now broken. But we all know that has it's limits, there's no versioning for things that move with Transport Case, and transport case is widely utilized in Automic, e.g. for bulk edits.

    At Broadcom I ask, with all due respect:

    How can this not be catched in QA? That parser that parses XML into your forms, I mean, even without access to the source I am of the opinion that this must be an "intricate" bit of software. When a release makes changes affecting it, this needs to be QA'd! Preferably automated, or if nothing else by a student who tests the basic functions, like editing the most common job types, and checks off on them still starting.

    Also @David Ainsworth, can we downgrade? Can we run a 12.3.1 AWI with a 12.3.2 engine, and will that prevent the problem?

    Nevermind, seen it.

    Thanks!


    ------------------------------
    # signature.sh --verbose=[true|false]
    # no configurables beyond this point, only signature

    Using the slide show widget for posting individual images is wrong. Please use the "insert image" button in the editor.

    Did you know? I will NOT respond to PM asking for help unless there's an actual reason to keep the discussion off of the public forums!

    "Efficient Solutions Monthly Magazine" says: These contain very good advise on asking good questions. No, you do not need StackExchange for Automic, but asking questions the right way never hurts:

    http://www.catb.org/~esr/faqs/smart-questions.html

    https://www.chiark.greenend.org.uk/~sgtatham/bugs.html
    ------------------------------



  • 16.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 16, 2020 06:07 AM
    @Carsten Schmitz, did you not already know? We are the QA.. ​


  • 17.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs
    Best Answer

    Broadcom Employee
    Posted Jun 19, 2020 08:43 AM
    Hi all,

    We have just released AWI Version 12.3.2 HF3 which corrects this issue.

    ------------------------------
    Product Manager - Automation
    CA Technologies, A Broadcom Company
    ------------------------------



  • 18.  RE: Bug in AWI 12.3.2.hf2 using SQL Jobs

    Posted Jun 25, 2020 02:18 PM
    Edited by Kenneth Hutchins Jun 25, 2020 02:20 PM
    Thanks for the update. 

    ------------------------------
    DevOps Engineer
    ULLICO
    ------------------------------