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

 Maurice Boer (MAURICEBOER)
Nationale Nederlanden

Nationale Nederlanden
NL
MAURICEBOER Member since 2010 19 posts
Nationale Nederlanden
Posted: Apr 3, 2023
Last activity: Aug 7, 2023
Posted: 3 Apr 2023 10:19 EDT
Last activity: 7 Aug 2023 10:32 EDT
Closed

Upgrade issue on sytem-locks

We got this error after upgrading via copy of PEGARULES schema:

Show More

We got this error after upgrading via copy of PEGARULES schema: 2023-04-03 16:14:30,278 [xxxxx] [ STANDARD] [ ] [ ] ( prpc.service.ServiceManager) ERROR - Service manager failed to startup com.pega.dsm.dnode.api.DNodeException: Could not perform database dataset operation on System-Locks at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil.lambda$observableForDatabaseOperation$0(DatabaseOperationsUtil.java:78) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:353) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:55) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.stream.DataObservableImpl.await(DataObservableImpl.java:117) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.stream.DataObservableImpl.await(DataObservableImpl.java:106) ~[d-node.jar:?] at com.pega.dsm.dnode.util.OperationWithLock.removeAllLocksForNode(OperationWithLock.java:72) ~[d-node.jar:?] at com.pega.dsm.dnode.api.prpc.service.ServiceManager.removeAllLocksForThisNode(ServiceManager.java:507) ~[d-node.jar:?] at com.pega.dsm.dnode.api.prpc.service.ServiceManager.bootstrap(ServiceManager.java:205) ~[d-node.jar:?] at com.pega.dsm.dnode.api.server.StreamServiceInitializationTask$1.run(StreamServiceInitializationTask.java:80) ~[d-node.jar:?] at com.pega.dsm.dnode.api.server.StreamServiceInitializationTask$1.run(StreamServiceInitializationTask.java:77) ~[d-node.jar:?] at com.pega.dsm.dnode.util.PrpcRunnable.execute(PrpcRunnable.java:67) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.prpc.service.ServiceHelper$2.run(ServiceHelper.java:291) ~[d-node.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1388) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1131) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:938) ~[prprivate-session.jar:?] at com.pega.dsm.dnode.impl.prpc.service.ServiceHelper.executeInPrpcContextInternal(ServiceHelper.java:284) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.prpc.service.ServiceHelper.executeInPrpcContext(ServiceHelper.java:146) ~[d-node.jar:?] at com.pega.dsm.dnode.api.server.StreamServiceInitializationTask.initStreamServerServiceAndValidate(StreamServiceInitializationTask.java:77) ~[d-node.jar:?] at com.pega.dsm.dnode.api.server.StreamServiceInitializationTask.runTask(StreamServiceInitializationTask.java:51) ~[d-node.jar:?] at com.pega.pegarules.session.internal.async.startup.StartupTaskUtil.runTask(StartupTaskUtil.java:89) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.initializeSystem(PRNodeImpl.java:1034) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:407) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:2176) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:683) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:180) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl$1.run(EngineImpl.java:157) ~[prprivate-session.jar:?] at java.security.AccessController.doPrivileged(AccessController.java:691) ~[?:1.8.0] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:154) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.doStartup(EngineBean.java:127) ~[prprivate-session.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0] at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388) ~[prbootstrap.jar:8.5.3-551] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430) ~[prbootstrap.jar:8.5.3-551] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api.jar:8.5.3-551] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:247) ~[prbootstrap-api.jar:8.5.3-551] at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.doStartup(EngineBeanBoot.java:135) ~[prbeans.jar:8.5.3-551] at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.doStartup(EJSLocalStatelessEngineBMT_f2439d86.java) ~[?:8.5.3-551] at com.pega.pegarules.web.servlet.WebAppLifeCycleListener._contextInitialized_privact(WebAppLifeCycleListener.java:210) ~[prwebj2ee.jar:?] at com.pega.pegarules.web.servlet.AbstractLifeCycleListener._contextInitialized_privact(AbstractLifeCycleListener.java:145) ~[prwebj2ee.jar:?] at com.pega.pegarules.web.servlet.AbstractLifeCycleListener$2.run(AbstractLifeCycleListener.java:81) ~[prwebj2ee.jar:?] at java.security.AccessController.doPrivileged(AccessController.java:691) ~[?:1.8.0] at com.pega.pegarules.web.servlet.AbstractLifeCycleListener.contextInitialized(AbstractLifeCycleListener.java:78) ~[prwebj2ee.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90) ~[?:1.8.0] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) ~[?:1.8.0] at java.lang.reflect.Method.invoke(Method.java:508) ~[?:1.8.0] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388) ~[prbootstrap.jar:8.5.3-551] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430) ~[prbootstrap.jar:8.5.3-551] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api.jar:8.5.3-551] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274) ~[prbootstrap-api.jar:8.5.3-551] at com.pega.pegarules.internal.web.servlet.WebAppLifeCycleListenerBoot.contextInitialized(WebAppLifeCycleListenerBoot.java:92) ~[prbootstrap-api.jar:8.5.3-551] at com.ibm.ws.webcontainer.webapp.WebApp.notifyServletContextCreated(WebApp.java:1841) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:443) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:171) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:904) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:789) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:427) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:719) ~[com.ibm.ws.webcontainer.jar:?] at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1249) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1591) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:720) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:1162) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:801) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2325) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5568) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5694) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2330) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:436) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:379) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:127) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:985) ~[com.ibm.ws.runtime.jar:?] at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:524) ~[com.ibm.ws.runtime.jar:?] at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909) ~[com.ibm.ws.runtime.jar:?] Caused by: java.lang.IllegalStateException: No mapping of property pxSystemNode to a database table column. Property-to-column map:Reading table mapping for class [System-Locks]Property name not found in conclusion for column [PXCOMMITDATETIME]. Using raw column name Property name not found in conclusion for column [PXCREATEDATETIME]. Using raw column name Property name not found in conclusion for column [PXCREATEOPERATOR]. Using raw column name Property name not found in conclusion for column [PXCREATEOPNAME]. Using raw column name Property name not found in conclusion for column [PXCREATESYSTEMID]. Using raw column name Property name not found in conclusion for column [PXEXPIREDATETIME]. Using raw column name Property name not found in conclusion for column [PXINSNAME]. Using raw column name Property name not found in conclusion for column [PXLOCKHANDLE]. Using raw column name Property name not found in conclusion for column [PXOBJCLASS]. Using raw column name Property name not found in conclusion for column [PXOWNERID]. Using raw column name Property name not found in conclusion for column [PXSAVEDATETIME]. Using raw column name Property name not found in conclusion for column [PXSYSTEMNAME]. Using raw column name Property name not found in conclusion for column [PXSYSTEMNODE]. Using raw column name Property name not found in conclusion for column [PXUPDATEDATETIME]. Using raw column name Property name not found in conclusion for column [PXUPDATEOPERATOR]. Using raw column name Property name not found in conclusion for column [PXUPDATEOPNAME]. Using raw column name Property name not found in conclusion for column [PXUPDATESYSTEMID]. Using raw column name Property name not found in conclusion for column [PXUSERHOST]. Using raw column name Property name not found in conclusion for column [PYLABEL]. Using raw column name Property name not found in conclusion for column [PZINSKEY]. Using raw column name at com.google.common.base.Preconditions.checkState(Preconditions.java:174) ~[guava-19.0.jar:?] at com.pega.dsm.dnode.impl.dataset.database.FiltersFromLookupKeys.initWithMultipleKeys(FiltersFromLookupKeys.java:143) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.dataset.database.FiltersFromLookupKeys.<init>(FiltersFromLookupKeys.java:107) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.dataset.database.FiltersFromLookupKeys.forDBNested(FiltersFromLookupKeys.java:94) ~[d-node.jar:?] at com.pega.dsm.dnode.util.DatabaseAPIUtils.setWhereConditions(DatabaseAPIUtils.java:125) ~[d-node.jar:?] at com.pega.dsm.dnode.util.DatabaseAPIUtils.setWhereConditions(DatabaseAPIUtils.java:140) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.dataset.database.DatabaseDeleteByKeysOperation$1.executeExposedLogic(DatabaseDeleteByKeysOperation.java:113) ~[d-node.jar:?] at com.pega.dsm.dnode.impl.dataset.database.DatabaseOperationsUtil.lambda$observableForDatabaseOperation$0(DatabaseOperationsUtil.java:73) ~[d-node.jar:?] ... 77 more

 

Any one who can help us with this issue?  

Show Less
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.5.3
Updates
Installation and Deployment
Data Model
Lead System Architect

Posted: 1 year ago
Posted: 12 Apr 2023 6:54 EDT
Saikishore Sanagapalli (Kishore Sanagapalli)
LTIMindtree
Senior Specialist - Pega Containerization Practitioner
LTIMindtree
SA

@MAURICEBOER

As per the error, it's clear that DSM Services as part of Stream Node coming up created the issue post the upgrade. You'll need to Truncate few DB Tables listed below and start the application again will fix the issue.

 

DB Tables to Truncate:

Truncate table <Schema-Name>.pr_sys_delayed_queue;

Truncate table <Schema-Name>.pr_data_stream_nodes;

Truncate table <Schema-Name>.pr_data_stream_sessions;

Truncate table <Schema-Name>.pr_sys_statusnodes;

Truncate table <Schema-Name>.pr_sys_statusdetails;

Truncate table <Schema-Name>.pr_data_stream_node_updates;

TRUNCATE table <Schema-Name>.pr_perf_stats;

 

To see attachments, please log in.
Posted: 1 year ago
Updated: 1 year ago
Posted: 13 Apr 2023 7:50 EDT
Updated: 17 Apr 2023 11:11 EDT
Marije Schillern (MarijeSchillern)
MOD
Senior Knowledge Management Specialist
Pegasystems Inc.
GB

  @MAURICEBOER  please let us know how you get on after carrying out @KishoreSanagapalli 's suggestions.

Also  it looks like the pega system name one of the requestors may not be valid in the database.  You can verify with a query:

SELECT pySystemName, pzinskey, pxcreatedatetime, pxupdatedatetime, pxcommitdatetime, pxsavedatetime, PXCREATESYSTEMID, PXUPDATESYSTEMID, PYACCESSGROUP, PYLABEL, LENGTH(pzpvstream) FROM PRPC_APP.pr_data_admin WHERE pxObjClass = 'Data-Admin-Requestor';

SELECT PYSETTING, PZINSKEY FROM PRPC_APP.pr_data_admin WHERE pxObjClass = 'Data-Admin-System-Settings' and pzinskey like '%SYSTEMNAME%';

To see attachments, please log in.
Posted: 1 year ago
Posted: 30 Jun 2023 12:57 EDT
Suresh Kumar Nahroli (SureshNahroli)
Standard and Poors
Pega Lead Architect
Standard and Poors
US

@Kishore Sanagapalli

 

We encountered the same issue during upgrade from 7.4 to 8.8. We deleted from the cache tables mentioned above and also deleted the custom system name record from pr_data_admin ( defaulting to pega) and restarted the server successfully.

In addition to this we also deleted the requestors (Data-Admin-Requestor) with custom system name 

This approach fixed the problem.

 

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