Hi forum readers,
I have written an interface using CRM API that's retrieving specific records from a view, then sync a creator table. As far as I know, here is no problem as I know of with the script, and all the records are currently retrieved, and creator tables updated.
Every night, a custom schedule runs and calls this script. However, when I looked at account usage log for this schedule, I realized I sometimes get "An internal exception occured" message (see capture “Schedule Log.PNG”)
After I checked if everything was fine, and it was, since the error message was not telling me anything, I modified the custom schedule so I would get an Email with my function result in its body. So far, the script is as follow:
------------------------------------------------------------------------
irec = thisapp.UpdateFromCRM();
sendmail
(
To : "pascal.h.coolen@orange.fr"
From : zoho.adminuserid
Subject : "AUDITCOMIN - Schedule"
Message : "Mise à jour = " + irec + "Enregistrements"
)
------------------------------------------------------------------------
Since 1/1/2011, I received 3 errors as you can see in the screen capture. However, the Emails content shows the right response from the script:
09-Jan-2011 11:30 - Success à (email says “Mise à jour = 0 Enregistrements”)
08-Jan-2011 11:30 - Success
à (email says “Mise à jour = 9 Enregistrements”)
07-Jan-2011 11:30 - Success
à (email says “Mise à jour = 12 Enregistrements”)
06-Jan-2011 11:30 - Success
à (email says “Mise à jour = 5 Enregistrements”)
05-Jan-2011 11:30 - Success
à (email says “Mise à jour = 17 Enregistrements”)
04-Jan-2011 11:30 - Failed - An internal exception occured
à (email says “Mise à jour = 18 Enregistrements”)
03-Jan-2011 11:30 - Failed - An internal exception occured
à (email says “Mise à jour = 2 Enregistrements”)
02-Jan-2011 11:30 - Success
à (email says “Mise à jour = 0 Enregistrements”)
01-Jan-2011 11:30 - Failed - An internal exception occurred
à (email says “Mise à jour = 0 Enregistrements”)
As you can see, there is no relationship between success/failure and the number of records retrieved, whether it is 0 or many. Anyway, it always returns a result, so why does it say internal error sometimes even if the script runs OK ?
I just don’t understand. I hope you will.
Best regards,