DD returning false (?) positive

Rather, I think DD thinks there's nothing to do, but this is my scenario (files attached below):

I have three tables who relate to each other in the following way: one QUIZ has many QUIZ_QUESTIONs, each of which has many QUIZ_QUESTION_CHOICEs. So, I have my DB schema and when I run it, DD tells me within 1 second that it "completed". The micro log tells me that 19 records were inserted into iwdeltracker, and indeed they were. However, there is nothing in any of the tables.

Wassup?

Attached are the relevant part of my config, the DCR, and the micro log.

Dave

Find more posts tagged with

Comments

Bill Klish

Are you intending to run this in DAS mode, or is this a standalone deployment of DCR data?

From the microlog it looks like you are attempting to run in DAS mode instead of DD mode.

Your DD schema looks similar to what we have used before, so I would think that isn't the issue. It doesn't look like DD thinks anything should be put into the Quiz_Question_Choice table, but 3 inserts appear for the Quiz_Question table. Also, it thinks that the Quiz entry already exists, based on something in the IWDELTRACKER table. Did you have some previous deployments that failed and may have left some junk over in this table?

We have had better luck using the xml-source element instead of teamsite-templating-records in our configs. Not sure that is related here, but possibly worth a shot, although I am not sure what that does if you use DAS mode.

Your config defines a database entry that presumably is found in your database.xml file as ellegirl_development_db, that is being interpreted by DD to deploy into the database located at the URL: 10.4.5.96:1433?database=ellegirl. Since you see the data showing up I assume this is the correct one.

Nothing else jumps out at me after an initial glance.

Migrateduser

Thank you for your response and I apologize for not having followed-up with what I found to be a solution.

To sum up the dbschema, there are 3 tables:

quiz
quiz_question
quiz_question_choice

such that quiz_question_choice.question_id maps many to one quiz_question.question_id and quiz_question.quiz_id maps many to one quiz.quiz_id.

The problem with what I was trying to do is that quiz_question_choice.question_id was in a higher-level replicant than my other quiz_question_choice elements. So, it was giving me problems, i.e. false positives, when I tried to reference a different replicant set than the other elements in my schema group.

What I did was create a hidden field in the same replicant container as other quiz_question_choice elements, which I used FormAPI to populate based on certain events.

Now, it's working perfectly fine.

Thanks again.

Bill Klish

We tackled those types of issues using the value-from-callout approach, rather than form api. There is a bit more control and robustness in java vs. javascript.

Glad it is working.