Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kumara Sri Gurudutta Sarma Juturi (Gurudatta)
Carelon Global Solutions

Carelon Global Solutions
IN
Gurudatta Member since 2016 7 posts
Carelon Global Solutions
Posted: Nov 22, 2016
Last activity: Nov 27, 2016
Posted: 22 Nov 2016 12:06 EST
Last activity: 27 Nov 2016 3:24 EST
Closed

unable to login to PEGA designer studio with default credentials

Hi All,

I have installed Pega 7.1.7 on Oracle 12c db and weblogic 12c application server.

Java-jdk1.7.0_45.

When I try to login to PEGA designer studio with default id/pwd i.e [email protected] I am getting below error.

Please help me out.

Cannot save Data-Admin-Operator-ID instance to database.com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations <update instance DATA-ADMIN-OPERATOR-ID Proprietary information hidden not only if new>. Error occurred while executing forward chaining on page '', using rule: {pyClassName=@baseclass, pxObjClass=Rule-Declare-Expressions, pyTargetProperty=.pxRuleOpenedInPopUp, pyPageContext=}

 

***Updated by Moderator: Marissa to update categories***

To see attachments, please log in.
Dev/Designer Studio
Security

Posted: 8 years ago
Posted: 22 Nov 2016 21:10 EST
Shashidhar Reddy Palle (Shashidhar_Palle)
PEGA
Application Architect, Application Architecture & Shared Services
Pegasystems Inc.
IN

Hi,

Could you please attach the complete logs when tried to log-in ?

Can you verify if any modifications have been done on pr_operators table in DB ?

To see attachments, please log in.
Posted: 8 years ago
Posted: 23 Nov 2016 4:25 EST
Kumara Sri Gurudutta Sarma Juturi (Gurudatta)
Carelon Global Solutions

Carelon Global Solutions
IN

Hi Shashidhar,

Please find the log below.

Looks like PR_OPERATORs table was updated. Actually alredy sepup was there earlier and later DB server decommissioned. so new db server created and installed PEGA.

I can see few users created in PR_OPERATORS table same as Dev DB users.

How to resolve this issue.

v 23 10:14:15 AST 2016 Total memory: 2,595,749,888 Free memory: 2,010,058,472 Requestor Count: 10 Shared Pages memory usage: 0%
2016-11-23 10:22:57,343 [fault (self-tuning)'] [  STANDARD] [                    ] [     PegaRULES:07.10] (  internal.access.DatabaseImpl) ERROR xxxxx.xx.xx.co
m|10.xx.xx.xx  - Encountered problem when performing a Commit

Show More

Hi Shashidhar,

Please find the log below.

Looks like PR_OPERATORs table was updated. Actually alredy sepup was there earlier and later DB server decommissioned. so new db server created and installed PEGA.

I can see few users created in PR_OPERATORS table same as Dev DB users.

How to resolve this issue.

v 23 10:14:15 AST 2016 Total memory: 2,595,749,888 Free memory: 2,010,058,472 Requestor Count: 10 Shared Pages memory usage: 0%
2016-11-23 10:22:57,343 [fault (self-tuning)'] [  STANDARD] [                    ] [     PegaRULES:07.10] (  internal.access.DatabaseImpl) ERROR xxxxx.xx.xx.co
m|10.xx.xx.xx  - Encountered problem when performing a Commit


com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations <update instance DATA-ADMIN-OPERATOR-ID Proprietary information hidden not only if new>. Error occurred while executing forward chaining on page '', using rule: {pyClassName=@baseclass, pxObjClass=Rule-Declare-Expressions, pyTargetProperty=.pxRuleOpenedInPopUp, pyPageContext=}
        at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3135)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2608)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2288)
        at com.pega.pegarules.data.internal.access.Saver.save(Saver.java:663)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4930)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4916)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4908)
        at com.pega.pegarules.session.internal.mgmt.authentication.Authentication.initializeUser(Authentication.java:1850)
        at com.pega.pegarules.session.internal.mgmt.authentication.Authentication.initializeUser(Authentication.java:1772)
        at com.pega.pegarules.session.internal.mgmt.authentication.Authentication.doAuthentication(Authentication.java:520)
        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.handleAuthentication(HttpAPI.java:2168)
        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.activityExecutionProlog(EngineAPI.java:547)
        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:382)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1188)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:926)
        at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:811)
        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:330)
        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:839)
        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315)
        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263)
        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:240)
        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:278)
        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:223)
        at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:485)
        at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:290)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:338)
        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:379)
        at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:216)
        at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:265)

 at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:118)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:751)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
        at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
        at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:341)
        at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:238)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3363)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3333)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
        at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2220)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2146)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2124)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1564)
        at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:295)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:254)
