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.




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.


Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 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?

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

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

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

  • 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??

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

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

  • 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
  • Ed Price - MSFT edited Revision 5. Comment: Missing "to"

  • 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.

  • 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?

  • 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 :-)

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

  • 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!

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

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

    Every time i try to install

    -Windows 7 Enterprise 64bit

    -Office 2010 32-bit

  • 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?

  • @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.

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

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

  • 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!

  • 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.

  • 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