{"id":2751,"date":"2015-01-19T17:10:29","date_gmt":"2015-01-19T17:10:29","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=2751"},"modified":"2020-08-12T09:38:22","modified_gmt":"2020-08-12T16:38:22","slug":"how-to-deleting-the-ephesoft-database-and-recreating-manually","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/","title":{"rendered":"Deleting the Ephesoft Database and Recreating it Manually"},"content":{"rendered":"

Issue<\/strong><\/span><\/h2>\n

Some situations may require you to start with a new Ephesoft environment. Rather than performing a complete uninstall and reinstall, you may be able to delete the database contents and start fresh.<\/span><\/p>\n

Important: <\/strong>This is recommended only for dev environments, as any production environments should be installed as cleanly as possible.<\/span><\/p>\n

Solution<\/strong><\/span><\/h2>\n

Perform the following steps to delete and manually recreate the Ephesoft database.<\/span><\/p>\n

    \n
  1. Stop Ephesoft Transact.<\/span><\/li>\n
  2. Take note of the database names and db_owner credentials for the following three databases:<\/span>\n
      \n
    • ephesoft<\/span><\/li>\n
    • report<\/span><\/li>\n
    • report_archive<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

      Note: <\/strong>If you lose the login credentials for the above databases, you will need to manually reconfigure the Ephesoft configuration files.<\/span><\/p>\n

        \n
      1. Delete the above three databases.<\/span><\/li>\n
      2. Recreate the databases with the following queries.<\/span><\/li>\n<\/ol>\n
        {path}\\Ephesoft\\Dependencies\\MsSQLSetup\\ephesoft-mssql-config.sql\r\n{path}\\Ephesoft\\Dependencies\\MySQLSetup\\ephesoft-mysql-config.sql<\/span><\/pre>\n
        Note<\/strong>: Ensure the database names match those in step 1. The above queries have a step for creating and associating credentials. Depending on your database policies, you may not want to use these queries. The query will error out on these lines if the user credentials already exist in the system.<\/span><\/p>\n
          \n
        1. Verify that the previous credentials noted in step 1 are reassociated or recreated.<\/span><\/li>\n
        2. Rename the serialized (.ser) files so Transact can perform database setup procedures. These files are located in SharedFolders\\database-update.<\/span><\/li>\n<\/ol>\n
          BatchClassUpdate.ser-executed to BatchClassUpdate.ser\r\nDependencyUpdate.ser-executed to DependencyUpdate.ser\r\nPluginConfigUpdate.ser-executed to PluginConfigUpdate.ser\r\nPluginUpdate.ser-executed to PluginUpdate.ser\r\nScannerConfigUpdate.ser-executed to ScannerConfigUpdate.ser<\/span><\/pre>\n
            \n
          1. Change the configuration flags.<\/span><\/li>\n<\/ol>\n
            {path}\\Ephesoft\\Application\\WEB-INF\\classes\\META-INF\\dcma-data-access\\dcma-db.properties\r\nupgradePatch.enable=true\r\n\r\n{path}\\Ephesoft\\Application\\WEB-INF\\classes\\META-INF\\dcma-workflows\\dcma-workflows.properties\r\nworkflow.deploy=true<\/span><\/pre>\n
              \n
            1. Start Ephesoft Transact.<\/span><\/li>\n<\/ol>\n
              Note: <\/strong>After Transact has restarted, the above .ser files should revert back to .ser-executed.<\/span><\/p>\n
                \n
              1. Verify the default batch classes have been created in the batch_class<\/strong> table in the ephesoft database.<\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
                Issue Some situations may require you to start with a new Ephesoft environment. Rather than performing a complete uninstall and […]<\/p>\n","protected":false},"author":54,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[361],"yoast_head":"\nDeleting the Ephesoft Database and Recreating it Manually | 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=\"Deleting the Ephesoft Database and Recreating it Manually\" \/>\n<meta property=\"og:description\" content=\"Issue Some situations may require you to start with a new Ephesoft environment. Rather than performing a complete uninstall and […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-19T17:10:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-12T16:38:22+00:00\" \/>\n<meta name=\"author\" content=\"lydiaxie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"lydiaxie\" \/>\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\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/\",\"name\":\"Deleting the Ephesoft Database and Recreating it Manually | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2015-01-19T17:10:29+00:00\",\"dateModified\":\"2020-08-12T16:38:22+00:00\",\"author\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1\"},\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deleting the Ephesoft Database and Recreating it Manually\"}]},{\"@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\/bca3e75d8d08163c3b26d530db9013d1\",\"name\":\"lydiaxie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g\",\"caption\":\"lydiaxie\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Deleting the Ephesoft Database and Recreating it Manually | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Deleting the Ephesoft Database and Recreating it Manually","og_description":"Issue Some situations may require you to start with a new Ephesoft environment. Rather than performing a complete uninstall and […]","og_url":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/","og_site_name":"Ephesoft Docs","article_published_time":"2015-01-19T17:10:29+00:00","article_modified_time":"2020-08-12T16:38:22+00:00","author":"lydiaxie","twitter_card":"summary_large_image","twitter_misc":{"Written by":"lydiaxie","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/","url":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/","name":"Deleting the Ephesoft Database and Recreating it Manually | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2015-01-19T17:10:29+00:00","dateModified":"2020-08-12T16:38:22+00:00","author":{"@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/bca3e75d8d08163c3b26d530db9013d1"},"breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/how-to-deleting-the-ephesoft-database-and-recreating-manually\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Deleting the Ephesoft Database and Recreating it Manually"}]},{"@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\/bca3e75d8d08163c3b26d530db9013d1","name":"lydiaxie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ephesoft.com\/docs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b98869ec848ba0d1f0d43297973b9cd7?s=96&r=g","caption":"lydiaxie"}}]}},"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/2751"}],"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\/54"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=2751"}],"version-history":[{"count":0,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/2751\/revisions"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=2751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/categories?post=2751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/tags?post=2751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}