StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



DDTExpand / Collapse
Author
Message
Posted 12/12/2006 5:18:39 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:36:26 PM
Posts: 371, Visits: 1,869
I'm having a problem with DDT. When I add a deployment package I'm able to create a package the first time I click on create package. However if I try to create a package more than once I get the following error. It's only happening on tables that I've added manually. The security tables added via the wizard are okay.

Post #5254
Posted 12/12/2006 6:20:07 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:36:26 PM
Posts: 371, Visits: 1,869
Another issue I've run into is that DDT doesn't seem to be able to deploy tables that contain timestamp columns. It trys to insert the timestamp value and hangs.
Post #5256
Posted 12/13/2006 8:09:46 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 1:09:23 PM
Posts: 2,686, Visits: 1,888
Hrm... yes, it should be skipping the timestamp columns... or inserting NULL.  I'll check into that.

On your first problem, what steps are you taking to reproduce the problem?  You said it happens on deployment data packages that you've already added, and then you're tring to add them a second time?


www.bungie.net
Post #5262
Posted 12/13/2006 5:45:55 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:36:26 PM
Posts: 371, Visits: 1,869

1.       Start with a profile that contains database and data deployment packages for the security tables only. Modify the security data deployment packages to extract all security records from my development application database.

2.       Everything works as it should; I can click on ‘create a package” as many times as I want and the package builds successfully.

3.       Add a new data deployment package that extracts data from a table in my development application database.

4.       Click on create package, package build is successful

5.       Click on create package a second time, the build fails with event ID: 1026

 

I just tried it again and I’m getting a different message.

 

-Larry

  Post Attachments 
DDTError1.png (33 views, 61.44 KB)

Post #5298
Posted 12/14/2006 2:24:06 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 9:49:13 AM
Posts: 4,798, Visits: 4,767
Larry,

I could not reproduce this so I recompiled the EXE to show the stack track in the message.  This should give us more information as to how to resolve the problem.  Just copy the EXE and the DLL to the following folder:

c:\program files\microfour\strataframe\

(You should see the existing files in this folder)

Overwrite them and run this again and then you can see the stack trace.  Let me have the stach trace and hopefully this will get us going in the right direction.  Thanks.

  Post Attachments 
DDT.zip (31 views, 812.77 KB)

Post #5306
Posted 12/14/2006 6:18:44 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:36:26 PM
Posts: 371, Visits: 1,869
Error message is attached,

  Post Attachments 
DDTEvent1026.png (32 views, 19.53 KB)
Post #5323
Posted 12/15/2006 9:20:54 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 9:49:13 AM
Posts: 4,798, Visits: 4,767
Larry,

It looks like this may be coming from your how your relationships are trying to gather the data.  The bottom line is that the foreign key table is being added to the collection more than once.  In other words, I think you have a relationship established that brings in a child table more than once.  You can get around this problem by changing the children levels and then manually bringing in the table causing the problem.

By default the children levels are set to infinite which will try to find all of the child relationships and bring in that data.  Reduce this number to prevent any overlapping of children tables....you may have to bring in the children tables by themselves.

Post #5324
Posted 12/15/2006 10:39:42 AM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: Yesterday @ 5:36:26 PM
Posts: 371, Visits: 1,869

Trent,

 

Setting the Children Levels to None eliminates the Event 1026 error. However the version of DDT you provided that includes the stack trace introduced the following error when you go to deploy the package.  

 

 

 

Reverting back to the 11/27/2006 compiled source code eliminates that issue. However there is still the problem of deploying data that includes a timestamp column.

 

 

-Larry

Post #5330