Encryption Upgrade Fails For Field/Column That Is Bigger Than 75 Characters With ERROR: SBL-SVC-00110 And Error: Base64 decode failed
(Doc ID 2941321.1)
Last updated on MAY 17, 2023
Applies to:
Siebel CRM - Version 22.10 to 23.4 [Release V17]Information in this document applies to any platform.
Symptoms
Encryption upgrade fails for field/column like "Description" which is bigger than 75 characters in size
E:\sba81\siebsrvr\bin>encryptupg /f RC2 /t AES /j E:\sba81\siebsrvr\bin\encrypt_columns.inp /l enu /u SADMIN /p xxxxxx /c E:\sba81\siebsrvr\bin\enu\siebel.cfg
DBCLog DBCLogError 1 0000000263ec3e08:0 2023-02-15 12:23:31 SQL Warning, SQL State 01004, 0, [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation data could not be encrypted or decrypted for record
SBL-SVC-00110:
Error: Base64 decode failed.
The issue can be reproduced at will with the following steps:
1. After the Incremental Repository Merge (IRM),ran the “encryptupg.exe" to upgrade the encryption of columns from RC2 to AES using the below command:
E:\sba81\siebsrvr\bin>encryptupg /f RC2 /t AES /j E:\sba81\siebsrvr\bin\encrypt_columns.inp /l enu /u SADMIN /p xxxxxx /c E:\sba81\siebsrvr\bin\enu\siebel.cfg
2. The encryption upgrade utility fails with error and stores old encrypted values of length 15 characters in the columns instead of 75 characters or more.
3. Siebel application shows "Data undefined" for the field.
Changes
Ran Encryption upgrade utility to upgrade the RC2 to AES encryption
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |