Occasional Visitor
Posts: 1
Registered: ‎05-09-2018

Failure of Facebook Campaign Solution - Throwing Errors and No Longer Syncing

The Facebook Campaign Solution has been throwing errors for me since May 1, and finally stopped inserting records in my Azure SQL instance on Monday night (May 7). I've tried everything I can think of, including syncing/redeploying from git. Eventually I started from scratch, linking the page and instantiating a new Azure SQL instance, still not working.


I'm getting the same error on both instances of the solution/database when a message is added to the history queue and the Process routine fires:


System.Exception: {"error":{"message":"(#100) The value must be a valid insights metric","type":"OAuthException","code":100,"fbtrace_id":"Hm\/5N5w7qeO"}}

at FacebookUtillity.FacebookUtility.<GetPageMetricAnalytics>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at FacebookUtillity.PageAnalyticsETL.<PopulateMeasures>d__0.MoveNext()


Any assistance would be greatly appreciated.