Hi Everyone,
I have the following error when I try to upload my forms into the ODK Aggregate:
Error: Problem persisting data or accessing data (org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [SELECT _URI, _CREATOR_URI_USER, _CREATION_DATE, _LAST_UPDATE_URI_USER, _LAST_UPDATE_DATE, _MODEL_VERSION, _UI_VERSION, _IS_COMPLETE, _SUBMISSION_DATE, _MARKED_AS_COMPLETE_DATE, GRP2_GRP2A_HIVMEDPREG, HOSPITAL, MOMFNM, GRP2_GRP2A_GRP2B_P1_FREQ, OTH_TRIBE, DEVICEID, GRP1_OTHERNAT, GRP2_LSTTEST, REPORTDATE, GRP2_RESULT, GRP2_GRP2A_GRP2B_OTHER_P3, GRP2_GRP2A_GRP2B_OTHER_P2, GRP1_MOMPHONE, GRP1_OTHERWATER, META_INSTANCE_ID, GRP1_MOMHEIGHT, GRP1_WATER, TRIBE, MOMSNM, GRP1_MOMWEIGHT2, GRP1_MOMWEIGHT1, GRP1_SMOKERS, GRP1_NATIONALITY, GRP2_GRP2A_GRP2B_OTHER_P1, GRP2_GRP2A_GRP2B_OTHER_B1, GRP1_CURLIVE, SIGNED_CONSENT, GRP2_FIRSTTEST, ID_ANCIDNO, GRP1_JOB, GRP1_CHLDNO, GRP1_JOBTYPE, TODAY, GRP1_INCOME, PAPFNM, GRP1_OTHERLIVE, GRP1_MOMMARST, GRP2_GRP2A_GRP2B_P3_FREQ, GRP2_GRP2A_GRP2B_P2_FREQ, CONSENT, PAPSNM, INFO8, INFO7, INFO4, GRP1_SCHLEV, INFO1, GRP2_GRP2A_GRP2B_WHYSMISS, SURVEY_COMPLETED, ID_OTHIDNO, GRP1_OTHERTOILET, GRP2_GRP2A_TRADHLR, EVERTEST, GRP2_GRP2A_GRP2B_MISSHIVMED, GRP1_RMNO, GRP2_GRP2A_GRP2B_B1_FREQ, ID_IPIDNO, ID_ARTIDNO, QCINITIAL1, SURVEY_DECLINE, VILLAGE, GRP1_HSEPPLNO, START, ID_PMTCTIDNO, ID_UNQIDNO, END, GRP2_GRP2A_RESULT2, GRP1_TOILET FROM odk_birthdefects.BIRTH_DEFECTS_CORE WHERE _MARKED_AS_COMPLETE_DATE > ? AND _IS_COMPLETE = ? ORDER BY _MARKED_AS_COMPLETE_DATE ASC , _URI ASC ;]; Packet for query is too large (1508 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1508 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.)
Any thoughts on why I am having this problem and how I can work it out?
Vincent