3758765 - Leading space in dump path causes failure with OS 'error number 2' for dump database or shared memory dump - SAP ASE

• A leading space in the dump path for 
  • dump database / dump transaction or
  • a configured shared memory dump set up with sp_shmdumpconfig
• Causes the the database dump or shared memory dump to fail
• With a message that includes OS error number 2 : "No such file or directory"
  • Due to the leading space, ASE adds an additional SYBASE environment path string and a space before the actual path specified

1. dump database
   
   dump database model to " /tmp/model.dmp"   -- note the added space before /tmp/...
   go
   -- outputs reduced for clarity
   
   Backup Server: 4.41.1.1: Creating new disk file /sybase/ASE161/ASE-16_1/install/ /tmp/model.dmp.
   Backup Server: 4.141.2.40: [11] The 'open' call failed for database/archive device while working on stripe device '/sybase/ASE161/ASE-16_1/install/ /tmp/model.dmp' with error number 2 (No such file or directory).
   Refer to your operating system documentation for further details.
   
   Msg 8009, Level 16, State 1:
   Server 'ASE161', Line 1:
   Error encountered by Backup Server.  Please refer to Backup Server messages for details.
   
   
   
2. shared memory dump
   
   When a leading space is included in the dump_path setting and a dump is trigered, the ASE errorlog entries include:
   
   Initiating shared memory dump for error 208.
   Unable to open dump file '/sybase/ASE161/ /tmp/dumps/ASE161.dmp.2026033110152700.00000'.
   errno: 2, No such file or directory
   
   
   The leading space offset is visible in the output from sp_shmdumpconfig but it requires close inspection, and ideally comparison to another condition, to spot the space.
   
   sp_shmdumpconfig
   go
   -- Lines have been removed for clarity.
   
   Configured Shared Memory Dump Conditions
   ----------------------------------------
    Error      208
      ...
       Unused Space:           Default (Omit)
       Dump Directory:          /tmp/dumps  -- note the offset indicating leading space
   
    Error      14108
      ...
       Unused Space:           Default (Omit)
       Dump Directory:         /tmp/dumps -- note there is no offset

SAP Adaptive Server Enterprise (ASE) - All versions

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem