{"id":12569,"date":"2017-10-16T22:19:52","date_gmt":"2017-10-17T05:19:52","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=12569"},"modified":"2020-11-03T17:08:11","modified_gmt":"2020-11-04T00:08:11","slug":"kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/","title":{"rendered":"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft."},"content":{"rendered":"<p><span style=\"color: #333333\"><strong>Applies to:\u00a0<\/strong>All versions of Ephesoft Transact<\/span><\/p>\n<h2><span style=\"color: #333333\"><strong>Issue<\/strong><\/span><\/h2>\n<p><span style=\"color: #333333\">SQL Server Express edition only has a 10 GB limit and is causing issues with Ephesoft.<\/span><\/p>\n<h2><span style=\"color: #333333\"><strong>Solution<\/strong><\/span><\/h2>\n<p><span style=\"color: #333333\">The following recommendations can be considered.<\/span><\/p>\n<p><span style=\"color: #333333\">1. Customer need to make sure that the clean up is executing successfully so that it can keep the most used table sizes in check. Please see the link below on how to clean up the Activiti tables and reporting service.<\/span><br \/>\n<span style=\"color: #333333\"><a style=\"color: #333333\" href=\"https:\/\/ephesoft.com\/docs\/kb0010063-manually-cleaning-the-activiti-table\">link<\/a><\/span><\/p>\n<p><span style=\"color: #333333\">2. Customer can point the reporting-archive database to a different database server or can execute a script to take a timely backup of the report_archive database and clear the report_archive database.<\/span><\/p>\n<p><span style=\"color: #333333\">3. Customer can increase the frequency of reporting purge operation by modifying the cron dcma.report.purging.cronExpression in dcma-reporting.properties which is by default set to execute after every 3 months. If you don&#8217;t need reporting data on UI older than 1 week, then they can set the purging cron to execute every weekend. This feature is only supported on Ephesoft v4.0.6.1 and above.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Applies to:\u00a0All versions of Ephesoft Transact Issue SQL Server Express edition only has a 10 GB limit and is causing [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12354],"tags":[1162,553,1163,1161,1430,157],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft. | 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=\"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft.\" \/>\n<meta property=\"og:description\" content=\"Applies to:\u00a0All versions of Ephesoft Transact Issue SQL Server Express edition only has a 10 GB limit and is causing [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-17T05:19:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-04T00:08:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/\",\"name\":\"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft. | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2017-10-17T05:19:52+00:00\",\"dateModified\":\"2020-11-04T00:08:11+00:00\",\"author\":{\"@id\":\"\"},\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft.\"}]},{\"@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\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft. | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft.","og_description":"Applies to:\u00a0All versions of Ephesoft Transact Issue SQL Server Express edition only has a 10 GB limit and is causing [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/","og_site_name":"Ephesoft Docs","article_published_time":"2017-10-17T05:19:52+00:00","article_modified_time":"2020-11-04T00:08:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/","url":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/","name":"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft. | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2017-10-17T05:19:52+00:00","dateModified":"2020-11-04T00:08:11+00:00","author":{"@id":""},"breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/kb0019347-sql-express-has-10-gigabytes-limit-which-can-cause-issues-with-ephesoft\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"KB0019347 \u2013 SQL Express has 10 gigabytes limit which can cause issues with Ephesoft."}]},{"@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":""}]}},"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/12569"}],"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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=12569"}],"version-history":[{"count":0,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/posts\/12569\/revisions"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=12569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/categories?post=12569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/tags?post=12569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}