000015726 - AM7.1-rsautil import-bulk-request produces Error : ORA-12899: value too large for column

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000015726
Applies ToAuthentication Manager 7.1

example contents of the .csv file: Here the user name is JoeUser, and he lives in external identity source "DC01.company.net", and will be provisioned a software token.

JoeUser,DC01.company.net,Desktop PC_4.0

IssueHow to to import a token bulk request using a .csv file
rsautil import-bulk-request -u xxxxxx -p xxxxxx -m xxxxxx -f c:\req.csv -r TOKEN --X
<rsa_home>/server//logs/CLU/UCM/UCM Requests_BulkToken_****.log shows error

Error : ORA-12899: value too large for column "RSA_REP"."UCM_REQUEST"."CREATED

_BY" (actual: 61, maximum: 32)

CauseThis error happens when your .csv file references users in an external identity source and they are not yet registered.
ResolutionUsers need to be registered in the internal database, listing users is not sufficient.

There are essentially 2 ways to register users in a large amount.

1) The only way to do this in bulk is with the SDK RegisterPrincipalsCommand

2) You could avoid using the SDK by doing 'some action' to all users. Easy example is:

a) create an administrative role which is essentially locked down to almost nothing, not many tasks or permissions

b) assign all users this administrative role, then unassign the administrative role.

This role assign/unassign action will register the users.

Legacy Article IDa51750