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 comp...
Admin
  • IrinaDragusanu's avatar
    IrinaDragusanu
    12 days ago

    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.

IrinaDragusanu's avatar
IrinaDragusanu
New Contributor III
12 days ago

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
    12 days ago

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

    • MarcusH's avatar
      MarcusH
      Valued Contributor
      12 days ago

      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.

      • IrinaDragusanu's avatar
        IrinaDragusanu
        New Contributor III
        11 days ago

        Yes, this is exactly what happened.

        In regards to the last phrase as a solution, Will this rule run in the background and automatically delete the invalid entries? or does it need to be manually run? Is there any example of bit of code you could help provide please? Thanks in advance.

    • IrinaDragusanu's avatar
      IrinaDragusanu
      New Contributor III
      12 days ago

      My guess is that there could have been something wrong with the template loaded with the rules. I've created it from scratch so I might have missed a coma or something else.