Skip to main content
Question

QB Automation Not Adding All Records

  • October 3, 2019
  • 0 replies
  • 25 views
Automation Purpose:  After adding a Master Record, populate a new table(s) with unique value(s) from a specific Master Record field(s).  New tables have the unique value set as their Key.   This enables the use of a vendor generated CoA based on the Child key, and containing duplicate Parent keys, to be used to populate Parent tables automatically while retaining linkages via Table-to-Table Relationships previously setup in QB.

QB Automation Setup:


Issue:  Not all unique records are being added to corresponding tables.  For instance, there are 29 Orders, 152 Plates, and 1364 QR, CE, and MS unique records verified by Excel.  The total # of unique records for the QR, CE, and MS tables are equivalent to the total # of records in the file.

The following is the result of 5 separate automation instances running to pull unique records into 5 different tables.


No errors are generated during QB Automation.


The original Master Record table is imported via Google Drive from a CSV file.  That import was successful and contains all 1364 records as expected.


This is being run using QB Premiere / Platform.

I suspect I am hitting automation limits, but with no error generated that is hard to verify.  The Order table is being populated as expected, with 29 unique records, but the others are not.  This suggests the issue is not how I programmed the QB Automation.  Subtle variations of the above automation scheme result in slightly different final row counts in the QR, CE, and MS tables.

Would anyone happen to know why all records are not being pulled into the corresponding tables and any potential ways to resolve the issue?



------------------------------
Cheers,

Derek L Buhr
------------------------------
This topic has been closed for replies.

  • DerekLBuhr
  • Author
  • Registered
  • October 3, 2019
CSV file containing data used for this purpose is attached.

------------------------------
Derek L Buhr
------------------------------
Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • October 7, 2019
Hi Derek,

When you do this import and the Automation triggers you may be getting an email indicating you are hitting the Automation threshold for how many Automations can fire at once. That email comes from the Automation service at a different level and doesn't end up in the error logs on the automations since it is a matter of the system restricting you for hitting the limit and not the Automation itself failing. If you check that email inbox for the user who created that Automation you may have an email that can verify if you have run into that limit. My instinct would also be that you are hitting the threshold with that many changes firing off and bulk importing. 

If you can't find that email to verify or not I would suggest reaching out to our Care team and letting them know what you are running into. They can help dig into what is going on directly in your app and also verify is an error is being run into. You can reach our Care team while logging into Quick Base under the ? Icon in the upper right hand corner and selecting Mange Support Case or directly here in the Community by clicking on Support where it appears in the top right corner of the screen.

------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Terms & ConditionsAccessibility statement