{"id":245,"date":"2018-06-13T03:31:38","date_gmt":"2018-06-13T03:31:38","guid":{"rendered":"http:\/\/supportingelement.com\/?p=245"},"modified":"2018-06-13T03:31:38","modified_gmt":"2018-06-13T03:31:38","slug":"how-to-remove-a-blocked-global-payroll-run-control","status":"publish","type":"post","link":"https:\/\/supportingelement.com\/index.php\/2018\/06\/13\/how-to-remove-a-blocked-global-payroll-run-control\/","title":{"rendered":"How to remove a blocked Global Payroll Run Control"},"content":{"rendered":"<p>This post covers options for dealing with the following PeopleSoft, Global Payroll process (GPPDPRUN) error:<\/p>\n<p style=\"text-align: center;\"><strong><em>User %1 has started or scheduled a run for all groups using Run Control %2.<\/em><\/strong><\/p>\n<p>This error is caused by another process that is running or blocked\/locked\/stuck.<\/p>\n<p>The following scenarios will cause this error:<\/p>\n<ul>\n<li>If the payroll process is in progress, subsequent attempts to run the process will result in this error.<\/li>\n<li>If the payroll process fails\/runs to error, subsequent attempts to run the process will result in this error.<\/li>\n<\/ul>\n<p>The first step is to resolve the issue that is causing the initial process to fail with an error.<\/p>\n<p>After resolving the cause of the issue, there are a couple of options for unblocking the queue:<\/p>\n<h3>Option 1 &#8211; Restart the stock\/locked process<\/h3>\n<p>Depending on the initial cause of the issue, the following can be used to unblock the queue:<\/p>\n<ul>\n<li>Restart the stuck process instance.<\/li>\n<li>Delete the process instance; run the payroll &#8220;Cancel&#8221; process; then re-Identify &amp; Calculate.<\/li>\n<\/ul>\n<p>Note: these actions are likely to require access via the User Profile that ran the initial process.<\/p>\n<h3>Option 2 &#8211; Delete the locked Run Control<\/h3>\n<p>Sometimes it may not be possible to access the User Profile that generated the initial process instance.\u00a0 For example, the user may not be available or the process was initiated by a Batch or System user profile.<\/p>\n<p>In this case the blocking\/stuck Run Control must be removed using a SQL Client to delete the Run Control from the &#8220;PS_GP_RUNCTL&#8221; table.\u00a0 For example:<\/p>\n<p style=\"text-align: center;\"><em>DELETE FROM PS_GP_RUNCTL WHERE OPRID = &#8216;JOHND&#8217;;<\/em><\/p>\n<p>After the locked Run Control is removed, it should be possible to re-calculate using another Run Control.<\/p>\n<p>Note: This solution should be used as a last resort and is not recommended for production situations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post covers options for dealing with the following PeopleSoft, Global Payroll process (GPPDPRUN) error: User %1 has started or scheduled a run for all groups using Run Control %2. This error is caused by another process that is running or blocked\/locked\/stuck. The following scenarios will cause this error: If the payroll process is in\u2026 <span class=\"read-more\"><a href=\"https:\/\/supportingelement.com\/index.php\/2018\/06\/13\/how-to-remove-a-blocked-global-payroll-run-control\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,21,1],"tags":[],"class_list":["post-245","post","type-post","status-publish","format-standard","hentry","category-global-payroll","category-peoplesoft","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/comments?post=245"}],"version-history":[{"count":1,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/245\/revisions"}],"predecessor-version":[{"id":246,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/posts\/245\/revisions\/246"}],"wp:attachment":[{"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/media?parent=245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/categories?post=245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supportingelement.com\/index.php\/wp-json\/wp\/v2\/tags?post=245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}