I am stuck on an Account Record when adding to Target List

đź’¬ General Discussion
1

When I attempt to add all Account Records from a certain State to my Target List, they always get hung up on a single record (record 62 of 317 on my search results.)

I have attempted to add them in the following ways:

  1. Go to Accounts, Search, Select box, Click on Traingle next to Delete, select action “Add to Target List”
  2. Create Target List, Select Account, Search by Criteria, Click on Traingle next to Delete, select action “Add to Target List”
  3. Native Reports, Build a report with Account fields, and criteria, Click “Add to Target List”
  4. KReporter, Build a report with Account fields, and criteria, Click Integraitons tab, Enable Export for Target List and CSV, Click “Add to Target List” icon.

In all cases, it gets stuck stopped on record 62, record 63 is not included.

Can you please tell me what to look for on the record to correct it so the flow will continue? There is a dash, but other records work with a dash in the account name.

I am worried I have a corrupted record, but prefer to fix it than delete it and deal with orpahan records.

Any help is appreciated!
Thanks,
Bill

2

Is there anything different with the 62nd record? Missing Contact, email, etc.? Have you checked with Christian Knoll info@kreporter.org who manages the product on SF? Permissions of the web directory? What do your logs contain related to the issue? Check php.ini as this can disallow the resources php has for processing data. Run a Quick Repair Rebuild?

Not much, maybe obvious, but I hope some of it helps.

-Nate

3

Thanks this is helpful!

a. I haven’t seen anything viably different with record, will have someone look in the DB today. I’ll check on email etc.
b. Since the problem occurs with all 4 methods above, I don’t think it is anything related to kReporter, but thanks for the support contact!
c. I’ll go check permissions, good idea
d. Do you know what I look for in the Logs? Is there something related to Target List, or Accounts, or is there something that relates to a common “Add to Target List” function?
e. I was thinking that it might be an issue with resources, we had a data load limit issue on our first virtual machine, but when we increased allocated Hardware resources it was resolved. I will check the php.ini file.

Thanks for that tip!

4

Here is what we are finding.

See attachment for debug log.

Here is the observed behavior:

When attempting to add 368 accounts from a report to a target list, sugarcrm processes for about 120-130 seconds, then stops. Watching Linux “top”, the “.php-fpm.bin” app takes 98-99% CPU during this time period, and mysql consumes the other 1-2%.

I don’t understand why this operation should be so processor intensive. It sounds to me like it should be a fairly straight forward database query.

Any ideas?

5

I can’t get the log file to attach. Is there a file size limit? It is 373 KB’s

6

Try pasting the code into the message body for the snippet you want to review. Also have you looked at your web server log? The PHP related errors will be there.

-Nate

7

That’s the difficult part. I don’t think that the php code is throwing an error. I can’t find any meaningful errors in the log. I think that there is some built-in timeout that we’re reaching.

I searched the log for INSERT, UPDATE, target, targetlist, report, and did not find anything interesting