The bpexpdate command does not delete a tape from NBU, it will however delete the tape from the Media database.
If this command :
bpmedialist -m <media id> gives the result :
Requested media is not assigned to this host in the EMM DB
then this shows that he tape is NOT in the media DB.
Now, we see this message on the bpexpdat command , which suggests this, but you could try the bpmedialist command for fun ...
So, I see you have attempeted to delete the tape, and this gives the confusing result that it cannot delete as it is allocated. Unfortunately , the bpexpdat command suggests otherwise, and I suspect the bpmedialist command will do as well.
From the EMM command, I see there is no assgn time, a tape nomally has this when it is in the media db, and a missing assign time is an indication the tape is not in the media db (there may be exceptions, hence I use the term 'indication').
I don't have a server to hand to compare against, so without this I will suggest two options ...
At first glance, it looks like the db has got confused, my VERY VERY STRONG RECOMENDATION is 1.
1. Log a call with Symantec. I would expect the engineer to get to dump of the emm db and look in the tables to see what is up with the tape. It should be possiible then to use maual SQL commands to either fix the entries, or just delete the tape.
I don't recommend 2. because at the sec, I can't test it. I shouldn't mention at all if I have a doubt, but I will do so only as I can mention my concerns.
2. Use the bptm makedbentry option to see if this wil create a new media db entry for the tape ..
bptm -makedbentry -m A00001 -den 4mm -poolnum 1
Only try this if the bpmedialist command shows the tape is not in the media db .
If this works, the bpmedialist command should now work, and you should be able to bpexpdate the tape, then delete it.
Regards,
Martin