﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum / StrataFrame Database Deployment Toolkit / Database Deployment Toolkit (How do I?)  / DDT: An error occurred while creating a stored procedure / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>forum@strataframe.net</webMaster><lastBuildDate>Fri, 29 Aug 2008 19:30:05 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: DDT: An error occurred while creating a stored procedure</title><link>http://forum.strataframe.net/Topic9634-11-1.aspx</link><description>[quote]Will this have any side effects?[/quote]&lt;/P&gt;&lt;P&gt;No, you should be OK here, but I will look into why you were having an issue.  I think your messaging package may be out of date and the new update should resolve that issue.  At any rate, glad you got it working!</description><pubDate>Tue, 19 Jun 2007 08:54:50 GMT</pubDate><dc:creator>Trent L. Taylor</dc:creator></item><item><title>RE: DDT: An error occurred while creating a stored procedure</title><link>http://forum.strataframe.net/Topic9634-11-1.aspx</link><description>Hello Trent,&lt;br&gt;&lt;br&gt;it seems i got it.&lt;br&gt;I included the messaging tables into my database. I didn't know that there are some "Table Properties" to tweak, so I did let them untouched.&lt;br&gt;&lt;br&gt;Whilst checking the differences between all tables, because of 14 tables included the messaging tables, but only two error messages at the log, I detected that for the messaging tables on the property sheet the "create INSERT stored procedure" was checked.&lt;br&gt;&lt;br&gt;After unchecking the "create INSERT stored procedure" for the messaging tables, no errormessage there.&lt;br&gt;&lt;br&gt;Will this have any side effects?&lt;br&gt;&lt;br&gt;Thanks and friendly greetings,&lt;br&gt;&lt;br&gt;Ralph</description><pubDate>Tue, 19 Jun 2007 06:28:56 GMT</pubDate><dc:creator>Ralph Rutschmann</dc:creator></item><item><title>RE: DDT: An error occurred while creating a stored procedure</title><link>http://forum.strataframe.net/Topic9634-11-1.aspx</link><description>I am having some trouble understanding the German text :) .... but I think that you are running into a Default value error.  If you have a table that is already deployed and has data then you add a column and do not allow NULL or do not specify a default value, you will receive an error.  I think this is what you are running into :)  Let me know if this does not fix your problem and then I will have to translate some of the German text for me.  Thanks.</description><pubDate>Mon, 18 Jun 2007 08:32:59 GMT</pubDate><dc:creator>Trent L. Taylor</dc:creator></item><item><title>DDT: An error occurred while creating a stored procedure</title><link>http://forum.strataframe.net/Topic9634-11-1.aspx</link><description>Hi,&lt;br&gt;&lt;br&gt;at the end of the deployment process I get a log with some errors. See attachment please.&lt;br&gt;&lt;br&gt;What do I have to do?&lt;br&gt;&lt;br&gt;TIA,&lt;br&gt;&lt;br&gt;Ralph</description><pubDate>Mon, 18 Jun 2007 02:41:48 GMT</pubDate><dc:creator>Ralph Rutschmann</dc:creator></item></channel></rss>