By Luiz Lima - 3/9/2010
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
|
By Ivan George Borges - 3/9/2010
Hi Luiz!Does it work if you deploy it via DDT?
|
By Luiz Lima - 3/9/2010
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
|
By Luiz Lima - 3/9/2010
IvanI forgot something important: This is database is new (with no data!!) tks
|
By Luiz Lima - 3/9/2010
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
|
By Ivan George Borges - 3/10/2010
Glad you got it working, Luiz!  Abraços.
|
By Trent L. Taylor - 3/10/2010
Glad you got it going 
|
By Luiz Lima - 3/10/2010
Guys,
The error came back again
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
|
By Ivan George Borges - 3/10/2010
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.
|
By Luiz Lima - 3/10/2010
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
|
By Ivan George Borges - 3/10/2010
The first table in Deployment data is Security Roles, the content of this table aren´t in my target database. 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.
|
By Luiz Lima - 3/10/2010
Ivan,I deleted the tables and recreate them and did data package wizard also.
Nothing.. the same error! Look my attached images. Help!
|
By Ivan George Borges - 3/10/2010
Try deleting the structures as well and importing them back.
|
By Luiz Lima - 3/11/2010
Ivan,
I´ve already done it.. a lot of times...
I will workaround this problem importing NO DATA... meanwhile...Other question... Every time that I run my program or DDT, it reruns every changes on FK or Tables... this is taking some times....
I spent 3 minutes to deploy the changes into my database.
If I change the version number of DDT, what will happen? Tks again
|
By Trent L. Taylor - 3/12/2010
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.
|