StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Error creating DD package

Error creating DD package

Michael Reese — Thu, 10 Jul 2008 08:19:15 GMT

I have been getting the following error when creating my DDT. It has not prevented me from completing my work but I would like to know what is happening? I am getting an IndexOutofRangeException Message stating that "There is no Row a Position 0.

How can I make it go away without blowing away my project work?

RE: Error creating DD package

Trent L. Taylor — Thu, 10 Jul 2008 08:19:15 GMT

Re-add the RBS tables to your package to ensure that the auditing structures get added. That should get rid of those errors.

RE: Error creating DD package

Michael Reese — Thu, 10 Jul 2008 06:56:37 GMT

Ok Thanks,

I went through the blow-away setup days which caused lots of redo. Could the following errors be causing the problem? I am getting errors when deploying the database tables relative to the AuditEvent Stored Procedures?

RE: Error creating DD package

Trent L. Taylor — Wed, 09 Jul 2008 18:22:28 GMT

Thanks for sharing your solution!

I am not sure why re-creating them got it fixed as we did not change anything on that end...but I am glad it fixed your package. We have some relatively complex data deployment packages within our medical app and everything seemed to be fine, but I appreciate your sharing this as it could be as simple as this if someone else is facing the same problem...though I would really like to know what caused that problem since this will be bugging me :crazy:

RE: Error creating DD package

Randy Jean — Wed, 09 Jul 2008 17:06:03 GMT

Just jumping in here... I'm having the same error when I choose to include deployment data which is just 2 simple tables. I checked authentication, etc.

Hmmmm... Why don't I just try blowing these away and re-creating their properties...

Yeah, that fixed it. Hope this helps. I'm guessing there were new options added in 1.6.6 that were not there when I set these up before.

- Randy

RE: Error creating DD package

Trent L. Taylor — Tue, 08 Jul 2008 09:59:43 GMT

OK...that makes more sense. Is sounds like you have an issue with one of your Data Deployment items. Check to make sure that your query, server and password, database from which you are pulling, etc. is correct. Also, if you are allowing the relationships to pull data from more than just itself (i.e. infinite, two deep, etc.) then that could be part of the problem as well...it would have something to do with the server from which is it pulling. To prove that, you would want to reduce this to None or One to only pull in the data for that one table. Try these items (since I cannot test that on my side with your data) and I am certain that one of these mentioned items will resolve your problem.

RE: Error creating DD package

Trent L. Taylor — Mon, 07 Jul 2008 16:55:33 GMT

Scroll down when you post and there is a section for attachments. You can attach it here or you can send me a PM (Private Message) with an attachment if you do not want to post it.

RE: Error creating DD package

Michael Reese — Mon, 07 Jul 2008 16:42:03 GMT

I'm feeling kind of dumb here. I never had to upload to you. Where do go to do that. I do not see a file attachment button anywhere?

RE: Error creating DD package

Trent L. Taylor — Mon, 07 Jul 2008 14:11:37 GMT

Well...there is really no way for me to determine that based on the stack trace and error message. If you can, send me the PKG file and I will see if I can reproduce it. That would be the best avenue so that I can see it in person.