<?xml-stylesheet type="text/xsl" href="https://community.appian.com/cfs-file/__key/system/syndication/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Generation</title><link>/b/appmarket/posts/database-load-generation</link><description>Overview 
 This tool can be used to quickly generate multiple rows for each of the application transactional tables to easily support database load testing. 
 Key Features &amp;amp; Functionality 
 
 Reads database metadata to automatically pull tables and columns</description><dc:language>en-US</dc:language><generator>Telligent Community 12</generator><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Sun, 15 Feb 2026 09:41:43 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>vigneshkumarradhakrishnan</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Latest Appian Record have the Generate Data Feature, what is the difference between the&amp;nbsp;&lt;span&gt;Latest Appian Record Generate Sample Data vs&amp;nbsp;this application&lt;/span&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Fri, 28 Feb 2025 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.2.2 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added more error logging.&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Fri, 07 Feb 2025 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v&lt;/strong&gt;&lt;strong&gt;2.2.1 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;&lt;span&gt;Bug fixes&lt;/span&gt;&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Fri, 31 Jan 2025 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v&lt;/strong&gt;&lt;strong&gt;2.2.0 Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added check for identity columns in SQL Server, updates to base application&lt;/li&gt;&lt;/ul&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Wed, 27 Mar 2024 08:28:07 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>ramyap826</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;Hi team,&lt;/p&gt;
