StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Error while attempting to create package (event ID #1026)

Error while attempting to create package (event ID #1026)

Michel Levy — Fri, 12 Feb 2010 13:48:15 GMT

Hi,

I've got an error IndexOutOfRange during during the creation of a package.

what does it mean? what should I do?

RE: Error while attempting to create package (event ID #1026)

Michel Levy — Fri, 12 Feb 2010 13:48:15 GMT

Trent, Ivan

I'll try it tomorrow (8:45 PM here in France, :doze: )

RE: Error while attempting to create package (event ID #1026)

Trent L. Taylor — Fri, 12 Feb 2010 13:40:55 GMT

LOL...Ivan, print some for me!!!! :D

RE: Error while attempting to create package (event ID #1026)

Ivan George Borges — Fri, 12 Feb 2010 13:36:55 GMT

I would bet a million dollars the problem will be the table that you changed the structure of. Once I change the structure of a table that has a Deployment Data package, I delete that package and re-create the package.

OK, I've already started printing the money...

RE: Error while attempting to create package (event ID #1026)

Trent L. Taylor — Fri, 12 Feb 2010 12:29:17 GMT

Cool :cool:. So you might want to start working backwards to determine what deployment package item is causing the issue. Once isolated it will be far easier to diagnose as to what is going on.

RE: Error while attempting to create package (event ID #1026)

Michel Levy — Fri, 12 Feb 2010 11:49:33 GMT

Sorry for misunderstanding :blush:

You are right: without deployment data, no error occurs

RE: Error while attempting to create package (event ID #1026)

Trent L. Taylor — Fri, 12 Feb 2010 11:39:57 GMT

I know that it isn't happening on deployment. I was referring to Deployment Data. It failed when trying to package up the deployment data. Please confirm. Thanks.

RE: Error while attempting to create package (event ID #1026)

Michel Levy — Fri, 12 Feb 2010 11:31:11 GMT

Ivan,

yes, I've changed the structure of one table on SSMS (alter columns from integer to decimal), and wanted to check if I could do it with DDT. So I've done the same changes in DDT project.

Trent,

the error occurs on building the package, not on deployment. But having a look in my project, I can see that the indexes with more than 16 columns included have been imported. As we know now that there is a problem here, that index is probably the culprit. I'll have a try without this index.

RE: Error while attempting to create package (event ID #1026)

Ivan George Borges — Fri, 12 Feb 2010 11:03:23 GMT

Hi Michel.

Have you changed the structure of a table that already had a Deployment Data package created?

RE: Error while attempting to create package (event ID #1026)

Trent L. Taylor — Fri, 12 Feb 2010 10:51:29 GMT

Well, this looks to be happening in regards to your deployment data. If you build the package [u][b]without[/b][/u] including the deployment data, does the error persist? I am willing to bet, "no." In that case, you will want to take a closer look at your deployment data entries again and possible remove them and add them back one-by-one to see which was is the culprit. Most times when something like this happens, it is actually an issue at the time of gathering the data from the source.