Find answers, ask questions, and connect with our
community around the world.

  • TurboIntegrator Error Handling

    Posted by Def on 27-Aug-21 at 1:27 pm


    As a technical consultant working mostly in TurboIntegrator, i feel the lack of error handling in TurboIntegrator. Based on my searching, the error handling consist of:

    1. Using itemskip

    2. Using itemreject to send message to the user

    3. Using textoutput to write error

    4. Using default value is the data source is invalid

    I already researched all of error handling above, but I feel that it is not enough.

    The thing is, I want to import data from csv using TurboIntegrator. I am using lookup cube to map the code from data source to account in my model. If the code does not exist in my model, the process will add the code into the dimension of lookup cube. systematically, the code will be added into the lookup cube, but the mapping will be blank.

    My purpose is to create an user friendly error handling based on the result of the process. If the mapping is blank, the system will display only message, not default error from TM1. Apparently, I cannot use available error handling, because:

    1. I cannot skip the non-existent code

    2. Using itemreject is the most preferable option, but how they display the error message is very messy and I don’t think that user wants to see it.

    3. Using textoutput is not preferable in my situation, because my clients consist of non-IT members that cannot access the server.

    Does anyone have any other ideas how to create more user friendly error handling?

    John replied 2 years, 10 months ago 2 Members · 3 Replies
  • 3 Replies
  • John

    27-Aug-21 at 1:57 pm
    2 Diamonds
    14 Gold
    2,210 Experience

    Afternoon Def,

    @Andrew might have some other ideas, but how about you keep doing what you are doing and add a few more steps:

    1. Map the new elements to a dummy target. That way they will successfully load, but obviously into a temporary target.
    2. Send an email from TM1 to someone responsible for mapping advising them of the problem and requesting they update ether mapping from the dummy added in step 1 to the correct target.
    3. Reprocess the text file after the mapping has been corrected.

    This is essentially the process we use with a large client, but we needed to add another step having the mapping entered into another text file that is swept by TM1. This was because the relevant person who is responsible for the mapping doesn’t have a TM1 licence.

    Would that work for you?


    • Def

      29-Aug-21 at 9:12 pm
      0 Diamonds
      4 Gold
      360 Experience

      Dear John,

      thank you for your reply! Using email is indeed appropriate to inform the user about any minor error that happened in the process. I think your solution will work, but I think I will need their permission first about sending the email.

      I personally think that IBM needs to tidy up their error display, though.

      Thank you again for the solution!



  • John

    29-Aug-21 at 9:21 pm
    2 Diamonds
    14 Gold
    2,210 Experience

    I’m glad you think that’ll work for you. Hey let me know if you need a solution to allow sending email from the TM1 server. Cheers, John

Log in to reply.