API tools faq
paste
ishanra

odk empty submssion json

ishanra
Apr 12th, 2022
271
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 16.80 KB | None | 0 0
raw download clone embed print report
  1. unsupported operand type(s) for +: 'NoneType' and 'str'
  2. 2022-04-12 12:06:07,461 55966 ERROR odoo12db odoo.sql_db: bad query: INSERT INTO "res_bank" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "country", "execute_method", "name", "type") VALUES (nextval('res_bank_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), true, 233, 'manual', NULL, 'normal') RETURNING id
  3. ERROR: null value in column "name" violates not-null constraint
  4. DETAIL:  Failing row contains (236, null, null, null, null, null, null, 233, null, null, t, null, 1, 2022-04-12 12:05:57.536203, 1, 2022-04-12 12:05:57.536203, null, null, manual, null, normal, null).
  5.  
  6. null value in column "name" violates not-null constraint
  7. DETAIL:  Failing row contains (236, null, null, null, null, null, null, 233, null, null, t, null, 1, 2022-04-12 12:05:57.536203, 1, 2022-04-12 12:05:57.536203, null, null, manual, null, normal, null).
  8.  
  9. local variable 'id' referenced before assignment
  10. local variable 'id' referenced before assignment
  11. local variable 'id' referenced before assignment
  12. local variable 'id' referenced before assignment
  13. local variable 'id' referenced before assignment
  14. local variable 'id' referenced before assignment
  15. local variable 'id' referenced before assignment
  16. local variable 'id' referenced before assignment
  17. local variable 'id' referenced before assignment
  18. local variable 'id' referenced before assignment
  19. local variable 'id' referenced before assignment
  20. local variable 'id' referenced before assignment
  21. local variable 'id' referenced before assignment
  22. local variable 'id' referenced before assignment
  23. local variable 'id' referenced before assignment
  24. local variable 'id' referenced before assignment
  25. local variable 'id' referenced before assignment
  26. local variable 'id' referenced before assignment
  27. local variable 'id' referenced before assignment
  28. local variable 'id' referenced before assignment
  29. local variable 'id' referenced before assignment
  30. local variable 'id' referenced before assignment
  31. local variable 'id' referenced before assignment
  32. local variable 'id' referenced before assignment
  33. local variable 'id' referenced before assignment
  34. local variable 'id' referenced before assignment
  35. local variable 'id' referenced before assignment
  36. local variable 'id' referenced before assignment
  37. local variable 'id' referenced before assignment
  38. local variable 'id' referenced before assignment
  39. local variable 'id' referenced before assignment
  40. local variable 'id' referenced before assignment
  41. local variable 'id' referenced before assignment
  42. local variable 'id' referenced before assignment
  43. local variable 'id' referenced before assignment
  44. local variable 'id' referenced before assignment
  45. local variable 'id' referenced before assignment
  46. local variable 'id' referenced before assignment
  47. local variable 'id' referenced before assignment
  48. local variable 'id' referenced before assignment
  49. local variable 'id' referenced before assignment
  50. local variable 'id' referenced before assignment
  51. local variable 'id' referenced before assignment
  52. local variable 'id' referenced before assignment
  53. local variable 'id' referenced before assignment
  54. local variable 'id' referenced before assignment
  55. local variable 'id' referenced before assignment
  56. local variable 'id' referenced before assignment
  57. local variable 'id' referenced before assignment
  58. local variable 'id' referenced before assignment
  59. local variable 'id' referenced before assignment
  60. local variable 'id' referenced before assignment
  61. local variable 'id' referenced before assignment
  62. local variable 'id' referenced before assignment
  63. local variable 'id' referenced before assignment
  64. local variable 'id' referenced before assignment
  65. local variable 'id' referenced before assignment
  66. local variable 'id' referenced before assignment
  67. local variable 'id' referenced before assignment
  68. local variable 'id' referenced before assignment
  69. local variable 'id' referenced before assignment
  70. local variable 'id' referenced before assignment
  71. local variable 'id' referenced before assignment
  72. local variable 'id' referenced before assignment
  73. local variable 'id' referenced before assignment
  74. local variable 'id' referenced before assignment
  75. local variable 'id' referenced before assignment
  76. local variable 'id' referenced before assignment
  77. local variable 'id' referenced before assignment
  78. local variable 'id' referenced before assignment
  79. local variable 'id' referenced before assignment
  80. local variable 'id' referenced before assignment
  81. local variable 'id' referenced before assignment
  82. local variable 'id' referenced before assignment
  83. local variable 'id' referenced before assignment
  84. local variable 'id' referenced before assignment
  85. local variable 'id' referenced before assignment
  86. local variable 'id' referenced before assignment
  87. local variable 'id' referenced before assignment
  88. local variable 'id' referenced before assignment
  89. local variable 'id' referenced before assignment
  90. local variable 'id' referenced before assignment
  91. local variable 'id' referenced before assignment
  92. local variable 'id' referenced before assignment
  93. local variable 'id' referenced before assignment
  94. local variable 'id' referenced before assignment
  95. local variable 'id' referenced before assignment
  96. local variable 'id' referenced before assignment
  97. local variable 'id' referenced before assignment
  98. local variable 'id' referenced before assignment
  99. local variable 'id' referenced before assignment
  100. local variable 'id' referenced before assignment
  101. local variable 'id' referenced before assignment
  102. local variable 'id' referenced before assignment
  103. local variable 'id' referenced before assignment
  104. local variable 'id' referenced before assignment
  105. local variable 'id' referenced before assignment
  106. local variable 'id' referenced before assignment
  107. local variable 'id' referenced before assignment
  108. local variable 'id' referenced before assignment
  109. local variable 'id' referenced before assignment
  110. local variable 'id' referenced before assignment
  111. local variable 'id' referenced before assignment
  112. local variable 'id' referenced before assignment
  113. local variable 'id' referenced before assignment
  114. local variable 'id' referenced before assignment
  115. local variable 'id' referenced before assignment
  116. local variable 'id' referenced before assignment
  117. local variable 'id' referenced before assignment
  118. local variable 'id' referenced before assignment
  119. local variable 'id' referenced before assignment
  120. local variable 'id' referenced before assignment
  121. local variable 'id' referenced before assignment
  122. local variable 'id' referenced before assignment
  123. local variable 'id' referenced before assignment
  124. local variable 'id' referenced before assignment
  125. local variable 'id' referenced before assignment
  126. local variable 'id' referenced before assignment
  127. local variable 'id' referenced before assignment
  128. local variable 'id' referenced before assignment
  129. local variable 'id' referenced before assignment
  130. local variable 'id' referenced before assignment
  131. local variable 'id' referenced before assignment
  132. local variable 'id' referenced before assignment
  133. local variable 'id' referenced before assignment
  134. local variable 'id' referenced before assignment
  135. local variable 'id' referenced before assignment
  136. local variable 'id' referenced before assignment
  137. local variable 'id' referenced before assignment
  138. local variable 'id' referenced before assignment
  139. local variable 'id' referenced before assignment
  140. local variable 'id' referenced before assignment
  141. local variable 'id' referenced before assignment
  142. local variable 'id' referenced before assignment
  143. local variable 'id' referenced before assignment
  144. local variable 'id' referenced before assignment
  145. local variable 'id' referenced before assignment
  146. local variable 'id' referenced before assignment
  147. local variable 'id' referenced before assignment
  148. local variable 'id' referenced before assignment
  149. local variable 'id' referenced before assignment
  150. local variable 'id' referenced before assignment
  151. local variable 'id' referenced before assignment
  152. local variable 'id' referenced before assignment
  153. local variable 'id' referenced before assignment
  154. local variable 'id' referenced before assignment
  155. local variable 'id' referenced before assignment
  156. local variable 'id' referenced before assignment
  157. local variable 'id' referenced before assignment
  158. local variable 'id' referenced before assignment
  159. local variable 'id' referenced before assignment
  160. local variable 'id' referenced before assignment
  161. local variable 'id' referenced before assignment
  162. local variable 'id' referenced before assignment
  163. local variable 'id' referenced before assignment
  164. local variable 'id' referenced before assignment
  165. local variable 'id' referenced before assignment
  166. local variable 'id' referenced before assignment
  167. local variable 'id' referenced before assignment
  168. local variable 'id' referenced before assignment
  169. local variable 'id' referenced before assignment
  170. local variable 'id' referenced before assignment
  171. local variable 'id' referenced before assignment
  172. local variable 'id' referenced before assignment
  173. local variable 'id' referenced before assignment
  174. local variable 'id' referenced before assignment
  175. local variable 'id' referenced before assignment
  176. local variable 'id' referenced before assignment
  177. local variable 'regd' referenced before assignment
  178. Failed in creating registration!
  179. 2022-04-12 12:06:07,462 55966 ERROR odoo12db odoo.sql_db: bad query: INSERT INTO "odk_submissions" ("id", "create_uid", "create_date", "write_uid", "write_date", "odk_batch_id", "odk_config_id", "odk_submission_id", "regd_creation_status", "submission_date", "submission_response") VALUES (nextval('odk_submissions_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), 'f01bdad5999b4c7796ee10d51d871565', 1, 'uuid:78286c7c-0348-4758-8312-2f571c93487b', false, '2022-03-30T08:52:57.381Z', '{''__id'': ''uuid:78286c7c-0348-4758-8312-2f571c93487b'', ''start'': ''2022-03-30T08:08:33.078Z'', ''end'': None, ''premium_factor'': ''2'', ''premium_g1_val1'': ''2000'', ''premium_g1_val2'': ''5000'', ''premium_g2_val1'': ''5000'', ''premium_g2_val2'': ''5000'', ''premium_g3_val1'': ''5000'', ''premium_g3_val2'': ''7000'', ''premium_g4_val1'': ''7000'', ''premium_g4_val2'': ''7000'', ''premium_g5_val1'': ''7000'', ''premium_g5_val2'': ''10000'', ''premium_g6_val1'': ''10000'', ''premium_g6_val2'': ''13000'', ''premium_g1'': ''2000'', ''premium_g2'': ''5000'', ''premium_g3'': ''5000'', ''premium_g4'': ''7000'', ''premium_g5'': ''7000'', ''premium_g6'': ''10000'', ''premium_total'': ''36000'', ''Regression_and_Progression'': None, ''check_book1'': None, ''check_book2'': None, ''Percentage_of_pupil_with_textbooks'': None, ''chalkboard1'': ''0'', ''chalkboard2'': ''0'', ''lesson_plan1'': ''0'', ''lesson_plan2'': ''0'', ''Classroom_with_adequate_TLM'': ''0'', ''Percentage_of_students_assessed_regularly_by_teacher'': None, ''Percentage_of_teachers_observed_by_head_teacher'': None, ''countif_rate1'': ''0'', ''counta_rate1'': None, ''countif_rate2'': ''0'', ''counta_rate2'': None, ''Percentage_of_students_achieving_grade_level_competency'': None, ''Female_to_male'': None, ''b11_w20'': ''0'', ''b12_w20'': ''0'', ''b13_w20'': ''0'', ''b14_w20'': ''0'', ''b15_w20'': ''0'', ''b21_w40_20'': ''0'', ''b22_w20'': None, ''Total_quality'': None, ''grand_total_le'': None, ''ideal_base_1'': None, ''ideal_b11'': None, ''ideal_b12'': None, ''ideal_b13'': None, ''ideal_b14'': None, ''ideal_b15'': None, ''ideal_b21'': None, ''ideal_b22'': None, ''ideal_base_2'': None, ''ideal_base_31'': None, ''ideal_base_32'': None, ''ideal_base_33'': None, ''ideal_base_34'': None, ''ideal_base_3'': None, ''ideal_total'': None, ''grand_total_factor'': ''8000'', ''grand_total'': None, ''__version__'': ''vSmePscjSZa8i6gGPk7YMQ'', ''__system'': {''submissionDate'': ''2022-03-30T08:52:57.381Z'', ''submitterId'': ''56'', ''submitterName'': ''mbsse'', ''attachmentsPresent'': 0, ''attachmentsExpected'': 0, ''status'': None, ''reviewState'': ''rejected'', ''deviceId'': ''collect:BtX1IodqKgO8JbSF'', ''edits'': 0}, ''group_ey66y74'': {''Enter_Today_s_date'': ''2022-03-30'', ''New_EMIS_Code'': None, ''Region'': None, ''District'': None, ''Council'': None, ''Chiefdom'': None, ''Ward'': None, ''Section'': None, ''Town_Village'': None, ''School_Name'': None, ''School_Ownership'': None, ''Cycle'': None, ''Account_Number'': None, ''Bank_Name'': None, ''BBAN'': None}, ''group_ad9sc65'': {''GPS_Cordinates'': {''type'': ''Point'', ''coordinates'': [-12.1, 8.3, 0], ''properties'': {''accuracy'': 0}}, ''Is_there_a_sign_post_ly_shows_school_name'': None, ''Take_snapshot_of_sch_ly_shows_school_name'': None, ''Head_Teacher_Name'': None, ''Head_Teacher_Mobile_Number'': None, ''Is_the_Head_Teacher_Present'': None, ''Name_of_Respondant'': None, ''Designation_of_Respondant'': None, ''Mobile_Number_of_Respondant'': None, ''Is_the_School_Approved'': None, ''Are_there_students_w_ility_in_this_School'': None, ''Was_there_an_SMC_meeting_this_term'': None, ''Take_picture_of_minu_page_with_the_date'': None, ''was_there_a_staff_me_teacher_performance'': None, ''Take_picture_of_minu_page_with_the_date_001'': None, ''Does_the_School_disp_u_see_this_displayed'': None, ''Take_a_picture_of_the_displayed_summary'': None, ''Does_the_School_have_rrent_year_s_SDP_SIP'': None, ''Take_a_picture_of_SD_page_with_the_date'': None, ''Does_the_school_keep_records_and_receipts'': None, ''Take_a_picture_of_do_page_with_the_date'': None, ''How_does_the_school_ds_received_from_PBF'': None, ''other_funds'': None}, ''group_so6sy88'': {''Enrollment'': None, ''Total_Pupils_enrolled_in_Class_1'': None, ''Total_Pupils_enrolled_in_Class_2'': None, ''Total_Pupils_enrolled_in_Class_3'': None, ''Total_Pupils_enrolled_in_Class_4'': None, ''Total_Pupils_enrolled_in_Class_5'': None, ''Total_Pupils_enrolled_in_Class_6'': None, ''Total_Enrollment_in_this_Level'': None}, ''group_fo2et49'': {''Attendance_in_Class_1_at_time_of_visit'': None, ''Attendance_in_Class_2_at_time_of_visit'': None, ''Attendance_in_Class_3_at_time_of_visit'': None, ''Attendance_in_Class_4_at_time_of_visit'': None, ''Attendance_in_Class_5_at_time_of_visit'': None, ''Attendance_in_Class_6_at_time_of_visit'': None, ''Total_Student_in_Att_ndance_at_the_School'': None, ''Total_Teachers_emplo_teach_in_this_School'': None, ''Number_of_teachers_f_ooms_physical_count'': None, ''Enumerator_Now_ask_Signed_FEEDBACK_FORM'': None, ''Enumerator_Now_coun_by_the_head_teacher'': None, ''How_many_dated_and_s_forms_did_you_count'': None, ''Do_a_headcount_of_te_d_on_school_premises'': None, ''Percentage_of_teachers_found_teaching'': None, ''Percentage_of_teachers_observed_by_the_head_teacher'': None}, ''group_tl6wr26'': {''class_1'': None, ''How_many_people_are_resent_in_this_class'': None, ''Are_you_sure_you_cou_present_in_the_Class'': None, ''Number_of_Pupils_wit_in_first_class_room'': None, ''Please_take_a_Photo_Books_in_this_Class'': None, ''How_many_Pupils_did_se_Books_Pen_Pencil'': None, ''Enumerator_Now_look_lk_in_the_Class_Room'': None, ''Did_you_See_Chalk_an_rd_in_this_Classroom'': None, ''Enumerator_Now_Ask_His_Her_LESSON_PLAN'': None, ''Did_the_Teacher_show_HIS_HER_Lesson_Plan'': None, ''Enumerator_randomly_n_the_last_two_weeks'': None, ''From_your_Observatio_n_the_last_two_weeks'': None, ''group_tl6wr26'': None, ''good'': None, ''average'': None, ''satisfactory'': None, ''poor'': None, ''How_many_Pupils_are_the_Assessment_with'': None, ''assessment_1_count'': ''0'', ''rate_sum_1'': ''0'', ''boy_count_1'': ''0'', ''girl_count_1'': None, ''Enumerator_Ask_the_y_Selected_Classroom'': None, ''[email protected]'': "Submissions(''uuid%3A78286c7c-0348-4758-8312-2f571c93487b'')/group_tl6wr26/assessment_1"}, ''group_kr5mb36'': {''class_2'': None, ''How_many_Pupils_are_present_this_Class'': None, ''Are_you_sure_you_cou_present_in_the_Class_001'': None, ''Number_of_students_w_s_in_First_Classroom'': None, ''Please_take_a_Photo_Books_in_this_Class_001'': None, ''How_many_Pupils_did_se_Books_Pen_Pencil_001'': None, ''Enumerator_Now_look_lk_in_the_Class_Room_001'': None, ''Did_you_See_Chalk_an_rd_in_this_Classroom_001'': None, ''Enumerator_Now_Ask_His_Her_LESSON_PLAN_001'': None, ''Did_the_Teacher_show_HIS_HER_Lesson_Plan_001'': None, ''Enumerator_randomly_n_the_last_two_weeks_001'': None, ''From_your_Observatio_n_the_last_two_weeks_001'': None, ''group_kr5mb36'': None, ''good'': None, ''average'': None, ''satisfactory'': None, ''poor'': None, ''How_many_Pupils_are_the_Assessment_with_2'': None, ''assessment_2_count'': ''0'', ''rate_sum_2'': ''0'', ''boy_count_2'': ''0'', ''girl_count_2'': None, ''Enumerator_Ask_the_y_Selected_Classroom'': None, ''[email protected]'': "Submissions(''uuid%3A78286c7c-0348-4758-8312-2f571c93487b'')/group_kr5mb36/assessment_2"}, ''group_c_equity'': {''poor_community'': None, ''c1_w67'': ''0'', ''c2_w10'': ''0'', ''c3_w20'': ''0'', ''c4_w3'': ''0'', ''total_equity'': ''0''}, ''meta'': {''instanceID'': ''uuid:78286c7c-0348-4758-8312-2f571c93487b''}, ''odk_batch_id'': ''f01bdad5999b4c7796ee10d51d871565''}') RETURNING id
  180.  
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!