Symptom:
When using the ?delegated_mstr_uid wildcard within the "Additional connection string parameters" in Database Connections > Advanced, users may note that under certain circumstances the string when passed to the database is right truncated as shown in the following MySQL example using Database Classes > Connection Management trace:
[HOST:TEST][SERVER:CastorServer][PID:1748][THR:3701405440][Database Classes][Connection Management] Connection cached: Connection ID: 0, Connection String:
DSN=TUTORIAL_WH;DBMS_SESSION.SET_IDENTIFIER=('mstr;, Multiprocess, Non-extended Fetch, Row by Row Insertion, Synchronous, Category: QUERY_ENGINE, ConnectionName: TutorialWHLinux,
DatabaseConnectionID: A7543BCC4AC0AE818ED0F4B4357D2A61, DatabaseInstanceID: A23BBC514D336D5B4FCE919FE19661A3, DatabaseInstanceName: Tutorial MySQL, DatabaseLoginID:
37BE16A011D3E48C1000E787EC6DE8A4, LoginName: Data, MSTRUID: mstr, RealDBUser: mysqladmin, UserName: MSTR User
DBMS_SESSION.SET_IDENTIFIER=('?delegated_mstr_uid')delegationuid=?delegated_mstr_uid