Xcode crash when refreshing provisioning profiles

Question

Remove this file:

~/Library/Developer/Xcode/connect1.apple.com 4.6.1.db

before running Xcode 4.6.1.

Here is apple's official workaround:

Run this command in terminal:

mkdir ~/Library/Developer/Xcode/OldPortalDBs; mv ~/Library/Developer/Xcode/connect1.apple.com* ~/Library/Developer/Xcode/OldPortalDBs

Worked like a charm for me.

Someone had this problem at NSCoder Night this week. Cleared by removing:

~/Library/Caches/com.apple.dt.Xcode.

sqlite3 ~/Library/Caches/com.apple.dt.Xcode/PortalData/connect1.apple.com

Shows that file to be an SQLite database, with references to certificates, teams, and profiles. I suspect (but haven't tried) that removing the PortalData folder would be sufficient to clear the error.

Removing this file worked for me.

~/Library/Developer/Xcode/connect1.apple.com 4.6.1.db

Thanks!