unable to create selection list

[Joseph_Friess]

I am currently running ver 10 and have some tapes made by ver 9 from another server. I first inventory all 3 tapes and then run a catalog. If prompts and reads all 3 tapes. The final byte count is accurate and I can see all drives , directories and files in the restore selection window.

When I run the restore I receive the error "unable to create selection list" This occurs on any drive or directory.

I have followed the process in Doc ID 279681 3 times which addresses corrupt catalogs.

HELP!

[Simon_Armstrong]

Can you restore the files from these tapes on the original backup exec v9 server?

Can you run a restore of a backup that was originally run on the backup exec v10 server?

I doubt it will help but you can try stopping the BE services, rename the catalog directory, restart the BE services. This will re-create the catalog directory. Run an inventory on all tapes and a catalog again. Then try the restore.

[Joseph_Friess]

I no longer have the Ver 9 server. When it was operational, I was able to restore from the tapes made on it. I can't say that I tried one on this specific tape set. Yes, I can restore a backup from a backup tape made on the ver 10 server.

I may try your suggestion on the catalog directory.

[Joseph_Friess]

I tried renaming the Catalog directory and redoing the inventory and catalog. Same results:unable to create selection list

[Joseph_Friess]

I have turned on logging and have found the follwoing error that occurs when I try to restore and receive the unable to create selection list error:

10/23/05 08:43:42 -1 PRINO Start(565): Object:MD_OBJTYPE_RESOURCE, Call:MID_INSERTOBJECT, Local:yes
10/23/05 08:43:42 -1 SQLLog(566):Database Exception Context:{? = CALL DBO.SAVERESOURCE(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} Error:-536837662: :: -2147217873:The statement has been terminated. :: DB Error Set 0: native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated. :: DB Error Set 1: native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 SQLLog(567):Database Exception Context:Resource Insert Error:-536837662: :: -2147217873:The statement has been terminated. :: DB Error Set 0: native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated. :: DB Error Set 1: native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 Error(6/10): 3621:native=0xe25 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f The statement has been terminated.
10/23/05 08:43:42 -1 Error(6/10): 2601:native=0xa29 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e2f Cannot insert duplicate key row in object 'Resource' with unique index 'uidx_Resource_NameInfo'.
10/23/05 08:43:42 -1 Error(6/10): -536837662:-536837662: :: -2147217873:The statement has been terminated.
10/23/05 08:43:43 -1 PRINO End(565): nRet=e00081e2
10/23/05 08:43:43 09 ScriptMgrBO, ParseServerAndResourceInfo: Failed:0xe00081e2.
10/23/05 08:43:43 -1 Error(9/8): -536837661:The database function to insert failed.

[Simon_Armstrong]

Cool, that tells us a bit more. Check out this link:

http://seer.support.veritas.com/docs/253911.htm

I know it's for v9.0, but maybe there's the same issue with v10????

[Christian_Borth]

Hi,
You got exactly the same problem I had a week ago!

http://forums.veritas.com/discussions/thread.jspa?threadID=54513&tstart=285

The difference is that you got response to your question ;)

As you can read from the link above, I solved the problem by upgrading to BE 10d! Maybe that will work for you too!

FYI! I tried the same solutions posted here, they did not solve the problem!!Message was edited by:
Christian Borthen

[Joseph_Friess]

Thanks for responding.

I am already at Ver 10. the tape I am trying to restore is from Ver 9.0

[Christian_Borth]

What version of 10 are you running?

I had problems restoring v8.6 tapes on my v10 build 5520. When I upgraded to v10d build 5629, I was able to restore tapebackup from v8.6 again!

[Joseph_Friess]

I have 5520; I thought I was at the latest. I'll try the newer verision and let you know.

[Joseph_Friess]

I upgraded to v10d build 5629 and that fixed the problem. I missed the V10d UPGARDE AS i WAS LOOKING FOR UPGRADES UNDER 10.0 rather 10.d

thanks to all who repsonded!