DDT: An error occurred while creating a stored procedure
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



DDT: An error occurred while creating a...Expand / Collapse
Author
Message
Posted 06/18/2007 2:41:48 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 8:21:39 AM
Posts: 46, Visits: 1,201
Hi,

at the end of the deployment process I get a log with some errors. See attachment please.

What do I have to do?

TIA,

Ralph


  Post Attachments 
BA_results3.txt (7 views, 7.33 KB)
Post #9634
Posted 06/18/2007 8:32:59 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 9:36:54 PM
Posts: 4,200, Visits: 4,251
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.
Post #9636
Posted 06/19/2007 6:28:56 AM


StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: Yesterday @ 8:21:39 AM
Posts: 46, Visits: 1,201
Hello Trent,

it seems i got it.
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.

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.

After unchecking the "create INSERT stored procedure" for the messaging tables, no errormessage there.

Will this have any side effects?

Thanks and friendly greetings,

Ralph
Post #9647
Posted 06/19/2007 8:54:50 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 9:36:54 PM
Posts: 4,200, Visits: 4,251
Will this have any side effects?

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!

Post #9648
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 1:31am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 11 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.