TM1 Explorers: Explore, Challenge and Summit with TM1 › Base Camp Forums › TM1 Technical › Turbo Integrator › TurboIntegrator Error Handling
Member27-Aug-21 at 1:27 pm0 Diamonds4 Gold290 ExperienceScout
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?
Administrator27-Aug-21 at 1:57 pm2 Diamonds14 Gold1,440 ExperienceHiker
@Andrew might have some other ideas, but how about you keep doing what you are doing and add a few more steps:
- Map the new elements to a dummy target. That way they will successfully load, but obviously into a temporary target.
- 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.
- 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?
Member29-Aug-21 at 9:12 pm0 Diamonds4 Gold290 ExperienceScout
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!
Administrator29-Aug-21 at 9:21 pm2 Diamonds14 Gold1,440 ExperienceHiker
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