&lt;p&gt;We are trying Data Generation App and have come across the below error.&lt;/p&gt;
&lt;p&gt;&lt;img height="115" src="/resized-image/__size/744x230/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1711527807764v1.png" width="372" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;Database - SQL Server&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Also , Is the tool compatible with SQL Server ?&lt;/p&gt;
&lt;p&gt;There are system Stored procedures used in the tool like (sp_MSforeachtable and dependent SPs) that are not available in SQL Server built-ins. So, we created custom SP. When running the Data Generation smart service got above error .&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Do you have any advice on how to resolve this error?&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Ramya&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Fri, 22 Mar 2024 22:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.1.0 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Fixed deprecated api with latest sdk&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Wed, 07 Feb 2024 23:00:00 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.0.3 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added a license file&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Tue, 05 Dec 2023 20:18:11 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>juergeng0002</dc:creator><slash:comments>0</slash:comments><description>&lt;p&gt;Hi Michael,&lt;br /&gt;When running the SQL Script for MariaDB to create the tables/procedures we are seeing the following error message:&lt;br /&gt;&lt;br /&gt;&lt;span&gt;&lt;span class="ui-provider ed cek brs cel cem cen ceo cep ceq cer ces cet ceu cev cew cex cey cez cfa cfb cfc cfd cfe cff cfg cfh cfi cfj cfk cfl cfm cfn cfo cfp cfq" dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;SQL Error [1064] [42000]: (conn=1263934) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &amp;#39;SET AUTOCOMMIT = 0;&lt;br /&gt; START TRANSACTION;&lt;br /&gt; SET time_zone = &amp;quot;+00:00&amp;quot;;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;DELIMIT...&amp;#39; at line 2&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Error position: line: 1&lt;/p&gt;
&lt;p&gt;Any advice or hint how to fix, or with which version of MariaDB the script is compatible with?&lt;br /&gt;&lt;br /&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Juergen&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Wed, 19 Jul 2023 22:00:55 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.0.2 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Bug Fixes:&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Add localization to DG Generate Data model&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Fix db script to remove DEFINER&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Fix 1.2.X to 2.0.0 upgrade zip&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Adding missing datetime2 to sqlserver script&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Tue, 11 Jul 2023 04:01:20 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>arkapravam8762</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;&lt;img src="/resized-image/__size/640x480/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1689047881495v2.png" alt=" " /&gt;&lt;/p&gt;
&lt;p&gt;Hi,&lt;br /&gt;&lt;br /&gt;Can you please tell, what will be the next steps to initiated the data generation app after installing the Data Generation as a plugin ?&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Fri, 31 Mar 2023 05:08:28 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>bernardw</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;Hi team,&lt;/p&gt;
&lt;p&gt;We are utilising the Data Generation App and have come across the below error when selecting &amp;#39;BUSINESS - ID Next Value - Fill with the next available primary key.&lt;/p&gt;
&lt;p&gt;&lt;span&gt;No enum constant com.appiancorp.ps.plugins.datageneration.generators.GeneratorType.IDNEXT&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Do you have any advice on how to resolve this error?&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Cheers,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;Bernie&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img height="21" src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1680239321605v1.png" width="320" alt=" " /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1680239329556v2.png" alt=" " /&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&lt;img src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1680239335729v3.png" alt=" " /&gt;&lt;/span&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Thu, 09 Feb 2023 22:59:10 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.0.1 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;- Added en_GB locale to process models missing localization&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Mon, 06 Feb 2023 02:47:03 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>davidj0006</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;I have just installed the Data Generation app and wanted to let others know of an issue I managed to get around. We are running with GB locale, and I think anyone else wih this locale will have the same issue I had. Two of the Process Models in the zip were invalid and prevented the import completing. The names for process models with guids 0002e471-1998-8000-fd81-024d98024d98 and&amp;nbsp;0002e982-5049-8000-418b-014d98014d98 were empty for GB locale. I edited the xml files and copied the US locale names into the empty &amp;lt;value&amp;gt; tags for GB, updated the zip, and it then imported successfully.&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Tue, 31 Jan 2023 22:59:07 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>Appian AppMarket</dc:creator><slash:comments>0</slash:comments><description>&lt;div&gt;&lt;strong&gt;v2.0.0 &lt;/strong&gt;&lt;strong&gt;Release Notes&lt;/strong&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;New Features:&lt;/div&gt;&lt;ul&gt;&lt;li&gt;App updated to 22.3&lt;/li&gt;&lt;li class="ql-indent-1"&gt;  Now uses OOTB execute stored procedure&lt;/li&gt;&lt;li class="ql-indent-1"&gt;  UX enhancements&lt;/li&gt;&lt;li&gt;New Generators&lt;/li&gt;&lt;li class="ql-indent-1"&gt;Next available primary key&lt;/li&gt;&lt;li class="ql-indent-1"&gt;UUID&lt;/li&gt;&lt;li&gt;Postgres Support&lt;/li&gt;&lt;li&gt;Support generating to multiple data sources&lt;/li&gt;&lt;li&gt;Updated documentation&lt;/li&gt;&lt;li&gt;Added process to re-sync records after data generation&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;Bug Fixes:&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Added more comprehensive generator errors&lt;/li&gt;&lt;li&gt;Run a delete on a table without inserting data&lt;/li&gt;&lt;li&gt;Fixed mariadb issue with too a table with too many columns&lt;/li&gt;&lt;li&gt;Fixed re-enabling of constraints after data generation&lt;/li&gt;&lt;li&gt;Issue with preview not updating&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item><item><title>RE: Data Generation</title><link>https://community.appian.com/b/appmarket/posts/database-load-generation</link><pubDate>Mon, 21 Nov 2022 05:27:39 GMT</pubDate><guid isPermaLink="false">d3a83456-d57b-489c-a84c-4e8267bb592a:91a9a3ce-0fe1-44ef-bcfa-fca6046139cf</guid><dc:creator>karlbrentsantos</dc:creator><slash:comments>1</slash:comments><description>&lt;p&gt;Hello I&amp;#39;ve been having issues here where it cannot get the tables any idea on how to fix it? I&amp;#39;ve also added the two procedure DG_GetTableColumns and DG_GetTable&lt;/p&gt;
&lt;p&gt;&lt;span class="mceItem mceNonEditable mceInsertMediaItem mceInsertMediaItem mceInsertMediaItemImage" id="pastedimage1669008449870v2"&gt;...&lt;/span&gt;&lt;img src="/resized-image/__size/320x240/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-91a9a3ce-0fe1-44ef-bcfa-fca6046139cf/pastedimage1669008455834v3.png" alt=" " /&gt;&lt;/p&gt;&lt;img src="https://community.appian.com/aggbug?PostID=2380&amp;AppID=50&amp;AppType=Weblog&amp;ContentType=0" width="1" height="1"&gt;</description></item></channel></rss>