StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Impossible to package

Impossible to package

Tony Charpentier — Fri, 30 Nov 2012 09:51:31 GMT

Hi,

i try to add a new field in Table and i have this error message,

With the another table all is ok but just this table have the problem !

it's the field tmu_icone witch we try to add in the table. and we have test with other name
like "test" , "aaaa". No way it's doesn't work

if you have an idea , it' ll be appreciate ??

We have just install the last version 1.7.6.0

thanks
tony

RE: Impossible to package

Olivier — Fri, 30 Nov 2012 09:51:31 GMT

hello Ivan,

We have deploy several times and the error stayed always.
If Michel, we had not say , i know this error, you must to remove your deploy meta data,
the error was always here.

May be the DDT 2.0 ll catch this error to inform the user to destroy the data deployement.
And more if we can store in DDT our meta data stand alone without sql server, it'll be great.

thanks
Olivier,

RE: Impossible to package

Trent L. Taylor — Fri, 30 Nov 2012 09:47:04 GMT

Thanks for your help, guys!

RE: Impossible to package

Ivan George Borges — Fri, 30 Nov 2012 09:40:20 GMT

Aha! It looks like I was on the right track. :)

By the way, every time I change the structure to a table that has a deployment package, I simply run the DDT deployment twice. The first time I will get the error while creating the package, but then it updates the structure on the database and for the second time everything goes fine.

RE: Impossible to package

Michel Levy — Fri, 30 Nov 2012 08:43:16 GMT

Fixed :D

1st error: They didn't update the good SF database (another one on their LAN). Let's update the good one, and no more error when creating package, but still when deploying.
2nd error: the infamous #1026, because data to deploy refers to a modified table in structure deployment.

So we delete the data deployment in the profile to package, and all is ok now.

Maybe a warning in DDT would be fine, if one ask for deploy in the same package data and structure modifications for the same table.

RE: Impossible to package

Trent L. Taylor — Tue, 27 Nov 2012 16:12:41 GMT

Okay, sounds good Oliver. I am sure that Michel will get you going down the right path. :)

RE: Impossible to package

Olivier — Tue, 27 Nov 2012 15:43:47 GMT

Hello trent,

Tony work with me, and he send the package and save database to michel.

We wait the analyse's michel.

thanks
Olivier

RE: Impossible to package

Trent L. Taylor — Tue, 27 Nov 2012 13:14:59 GMT

Yeah, there is something in your environment. Can you do like Michel asked? I would like to look at the DDT package and possibly the StrataFrame database like Michel mentioned.

RE: Impossible to package

Tony Charpentier — Tue, 27 Nov 2012 09:53:38 GMT

Trent : i have this error when i deploy.

Ivan : i dont delete the table, i just add a field.
If i delete the last field create, i can deploy without problem.

thanks

RE: Impossible to package

Trent L. Taylor — Tue, 27 Nov 2012 09:20:31 GMT

Tony, are you getting this error when you click the "save" when modifying the table? Let me know when you get this error message. Thanks.

RE: Impossible to package

Ivan George Borges — Tue, 27 Nov 2012 09:16:10 GMT

Hi Tony.

Also, have you checked your Project's "Object Name History" node to see if you are deleting the table or something like it?

RE: Impossible to package

Michel Levy — Tue, 27 Nov 2012 05:53:26 GMT

Hello Tony,

on a new DDT project, I raise no error with your definiton
on your DDT project (this one you gave me during the training), I raise an error which is not related to this column. The strange issue is that the pkg file is created, and the definition of the column id_icone is well defined in the fields.xml inside the pkg.

Would you please send me (e-mail) the pkg file and a backup of your Strataframe database please?