Caused by: com.pega.pegarules.pub.PRRuntimeException: Error occurred while executing forward chaining on page '', using rule: {pyClassName=@baseclass, pxObjClass=Rule-Declare-Expressions, pyTargetProperty=.pxRuleOpenedInPopUp, pyPageContext=}
        at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngineUtilImpl.runActivity(ChainingEngineUtilImpl.java:260)
        at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngineUtilImpl.executeBackwardChainingRule(ChainingEngineUtilImpl.java:393)
        at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngine.deriveGoalValue(ChainingEngine.java:491)
        at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngine.forceFeedDeriveGoalValue(ChainingEngine.java:401)
        at com.pega.pegarules.exec.internal.declare.infengine.InferenceEngineImpl.seekGoalValue(InferenceEngineImpl.java:524)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyBase.seekValue(ClipboardPropertyBase.java:1229)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.autoChain(ClipboardPropertyImpl.java:1187)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.autoChain(ClipboardPropertyImpl.java:922)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyBase.autoChain(ClipboardPropertyBase.java:3235)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.getValue(ClipboardPropertyImpl.java:4291)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.getValue(ClipboardPropertyImpl.java:4282)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.getStringValue(ClipboardPropertyImpl.java:3530)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.getStringValue(ClipboardPropertyImpl.java:3534)
        at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addProperty(DirectStreamEncoder.java:916)
        at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder$PageSection.addPage(DirectStreamEncoder.java:743)
        at com.pega.pegarules.data.internal.clipboard.DirectStreamEncoder.encode(DirectStreamEncoder.java:317)
        at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.encode(StorageStreamCommonImpl.java:825)
        at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getStreamForm(ClipboardPageImpl.java:3619)
        at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.getStreamFormOfPage(PageDatabaseMapperImpl.java:1448)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3070)

 ... 56 more
Caused by: java.lang.NoClassDefFoundError: com/pega/push/notification/unifiedpush/message/UnifiedMessage
        at java.lang.Class.getDeclaredMethods0(Native Method)
        at java.lang.Class.privateGetDeclaredMethods(Class.java:2531)
        at java.lang.Class.getMethod0(Class.java:2774)
        at java.lang.Class.getMethod(Class.java:1663)
        at com.pega.pegarules.generation.internal.library.LibraryMetadataCache.getLibraryCache(LibraryMetadataCache.java:167)
        at com.pega.pegarules.generation.internal.library.LibraryMetadataCache.libraryContainsSignature(LibraryMetadataCache.java:379)
        at com.pega.pegarules.generation.internal.library.LibraryFunctionUtilityImpl.resolveMethodCall(LibraryFunctionUtilityImpl.java:2921)
        at com.pega.pegarules.session.internal.mgmt.Executable.resolveMethodCall(Executable.java:10960)
        at com.pegarules.generated.expressions.ra_action__pxruleopenedinpopup__e115ffea35b71731e01ca60c2fef6d21.perform(ra_action__pxruleopenedinpopup__e115ffea35b71731e01ca60c2fef6d21.java:122)
        at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:3180)
        at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngineUtilImpl.runActivity(ChainingEngineUtilImpl.java:227)
        ... 75 more
Caused by: java.lang.ClassNotFoundException: com.pega.push.notification.unifiedpush.message.UnifiedMessage
        at com.pega.pegarules.internal.bootstrap.phase2.PRBaseLoader.findClass(PRBaseLoader.java:312)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
        at com.pega.pegarules.internal.bootstrap.phase2.PRBaseLoader.loadClass(PRBaseLoader.java:237)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        at com.pega.pegarules.bootstrap.loader.PRAppLoader.loadClass(PRAppLoader.java:796)
        at com.pega.pegarules.bootstrap.loader.PRAppLoader.loadClass(PRAppLoader.java:659)
        at com.pega.pegarules.exec.internal.util.classloader.PRClassLoaderDB.loadClass(PRClassLoaderDB.java:1034)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        at com.pega.pegarules.exec.internal.util.classloader.PRClassLoaderDB$Loader.loadClass(PRClassLoaderDB.java:2038)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        ... 86 more
2016-11-23 10:22:57,346 [fault (self-tuning)'] [  STANDARD] [                    ] [     PegaRULES:07.10] (.authentication.Authentication) ERROR xxxxxxxxxxx|10.xx.xx.xx - Cannot save Data-Admin-Operator-ID instance to database.com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations <update instance DATA-ADMIN-OPERATOR-ID Proprietary information hidden not only if new>. Error occurred while executing forward chaining on page '', using rule: {pyClassName=@baseclass, pxObjClass=Rule-Declare-Expressions, pyTargetProperty=.pxRuleOpenedInPopUp, pyPageContext=}
com.pega.pegarules.pub.PRRuntimeException: Encountered database exception when preprocessing deferred operations <update instance DATA-ADMIN-OPERATOR-ID Proprietary information hidden not only if new>. Error occurred while executing forward chaining on page '', using rule: {pyClassName=@baseclass, pxObjClass=Rule-Declare-Expressions, pyTargetProperty=.pxRuleOpenedInPopUp, pyPageContext=}
        at com.pega.pegarules.data.internal.access.DatabaseImpl.preprocessInstancesBeforeCriticalCommitSection(DatabaseImpl.java:3135)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2608)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2288)
        at com.pega.pegarules.data.internal.access.Saver.save(Saver.java:663)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4930)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4916)
        at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:4908)
        at com.pega.pegarules.session.internal.mgmt.authentication.Authentication.initializeUser(Authentication.java:1850)

 

 


Show Less
To see attachments, please log in.
Posted: 8 years ago
Posted: 27 Nov 2016 3:24 EST
Kumara Sri Gurudutta Sarma Juturi (Gurudatta)
Carelon Global Solutions

Carelon Global Solutions
IN

Hi All,

 

Please see the error logs while installing the PEGA.

Show More

Hi All,

 

Please see the error logs while installing the PEGA.


[java] 2016-11-24 20:05:14,570 [        xxxxxx] [  STANDARD] [                    ] (l.access.ConnectionManagerImpl) ERROR   - Not returning connection       7 for database "pegarules" to the pool as it previously encountered the following error
20605      [java] User ID: (unknown)
20606      [java] Last SQL: {call PRPC_DATA_USR.sppr_sys_updatescache_gettime (?,?,?)}
20607      [java] java.sql.SQLException: ORA-06598: insufficient INHERIT PRIVILEGES privilege
20608      [java] ORA-06512: at "PRPC_DATA_USR.SPPR_SYS_UPDATESCACHE_GETTIME", line 1
20609      [java] ORA-06512: at line 1
                                                                                                                                                      20588,6       90%
---------------------------------
20657      [java] 2016-11-24 20:05:14,573 [        xxxxx] [  STANDARD] [                    ] (  internal.access.DatabaseImpl) ERROR   - [setDataNodeState] Excep      tion while updating system state. Message: Database-General   Problem encountered executing a stored procedure        6598    65000   ORA-06598: insufficient INHE      RIT PRIVILEGES privilege
20658      [java] ORA-06512: at "PRPC_DATA_USR.SPPR_SYS_UPDATESCACHE_GETTIME", line 1
20659      [java] ORA-06512: at line 1
20660      [java]
20661      [java] com.pega.pegarules.pub.database.DatabaseException: Database-General Problem encountered executing a stored procedure        6598    65000   ORA-06598:       insufficient INHERIT PRIVILEGES privilege
20662      [java] ORA-06512: at "PRPC_DATA_USR.SPPR_SYS_UPDATESCACHE_GETTIME", line 1
20663      [java] ORA-06512: at line 1
20664      [java]
20665      [java] From: (BCFB9A46EC04785FAA7376E0AEEFC65F0:(PREnvironment))
20666      [java]     SQL: {call PRPC_DATA_USR.sppr_sys_updatescache_gettime (?,?,?)}
20667      [java]     SQL Inserts: <SYSTEM-STATUS-NODES PRPC!SARYPTINTAPP!777F12059A712282D20E0700AD4C85A6>   <1970-01-01 03:00:00.0> <1970-01-01 03:00:00.0>
20668      [java]
20669      [java] Caused by SQL Problems.
20670      [java] Problem #1, SQLState 65000, Error code 6598: java.sql.SQLException: ORA-06598: insufficient INHERIT PRIVILEGES privilege
20671      [java] ORA-06512: at "PRPC_DATA_USR.SPPR_SYS_UPDATESCACHE_GETTIME", line 1
20672      [java] ORA-06512: at line 1
-----------------------------

 


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice