Discussion

Problem reading Data-Admin-Operator-ID instance

Hi,
We have installed 5.4 in Tomcat and it was working very fine. Suddenly it is started giving following issue.
When user tries to login it is giving error ‘Security Access Error: Login not accepted. Enter valid user ID and password’. This is not due to wrong user name / password. In the system log, we are getting following error

(.authentication.Authentication) ERROR localhost|127.0.0.1 - Problem reading
Data-Admin-Operator-ID instance
java.lang.NullPointerException
at com.pega.pegarules.engine.database.PageDatabaseMapper.getStreamBytes(
PageDatabaseMapper.java:2062)
at com.pega.pegarules.engine.database.PageDatabaseMapper.populatePageOrS
tringMapFromStreamColumn(PageDatabaseMapper.java:1949)
at com.pega.pegarules.engine.database.PageDatabaseMapper.createPageFromR
esultSet(PageDatabaseMapper.java:307)
at com.pega.pegarules.engine.database.Opener.getResultFromResultSet(Open
er.java:673)
at com.pega.pegarules.engine.database.Opener.openData(Opener.java:521)
at com.pega.pegarules.engine.database.DatabaseImpl.open(DatabaseImpl.jav
a:2967)
at com.pega.pegarules.engine.database.DatabaseImpl.open(DatabaseImpl.jav
a:2787)
at com.pega.pegarules.engine.database.DatabaseImpl.open(DatabaseImpl.jav
a:2774)
at com.pega.pegarules.authentication.Authentication.validatePegaCredenti
als(Authentication.java:1474)
at com.pega.pegarules.authentication.SchemePRBasic.authenticateOperator(

It looks something went wrong on Tomcat configuration. I tried to create new operators (new organization & all ) through PRDBUtil and it is creating fine. I am able to see the new operator rules in back end table. But when I try to login with operator id on prweb/PRServlet, it is giving issue.

I tried to use external java code and read the table with same jdbc driver and it is works fine.

Can you please add your thoughts?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

Pega
June 29, 2009 - 10:46am

Are you using Oracle for PegaRULES database?
This problem is normally seen due to data corruption caused by using wrong jdbc driver that PRPC application is configured to run with.
E.g If you are using Oracle 10g database and are using 9i jdbc driver then you would face this problem.
Make sure that correct jdbc driver jars are used when configuring jdbc/PegaRULES datasource.

June 29, 2009 - 12:13pm

Yes. My JDBC driver was changed when I installed java analyzer tool. It looks like I copied into wrong place. After changing to correct JDBC driver, it was not working. As you said data got corrupted. I deleted the tables and installed everything again.
Thank a lot for your reply.

April 15, 2016 - 3:24am

I encountered similar issue when showing some data from list view report, but it works fine for some other users for the same function to show data.

If it's a data issue in our business table?  anyone may advice it? Thanks in advance.

The error log from Pega:

java.lang.NullPointerException
 at com.pega.pegarules.engine.database.PageDatabaseMapper.getStreamBytes(PageDatabaseMapper.java:1733)
 at com.pega.pegarules.engine.database.PageDatabaseMapper.populatePageOrStringMapFromStreamColumn(PageDatabaseMapper.java:1618)
 at com.pega.pegarules.engine.database.ResultPageIterator.getClipboardPage(ResultPageIterator.java:970)
 at com.pega.pegarules.engine.database.ResultPageIterator.next(ResultPageIterator.java:461)
 at com.pega.pegarules.engine.database.RDBPageResultPackager.handleResultSet(RDBPageResultPackager.java:440)
 at com.pega.pegarules.engine.database.RDBPageResultPackager.packageResults(RDBPageResultPackager.java:191)
 at com.pega.pegarules.engine.database.DatabaseImpl.list(DatabaseImpl.java:4044)
 at com.pega.pegarules.engine.database.DatabaseImpl.executeRDB(DatabaseImpl.java:4281)
 at com.pega.pegarules.engine.database.DatabaseImpl.executeRDB(DatabaseImpl.java:4250)
 at com.pegarules.generated.activity.ra_activity_embed_listparams_getcontent_6f405588372059646d594b8c86a439df.step1_circum0(ra_activity_embed_listparams_getcontent_6f405588372059646d594b8c86a439df.java:182)
 at com.pegarules.generated.activity.ra_activity_embed_listparams_getcontent_6f405588372059646d594b8c86a439df.perform(ra_activity_embed_listparams_getcontent_6f405588372059646d594b8c86a439df.java:70)
 at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:2841)
 at com.pegarules.generated.pega_wb_listview.callContentActivity05_01_01(pega_wb_listview.java:411)
 at com.pegarules.generated.pega_wb_listview.callContentActivity(pega_wb_listview.java:443)
 at com.pegarules.generated.activity.ra_activity_rule_obj_listview_process_958f9f39008880096c3e05b238f41186.step11_circum0(ra_activity_rule_obj_listview_process_958f9f39008880096c3e05b238f41186.java:1221)
 at com.pegarules.generated.activity.ra_activity_rule_obj_listview_process_958f9f39008880096c3e05b238f41186.perform(ra_activity_rule_obj_listview_process_958f9f39008880096c3e05b238f41186.java:220)
 at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:2841)
 at com.pegarules.generated.activity.ra_activity_rule_obj_listview_showview_c864c661f7b84e7e6e245664409ddefa.step4_circum0(ra_activity_rule_obj_listview_showview_c864c661f7b84e7e6e245664409ddefa.java:584)
 at com.pegarules.generated.activity.ra_activity_rule_obj_listview_showview_c864c661f7b84e7e6e245664409ddefa.perform(ra_activity_rule_obj_listview_showview_c864c661f7b84e7e6e245664409ddefa.java:115)
 at com.pega.pegarules.engine.runtime.Executable.doActivity(Executable.java:2841)