Skip to Main Content
Merative Ideas Portal

Shape the future of Merative!

We invite you to shape the future of Merative, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Start by posting ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the Merative team to refine your idea

Help Merative prioritize your ideas and requests

The Merative team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at Merative works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at Merative, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.


Merative External Privacy Statement: https://www.merative.com/privacy

Status Future consideration
Created by Guest
Created on Oct 19, 2020

Performance Issue: Attaching 3MB file as case log on an Child Welfare Investigation is taking 18 seconds

Issue: Attaching 3MB file is taking avg 18 sec
Purepath: /Curam/en_US/CaseContactLogWizard_addAttachmentsAction.do
*Steps: *

Create Intake
Create Assessment
Create New Case Log from Contacts tab
Add all the details and attach a 3MB .JPEG file in the attachments page and click on Finish button
On clicking on finish button on case logs pop up, it is taking average of ~15 sec -~18 sec and more than ~25sec most of the times.
Analysis: We observed that the following SQLs are major contributors for the high response times.
If we carefully look into the SQLs, The select SQL is executed 3037 times and there is a Update SQL executed 1013 times and immediately followed by a Delete SQL of 1013 times. Whatever we updated in earlier SQL is getting deleted immediatly.
3,037 × SELECT WIZARDSTATEID,SERIALIZEDSTATE,NEXTWIZARDSTATEID,CREATEDBY,CREATEDON,LASTUPDATEDBY,LASTUPDATEDON FROM WIZARDSTATE WHERE WIZARDSTATEID=?
1,013 × UPDATE WIZARDSTATE SET SERIALIZEDSTATE=?,NEXTWIZARDSTATEID=?,LASTUPDATEDBY=?,LASTUPDATEDON=?, lastWritten = ? WHERE WIZARDSTATEID=?
1,013 × DELETE FROM WIZARDSTATE WHERE WIZARDSTATEID=?
1,011 × INSERT INTO WIZARDSTATE (WIZARDSTATEID,SERIALIZEDSTATE,NEXTWIZARDSTATEID,CREATEDBY,CREATEDON,LASTUPDATEDBY,LASTUPDATEDON, lastWritten) VALUES (?,?,?,?,?,?,?, ?)
Note: 3037 Select SQL = (1013 Update SQL+1013 Delete SQL +1011 Insert SQL)
Please refer attached document for more details on the issue.

Customer Name North Carolina - Dept of Health and Human Services
  • Attach files
  • Guest
    Reply
    |
    Oct 19, 2022

    Merative Team,

    Can you please provide an update on this ticket, if it is being actively considered for any release?

    Thanks,

    Suresh

  • Guest
    Reply
    |
    Nov 2, 2020

    Due to processing by IBM, this request was reassigned to have the following updated attributes:
    Brand - Watson Health
    Product family - Cúram Social Program Management
    Product - Social Program Management Platform
    Component - Functionality
    Source - Other

    For recording keeping, the previous attributes were:
    Brand - Watson Health
    Product family - Cúram Social Program Management
    Product - Child Welfare
    Component - Functionality
    Source -

  • Guest
    Reply
    |
    Nov 2, 2020

    Hi Ratheesh,

    We have reviewed your enhancement suggestion. Based on the information provided, our understanding of your request is as follows:
    Address performance issues in the wizard infrastructure when attaching files.

    The theme is aligned with our current multi-year strategy for our product and we have accepted your suggestion as a consideration for a future release. Not all items under consideration will make it into a release. As plans are confirmed, you will be notified when a specific release includes this enhancement.

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.

    Regards,
    Shane McFadden, SPM Offering Management team
    You can find more information on the request process here.

  • Guest
    Reply
    |
    Oct 20, 2020

    Hi Ratheesh,

    Thank you for taking the time to share your ideas with us. We are committed to involving our users in building our product roadmap and appreciate your suggestions.

    We will review the information you have provided and get back to you within 30 days. If additional details are required in order to complete our evaluation, we will send you a request for more information.

    Thank you,
    Shane McFadden, SPM Offering Management team
    You can find more information on the request process here.