IJ50265: ADDING A DOCUMENT WITH SPACE IN NAME ADDS A ? (SQLSERVER ) AND THEREFORE CAN'T BE OPENED.

APAR status

• Closed as program error.

Error description

• Adding a document with space in name adds a ? (SQLServer ) and
  therefore can't be opened.
  Happens in Oracle and DB2 as well, but in SQLServer the ? is
  added causing the issue for not opening the url.
  
  The white space should be getting removed, but it is not. The
  difference with SQL server is that, when it is not removed, it
  displays as a question mark.
  
  
  
  
  
  
  STEPS TO REPRODUCE:
  
  7613 with SQLServer
  
  
  1. Go to Asset application and find 11400
  2. Click to Add file such as 2024-01-103-07p.m..pdf
  2024-01-103-07p.m..txt
  
  3. The result when added is
  \DOCLINKS\ATTACHMENTS/2024-01-103-07?p.m..pdf
  and can't be opened.
  
  
  
  
  RESULT:
  
  Space in file name is converted to ? when added
  
  
  
  
  
  EXPECTED RESULT:
  
  
  Should open as expected with no ? added to url.
  
  
  
  
  
  Product Version:
  
  
  Tivoli's process automation engine 7.6.1.3-IFIX20231223-1405
  Build 20220823-0909 DB Build V7613-344 HFDB Build HF7613-130
  

Local fix

• use a standard space character in the filename instead of a
  NARROW NO-BREAK SPACE
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Adding a document with space in name adds a ? (SQLServer )   *
  * and therefore can't be opened.                               *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.x Product
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels