StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Errors creating package

Errors creating package

Greg McGuffey — Tue, 15 Apr 2008 10:09:16 GMT

I'm getting a 1026 message ID error when I try to create a package. It indicates there is "No row at position zero". Screen shot attached.

RE: Errors creating package

Trent L. Taylor — Tue, 15 Apr 2008 10:09:16 GMT

Ahhh...priorities. You need to set the view priorities since one relies on the other. This is a relatively new feature of the DDT. It will need to look like this:

I went ahead and made your profile work, so if you do this you should be in good shape.

[quote] Is there any way to set a folder for the file(s)?[/quote]

We are adding a new feature...literally as we speak here, that allows you to have pre and post scripts that execute. You would have to write a pre-script that sets the folder for you...which honestly I recommend against. This is a setting on the SQL Server side of things and when you start moving the MDF file locations...well...it becomes a full time job and your responsibility instead of SQL Servers. But if you have this need you will be able to set the folder location via a pre-execution script in the next update.

[quote]How do I get rid of the extra data (.mdf) file?[/quote]

If it is not in use, then just "smoke it" but if it IS in use, then you may have to detach it first. Again, this would need to be done via a script...or manually through the Management Studio.

RE: Errors creating package

Greg McGuffey — Mon, 14 Apr 2008 15:02:03 GMT

Also, I'm also having problems managing my filegroups. I just have one (PRIMARY), but in some cases, the file was not originally placed in the standard SQL server data folder, but in another folder. I just noticed that I now have two data files (plus a log file): my original and an updated one added by the DDT. So, two questions:

1. Is there any way to set a folder for the file(s)?
2. How do I get rid of the extra data (.mdf) file?

I sometimes wish learning all this stuff wasn't so painful :pinch:

Thanks!

RE: Errors creating package

Greg McGuffey — Mon, 14 Apr 2008 14:40:37 GMT

That helped, but still issues. It is barfing on the a couple of the SF security views, with this error:
[quote]X 4/14/2008 12:32:09 PM-> SqlException
X 4/14/2008 12:32:09 PM-> Invalid object name 'SFSUserPermissionInfo'.
X 4/14/2008 12:32:09 PM-> Invalid object name 'SFSUserRolePermissionInfo'.[/quote]

I'm attaching the package and the log file.

RE: Errors creating package

Trent L. Taylor — Mon, 14 Apr 2008 11:26:31 GMT

Greg,

Did you notice that the SFSAuditDataActions and SFSAutodDataFields are in your package twice? Just smoke one of them and see if the issue persists. I will check to see if I need to make an import change to prevent this from happening again in the future, but this is probably the crux of your issue.

RE: Errors creating package

Trent L. Taylor — Fri, 11 Apr 2008 20:28:12 GMT

You too,amigo :)

RE: Errors creating package

Greg McGuffey — Fri, 11 Apr 2008 19:49:21 GMT

Thanks Trent.

Have a good weekend!

RE: Errors creating package

Trent L. Taylor — Fri, 11 Apr 2008 19:34:15 GMT

I wil take a look at it. From looking at the log file it looks as though the security tables are not up to date....but I will run it and see if I can see what is going on.

RE: Errors creating package

Greg McGuffey — Fri, 11 Apr 2008 15:51:40 GMT

Here is the package. I haven't had a chance to check it out yet, but I'm pretty sure the issue with it attempting to delete the data file is because I have a mismatch between the actual file name and the template assigned to the file group. However, as mentioned, I still get errors when attempting to load this to a new db.

I also figured out were the log files are...in the same folder as the package file...doh! I've attached the log file from when I was creating a brand new database.

RE: Errors creating package

Trent L. Taylor — Wed, 09 Apr 2008 22:27:38 GMT

Hmmm...you might let me take a look at your package and try it on my side so I can see it live and in color :D

RE: Errors creating package

Greg McGuffey — Wed, 09 Apr 2008 12:36:41 GMT

OK, I deleted the data packages and then used the wizard to recreate the packages. After doing a bit of massaging to get them the way I like 'em, the package deployed nicely. :D

Next....:blink:

When deploying it, I get errors. When deploying to an existing db, I first get an error that it can't delete the file group...fortunately. (my history is completely clear and I'm using the $DbName$ token in the file group name). This is the case even if the name if the same as the db name in the DDT.

Then I get errors related to various items (PK, FK, views)...I'd post the log, but I can't find it :blush:

I tried to deploy it to a new db (using a new name), but it also errored out.

Probably the best would be to figure out were the log file is, then you could see the issues. Sooooooooo, were is that rascal?

RE: Errors creating package

Trent L. Taylor — Wed, 09 Apr 2008 09:30:22 GMT

LOL...Yeah, Ivan is right, there were some structure changes in the last update of the security. So that could be what is getting in the way, but generally you get a different error. But that is definitely a possibility.

RE: Errors creating package

Ivan George Borges — Tue, 08 Apr 2008 18:09:21 GMT

Yes, if I'm not mistaken the Security tables had a new field or something, so if you had the Security tables already in Deployment Data, that could be it. As Trent said, deleting the packages and generating them back again should do it. This boy is learning a lot... :D

RE: Errors creating package

Greg McGuffey — Tue, 08 Apr 2008 17:05:38 GMT

I'm just deploying permissions and roles (and associated links).

So, if SF made changes then yes. I haven't.

I about to do a meeting, then finish a bug fix...so I'll get back to this tomorrow am.

Thanks for the ideas!

RE: Errors creating package

Ivan George Borges — Tue, 08 Apr 2008 15:02:59 GMT

Hey Greg, have you changed the structure of a table that you already had in the Deployment Data node?

RE: Errors creating package

Trent L. Taylor — Tue, 08 Apr 2008 13:38:40 GMT

It looks like something may be fishy about your Deployment Data items. Just looking at the code and the stack trace isn't cluing me in as to what is causing the issue...other than it is possible that the error may be occuring due to a recursive call that attempts to get the children records based on the level specified...or the server cannot be accessed...or something along those lines.

You might try removing the deployment data items and adding them back one at a time to see where the error is coming from so that we can at least trouble shoot what is causing the error.