Importing from Fogbugz to local instance of YouTrack
I'm trying to import Fogbugz into my local instance of YouTrack but getting the below errors?
Any help would be much appreciated.
This is what I'm getting:
Importing project [ Beam.Repo ]
Creating custom fields in project [ Beam.Repo ]
Traceback (most recent call last):
File "fb2youtrack.py", line 296, in <module>
main()
File "fb2youtrack.py", line 28, in main
fb2youtrack(target_url, target_login, target_password, source_url, source_login, source_password, project_names, max_issue_id)
File "fb2youtrack.py", line 261, in fb2youtrack
lambda bundle, value: _to_yt_subsystem(bundle, value))
File "fb2youtrack.py", line 118, in add_values_to_field
add_field_values_to_bundle(connection, bundle, yt_values)
File "fb2youtrack.py", line 94, in add_field_values_to_bundle
connection.addValueToBundle(bundle, value)
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 778, in addValueToBundle
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 77, in _put
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 54, in _reqXml
response, content = self._req(method, url, body, ignoreStatus)
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 47, in _req
youtrack.YouTrackException: Error for http://forum.jetbrains.com/admin/customfield/ownedFieldBundle/Beam.Repo%20Subsystems2/Domain%5CReference?owner=User1: 400: Bad Request
Any help would be much appreciated.
This is what I'm getting:
Importing project [ Beam.Repo ]
Creating custom fields in project [ Beam.Repo ]
Traceback (most recent call last):
File "fb2youtrack.py", line 296, in <module>
main()
File "fb2youtrack.py", line 28, in main
fb2youtrack(target_url, target_login, target_password, source_url, source_login, source_password, project_names, max_issue_id)
File "fb2youtrack.py", line 261, in fb2youtrack
lambda bundle, value: _to_yt_subsystem(bundle, value))
File "fb2youtrack.py", line 118, in add_values_to_field
add_field_values_to_bundle(connection, bundle, yt_values)
File "fb2youtrack.py", line 94, in add_field_values_to_bundle
connection.addValueToBundle(bundle, value)
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 778, in addValueToBundle
return self._put(request)
return self._reqXml('PUT', url, '<empty/>\n\n')response, content = self._req(method, url, body, ignoreStatus)
File "C:\Temp\Jetbrains\JetBrains2\python\youtrack\connection.py", line 47, in _req
raise youtrack.YouTrackException(url, response, content)
Please sign in to leave a comment.
Answer please few questions:
1. What version of YouTrack do you use?
2. Do you use latest version of python client library?
3. What YouTrack user account do you use while importing?
Thanks for the response,
Details Below:
YouTrack - V4.1.2 (build #5749)
Python Client Library : JetBrains-youtrack-rest-python-library-8698167 (Looks to be the latest)
User Account used for importing: root
Please, show me settings for Area 'Domain\Reference' in project 'Beam.Repo' and profile for User1?
I've attached a screen capture of project "Beam.Repo" with all Area's.
User1 is actually Andrei, I changed the name for anonymity when originally posting.
Thanks again,
Mark
Does Andrei belong to Administrators?
Yes, Andrei is a member of the Administrators group on Fogbugz.
Thanks,
Mark
Was user Andrei created in YouTrack? If no, does his account contain email address?
And it would be great to see full log. If you don't want attach it here you can send it by email youtrack-feedback (at) jetbrains.com.
Andrei's account was imported from fogbugz complete with email address.
I've also sent the full import log via mail if that helps.
Thanks again,
Mark
Please tell me how do you run YouTrack (as jar, war or windows service)?
Do you use Apache/Nginx as frontend?
I installed via the windows installer so I believe its Apache Tomcat being run as a windows service. Just a standard install on a windows 2008 standard server.
The problem is that your Areas names contain backslash (for example, 'Domain\Reference').
By default Tomcat doesn't allow using URLs with backslash.
So, there are two ways to solve this problem.
You can rename Areas and replace backslash with something else.
Or you can setup Tomcat to allow backslashes in URLs.
Here is instruction how to do that for windows service installation:
1.Stop the YouTrack service.
2. In the command line, run:
This will cause Tomcat webserver properties manager to appear in your Windows system tray.
3. Click on the above mentioned manager and select 'Java' tab.
4. Add -Dorg.apache.catalina.connector.CoyoteAdapter.ALLOW_BACKSLASH=true into Java options input.
5. Click OK. This will close the manager (Attention! This feels a bit counter-intuitive, but you really have to close it here)
6. Run the YouTrack service.
And thank you for your patience!
Thanks a million for that as it appears to have worked :)
I now have 98% of our projects migrated across but I did encounter what looks to be a licence restriction when importing one of the last projects. Can you tell me if the below log is considered a restriction or a problem?
Importing project [ Systems Administration ]
Creating custom fields in project [ Systems Administration ]
Importing issues for project [ Systems Administration ]
<?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error><?xml version="1.0" ?><error>Can't change group due to license restrictions</error>Importing issues for project [ Systems Administration ] finished
Importing issue links
<?xml version="1.0" ?><importReport><item imported="false"><error fieldName="source" value="12-306">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-56">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-293">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-327">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="18-312">Value is unknown</error></item><item imported="true"/><item imported="false"><error fieldName="target" value="22-340">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/></importReport>
Importing issue links finished
Thanks again for all the help,
Mark
The message "Can't change group due to license restrictions" means you have reached a limit of users.
Do you use inCloud YouTrack to import issues to? If so, what plan do you use, trial?
What about links, it seems some of issues were not imported.
Could you please download the latest version of the library and try again.
Yesterday I've fixed bug that might cause this problem.
We are using a local “Stand-Alone” instance of YouTrack (10-user pack) so I guess that explains the license restriction bit.
I download the latest version of the library and tried again; this time the only failures listed was “Importing issue links” (details below)
Importing issue links
<?xml version="1.0" ?><importReport><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-56">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-293">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="19-327">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="18-312">Value is unknown</error></item><item imported="true"/><item imported="false"><error fieldName="target" value="22-340">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="25-1036">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/></importReport>
Importing issue links finished
Thanks,
Mark
Please, send me full import log to investigate the problem.
I think the reason is the same as in previous case, but I need to check it.
I just sent you the full import log via mail.
Thanks again,
Mark
Thank you for the log.
As I can see some projects were not imported to YouTrack. For example, project with id 14.
So, YouTrack tries to find issue (for example, "14-278") from this project and fails to create link because the issue doesn't exist. You should import all projects that have links to each other.
That’s strange, I've checked and can confirm I have listed all active projects in fogbugz to be imported, just to be sure I have also undeleted all previous projects and included them in the import script but still get the same error.
Any suggestions?
Importing issue links
<?xml version="1.0" ?><importReport><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="22-340">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="22-340">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="25-1036">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="false"><error fieldName="target" value="14-278">Value is unknown</error></item><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/><item imported="true"/></importReport>
Importing issue links finished
Let's see on project with id=14.
Please check that this project was imported in YouTrack. Can you find mentioned issues in YouTrack? And in FogBugz?
For example, please check issue 14-278.
I've had a look and I believe I have found the missing projects. They are deleted projects in Fogbugz that are still there but not visible unless I undelete them.
I should be able to take it from here but want to say thanks again for all the help :)