Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Engage!
Wiki Ninjas Blog (Announcements)

Wiki Ninjas on Twitter

TechNet Wiki Discussion Forum


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.


, , , , , , , , , , , ,
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 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.

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

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

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

  • 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

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

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

  • 6 Jul 2011 7:17 PM

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

  • 6 Jul 2011 7:19 PM

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

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

Page 1 of 4 (39 items) 1234