Problem

-- Command "jtood show [partner]" in CLI is not working

-- Output is incomplete, it will only show the last line of each message, e.g.:

$ jtood show partner
Error: 0 [OK]
Error: 0 [OK]
Error: 0 [OK]

-- Database in use is AxwayDB/MySQL

-- In $ACTISEDI/param/is/n0is0/oftp/params multiple lines of the parameter "showdefault" are seen:

showdefault=Req: $REQ $ORG->$DST $VFN, $FND-$FNT
showdefault=Partner: $PID Type: $DSN File: $FIL
showdefault=Stat:$STA [$STT]
showdefault=Prio: $PRI
showdefault=Transfer: $TFD-$TFT Event: $EVN EERP: $EED-$EET  $EEV
showdefault=Format:$FMT Reclen:$LEN Del:$DEL Bytes:$BYT Record:$REC Gzip:$GZP
showdefault=Error: $ERR [$ERT]

-- This should be (per default):

showdefault=Request: $REQ = $ORG->$DST $VFN, $FND-$FNT\nPartner: $PID Type: $DSN File: $FIL\nStatus: $STA [$STT]\nPriority: $PRI\nTransferdate: $TFD-$TFT Event: $EVN EERPDate: $EED-$EET EERP-Event: $EEV\nFormat: $FMT Reclen: $LEN Del: $DEL Bytes: $BYT Record: $REC Gzip: $GZP\nError: $ERR [$ERT]

-- Checking the "param/is/n0is0/oftp/params in the UI -> Configuration-> Parameter Tables page it shows a little warning sign with the message:

Too many lines (max. no. of lines 1, lines 7) \Last line:\n 1: " Req: $REQ $ORG -> $DST $VFN, $FND - $FNT "

-- the "\n" are missing in the UI entry of the "value" column of the "showdefault" parameter.

Request: $REQ = $ORG->$DST $VFN, $FND-$FNTPartner: $PID Type: $DSN File: $FILStatus: $STA [$STT]Priority: $PRITransferdate: $TFD-$TFT Event: $EVN EERPDate: $EED-$EET EERP-Event: $EEVFormat: $FMT Reclen: $LEN Del: $DEL Bytes: $BYT Record: $REC Gzip: $GZPError: $ERR [$ERT]

Resolution

** MySQL interprets and converts "\n" to newlines, causing the showdefault parameter to produce line breaks in that column of this database entry instead of setting it as entered.

** Per TechOnlineDoc the "showdefault" is not a required parameter

To solve the issue, it is recommended to disable "showdefault" in the UI, this causing TSIM to use the default value.

To do so, follow these steps:

1. Log into the UI
2. Go to configuration -> Base Data -> Parameter table
3. Search for the File/Table params
4. Select the first found params file
5. Find the "showdefault" row, and delete the content of the field
6. Remove the checkmark in the "Used" column for the "showdefault" row
7. Click OK
8. Select the next params file an repeat step 5 through 7
9. Repeat until all params file are updated
10. Activate changes