StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » DDT: An error occurred while creating a stored procedure

DDT: An error occurred while creating a stored procedure

Ralph Rutschmann — Tue, 19 Jun 2007 08:54:50 GMT

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

RE: DDT: An error occurred while creating a stored procedure

Trent L. Taylor — Tue, 19 Jun 2007 08:54:50 GMT

[quote]Will this have any side effects?[/quote]

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!

RE: DDT: An error occurred while creating a stored procedure

Ralph Rutschmann — Tue, 19 Jun 2007 06:28:56 GMT

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

RE: DDT: An error occurred while creating a stored procedure

Trent L. Taylor — Mon, 18 Jun 2007 08:32:59 GMT

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.