Tokenization: Client returns error 78043 (SOM_RES_INVALID) server log shows 'PLS-00201: identifier 'RSAPSORTS' must be declared'
3 years ago
Originally Published: 2010-12-30
Article Number
000040205
Applies To
Tokenization Client
Issue
Tokenization: Client returns error 78043 (SOM_RES_INVALID), server log shows "PLS-00201: identifier 'RSAPSORTS' must be declared"
Client returns error 78043 (SOM_RES_INVALID)

Server log shows "PLS-00201: identifier 'RSAPSORTS' must be declared", e.g.:

%RSARTS  2010-12-30 13:44:28,035  ERROR  [com.rsa.token.mvc.model.TokenTypes] - 12/30/2010 13:44:28.035 CST, messageId=78801,SOM_SERVER_DB_ERROR,Database error for user [server] with requestId=11. The database returned [ORA-06550: line 1, column 7:
PLS-00201: identifier 'RSAPSORTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

]. %RSARTS  2010-12-30 13:44:28,035  ERROR  [com.rsa.token.mvc.model.TokenTypes] - SQL / DB Error Exception while loading token types: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'RSAPSORTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 %RSARTS  2010-12-30 13:44:28,035  ERROR  [com.rsa.token.mvc.controller.SomController] - 12/30/2010 13:44:28.035 CST, messageId=78814,SOM_SERVER_INIT_ERROR,Server init failed with the message - [SQL / DB Error Exception while loading token types: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'RSAPSORTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Resolution
Grant execute permission on the table to the user
Notes
See also http://www.orafaq.com/forum/t/60312/0/
Don't see what you're looking for?