How do I update my Resource table on 2.34, It throws up SQL error (see attached file for error log details)

Support - Assistance technique
1

I need help, Our resource table under data analytics does not update. it throws an error " Process failed: StatementCallback; bad SQL grammar [create table categorystructure_temp (categoryoptioncomboid bigint not null, categoryoptioncomboname varchar(255), “Newly enrolled on ART/Previously enrolled on ART” varchar(230), “jLMHovzuGcC” character(11), “Declined HIV Test” varchar(230), “DGGM3JRLLi2” character(11), “Stand alone/Gender/(1-4/5-9/10-14/15-19/20-24/25-” varchar(230), “h7cJZv14qGY” character(11), “(<10/10-14/15-19/20-24/25-29/30-34/35-39/40-44/45” varchar(230), “tEcVnCJSj40” character(11), “(<1/1-4/5-9/10-14/15-19/20-24/25-29/30-34/35-39/4” varchar(230), “L9mo9oSDwua” character(11), “Facility/Community” varchar(230), “YzwviLPoTgi” character(11), “(0-9/10-14/15-19/20-24/25-29/30-34/35-39/40-44/45” varchar(230), “YMwjO7sF87M” character(11), “(1-4/5-9/10-14/15-19)” varchar(230), “wcHgFzdZjGA” character(11), “(<1/1-4/5-9/10-14/15-19/20-24/25-49/50+)” varchar(230), “Jy6nZOBP7s1” character(11), “(1-4/5-9/10-14/15-19/20-24/25-29/30-34/35-39/40-4” varchar(230), “CqINRH8m0ey” character(11), “(10-14/15-19/20-24/25-29/30-34/35-39/40-44/45-49/” varchar(230), “OBDxnfGRsJx” character(11), “(15-19/20-24/25-29/30-34/35-39/40-44/45-49/50+)” varchar(230), “oCXkgXePeDI” character(11), “(5-19/20-24/25-29/30-34/35-39/40-44/45-49/50+)” varchar(230), “rmPNjKAagIt” character(11), “(<1/1-4/5-9/10-14)” varchar(230), “m1KIKij2URC” character(11), “(<15/>15)” varchar(230), “oiBu2ubOj1T” character(11), “(Paediatric Services/Malnutrition Clinic/Malnutri” varchar(230), “w5KRHURbSoD” character(11), “ANC/(<10/10-14/15-19/20-24/25-29/30-34/35-39/40-4” varchar(230), “vJE20iDaU1F” character(11), “Facility/Outside Facility” varchar(230), “p84AKSzLNPA” character(11), “Gender” varchar(230), “TdJfHLbHlUP” character(11), “In-patient/(Out-patients-Gender/CT site/TB site/F” varchar(230), “XMOs6Z9b5ns” character(11), “In-patient/Gender/(1-4/5-9/10-14/15-19/20-24/25-2” varchar(230), “xHQydjRSVJZ” character(11), “Xpert (with/without sputum AFB)/Sputum AFB ONLY/O” varchar(230), “o9J3GDirIp7” character(11), “Outreach/Gender/Others/(1-4/5-9/10-14/15-19/20-24” varchar(230), “BWEnaqaTIEV” character(11), “Outreach/Pregnant Women/(1-4/5-9/10-14/15-19/20-2” varchar(230), “U6YSJoQe3mH” character(11), “PMTCT HTS/(ANC/L&D/<72hrs)” varchar(230), “CrizWPyZyVy” character(11), “PMTCT HTS/(ANC/L&D/<72hrs)/Age_band” varchar(230), “D3E7qSSnxGH” character(11), “Pos/Neg” varchar(230), “b4owZnME9k2” character(11), “PrEP_HIV Status” varchar(230), “jK25FeTpgQ7” character(11), “Previously HIV+ve in Care” varchar(230), “JkQOjJtXJ1N” character(11), “Site of Delivery (Facility/Outside Facility)” varchar(230), “Qv2preexP9H” character(11), “In-patient/(Out-patients-/CT site/TB site/FP site” varchar(230), “O364wY9pMiq” character(11), “Mode of notification/Dual Approach/ Provider Assi” varchar(230), “RiT4n9yIMTW” character(11), “Negative” varchar(230), “dG0oiz7eN6R” character(11), “Positive” varchar(230), “qK0G49oUJXC” character(11), “Previously HIV+ve in Care/Negative /Positive/Decl” varchar(230), “IEyzsOdl1lp” character(11), "Known Positives/Newly Tested Positives/Negative " varchar(230), “uGWConN5vHi” character(11), "Newly Initiated on ART/Already on ART " varchar(230), “kHW0ANYu9GB” character(11), “(Pregnant/Postpatum)” varchar(230), “crihdSel3bL” character(11), “(OLD_First_time_this_FY/OLD_on_Follow_up_this_FY)” varchar(230), “MWq0nuX1YBG” character(11), “(0-14/>=15)” varchar(230), “r4ABg5cwWZM” character(11), “(Pregnant/Non-Pregnant)” varchar(230), “oa7QAVmaO6U” character(11), “Male” varchar(230), “KHrDMfxn683” character(11), “Female” varchar(230), “AP9QwQoIuSY” character(11), “Pregnancy status” varchar(230), “Huj4TgmEkZ5” character(11), “KP Target Group” varchar(230), “gekxpCRSFgH” character(11), “RECENT_Confirmed By VL” varchar(230), “LykUXT2T6Xa” character(11), “RECENT By Test Result” varchar(230), “x4rFOOIx6QN” character(11), “HTS_RECENT_Age_Disagg” varchar(230), “WnpKAwVh7Yz” character(11), “HTS_RECENT Modalities” varchar(230), “euja8S81MxO” character(11), “(10-14/15-19/20-24)” varchar(230), “xhi0cG7y4KY” character(11), “ARV Bottles” varchar(230), “dF65xCU8omD” character(11), “ARV Drugs” varchar(230), “mSMXr26bqEo” character(11), “(15-19/20-24/25-29/30-34/35-39/40-44/45-49/50-64/” varchar(230), “ZnatAsD13jp” character(11), "CXCA SCRN (Outcome)" varchar(230), “VEaV1XR0brd” character(11), “CXCA_ SCRN (Methods)” varchar(230), “NguYltSBJKc” character(11), “HTS_SELF” varchar(230), “VD3jUEqFSMx” character(11), “(10-14/15-19/20-24/25-29/30-34/35-39/40-44/45-49/” varchar(230), “Smg4TqwlIdN” character(11), “(<1/1-4/5-9/10-14/15-19/20-24/25-29/30-34/35-39/4” varchar(230), “CR22Dx15B6m” character(11), "Pregnant/Breastfeeding " varchar(230), “lY57FOnC3x2” character(11), “(<10/10-14/15-19/20-24/25-29/30-34/35-39/40-44/45” varchar(230), “TRXflR3Ld6F” character(11), “<36weeks/> 36wks of pregnancy” varchar(230), “CNIImfca78P” character(11), “(15-19/20-24/25-29/30-34/35-39/40-44/45-49/50-54/” varchar(230), “fa5VUEv82yU” character(11), primary key (categoryoptioncomboid))]; nested exception is org.postgresql.util.PSQLException: ERROR: column “(<10/10-14/15-19/20-24/25-29/30-34/35-39/40-44/45” specified more than once error"each time we ran it on the systemdhis2 error log.pdf (78.6 KB)

I have attached the log details or you attention and action,

Regdars,
Nnenna

2

I need your help with the question I posted. Somebody should please help me out. I can see data on the data entry page but not on the pivot table. Manual data analytics can run for all parameters except for the Resource table.
@Lars kindly help us.

Thank you

3

Dear Nnenna,
It seems that the problem is related to 2 category option combinations with the same name:
(<10/10-14/15-19/20-24/25-29/30-34/35-39/40-44/45
Perhaps you can try to edit one of them in the Maintenance app so it is different before trying again.
Best regards,
Paul

4

Thanks a lot. I will try it right away