0
Hi All,

I am now facing a problem to create 500+ main task and sub task on one go in a transition.
But since it involves multiple tables.
1. Main task table
2. Sub task table
3. TS_SUBTASKS
4. TS_NOTIFICATIONEVENTS

(Not to mention data feed in select-query),

it will be obtrusive to run the script in the transition (it is expected to take about more than 80 secs on this with AppScript).


Any idea to workaround this?

Thanks,
Derek
Responses (3)
  • Accepted Answer

    Thursday, August 16 2018, 11:39 PM - #Permalink
    0
    We faced similar problem with an SBM C++ API program. We ended up doing it with SQL, but this had a tremendous learning curve and took 2 very sharp SQL gurus over a year. And it still isn't identical to what the API does. Our application requires thousands of "submits" and "updates" every day. The API approach was taking hours which prevented users from touching the system for half the day. Unacceptable.

    You could try ModScript. It has "QuickSubmitToProject" which might (one would hope) create the proper Change Records. This means you could use regular Notification Rules to create the Notifications/Escalations and might not need to manually create ts_NotificationEvents records. ModScript might have the same overhead penalty as AppScript. Speaking of which, I wonder if Serena ^H^H^H^H MicroFocus has any AppScript vs ModScript performance comparisons they can share ....
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 17 2018, 01:24 AM - #Permalink
    0
    Paul Thompson wrote:

    We faced similar problem with an SBM C++ API program. We ended up doing it with SQL, but this had a tremendous learning curve and took 2 very sharp SQL gurus over a year. And it still isn't identical to what the API does. Our application requires thousands of "submits" and "updates" every day. The API approach was taking hours which prevented users from touching the system for half the day. Unacceptable.

    You could try ModScript. It has "QuickSubmitToProject" which might (one would hope) create the proper Change Records. This means you could use regular Notification Rules to create the Notifications/Escalations and might not need to manually create ts_NotificationEvents records. ModScript might have the same overhead penalty as AppScript. Speaking of which, I wonder if Serena ^H^H^H^H MicroFocus has any AppScript vs ModScript performance comparisons they can share ....

    I think we are on the same pace. We have used this with SQL, but the end result isn't really good and does not really leverage the engine. It lacks many of the features that brought nuisance to the end user and the support. So we try to move back to the internal engine this time.

    sadly ModScript isn't here in my company (the version is a few years behind)
    So probably going Appscript or Orchestration or (?Javascript) is the only solution.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, September 07 2018, 10:24 AM - #Permalink
    0
    One option could possibly be to invoke a ModScript via an asynch web service call. As such, since it was async, the transition that starts the process would be able to complete without waiting for the script to end. The ModScript might still take some time to complete, but the user wouldn't have to sit and wait for the transition they are running to finish. This should be pretty easy to set up in 11.4 as there is a new WebServices entrypoint for executing ModScripts.

    ModScript and AppScript have similar performance.
    Like
    • Paul Thompson
      2 weeks ago
      Along those lines .... another option would be a special transition used to initiate the task/subtask creation process. Use a Notification Rule to detect that transition (and any other conditions) and let the Notification run the AppScript / ModScript. That will happen in the background as well. Be careful with record locks and updating.

      As a side-note, look really hard at why you would prefer sub-tasks over regular posting. Sub-tasks require more work to create and maintain beyond TS_SUBTASKS table. Granted, they do offer some "built-in" functionality that regular POSTed items can't do.
    • Paul Thompson
      2 weeks ago
      [quote]ModScript and AppScript have similar performance[/quote]

      Darn.
    The reply is currently minimized Show
Your Reply

Recent Tweets

RT @TrainingsEdu: Potřebujete získat znalosti o produktu Micro Focus UCMDB, porozumět základním pojmům a aplikacím? Na kurzu Universal CMDB…

by Micro Focus Support