Folks,
I do not know if it is just my computer or a problem in
general with ASE 12.5.3 ESD #1 on Windows 2000 Professional.
When I use a dump file name with several colons in the file
name (for the time), the dump (both database and tran) fails
if there are more than two in the full path (one for the
drive and one in the file name).

I get the following when using different numbers of
colons. Are any others experiencing the same problem?

Cheers

Raymond


dump database model to
"c:\temp\model.dmp.20050321.21:23:45:678"

Server Message: Number 3216, Severity 10
Server 'RPM01', Line 1:
Backup Server session id is: 5. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Server Message: Number 404101, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.41.1.1: Creating new disk file
c:\temp\model.dmp.20050321.21:23:45:678.
Server Message: Number 414102, Severity 2
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.141.2.40: [7] The 'CreateFile' call failed
for device 'c:\temp\model.dmp.20050321.21:23:45:678' with
error number 123 (The filename, directory name, or volume
label syntax is incorrect). Refer to your operating system
documentation for further details.
Server Message: Number 8009, Severity 16
Server 'RPM01', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for details.

dump database model to
"c:\temp\model.dmp.20050321.21:23:45.678"

Server Message: Number 3216, Severity 10
Server 'RPM01', Line 1:
Backup Server session id is: 8. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Server Message: Number 404101, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.41.1.1: Creating new disk file
c:\temp\model.dmp.20050321.21:23:45.678.
Server Message: Number 414102, Severity 2
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.141.2.40: [7] The 'CreateFile' call failed
for device 'c:\temp\model.dmp.20050321.21:23:45.678' with
error number 87 (The parameter is incorrect). Refer to your
operating system documentation for further details.
Server Message: Number 8009, Severity 16
Server 'RPM01', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for details.

dump database model to
"c:\temp\model.dmp.20050321.21:23.45.678"

Server Message: Number 3216, Severity 10
Server 'RPM01', Line 1:
Backup Server session id is: 11. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Server Message: Number 404101, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.41.1.1: Creating new disk file
c:\temp\model.dmp.20050321.21:23.45.678.
Server Message: Number 602801, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'model050801298E '
section number 1 mounted on disk file
'c:\temp\model.dmp.20050321.21:23.45.678'
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_begin_phase', Line 0:
Backup Server: 4.58.1.1: Database model: 332 kilobytes
DUMPed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_run_list', Line 0:
Backup Server: 4.58.1.1: Database model: 336 kilobytes
DUMPed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_dump', Line 0:
Backup Server: 4.58.1.1: Database model: 340 kilobytes
DUMPed.
Server Message: Number 304201, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_dump', Line 0:
Backup Server: 3.42.1.1: DUMP is complete (database model).

dump database model to
"c:\temp\model.dmp.20050321.21:23.45:678"

Server Message: Number 3216, Severity 10
Server 'RPM01', Line 1:
Backup Server session id is: 14. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Server Message: Number 404101, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.41.1.1: Creating new disk file
c:\temp\model.dmp.20050321.21:23.45:678.
Server Message: Number 414102, Severity 2
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.141.2.40: [7] The 'CreateFile' call failed
for device 'c:\temp\model.dmp.20050321.21:23.45:678' with
error number 87 (The parameter is incorrect). Refer to your
operating system documentation for further details.
Server Message: Number 8009, Severity 16
Server 'RPM01', Line 1:
Error encountered by Backup Server. Please refer to Backup
Server messages for details.

dump database model to
"C:\temp\model.dmp.20050321.21.23:45.678"

Server Message: Number 3216, Severity 10
Server 'RPM01', Line 1:
Backup Server session id is: 32. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Server Message: Number 404101, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 4.41.1.1: Creating new disk file
C:\temp\model.dmp.20050321.21.23:45.678.
Server Message: Number 602801, Severity 1
Server 'RPM01_BS', Procedure 'bs_write_header', Line 0:
Backup Server: 6.28.1.1: Dumpfile name 'model0508012A11 '
section number 1 mounted on disk file
'C:\temp\model.dmp.20050321.21.23:45.678'
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_begin_phase', Line 0:
Backup Server: 4.58.1.1: Database model: 332 kilobytes
DUMPed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 1 completed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 2 completed.
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_run_list', Line 0:
Backup Server: 4.58.1.1: Database model: 336 kilobytes
DUMPed.
Server Message: Number 304301, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_phase', Line 0:
Backup Server: 3.43.1.1: Dump phase number 3 completed.
Server Message: Number 405801, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_dump', Line 0:
Backup Server: 4.58.1.1: Database model: 340 kilobytes
DUMPed.
Server Message: Number 304201, Severity 1
Server 'RPM01_BS', Procedure 'bs_end_dump', Line 0:
Backup Server: 3.42.1.1: DUMP is complete (database model).

Have you considered the possibility that it might be a Windows issue?

Try creating a new folder in Windows and renaming it to something
that contains colons - I bet you find you can't.

-bret


Raymond, Mardle wrote:

Bret,
Yep, down to Windows. A facet of the wonderful operating
system I was unaware of. Strange how it allowed one colon to
be used, though. And also explains why it worked in UNIX.
Thanks

Raymond