My issue has been RESOLVED!!!
I am posting the solution in case someone had a similar environment and issue.
I setup a tech support call with the Pro Apps team and Gabriel from the team was amazing, helpful and above all patient. He didn't just suggest a solution and drop off. He stayed with me on the phone for two hours until we hit a dead end. At that point, I went and purchased a USB 3.0 Lacie mobile drive to continue with further experiments. Here is the description of the steps:
My environment: I keep my data including the Aperture library on an external Lacie drive (8TB RAID-1 config resulting in 4TB usable storage). I use Superduper 3.2.5 to clone/smartupdate my internal drive as well as data drive to other external drives. For some reasons, I had configured my external drive in "case sensitive" manner.
Solution:
- Per Grabriel, I should repair permissions on my Aperture Library and it is done by copying the file to the internal drive of the Mac. But, that kept failing with an error indicating the "case sensitive" feature of the external Aperture library was causing error with the "non-case sensitive" nature of the Mac OS drive.
- We tried copying the library to another drive that was formatted in ExFAT format, but that was extremely slow as it was a slow USB 2.0 interface and very old drive.
- With the newly purchased 4TB Lacie mobile drive with USB 3.0, formatted in either "non-case sensitive" or ExFAT, it failed with the same error.
- At this point I formatted the new drive in "non-case sensitive" option and then used Superduper to copy the Aperture library to the new drive. It went thru without any problem.
- Now I copied the file from the new Lacie drive to the "picture" folder of the Mac (internal drive).
- Fixed the permissions on the entire internal drive.
- Used the Aperture's tool to Repair Permission, Repair Database and Rebuilt Database - in that sequence.
- Copied the repaired library back to the new Lacie drive.
- Launched Photos App while keeping the "Option" key pressed. Selected the Aperture library from the new Lacie drive.
- Photos took 3 hours to import the library successfully! All my smart albums and tags are still there!!! Goodbye Aperture!
I am adding the links below that Gabriel provided, which I used in my steps.
Resolve issues caused by changing
the permissions of items in your home folder
Get help with Aperture 3