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 4 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 10 Jun 2011 6:29 PM

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

  • Posted by
    on 10 Jun 2011 10:23 PM

    It would be nice if this program was supported on Windows 7 Home Premium, it seems kind of silly that Power Pivot works in this OS, but certain addons do not.  Please add Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit  support.

  • Posted by
    on 14 Jun 2011 2:00 AM

    When updating the PowerPivot it gives an error: "Unable to update - The following tables could not be updated: tblTweets - Linked tables might not be updated becuase of conflcting data types or duplicate values in a column....". Now what?

  • Posted by
    on 14 Jun 2011 9:27 AM

    Hi Aaron,

    thanks for adding the PowerPivot issue; a small note please: in my German Excel 2010 version I had also to close and reopen Excel when changing the system's date and time format.

    Regards :-)

  • Posted by
    on 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).

  • Posted by
    on 14 Jun 2011 1:55 PM

    Thank you everyone for your comments and emails. Aaron updated the article with two new known issues. Let us know if you have any more feedback, and thank you again for your comments! You're enabling us to make this list of Known Issues as helpful as possible!

  • Posted by
    on 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.

  • Posted by
    on 20 Jun 2011 1:17 PM

    "Error 1001. InstallUtilLib.dll: Unknown error."

    Every time i try to install

    -Windows 7 Enterprise 64bit

    -Office 2010 32-bit

  • Posted by
    on 5 Jul 2011 3:51 PM

    Hi.  Steve from Chevron here.  When I attempt to run the query from inside my firewall, I get a timeout error.  When I run it outside of our corp network, it runs fine.  Might I inquire as to which port the code is using?  Any other ideas why it would be blocked?

  • Posted by
    on 5 Jul 2011 10:11 PM

    @Steve_Walker  The requests are sent out on the standard http port (i.e. 80).  Here is a sample request: search.twitter.com/search.atom.

  • Posted by
    on 6 Jul 2011 7:17 PM

    Just for reference, I've been running this on Windows 7 Home Premium without issue.

  • Posted by
    on 6 Jul 2011 7:19 PM

    I'm running Windows 7 Home Premium 64-bit with 32-bit Windows without issue.

  • Posted by
    on 14 Jul 2011 4:55 PM

    Has anyone come up with a way to capture the # of Followers of accounts that mention or retweet one's account? Specifically, the # of Followers at the time they send the retweet or mention? Thanks!

  • Posted by
    on 19 Jul 2011 8:43 AM

    Hi there.. Im having a huge problem when trying to update the new data gathered (after search) because PowerPivot buttons appear GRAYED OUT =/ =S so i cant update data at all cuz i cant click on them... any ideas?? im using windows 7 ultimate 32 bit with latest version of twitter analytics & powerpivot as well.

    Thx in advance guys, id´ really appreciate your help, feel free to email me: omegaomega75@hotmail.com or add me to live msn.

  • Posted by
    on 21 Jul 2011 6:31 AM

    When ever I try and run a search excel freezes for a couple of minutes and then throws up a box saying "An Exeption occured while searching: X  Please verify your search query (see Instruction worksheet) and try again.  If the problem persists, etc..."

    Whats all that about then?

Page 1 of 3 (43 items) 123