AnsweredAssumed Answered

CA SSO : Authentication failed (Error : Unicode converter truncated character)

Question asked by Dhi1ip on Sep 7, 2018
Latest reply on Sep 24, 2018 by Dhi1ip

Hi,

 

I have setup a new Oracle user store where the password are stored in a plain text format. I am getting the following error during the authentication.

 

 

SQS (With Bind Query):
<<
SELECT Name FROM SmUser WHERE Name = ?
SQL_SUCCESS
..
SELECT Name FROM SmUser WHERE Name = ? AND Password = ?/bind:<<USER_NAME>>/bind:****
SQL_NO_DATA
>>

 

 

SQS (With Literal Query):

<<

SELECT Name FROM SmUser WHERE Name = '<<USER_NAME>>' AND Password = '****'

..
[SQL Error.][][][-1][CSmDbConnectionODBC::CheckForError][CSmDbODBC.cpp:1436][[DataDirect][ODBC lib]Unicode converter truncated character][HY000][][][][][]
[ODBC Error: State = HY000 Internal Code = 0 - [DataDirect][ODBC lib] Unicode converter truncated character - MappedResult:-4007][][][][CSmDbConnectionODBC::MapResult][CSmDbODBC.cpp:351][[DataDirect][ODBC lib] Unicode converter truncated character][-1][][][][][]
[Finish processing SQL statement.][][][Exception][CSmRecordset::DoSelect][CDb.cpp:282][Internal Error: Database error. Code is -4007 (DBMSG: <<<State = HY000 Internal Code = 0 - [DataDirect][ODBC lib] Unicode converter truncated character>>>)][][][][][][]

>>

 

If I try to execute the same query in SQL developer, I am getting the expected result.

 

Username : 25 characters (has LC, Number, _ , @ and .)
Password : 20 characters (has LC, UC and Number)

 

Thanks.

 

Regards,

Dhilip

Outcomes