StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » DatabaseMigratorClass Error

DatabaseMigratorClass Error

Luiz Lima — Fri, 12 Mar 2010 09:17:37 GMT

Hi,

I´ve copied and made changes in the SampleDataInstaller program and everything was working ok, but at the end of process I´ve got an error (showed in attachment image).
I think that is related to my FKs???

Any help?

Tks

RE: DatabaseMigratorClass Error

Trent L. Taylor — Fri, 12 Mar 2010 09:17:37 GMT

The version number in the DDT is not used. It is for reference only. The error is coming from one of two places:

1. The location from which the data is being imported doesn't match the expected output. In other words, there are fields in the deployment data that are or are not in your deployed structures.

2. You application is passing in a deployment package as part of the migration that doesn't exist.

You are welcome to post a sample reproducing the issue, but you will need to include your deployment source as well as the PKG file that causes the issue. Otherwise we will most likely continue to go around and around and not get anywhere.

RE: DatabaseMigratorClass Error

Luiz Lima — Thu, 11 Mar 2010 07:06:17 GMT

Ivan,

I´ve already done it.. a lot of times...
I will workaround this problem importing NO DATA... meanwhile...

RE: DatabaseMigratorClass Error

Ivan George Borges — Wed, 10 Mar 2010 18:12:20 GMT

Try deleting the structures as well and importing them back.

RE: DatabaseMigratorClass Error

Luiz Lima — Wed, 10 Mar 2010 17:06:10 GMT

Ivan,

I deleted the tables and recreate them and did data package wizard also.
Nothing.. the same error!

Look my attached images.

Help!

RE: DatabaseMigratorClass Error

Ivan George Borges — Wed, 10 Mar 2010 15:59:14 GMT

[quote]The first table in Deployment data is Security Roles, the content of this table aren´t in my target database.[/quote]

Just checking... are you using the Role Base Security? I assume you are, and if so, have you imported the Security Tables structures into your DDT project? You see them listed under Tables? They all start with a SFS prefix.

Again, assuming you have, maybe your Security Tables Deployment Packages have an old version of the structures or something, so you could try deleting all Security Tables Deployment Packages and adding them back.

RE: DatabaseMigratorClass Error

Luiz Lima — Wed, 10 Mar 2010 13:25:02 GMT

Ivan,

I already done it!
Isolating pass by pass, I´ve got that the problem is related to Security tables. (the rest works fine)
The first table in Deployment data is Security Roles, the content of this table aren´t in my target database.

Any Idea?

Tks

RE: DatabaseMigratorClass Error

Ivan George Borges — Wed, 10 Mar 2010 12:38:38 GMT

Hey Luiz.

Wouldn't you like to try and isolate the problem? Maybe, you could start with a simple project with one simple table and run the whole process with that, so you could see at least if you get it working. Then you could add other tables until you start getting the error. That could give you a hint of where you need to dig deeper.

RE: DatabaseMigratorClass Error

Luiz Lima — Wed, 10 Mar 2010 12:23:19 GMT

Guys,

The error came back again:crying:
The whole process works fine, but at the end, when DataDeployment will start, the system crash with the same error.
It can be occurs because Security Tables?

Tks again

RE: DatabaseMigratorClass Error

Trent L. Taylor — Wed, 10 Mar 2010 08:27:30 GMT

Glad you got it going :)

RE: DatabaseMigratorClass Error

Ivan George Borges — Wed, 10 Mar 2010 06:50:28 GMT

Glad you got it working, Luiz! ;)

Abraços.

RE: DatabaseMigratorClass Error

Luiz Lima — Tue, 09 Mar 2010 20:22:08 GMT

Ivan

I´ve got it!
I unchecked the option "Checking existing data on Creation or Re-enabling" and also, I checked the whole FK on my DDT.

Tks a lot

RE: DatabaseMigratorClass Error

Luiz Lima — Tue, 09 Mar 2010 14:31:24 GMT

Ivan

I forgot something important: This is database is new (with no data!!)

tks

RE: DatabaseMigratorClass Error

Luiz Lima — Tue, 09 Mar 2010 14:29:28 GMT

Ivan,

I can´t run DDT under this database because it is in the same server of Database´s Profile.
When I run database´s profile with DDT, I got foreign key error, but this error means about a table with data related to another.
Can I turn on a debug?

Tks

RE: DatabaseMigratorClass Error

Ivan George Borges — Tue, 09 Mar 2010 14:02:27 GMT

Hi Luiz!

Does it work if you deploy it via DDT?