• State Verified Answer
  • Replies 7 replies
  • Subscribers 12 subscribers
  • Views 15109 views
  • Users 0 members are here
Options
Related

Aras losing data

Riaan H
Offline

Hi Team,

I am experiencing a serious problem with my one Aras instance. We are losing data in the system, it is just disappearing without a trace. The user would add data, and then checking the next day, it is gone, without a trace, not even in the history file.

My gut feeling is that transactions in SQL was being rolled back, without being committed. I pulled a report from SQL and there seems to be rollbacks aligned with the data loss.

As part of this Aras instance I am creating a CAD interface in C# .NET. I am exclusively using applyAML() to talk to Aras, I am not using applySQL. Could I be doing something wrong in .NET?

Kind Regards

Riaan

Parents
  • +1 Offline

    Hi Team,

    I have finally discovered the reason for the data loss of one of users of my CAD integration tool.

    For future reference, here is the scenario, that led to it:

    1) A part exists in Aras without CAD.

    2) The user opens the Part in Aras, sees that there is no CAD attached.

    3) He opens the CAD integration tool, which is a C# application.

    4) Loads the file from CAD to Aras, also adding some extra fields, like design notes.

    5) Closes the integration tool.

    6) Goes back to Aras and adds some more stuff to the Part, for example linking a document.

    7) Tomorrow morning opens the Part, and the CAD is missing!

    ...........The issue came that in Step6, he did not refresh the Part in the browser and edited the previous generation of the part, the one before the CAD was added. Aras did not commit the CAD work and he was left with only the Step6 generation of the Part.

    The only solution which I can think of at the moment is user training.

    Such a simple issue that led to a lot of sleepless nights!

  • 0 Offline in reply to Riaan H

    Aras does some checking on the validation for locking in the method: cui_command_lock_item_can_exec

    But this does not pick my scenario up as a problem. I have played around with adding a check in this method, but it is being called multiple times whilst loading a form, so I am leaving that alone for possible performance issues.

    Instead I have added some code in: cui_command_lock_item_execute

    This only gets called just before edit. I am able to catch out-of-date items quite successfully in there, and then handle it.

    I am still doing testing, but it seems to be working.

  • +1 in reply to Riaan H

    Many thanks for sharing your insights! That´s a very interesting scenario that can happen to all of us!

    Out of interest – which Innovator version do you use? Based on the mentioned Method, you seem to use Innovator 14+ , but is it higher or lower than Innovator 23?

    If you are below I23, your described behavior somehow fits to this issue: www.aras.com/.../warning-versioning-and-tab-pane-very-buggy-in-new-innovator-versions-are-you-affected 

    You don´t have to read the full thread. But the main issue I tried to point out was, that old revisions of an item can overwrite the latest one without the user´s knowledge. This behavior in worst case could lead to severe data loss.

    The issue was caused by a corrupted lock behavior and repaired in I23. In your context it sounds somewhat familiar, so I wonder if these two are connected?

     

  • 0 Offline in reply to AngelaIp

    Hi Angela,

    After having a quick look at your Tabs issue, it could be related but I am not sure. But the outcome is the same, a version and therefore data disappears.

    My problem occurred on V2023, the open version.

    You can quickly check it on your own Aras:

    1) Open two independent sessions, with the same part open in both.

    2) Edit the part in Session 1, add a relationship or edit an attribute. Press Done to unlock the part, don't close it.

    4) Edit the same part in Session 2 as well - but don't refresh it. Add some other changes than those in Session 1. Press Done.

    5) Now the magic part.....refresh the part in Session 1......Only the changes in session 2 is recorded. All changes in Session 1 have disappeared.

    Yes, this will lead to great confusion and data loss, because it will seemingly occur at random, and therefore difficult to trace........ask me.

    But a simple script addition is all that is needed to stop it from happening.

    Kind Regards

    Riaan

    .

Reply
  • 0 Offline in reply to AngelaIp

    Hi Angela,

    After having a quick look at your Tabs issue, it could be related but I am not sure. But the outcome is the same, a version and therefore data disappears.

    My problem occurred on V2023, the open version.

    You can quickly check it on your own Aras:

    1) Open two independent sessions, with the same part open in both.

    2) Edit the part in Session 1, add a relationship or edit an attribute. Press Done to unlock the part, don't close it.

    4) Edit the same part in Session 2 as well - but don't refresh it. Add some other changes than those in Session 1. Press Done.

    5) Now the magic part.....refresh the part in Session 1......Only the changes in session 2 is recorded. All changes in Session 1 have disappeared.

    Yes, this will lead to great confusion and data loss, because it will seemingly occur at random, and therefore difficult to trace........ask me.

    But a simple script addition is all that is needed to stop it from happening.

    Kind Regards

    Riaan

    .

Children
No Data