Unable to create selection List

[Luca_Salvatore]

I have just upgraded from backup exec 10 5520 to 10d. Its running on windows server 2003. When trying to restore data from any time of media (tape or disk) I get the error "unable to create selection list."

This has only started hapening since upgrading to 10d. All backup jobs run fine but i cannot restore from anything! even from backup jobs created before the upgrade. sgmon shows the following:

beserver: 11/17/05 11:37:39 -1 SQLLog(36):Database Exception Context:{CALL SaveRestoreScriptEntry(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} Error:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified. :: DB Error Set 0: native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:37:39 -1 SQLLog(37):Database Exception Context:Script InsertRestoreDetail Error:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified. :: DB Error Set 0: native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:37:39 -1 Error(9/8): 8144:native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:37:39 -1 Error(9/8): -536837662:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:38:16 -1 SQLLog(38):AgeSession m_threadMap: SessionThreadID:b94, CurrentThreadID:dc0
beserver: 11/17/05 11:38:19 -1 SQLLog(39):Database Exception Context:{CALL SaveRestoreScriptEntry(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} Error:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified. :: DB Error Set 0: native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:38:19 -1 SQLLog(40):Database Exception Context:Script InsertRestoreDetail Error:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified. :: DB Error Set 0: native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:38:19 -1 Error(9/8): 8144:native=0x1fd0 source=Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Procedure or function SaveRestoreScriptEntry has too many arguments specified.
beserver: 11/17/05 11:38:19 -1 Error(9/8): -536837662:-536837662: :: -2147217900:Procedure or function SaveRestoreScriptEntry has too many arguments specified.

I really need this solved quickly, as i need to restore some important files. i have worked through tech note 279681, which did not solve the problem and there are no other technotes for this error related to 10d. what good is backed up data if it cant be restored!!!!

please help.

[Ajit_Kulkarni]

Hello,


As a test, please create a new backup job and then try to restore it. Check if you are getting the same error.

Regards,


NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.

[Luca_Salvatore]

tI have tried this and it has not worked. I have also tried to rename to catalogs folder, inventory and catalog the b2d folders, restart services, restart computer, nothing works.

[Keith_Chadwell]

Were you ever able to get this fixed. I'm having the exact same problem.

[STeve_O]

Need to reload the backup exec database from base or backup using beutility

[kyle_fung]

I too have exactly the same problem after upgrading to 10d. I wonder if this is a bug that Symantec introduced. A search of the KB seems to indicate that they've had this problem before.
http://seer.support.veritas.com/docs/279681.htm

[Keith_Chadwell]

I attempted a restore from backup and a restore from base and both completed successfully but my problem continues. I've tried stopping all services and renaming the catalog folder restarting services then repeating that to re-index. I've made sure I have plenty of disk space and that the security is allowing write access.

I'm stuck....

[Keith_Chadwell]

Do you still have the problem or have you been able to fix it? Anyone have any success placing a call to their support? Do you pay per call?

[Luca_Salvatore]

The way i fixed trhis problem was to use a blank database and i had to recreate all the jobs. The problem was the upgrade to 10d corrupted the database.

You can make a new database from the beutility. Reload it from base i think will do the trick.

[Keith_Chadwell]

Did you have to re-catalog all your existing jobs after making a new database from 'base'? I did re-create the new database and wasn't able to do a restore with existing catalogs?

[Jose_Martins]

I'm having the same message each time i trie to restore, i'm using the revision 5484 sp4 in a windows 2003 server
If i restore the entire session of sql databases, the restore is done sucessfuly, but if i make a selection inside of the session i got all the time the discribed error.

I have rebuild the BE database and i checked the permissions on the Data folder,

I don't know what to do, this is being a big problem for me ...Message was edited by:
Jose Martins

[Azad_Kamali]

I've exactly the same problem with BackupExex 10 Rev 5484 sp4 in a windows 2003 server.

I've recreate the indexes and catalogs two times which costs me 40 hour each time. but no difference.

It seems that symantec is going to do nothing for this problem!

Please sombody help if found anything.

Thanks,

[Azad_Kamali]

Bingo,

At last, reinstalling the program, solved my problem.

I made a clean install (of 10d version of BackupExec) . Then copied the catalog folder to this new installation. and after an inventory job, I could restore my data.

Azad