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

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 = ‘bt_2fa_perf_test_1@bt.com‘ 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