Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Analytics for Twitter: Known Issues

Analytics for Twitter: Known Issues

Analytics for Twitter: Known Issues

This Wiki article documents some known issues with version 1.3 of Analytics for Twitter. 

Click here to download the latest version of Analytics for Twitter.

Analytics for Twitter is being refreshed for Office 2013.  For updates & status please visit the Analytics for Twitter 2013 wiki.

Table of Contents

Exception while Searching - Twitter API Updated


ISSUE:
During a search query an exception message box appears and states: 
“An exception occurred while searching: @Windows8

Please verify your search query (see Instructions worksheet) and try again.”

CAUSE:
Twitter has updated their API and appears to be rate limiting on the legacy API.

SOLUTION:
Try to perform your search during off peak hours (evening, night, etc).   We are working on a new version that utilizes the new Twitter API.  New versions will be made available here.

"400 Bad Request: The request was invalid." message box


ISSUE:
During a search query an exception message box appears and states: “400 Bad Request: The request was invalid.”

CAUSE:
The search query specified is not supported.

SOLUTION:
Update your search query to conform to one of the supported formats detailed in the “Instructions” worksheet.


"420 Enhance Your Calm ..." message box


ISSUE:
During a search query an exception message box appears and states: “420 Enhance Your Calm: Returned by the Twitter Search API when you are being rate limited.”

CAUSE:
Twitter is temporarily limiting traffic from your machine and/or domain.

SOLUTION:
Wait a few minutes and try again. If the problem persists, try your query on an alternative network.

"PowerPivot for Excel. Unable to Update. The following tables could not be updated: tblTweets" message box


ISSUE:
After clicking the "Update All" function in the PowerPivot ribbon bar, a PowerPivot for Excel message box pops up and states: “Unable to Update. The following tables could not be updated: tblTweets. Linked tables might not bet updated because of conflicting data types or duplicate values in a column. Ensure that the data type of the selected content matches ...”

CAUSE:
PowerPivot does not support importing date columns that are formatted in several international formats (i.e. German, en-NZ, etc).

SOLUTION:
Close Excel, change your PC's date and time format to English/US, reopen the document, and then try again.

Supported Windows Operating Systems


ISSUE:
Why are the only supported operating system versions: Windows 7 Enterprise and Windows 7 Professional?

CAUSE:
Windows 7 Enterprise and Professional were the only operating system versions tested prior to release.

SOLUTION:
Try "Analytics for Twitter" on your Windows OS version and post back and let us know if it worked for you.

Compatibility Issues with PowerPivot CTP3


ISSUE:
A "PowerPivot for Excel" error message specifying "Unable to Update" is presented during a PowerPivot table refresh while using the CTP3 (Beta) version of PowerPivot.

CAUSE:
The CTP3 version of PowerPivot has added rules that invalidate certain relationships defined in the "Analytics for Twitter" solution.

SOLUTION:
Stick with the Released version of PowerPivot (i.e. version 1). It is possible that Microsoft might release an update when the CTP3 PowerPivot version is formally released to the public.


, , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 8 Aug 2013 11:45 PM

    John Broomfield edited Revision 22. Comment: I am playing with the 2010 version. Can you just change the search URL used in your code from this - "search.twitter.com/search.atom " to this - "twitter.com/search to comply with the new API?

  • 2 Sep 2012 12:28 PM

    Richard Mueller edited Revision 19. Comment: Removed carriage return in heading line in HTML

  • 2 Sep 2012 12:27 PM

    Richard Mueller edited Revision 18. Comment: Fixed duplicate <a name> tags in HTML so TOC works

  • 24 May 2012 1:19 PM

    Fernando Lugão Veltem edited Revision 17. Comment: added tags

  • 18 Jan 2012 8:26 AM

    edgarblem edited Revision 15. Comment: I have the same problem about an eception occurs, i think it has to be with th date, how can ia change the date??

  • 14 Jun 2011 2:03 PM

    Ed Price - MSFT edited Revision 12. Comment: I added en-NZ, since a customer mentioned that was also affected by this issue.

  • 14 Jun 2011 1:41 PM

    Ed Price - MSFT edited Revision 8. Comment: Just clarifying that you need to close and reopen Excel (Mourad's point).

  • 10 Jun 2011 6:29 PM

    Ed Price - MSFT edited Revision 5. Comment: Missing "to"

Page 1 of 1 (8 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 8 Aug 2013 11:45 PM

    John Broomfield edited Revision 22. Comment: I am playing with the 2010 version. Can you just change the search URL used in your code from this - "search.twitter.com/search.atom " to this - "twitter.com/search to comply with the new API?

  • Posted by
    on 21 Feb 2013 11:43 AM

    perfecto

  • Posted by
    on 19 Feb 2013 11:20 PM

    Do you have the xls updated for Excel 2013 & latest powerpivot? Clicking twitter search query button keeps spinning on downloading old powerpivot.

  • Posted by
    on 12 Dec 2012 2:37 AM

    Hi Aaron,

    the provided C# source files do not inclue a class called TwitterSearchStatus

    I am currently trying to get the workbook running on Office 2012 and it fails because the check, whether PowerPivot is installed or not, fails

    so i would like to change/adopt that check to Office 2012 and make it run again

    it would be perfect if you could send me the whole VS solution - is this possible?

    kind regards,

    gerhard

  • Posted by
    on 20 Nov 2012 1:13 PM

    Oh and I did notice that the "Exception while searching for X" error, was being caused by our corporate proxy requiring authentication. Odd that PowePivot/Excel doesn't pass in the current user context when going via a proxy.

  • Posted by
    on 20 Nov 2012 1:11 PM

    When I click Update All in the PowerPivot tab, the PowerPivot for Excel window opens and then a command window opens (running c:\Program Files\Microsoft Analysis Services\AS OLEDB\10\SQLDUMPER.EXE) and then I get a Dr Watson "Microsoft PowerPivot Engine has stopped working". "Check online for this problem" returns nothing, but PowerPivot for Excel does pop up the following error box:

    Unable to load the VertiPaq engine.

    ============================

    Error Message:

    ============================

    External component has thrown an exception.

    ============================

    Call Stack:

    ============================

    Server stack trace:

      at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)

      at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)

      at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.MethodInvokeCallBack(String memberName, String dispID, BindingFlags flags, Object[] args, Boolean ignoreRetry)

      at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.HandleMethodInvoke(IMethodCallMessage callMessage)

    Exception rethrown at [0]:

      at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

      at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

      at Microsoft.Office.Interop.Excel.OLEDBConnection.Reconnect()

      at Microsoft.AnalysisServices.Modeler.FieldList.InProcServer.LoadOLEDBConnection(Boolean raiseCompleteEvent)

    ============================

    This is the first time I've tried to run a PowerPivot on my Win7Ent x86 Excel2010 PC, so I'll try a vanila PowerPivot and see what happens.

  • Posted by
    on 17 Oct 2012 7:53 AM

    Any guidance on using this on Windows 8 and Office 2013? I'm setting up a workshop with journalists on Twitter analytics using Excel but it'd be great to have it on the latest MS wave.

  • Posted by
    on 15 Oct 2012 4:01 AM

    For some reason, the imported dates (Pub Date etc) get screwed up in PowerPivot.. a run of results from 8 Oct 2012 to 15 Oct 2012 shows as follows (regardless of whether system is set to US or UK date formatting)

    10 Aug displays instead of 8 Oct

    10 Sept instead of 9 Oct

    10 Oct displays correctly

    10 Nov displays instead of 11 Oct

    10 Dec instead of 12 Oct

    13 Oct - correct

    14 Oct - correct

    15 Oct - correct

  • Posted by
    on 11 Sep 2012 7:04 PM

    Check out Aaron's new temporary workaround for the Twitter API update issue. Thanks!

  • Posted by
    on 7 Sep 2012 11:35 AM

    Everybody, We're looking into these issues. I'll be back to update the article. Thanks!

  • Posted by
    on 6 Sep 2012 2:57 AM

    I'm getting receiving an error An Exception occurred while searching for @whatever

    whenever I search for anything. PowerPivot for SQL Server 2012 on Windows 8 RTM

  • Posted by
    on 3 Sep 2012 1:09 AM

    It doesn't seem to work at this time....Sad

  • Posted by
    on 2 Sep 2012 12:28 PM

    Richard Mueller edited Revision 19. Comment: Removed carriage return in heading line in HTML

  • Posted by
    on 2 Sep 2012 12:27 PM

    Richard Mueller edited Revision 18. Comment: Fixed duplicate <a name> tags in HTML so TOC works

  • Posted by
    on 2 Sep 2012 9:59 AM

    It seems that Twitter is getting serious with its announced API changes as this tool is no longer able to grab any Tweets (It still worked three days ago...).

    Can anybody confirm this?

Page 1 of 3 (43 items) 123