After several attempts and looking at all possible issues we have been struggling to get Autoloader Tape Drive up and working. We have a Dell Gold Support for it and hence logged a call with Dell yesterday.
Discussed the whole issue with dell support. The problem seemed to be much more serious than intended. He asked me to open up the top lid of the autoloader. On opening I found that one the tapes was stuck in the tape drive and failed to eject. Thre was nothing that he could do and ordered a replacement of tape drive. Now we are expecting a Dell installation engineer to come and replace the faulty tape drive.