Issues Siebel 2018 Upgrade

After upgrade, we encountered some issues with attachment / Document Server.

-> Any attachment upload is successful
-> able to download any attachment, which is uploaded before upgrade
-> unable to download any attachment, which is uploaded after upgrade

OM  Logs

SBL-SVC-00155: No file has been attached to this record. Please attach a file.
SBL-UIF-00230: The file %1 could not be found on any specified file system.

FSMSrvr Log

IDS : FLAGS [1] : REQID [1-B1AW-7B] : SRBSESSID [e1450298200002MI_PRD_SS03] : SRMCONNID [15] 
SRC : SRC_ID [] : SRC_KEY [] 
DEST : ROUTE_ID [FSMSrvr] : ROUTE_KEY [] : ROUTE_SRVR [] : LANG_CODE [ENU] : CODE_PAGE [1200] : LANG_IND [0] : CLIENTPROC_ID [18517] 

FSMLog FSMInfo 3 0000024f5ba853c2:0 2018-09-24 09:47:58 FSMSrvr getting thrctx



on further investigation, we found that new documents on siebel file system is having some naming issue.

usually Siebel attachment will be saved like tablename_rowid_revision.SAF
but after upgrade we noticed that all new files missing revision value.


So new files are like S_DOC_CORR_1-23EUN9_.SAF

On further ticket, oracle confirmed that there is a Bug 26452153 : FILE_REV_NUM IS 0 DURING FILE UPLOAD 

it is found that, In the bug there was corruption in NEXT_FILE_SUFFIX column in table S_SSA_ID. 

on production, NEXT_FILE_SUFFIX is having a value "ActivationList" and all lower environment is a 5 char value. (ex: 4DFGT)

we replaced it with a sql update and all functionality started working.