-Magnus- Super Contributor.
Super Contributor.
956 views

Remote DB and token

Hi,
I have moved to an external Oracle DB and getting this error when tokens created:


DEBUG, http.PwmResponse, {30} forcing logout due to error 5051 ERROR_DB_UNAVAILABLE (unexpected error trying to store token in datastore: 5051 ERROR_DB_UNAVAILABLE (put operation opId=582 failed, error: ORA-12899: value too large for column "SSPR"."TOKENS"."ID" (actual: 133, maximum: 128) [xxxxxxx]
))


Related setting is :

Token Storage Method = DATABASE
Token Length = 6
Response Read Location = DATABASE
Response Write Location = DATABASE
Responses Storage Hashing Method = PBKDF2_SHA512
Database Key Column Type = VARCHAR2
Database Value Column Type = CLOB


What have I missed ?

regards Magnus
0 Likes
3 Replies
Knowledge Partner
Knowledge Partner

Re: Remote DB and token

How did you create the database's tables? It sounds like your column to
hold the token is too small for whatever reason. Look at the sspr
database's tokens table and verify the id column is a varchar 128 or
whatever, and then alter it to be something more like 133 characters, and
perhaps that will help. Why the ID is that size, I do not know, but
that's what the error means.


--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
-Magnus- Super Contributor.
Super Contributor.

Re: Remote DB and token

How did you create the database's tables? It sounds like your column to
hold the token is too small for whatever reason.


I expanded the column and no more errors..
thank you !
//Magnus
0 Likes
Knowledge Partner
Knowledge Partner

Re: Remote DB and token

Well that works; how were the tables created? If manually, I guess the
size issue makes sense, but if via something from Micro Focus then we
probably should change that to work better in the future.

--
Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.