Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How to fix OSCL authentication against JAS 6.0.5 ifix001 with ERROR 22001: A truncation error was encountered trying to shrink VARCHAR ?

Questions
Tags
Users
Badges
Ulf Arne Bister
(1.3k●4●13) Jan 11 '18, 9:05 a.m.

Hi,

Setup as follows:
Distributed JTS with Apps on Liberty authenticating against Jazz Authorization Server (JAS) 6.0.5 ifix001, using Derby. All on RHEL Linux.
Using an RTC Eclipse Client I can authenticate against either /ccm , /qm or /rm server fine.
Using a 3rd party integration in the same Eclipse Client (pure::variants) I get an authentication error and find in the JAS logfile:

com.ibm.ws.security.oauth20.plugins.db.CachedDBOidcTokenStore E Internal error adding token: A truncation error was encountered trying to shrink VARCHAR '{xor}OiYVNz0YPDYQNhUWCiUWbhE2FWZxOiYVJTsIFjYQNhULEQoZDwkaahQ&' to length 2048.
[...]
ERROR 22001: A truncation error was encountered trying to shrink VARCHAR '{xor}OiYVNz0YPDYQNhUWCiUWbhE2FWZxOiYVJTsIFjYQNhULEQoZDwkaahQ&' to length 2048.
              at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

Did anybody encounter something similar? Do you have an idea what the underlying problem is or how to fix it?

best,
Arne

0 votes

1 answer
5,965 views
0 votes

Accepted answer

Permanent link
Shubjit Naik
(1.5k●1●6●13) edited
Jan 11 '18, 1:02 p.m.

 HI Arne


This issue is seen with the default Derby database. This problem occurs when a userid connected to too many LDAP groups tries to logon to the RTC server using oidc, TOKENSTRING column is too small.

You could use a DERBY DB Viewe, example Squirrel Client and increase the TOKENSTRING Column size.

Here is the Defect

Best Regards
Shubjit

Ulf Arne Bister selected this answer as the correct answer

2 votes

Comments
Ulf Arne Bister
Jan 16 '18, 3:49 a.m.
The workaround did the trick. I had to increase TOKENSTRING column to 16384 Bytes and then the error message went away. For this I used DBVisualizer. JAS Liberty had to be stopped for that measure because the embedded Derby does not like multiple connections apparently. Thanks for the quick help!

1 vote

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,622

Question asked: Jan 11 '18, 9:05 a.m.

Question was seen: 5,965 times

Last updated: Jan 16 '18, 3:49 a.m.

Confirmation Cancel Confirm