Apex Code Development You need to sign in to do that
Don't have an account?
Irene Sless Notification of Errors in API integration upload
We have an integration running hourly from our accounting system to upload data into Salesforce. What I would like to know is, other than manually checking log files, is there an automated way to receive notification if an error occurred, and what the error is?
Currently the only way we can tell is if a user picks up that data which should be in SF isn't there, because they have a document from the accounting system (ie a reference to a quote), and this quote is not in SF (but should be).
Debug logs in SF stop after 20 runs, then one has to refresh, and this can't be reset automatically either, which would be a great thing if it did, as with hourly runs the sync uses up the 20 limit more than once a day!
It would be great if an email could be sent to the Administrator if there were any errors in the sync process. Is this possible to do?
Currently the only way we can tell is if a user picks up that data which should be in SF isn't there, because they have a document from the accounting system (ie a reference to a quote), and this quote is not in SF (but should be).
Debug logs in SF stop after 20 runs, then one has to refresh, and this can't be reset automatically either, which would be a great thing if it did, as with hourly runs the sync uses up the 20 limit more than once a day!
It would be great if an email could be sent to the Administrator if there were any errors in the sync process. Is this possible to do?
This is a classical integration design problem in your integration solution. I am not sure how your integration solution is setup and how it works. But your integration solution should check once a record is pushed to salesforce and if there is an api error or issue, it should create an error in a log file or database and send an email with the error to the admin for notification. It should also send a summary email on how many records were pushed to salesforce , how many failed with error message. Now this can be done in your integration solution as well.
1. Are you using data loader, jitterbit or informatica to push data from acocunting system to salesforce or is this some custom code some body created which runs on your server to push to salesforce?
2. Can you also tell me what is the accounting system you use?
Thanks
Buyan
That is what was hoping to hear :). The integration was outsourced to another company (FuseIT), so we don't control it, but are requesting this from them.
1. No, it's a .NET based app - see http://www.fuseit.com/en/Solutions/SFAccredo.aspx
2. Accredo (http://www.accredo.co.nz/products - we use Saturn)
Thanks!
That is what was hoping to hear :). The integration was outsourced to another company (FuseIT), so we don't control it, but are requesting this from them.
1. No, it's a .NET based app - see http://www.fuseit.com/en/Solutions/SFAccredo.aspx
2. Accredo (http://www.accredo.co.nz/products - we use Saturn)
Thanks!
Thanks for your reply. You should follow up with FuseIt to have them send you a summary email every day on the status of the uploads and failures. Just curious. Are you the salesforce admin for your org and how many users do you have in your org? If my answer solves your question, can you please click like and mark it as solved as well..
Thanks
Buyan
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
<section name="salesforceSync" type="System.Configuration.NameValueSectionHandler" />
<section name="accredo" type="System.Configuration.NameValueSectionHandler" />
<section name="G4S" type="System.Configuration.NameValueSectionHandler" />
</configSections>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<accredo>
<!-- Accredo DB and login -->
<add key="AccredoDB" value="xxxxx" />
<add key="AccredoUser" value="xxxx" />
<add key="AccredoPassword" value="xxxx" />
<add key="AccredoProcessUser" value="xxxxx" />
<add key="StandardPriceBookId" value="xxxxxx" />
</accredo>
<salesforceSync>
<!--These keys store the last time that the Sync was run for an object-->
<!--Format: 30/09/2014 3:17:22 p.m. -->
<add key="SyncTimeCustomer" value="8/05/2015 1:40:28 p.m." />
<add key="SyncTimeContact" value="8/05/2015 1:40:31 p.m." />
<add key="SyncTimeProduct" value="8/05/2015 1:40:37 p.m." />
<add key="SyncTimePriceList" value="5/04/2015 8:53:05 a.m." />
<add key="SyncTimeQuote" value="8/05/2015 1:49:30 p.m." />
<add key="SyncTimeQuoteLine" value="8/05/2015 1:45:04 p.m." />
<add key="SyncTimeInvoice" value="8/05/2015 1:48:00 p.m." />
<add key="SyncTimeInvoiceLine" value="8/05/2015 1:48:04 p.m." />
<add key="SyncTimeOrderEntry" value="8/05/2015 1:45:25 p.m." />
<add key="SyncTimeOrderEntryLine" value="8/05/2015 1:47:55 p.m." />
<!--
Format = "frequency hours~start hour~finish hour"
e.g. 2~7~19 = every 2 hours between 7am and 7pm
24 = every 24 hours, so no finish hour is required
polling of Sync frequencies will occur every hour
-->
<add key="SyncFrequencyCustomer" value="1~7~19" />
<add key="SyncFrequencyContact" value="1~7~19" />
<add key="SyncFrequencyProduct" value="1~7~19" />
<add key="SyncFrequencyPriceList" value="24~8" />
<add key="SyncFrequencyQuote" value="1~7~19" />
<add key="SyncFrequencyOrderEntry" value="1~7~19" />
<add key="SyncFrequencyInvoice" value="1~7~19" />
</salesforceSync>
<G4S>
<add key="LicenseFileLocation" value="D:\AccredoSalesforce\G4S\G4SLicense.lic" />
</G4S>
<connectionStrings>
<add name="G4S" connectionString="G4S:user id=xxxxx;password=xxxxxxxxxxx" />
</connectionStrings>
<log4net>
<appender name="RollingFile" type="log4net.Appender.RollingFileAppender">
<file value="logs/log." />
<PreserveLogFileNameExtension value="true" />
<appendToFile value="true" />
<rollingStyle value="Composite" />
<maxSizeRollBackups value="100" />
<maximumFileSize value="10000KB" />
<staticLogFileName value="false" />
<datePattern value="yyyyMMddhhmmss'.log'" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d %-2p %c - %m%n" />
</layout>
<!--<filter type="log4net.Filter.LoggerMatchFilter">
<loggerToMatch value="FuseIT.G4S.SalesforceConnector" />
<AcceptOnMatch value="false" />
</filter>-->
</appender>
<appender name="TraceAppender" type="log4net.Appender.TraceAppender">
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d - %m%n" />
</layout>
</appender>
<root>
<!-- Use ALL, DEBUG, INFO, WARN, ERROR, FATAL or OFF -->
<priority value="DEBUG" />
<appender-ref ref="TraceAppender" />
<appender-ref ref="FileAppender" />
<appender-ref ref="RollingFile" />
</root>
</log4net>
</configuration>
If this service is running in your server and you guys have access to the folder, you should see
yyyyMMddhhmmss'.log like 200150514xxx.log file. This should have errors in it and this might help you guys to be notified in advance on errors.
Thanks
Buyan
We can create custom code which can check the log files and send an email alert. This would be on the assumption that fuseit logs the error in the file and i understand the log file is cumbersome. Where are you based and is there a good time to talk to you tomorrow? I am in Delaware USA and available between 9 to 12 EST?
Thanks
Buyan