Event import via API stopping after the 100th record

Hi all,

I just upgraded from version 2.33.3 to 2.34.1.

While bulk importing events via curl and Postman, it is importing the 100th record and after that throwing the following error

{“httpStatus”:“Internal Server Error”,“httpStatusCode”:500,“status”:“ERROR”,“message”:“no transaction is in progress”}

Has anyone faced any such issue? And how did you resolve it.

1 Like

Ahoy @seidhus- I am experiencing the same issue exact issue! There is so little information about it too. I’m on 2.34.1

@Karoline have you seen anything else like this between the community and Jira–I’m going to check now : )

edit: I’ve found nothing. I’ll try and get a Jira ticket written and give instructions on how to reproduce.

Hi @chase.freeman, I have found a workaround. If you wrap the event payload within enrollment, it can accept as many as you like. To be safe I put the orgunit, enrollment and TEI IDs in the enrollment and started the event payload.

But this way, it seems to be slow because it needs to update TEIs and enrollments - which are usually slow before creating/updating the events.

Hope the issue is fixed and we start working the old way.

I had to convert mine to JSON to import more than 100 at a time.

Hi Chase, any update on this, can you share the ticket number to follow up? @Karoline Do you know if this is fixed yet?

@waviles I don’t have any updates as I resolved my issue so I didn’t dig in much further. What version of DHIS2 are you using? I hope this issue would have been resolved in the latest patch updates.

Chase

Thanks Chase, We are in 2.34.1 and trying to upload data using the Bulk Load application (https://apps.dhis2.org/app/ce68be24-22ce-4cfd-98f7-71f4a0155a0f) but it just imports the first 100 records. Maybe worthy try with DHIS2 2.34.2, will upgrade and test to see if it is fixed.

Best

1 Like

@waviles I recommend looking at the 2.34.2 release notes as a first step to see if anything was mentioned about data import and THEN, test via an upgrade.

Edit - I’ve not used that tool before. You can try using our Tools available to the community here: https://baosystems.com/product/dhis2-utility-tools/

Edit Again: I think this is the bug which seems to have been resolved in 2.34.2: https://jira.dhis2.org/browse/DHIS2-9936?jql=text%20~%20"no%20transaction%20is%20in%20progress"

Thank you Chase, yes, that´s exactly what is happening in our instance, from the ticket I see it is not resolved in 2.34.2. I appreciate your help pointing me your tools. I will take some time to test them but from what I read they are awesome!

Best

William

1 Like

Hi @waviles,

The issue has been fixed in the next 2.34 patch release which will be 2.34.3. Release date is TBD but we try to release patch versions of each major release every 2 months so it should hopefully be released within end of the year.

Best regards,
Karoline

1 Like

Thank you @Karoline. Looking forward

Best

1 Like