Forum Discussion

IrinaDragusanu's avatar
IrinaDragusanu
New Contributor III
2 months ago
Solved

Lookup Transformational rule UNDO

Hello. I have a set of Lookup Transformational rules. I have tried to load a mass upload for multiple lines of transformational rules through a trx file. I had a message saying the load has been completed with errors. However when I try to search for one rule I can't find it in the set of rules. When I try creating one of them manually it won't let me create it as it says it exists already, even though it doesn't show in the rule set. How can I undo what I did? How can I sort it out. A lot of people are depending of these rule set as it helps with Data extraction. Please support.

  • Hi Chul,

    Thanks for your reply. The above suggestion didn't work. The background is:

    I have loaded a mass trx file to load some transformational rules. I imagine my beginner trx file was broken. It loaded the rules in the background but not showing in the Rules set. We were able to find the imported rules in the Application Database Tables. So we used the Rules IDs to delete them with a custom BR rule. However it is not recommended to use this type of BR rule that deletes the rule IDs from the Data Tables, as it can mess up the system if something goes wrong. Hope it helps.

10 Replies

  • IrinaDragusanu's avatar
    IrinaDragusanu
    New Contributor III

    Hi Chul,

    Thanks for your reply. The above suggestion didn't work. The background is:

    I have loaded a mass trx file to load some transformational rules. I imagine my beginner trx file was broken. It loaded the rules in the background but not showing in the Rules set. We were able to find the imported rules in the Application Database Tables. So we used the Rules IDs to delete them with a custom BR rule. However it is not recommended to use this type of BR rule that deletes the rule IDs from the Data Tables, as it can mess up the system if something goes wrong. Hope it helps.

    • DanielWillis's avatar
      DanielWillis
      Valued Contributor

      Any idea what caused it? Anything funny about the rule?

      • MarcusH's avatar
        MarcusH
        Valued Contributor

        The TRX load process does only very basic checks on the records being loaded. I have had instances where the TRX file is loaded without any errors but the maps do not appear. When I looked at the database table I could see that the record was present but the RuleType was invalid (I think that was it). It isn't a major problem as the users do not maintain the maps and we use the XML format. If it were to become a problem, I would add a Rule to the TransformationEventHandler to delete any invalid map records.

  • chul's avatar
    chul
    Contributor III

    I suggest extracting the existing Rule Group via trx, update that with your adds/changes using a text editor (NOT Excel), then upload it.