Hi,
I was trying to run Analytics Table, so I got this error “Process failed: StatementCallback; bad SQL grammar [create table analytics_temp_2000 (check (year = 2000), check (pestartdate < '2001-01-01))i…”
please advise how to sort it out.
Hi @Celestine
Welcome to the DHIS2 Community! 
Interesting, do you have data as old as the year 2000?
Could you check the API request that’s failing when the process is running? Before running the Analytics Tables export, open the Network tab (F12) and then run the export so that you’d have an idea of the network requests that are being sent. Once the process fails, see the network request that’s failing and share the error…
Thanks!
Hi @Gassim
This is the network request report when I run the Analytics Tables export
And we do not have data as old as the year 2000
Thanks! What version of DHIS2 are you using? I’m running the Analytics Tables export on play.dhis2.org and I see the API requests are different than yours. I don’t see the “ANALYTICS_TABLE” request… you’ll probably need to upgrade or update if you’re using an older version or patch.
Please update to one of the latest supported versions of DHIS2 - currently, 2.37, 2.38, 2.39 and version 40.