Body: <p>I keep attempting to validate a batch data entry and keep receiving this error message:</p>
  <p>&quot;Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: unknown error
  Return to home page.&quot;</p>
  <p>Has anyone had this happen to them? Any help would be appreciated!</p>
  <p>Edits: Here is the error message in full
  ml/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace()</p>
  <h1>1 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))</h1>
  <h1>2 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR_Error-&gt;__construct(&quot;DB Error: unknown error&quot;, -1, 16, (Array:2), &quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;)</h1>
  <h1>3 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error-&gt;__construct(-1, 16, (Array:2), &quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;)</h1>
  <h1>4 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR-&gt;_raiseError(Object(DB_mysqli), NULL, -1, 16, (Array:2), &quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;, &quot;DB_Error&quot;, TRUE)</h1>
  <h1>5 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR-&gt;__call(&quot;raiseError&quot;, (Array:7))</h1>
  <h1>6 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB_common-&gt;raiseError(-1, NULL, NULL, &quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;, &quot;1205 ** Lock wait timeout exceeded; try restarting transaction&quot;)</h1>
  <h1>7 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB_mysqli-&gt;mysqliRaiseError()</h1>
  <h1>8 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysqli-&gt;simpleQuery(&quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;)</h1>
  <h1>9 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB_common-&gt;query(&quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;)</h1>
  <h1>10 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1040): DB_DataObject-&gt;_query(&quot;INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_in...&quot;)</h1>
  <h1>11 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(572): DB_DataObject-&gt;insert()</h1>
  <h1>12 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(231): CRM_Core_DAO-&gt;save()</h1>
  <h1>13 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(502): CRM_Contribute_BAO_Contribution::add((Array:29), (Array:0))</h1>
  <h1>14 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Batch/Form/Entry.php(566): CRM_Contribute_BAO_Contribution::create((Array:29))</h1>
  <h1>15 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Batch/Form/Entry.php(427): CRM_Batch_Form_Entry-&gt;processContribution((Array:11))</h1>
  <h1>16 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(490): CRM_Batch_Form_Entry-&gt;postProcess()</h1>
  <h1>17 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(169): CRM_Core_Form-&gt;mainProcess()</h1>
  <h1>18 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(136): CRM_Core_QuickForm_Action_Upload-&gt;realPerform(Object(CRM_Batch_Form_Entry), &quot;upload&quot;)</h1>
  <h1>19 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Upload-&gt;perform(Object(CRM_Batch_Form_Entry), &quot;upload&quot;)</h1>
  <h1>20 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Batch_Form_Entry), &quot;upload&quot;)</h1>
  <h1>21 /home/mrg/public_html/wp-content/plugins/extensions/biz.jmaconsulting.grantapplications/CRM/Core/Controller.php(351): HTML_QuickForm_Page-&gt;handle(&quot;upload&quot;)</h1>
  <h1>22 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(114): CRM_Core_Controller-&gt;run()</h1>
  <h1>23 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(284): CRM_Utils_Wrapper-&gt;run(&quot;CRM_Batch_Form_Entry&quot;, NULL, (Array:0))</h1>
  <h1>24 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:12))</h1>
  <h1>25 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))</h1>
  <h1>26 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm.php(1392): CRM_Core_Invoke::invoke((Array:3))</h1>
  <h1>27 /home/mrg/public_html/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress-&gt;invoke(&quot;&quot;)</h1>
  <h1>28 /home/mrg/public_html/wp-includes/class-wp-hook.php(310): WP_Hook-&gt;apply_filters(&quot;&quot;, (Array:1))</h1>
  <h1>29 /home/mrg/public_html/wp-includes/plugin.php(465): WP_Hook-&gt;do_action((Array:1))</h1>
  <h1>30 /home/mrg/public_html/wp-admin/admin.php(253): do_action(&quot;toplevel_page_CiviCRM&quot;)</h1>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-16T00:08:07.497Z
Comments.Text: Can you locate the log file (see https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories) and edit your question to include the fuller error message listed in the log file?
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-16T00:33:40.807Z
Comments.Text: The directions to locate the log file aren't very clear to me.
Comments.UserDisplayName: Jude Perez
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-16T00:41:41.823Z
Comments.Text: Ok you can try turning on the debug settings as described at https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#using-the-built-in-debugging-tools, and then do the batch validate, and you should see the full errors on the screen. Then make sure to turn off the setting after.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-25T18:31:15.480Z
Comments.Text: Thanks! The error code is too long to fit into these comments but here's the first: ml/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace()
  #1 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))
  
  There were over 25 lines of error messages.
