Good morning
Please I have upgraded Postgres on my production machine to version 9.5 but there is a problem with running analytics for the (DHIMS) instance.Analytics run up to a stage and it fails.For the other instances its able to run successfully without any Errors.
This is the output of the Error in the Dhims instance :
Process failed: StatementCallback; bad SQL grammar [create table analytics_event_temp_-1_r8cbfnorkzf (“NnDT5gCZWIV” character(11),“c4FZPyewH2T” character(11),“UQ2uRl1W3Uo” character(11),“z55ITiNX4Mq” character(11),“uidlevel1” character(11),“uidlevel2” character(11),“uidlevel3” character(11),“uidlevel4” character(11),“uidlevel5” character(11),“daily” character varying(15),“weekly” character varying(15),“monthly” character varying(15),“bimonthly” character varying(15),“quarterly” character varying(15),“sixmonthly” character varying(15),“sixmonthlyapril” character varying(15),“yearly” character varying(15),“financialapril” character varying(15),“financialjuly” character varying(15),“financialoct” character varying(15),“MDwHGMsu6gg” text,“WNLsSdnHKRF” double precision,“A2vekyGTQ6V” integer,“nuTG5oDYq1h” integer,“QgfEo83eGud” double precision,“hthscpXZskf” double precision,“nMRZ5AFN3Sc” integer,“fU4Qm82nadu” integer,“GMWjDk802dk” double precision,“bujJrvwTeeb” integer,“okyFp1Ayuuz” integer,“lt6mfYf7z7r” integer,“gsygkpBK3kL” integer,“d8ljPVscr2S” integer,“DfzJfTKnr0o” integer,“Onu4LIEdmy3” integer,“UoMleDhUWQ2” integer,“IyalaDef29T” timestamp,“YCqpSEcNXLV” text,“NpfGP6uDDC4” text,“LlNpGmBKYf2” integer,“nuYL3N99QZh” integer,“R0YnFvdVwdX” double precision,“JxeKznhlReD” integer,“VaperHSbt6F” integer,“auCWPadYMcT” integer,“nmwLo6THZWC” text,“I63LrdwqTcR” integer,“lUYKf5V4flp” double precision,“nbMAnj2G6EV” integer,“WJFFJksiyt7” integer,“t04lU9MJhCx” double precision,“QWIBeUxbs0I” integer,“Nl7NOh2aKfN” integer,“m6OO4ot3qkD” integer,“UMqgh7Nfj77” integer,“ZSoft3fV1n2” text,“k4O3uliDBlu” integer,“CUTuqJrCW6A” double precision,“RIDuh05Ht8p” double precision,“HPmbWoidORo” integer,“quWQIr8b5FI” integer,“QU56kvWQR6F” integer,“YQxHNQN8R3x” timestamp,“tfXJYNRNLy1” text,“elenxF40bF4” double precision,“FAsA031g2j1” integer,“dzLlZjQPkmb” integer,“C1jVtURZbyD” integer,“PRsfozXNGBP” text,“kUpqN5rVJ1p” integer,“gGL2jU3DjNx” integer,“amP94vVPGWm” text,“p4K1V1GPI5M” text,“PIe13JIjj6O” integer,“UW1ZbffR1Oq” double precision,“CP0u7S8c6e3” integer,“xL21f2NimzD” integer,“GIbnxlp7YTw” integer,“hIBo8rxuTcB” integer,“QVn6ULdcgsj” double precision,“sQT4KK2YNQO” integer,“oQTnPAOTBBf” integer,“Dp2yLIYLSR6” text,“ATGVxtgo1gk” integer,“TrPIZzy7l2b” integer,“yjcVJx4qTdK” double precision,“zqo1Lje50qo” integer,“DL5Fb9l54wG” integer,“ad4zKsdpyTT” integer,“mUXqNqUrQqn” text,“YOo0PAmkhRO” integer,“dTYKeIuXNO2” integer,“yzqzP3SUOyM” integer,“rMh0u6ShP5T” integer,“Knfh3UiwRRv” double precision,“ajjOCYZJipg” integer,“psi” character(11) not null,“pi” character(11) not null,“ps” character(11) not null,“enrollmentdate” timestamp,“incidentdate” timestamp,“executiondate” timestamp,“duedate” timestamp,“completeddate” timestamp,“longitude” double precision,“latitude” double precision,“ou” character(11) not null,“ouname” character varying(230) not null,“oucode” character varying(50)) with (autovacuum_enabled = false)]; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near “-” Position: 35
2016-07-27 08:04:31Creating analytics tables
Process failed: StatementCallback; bad SQL grammar [create table analytics_event_temp_-1_r8cbfnorkzf (“NnDT5gCZWIV” character(11),“c4FZPyewH2T” character(11),"UQ2uRl1W3Uo”
Can someone please help me out.
Regards
Tony.