Rational Insight tables: Why would only some Projects migrating records to RIODS, RICALM etc...

 You probably should open a PMR - I am a user of Insight not a developer of Insight - so I am just giving you my own experience with it - sounds like you may have something else going on with your configuration.

 Have you created projects since you downloaded the ETLs form the server(s)?   Each project has an entry in the XDC file as a resource under the resource group.  If you have added projects since you downloaded the ETLs to the Insight server those projects will not be picked up.  Try downloading the ETLs again and see if your projects are picked up.

 As an administrator  if you go under the Reports heading for a particular application there is a Downloads section on the left that you select and configuration files for Rational Reporting Data sources - this will download a zip file for that particular application that contains the xdc files that must be added to the Insight server under <Insight Base>/etl/configs/Configurations.  The xdc files have all the current projects in them and will get the data for each project.  If you add new projects you need to update the xdc files or re download them from the server.  You need to do this for each application you are using (rqm, rtc, rrc)

David, we tried what you told us and we still could not figure out our issue. Would you have time to have a phone meeting with us or should we just open a PMR? Thanks.

Through the PMR we determined that our reporting user did not have sufficient access to read all of the projects.  Those projects it was reading was due to the fact that the projects were configured to have open access to any user.