Error while saving as pivot table in datavisualiser for period Fixed Weekly : cannot execute nextval() in a read-only transaction

Support - Assistance technique
1

I’m getting an error which is reproducible in play dhis2 2.39.2 version. Does anyone faced this issue, do you have any workaround?

Steps to reproduce:

  1. Try to create a pivot table in data visualizer with IDSR data elements (since it’s weekly dataset)
  2. Select Period as fixed weekly, select all week of this year
  3. Even if you don’t get any data, try to save this report.
  4. You will get the below error.

image
image1920×1126 116 KB

1 Like
2

Hi @jthomas

I am able to reproduce the issue as you described; however, when I tried in the development versions, this issue is not reproducible so if it’s a bug it’s probably been fixed. See screenshot below:

/
/1693×852 247 KB

Thanks for reporting this though. Hopefully in version 2.39.3 it will not appear.

1 Like
3

Thanks @Gassim Great, Looking forward for 2.39.3. Thanks for this testing in both versions.

1 Like