ACO0151E Errors occurred while processing the request

[shaaha85]

Hi guys,

I am getting below error when i try to restore from one server to another server.

*The server is having 7 databases in it.I can able to restore other databases,we are facing problem with one DB.
*I am selecting full databse in GUI ,Right click and select relocate to 'F:\test' drive and started Restore.
* The target is having enough space.

Please guide me to fix it.

######################################################
09/03/2013 10:06:53 Request : RESTORE
09/03/2013 10:06:53 Database Input List : -
09/03/2013 10:06:53 Object Input List : -
09/03/2013 10:06:53 Group Input List : -
09/03/2013 10:06:53 File Input List : -
09/03/2013 10:06:53 Log or Set Input List : -
09/03/2013 10:06:53 Into Input List : -
09/03/2013 10:06:53 Undo File : -
09/03/2013 10:06:53 Relocate Input List : -
09/03/2013 10:06:53 To Input List : -
09/03/2013 10:06:53 Include Inactive Files? : No
09/03/2013 10:06:53 Number of Buffers : 3
09/03/2013 10:06:53 Buffer Size : 4096
09/03/2013 10:06:53 Number of SQL Buffers : 3
09/03/2013 10:06:53 SQL Buffer Size : 4096
09/03/2013 10:06:53 Number of Stripes specified : 3
09/03/2013 10:06:53 Wait for Tape Mounts? : Yes
09/03/2013 10:06:53 DateTime : -
09/03/2013 10:06:53 MarkName : -
09/03/2013 10:06:53 After : -
09/03/2013 10:06:53 Recovery : Yes
09/03/2013 10:06:53 Replace : No
09/03/2013 10:06:53 Restricted User Only? : No
09/03/2013 10:06:53 Partial? : -
09/03/2013 10:06:53 TSM Options File : C:\Program Files\Tivoli\TSM\TDPSql\dsm.opt
09/03/2013 10:06:53 TSM Nodename Override : -
09/03/2013 10:06:53 Fromsqlserver :xxxxxxxxx
09/03/2013 10:06:53 Sqlserver : YYYYYYYY
09/03/2013 10:06:53
09/03/2013 10:06:54 Restore of SSM_OLTP failed.
09/03/2013 10:06:54 An exception occurred while executing a Transact-SQL statement or batch.
09/03/2013 10:06:54 Incorrect syntax near 'F:'. (HRESULT:0x80131501)
09/03/2013 10:06:54 Total database backups inspected: 1
09/03/2013 10:06:54 Total database backups requested for restore: 1
09/03/2013 10:06:54 Total database backups restored: 0
09/03/2013 10:06:54 Total database skipped: 0
09/03/2013 10:06:54 Throughput rate: 0.00 Kb/Sec
09/03/2013 10:06:54 Total bytes transferred: 0
09/03/2013 10:06:54 Elapsed processing time: 1.02 Secs
09/03/2013 10:06:54 ACO0151E Errors occurred while processing the request.
09/03/2013 10:07:12 =========================================================================

#######################################################################

 

[moon-buddy]

Did you look at the LOGS for the specific error/s?

You may want to look at this.

 

[shaaha85]

Hi,
I couldn't able to fine much LOGS for error Incorrect syntax near 'F:'. (HRESULT:0x80131501).

Our database size is 350 GB. F: drive is having enough free space.But C drive is having only 158 MB free space.Will it cause for this error?

&

tdpsql.cfg:
SQLSERVer YYYYYYC0903
FROMSQLserver XXXXXXX0211
SQLAUTHentication INTegrated
MOUNTWaitfordata Yes
BACKUPMethod LEGACY
DIFFESTimate 20
BUFFers 3
BUFFERSIze 4096
STRIPes 3
SQLBUFFers 3
SQLBUFFERSIze 4096
LOGPrune 14
DATEformat 1
NUMBERformat 1
TARGETNode 1
LANGuage ENU
LASTPRUNEDate 09/03/2013 08:59:51

 

[Rusev]

Hi,

Can i ask which version of DP are you using and also what is the version of TDP, there are multiple problems with some of the old version, which are requiering a fix to be installed and etc. You need to provide more specific information about your setup.

Thanks

 

[shaaha85]

Hi,

Please find the details of TDP version.

Target server:
TDP V 5.5.2.0
SQL server 2005
OS: Win 2003




Source server:
TDP V 5.5.2.0
SQL server 2005
OS: Win 2003

I have a question here.If its problem with TDP version, is it possible to restore other databases except one problematic database?

 

[Rusev]

Thats why i was thinking, well you can try and upgrade with the 5.5.6 client where this issue should be fixed (if its the same as sometimes 1 err message is related with more issues) but it wont hurt you to try it.

http://public.dhe.ibm.com/storage/t...aintenance/tivoli-data-protection/ntsql/v556/

You can try the earliest version as well, most fixes should be available:

ftp://public.dhe.ibm.com/storage/tivoli-storage-management/patches/tivoli-data-protection/sql/