THIS IS EXCEPTIONALLY CRITICAL FOR ME AND I WOULD APPRECIATE IF YOU CAN HELP ME TO UNDERSTAND WHAT WENT WRONG!
1. Installed JIRA 4.4.4 with ORACLE DB
2. Imported the production XML backup using Restore system option.
3. All issues and users were appearing properly.
4. Installed GreenHopper 5.8.6 version.
5. For some reason, I have opted for Reindex option.
6. None of the issue related to any of the project was available. All filters started showing 0 issues.
ONLY A UNOBVIOUS THING WHICH I REMEMBER AND I DID WAS - I killed tomcat6 service through task manager and started the service again