{"id":43683,"date":"2020-02-12T17:09:23","date_gmt":"2020-02-13T00:09:23","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=43683"},"modified":"2022-06-22T13:44:29","modified_gmt":"2022-06-22T20:44:29","slug":"kb00010399-cleanup-issue-for-finished-batches-in-2019-1","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/","title":{"rendered":"Transact 2019.1 Cleanup Issue for FINISHED Batches"},"content":{"rendered":"

Environment<\/strong>:<\/p>\n

Ephesoft Transact 2019.1 on Windows with MSSQL database.<\/p>\n

Issue<\/strong>:<\/p>\n

There is an issue in Ephesoft Transact 2019.1 where the FINISHED batches in the Batch Instance Management screen do not get cleaned up using the CLEANUP job. The following error appears in the dcma-report-all.log<\/strong><\/p>\n

com.ephesoft.dcma.report.service.EtlServiceImpl \u2013 ess-sync_hist_manual_steps_in_workflow \u2013 An error occurred, processing will be stopped:\r\n\r\nCouldn't execute SQL : MERGE hist_manual_steps_in_workflow AS TARGET\r\n\r\nThe MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE\/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.<\/pre>\n
Solution<\/strong>:<\/p>\n
A Hotfix has been deployed to resolve this issue. Download the hotfix from the Customer Support Portal Downloads<\/a> page and follow the steps below to deploy:<\/p>\n
    \n
  1. Stop the Ephesoft Transact Service.<\/li>\n
  2. Download and extract the hotfix to a temporary location.<\/li>\n
  3. Navigate to the <ephesoft_home<\/em>>\\Application\\WEB-INF\\classes\\META-INF\\dcma-reporting\\Migration<\/strong><\/li>\n<\/ol>\n
    \u00a0 \u00a0 Note<\/strong>: Replace <ephesoft_home><\/em><\/strong> with the location where the Ephesoft Transact service is located.<\/p>\n
      \n
    1. Backup the existing .ktr file and delete the original.<\/li>\n
    2. Copy the backup .ktr file to the <ephesoft_home<\/em>>\\Application\\WEB-INF\\classes\\META-INF\\dcma-reporting\\Migration<\/strong><\/li>\n
    3. Navigate to the <ephesoft_home<\/em>>\\Application\\WEB-INF\\classes\\META-INF\\dcma-reporting\\Dashboard<\/strong><\/li>\n
    4. Backup the existing .ktr file and delete the original.<\/li>\n
    5. Copy the extracted .ktr file to <ephesoft_home<\/em>>\\Application\\WEB-INF\\classes\\META-INF\\dcma-reporting\\Dashboard<\/strong><\/li>\n
    6. Start the Ephesoft Transact service.<\/li>\n
    7. Verify that the batches in the FINISHED state no longer appear on the Batch Instance Management <\/strong>screen. If they are, then you have successfully applied the hotfix.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
      Environment: Ephesoft Transact 2019.1 on Windows with MSSQL database. Issue: There is an issue in Ephesoft Transact 2019.1 where the […]<\/p>\n","protected":false},"author":62,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12382],"tags":[10908,1430],"yoast_head":"\nTransact 2019.1 Cleanup Issue for FINISHED Batches | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transact 2019.1 Cleanup Issue for FINISHED Batches\" \/>\n<meta property=\"og:description\" content=\"Environment: Ephesoft Transact 2019.1 on Windows with MSSQL database. Issue: There is an issue in Ephesoft Transact 2019.1 where the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-13T00:09:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-22T20:44:29+00:00\" \/>\n<meta name=\"author\" content=\"Breanna Fitzgerald\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Breanna Fitzgerald\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/\",\"name\":\"Transact 2019.1 Cleanup Issue for FINISHED Batches | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2020-02-13T00:09:23+00:00\",\"dateModified\":\"2022-06-22T20:44:29+00:00\",\"author\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/d74c698404588430489bf05dfdf4bedd\"},\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact 2019.1 Cleanup Issue for FINISHED Batches\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/d74c698404588430489bf05dfdf4bedd\",\"name\":\"Breanna Fitzgerald\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e0624b0af4f5f3caa370053f6eef54c8?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e0624b0af4f5f3caa370053f6eef54c8?s=96&r=g\",\"caption\":\"Breanna Fitzgerald\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Transact 2019.1 Cleanup Issue for FINISHED Batches | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Transact 2019.1 Cleanup Issue for FINISHED Batches","og_description":"Environment: Ephesoft Transact 2019.1 on Windows with MSSQL database. Issue: There is an issue in Ephesoft Transact 2019.1 where the […]","og_url":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/","og_site_name":"Ephesoft Docs","article_published_time":"2020-02-13T00:09:23+00:00","article_modified_time":"2022-06-22T20:44:29+00:00","author":"Breanna Fitzgerald","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Breanna Fitzgerald","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/","url":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/","name":"Transact 2019.1 Cleanup Issue for FINISHED Batches | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2020-02-13T00:09:23+00:00","dateModified":"2022-06-22T20:44:29+00:00","author":{"@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/d74c698404588430489bf05dfdf4bedd"},"breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/kb00010399-cleanup-issue-for-finished-batches-in-2019-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact 2019.1 Cleanup Issue for FINISHED Batches"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/d74c698404588430489bf05dfdf4bedd","name":"Breanna Fitzgerald","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e0624b0af4f5f3caa370053f6eef54c8?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e0624b0af4f5f3caa370053f6eef54c8?s=96&r=g","caption":"Breanna Fitzgerald"}}]}},"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/43683"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/users\/62"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=43683"}],"version-history":[{"count":4,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/43683\/revisions"}],"predecessor-version":[{"id":51401,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/43683\/revisions\/51401"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=43683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/categories?post=43683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/tags?post=43683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}