Comments.UserDisplayName: Jude Perez
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-25T18:32:55.227Z
Comments.Text: If you edit the original question it might paste better.
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-25T19:08:24.233Z
Comments.Text: It's a database lock timeout but it's not obvious why. Two things you can try: 1. Temporarily disable the Grant Applications extension and see if that fixes it. 2. If you're on a recent version there's a setting in civicrm.settings.php that might help: `define('CIVICRM_SUPPORT_MULTIPLE_LOCKS', TRUE);`
Comments.UserDisplayName: Demerit
Tags: <contributions><batches>
Title: Error Message when trying to validate Batch data entry
ThreadText: # Error Message when trying to validate Batch data entry
  
  (Asked by: username_0 on 2019-07-15)
  
  I keep attempting to validate a batch data entry and keep receiving this error message:
  
  "Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: unknown error
  Return to home page."
  
  Has anyone had this happen to them? Any help would be appreciated!
  
  Edits: Here is the error message in full
  ml/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM\_Core\_Error::backtrace()
  
  # 1 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM\_Core\_Error::handle(Object(DB\_Error))
  
  # 2 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB.php(985): PEAR\_Error->\_\_construct("DB Error: unknown error", -1, 16, (Array:2), "INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...")
  
  # 3 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB\_Error->\_\_construct(-1, 16, (Array:2), "INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...")
  
  # 4 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->\_raiseError(Object(DB\_mysqli), NULL, -1, 16, (Array:2), "INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...", "DB\_Error", TRUE)
  
  # 5 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1907): PEAR->\_\_call("raiseError", (Array:7))
  
  # 6 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(933): DB\_common->raiseError(-1, NULL, NULL, "INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...", "1205 \*\* Lock wait timeout exceeded; try restarting transaction")
  
  # 7 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/mysqli.php(403): DB\_mysqli->mysqliRaiseError()
  
  # 8 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB\_mysqli->simpleQuery("INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...")
  
  # 9 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2415): DB\_common->query("INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...")
  
  # 10 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1040): DB\_DataObject->\_query("INSERT INTO civicrm\_contribution (contact\_id , financial\_type\_id , payment\_in...")
  
  # 11 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(572): DB\_DataObject->insert()
  
  # 12 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(231): CRM\_Core\_DAO->save()
  
  # 13 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(502): CRM\_Contribute\_BAO\_Contribution::add((Array:29), (Array:0))
  
  # 14 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Batch/Form/Entry.php(566): CRM\_Contribute\_BAO\_Contribution::create((Array:29))
  
  # 15 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Batch/Form/Entry.php(427): CRM\_Batch\_Form\_Entry->processContribution((Array:11))
  
  # 16 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(490): CRM\_Batch\_Form\_Entry->postProcess()
  
  # 17 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(169): CRM\_Core\_Form->mainProcess()
  
  # 18 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Upload.php(136): CRM\_Core\_QuickForm\_Action\_Upload->realPerform(Object(CRM\_Batch\_Form\_Entry), "upload")
  
  # 19 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM\_Core\_QuickForm\_Action\_Upload->perform(Object(CRM\_Batch\_Form\_Entry), "upload")
  
  # 20 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML\_QuickForm\_Controller->handle(Object(CRM\_Batch\_Form\_Entry), "upload")
  
  # 21 /home/mrg/public\_html/wp-content/plugins/extensions/biz.jmaconsulting.grantapplications/CRM/Core/Controller.php(351): HTML\_QuickForm\_Page->handle("upload")
  
  # 22 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(114): CRM\_Core\_Controller->run()
  
  # 23 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(284): CRM\_Utils\_Wrapper->run("CRM\_Batch\_Form\_Entry", NULL, (Array:0))
  
  # 24 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(85): CRM\_Core\_Invoke::runItem((Array:12))
  
  # 25 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM\_Core\_Invoke::\_invoke((Array:3))
  
  # 26 /home/mrg/public\_html/wp-content/plugins/civicrm/civicrm.php(1392): CRM\_Core\_Invoke::invoke((Array:3))
  
  # 27 /home/mrg/public\_html/wp-includes/class-wp-hook.php(286): CiviCRM\_For\_WordPress->invoke("")
  
  # 28 /home/mrg/public\_html/wp-includes/class-wp-hook.php(310): WP\_Hook->apply\_filters("", (Array:1))
  
  # 29 /home/mrg/public\_html/wp-includes/plugin.php(465): WP\_Hook->do\_action((Array:1))
  
  # 30 /home/mrg/public\_html/wp-admin/admin.php(253): do\_action("toplevel\_page\_CiviCRM")
  
  **Tags:** contributions, batches
  
  > **Comments:**
  > **username_1**: Can you locate the log file (see https://civicrm.stackexchange.com/questions/15931/where-are-the-configandlog-and-templates-c-directories) and edit your question to include the fuller error message listed in the log file?  
  > **username_0**: The directions to locate the log file aren't very clear to me.  
  > **username_1**: Ok you can try turning on the debug settings as described at https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#using-the-built-in-debugging-tools, and then do the batch validate, and you should see the full errors on the screen. Then make sure to turn off the setting after.  
  > **username_0**: Thanks! The error code is too long to fit into these comments but here's the first: ml/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace() #1 /home/mrg/public_html/wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::handle(Object(DB_Error))  There were over 25 lines of error messages.  
  > **username_1**: If you edit the original question it might paste better.  
  > **username_1**: It's a database lock timeout but it's not obvious why. Two things you can try: 1. Temporarily disable the Grant Applications extension and see if that fixes it. 2. If you're on a recent version there's a setting in civicrm.settings.php that might help: `define('CIVICRM_SUPPORT_MULTIPLE_LOCKS', TRUE);`  
  
  ---
  
  ## 0 answers
  
  