StrataFrame Forum

Problem with DDT

http://forum.strataframe.net/Topic22494.aspx

By Rainer Kempf, RK - 3/27/2009

Hello Trent



Today i installed latest Beta-Version.



I want to create new Deployment Package



Then first error appears (error.gif)



i ignore and then want to deploy my Data



Here comes up also error (error1.gif)





what is wrong ?????



thank rainer
By Trent L. Taylor - 3/27/2009

I am not entirely sure what the error is saying after the IndexOutOfRange.  But I think that most likely your StrataFrame structures are not up to date or you have some old SF assemblies in the GAC that are being seen.  There is something out of sync otherwise this would not appear.  Try update your SF data structures through the install again.  If the error persists, then please provide more details.  Thanks.
By Rainer Kempf, RK - 3/27/2009

Hello Trent,



I reinstalled SF but error still exist.



Also Assembly are in right version.



Also for your Information little bug (Wrong tooltip in DDT)





Please help me.....



thanks

Rainer
By Rainer Kempf, RK - 3/27/2009

Hi Trent



Here again some Information of Logfile





• 28.03.2009 07:22:30-> Ensuring Triggers exist on database 'ERPSTAMM'

• 28.03.2009 07:22:30-> Trigger verification complete.

• 28.03.2009 07:22:30-> Ensuring Assemblies exist on database 'ERPSTAMM'

• 28.03.2009 07:22:30-> Assembly verification complete.

• 28.03.2009 07:22:30-> Ensuring Views, Stored Procedures, and UDFs exist on database 'ERPSTAMM'

• 28.03.2009 07:22:31-> View, Stored Procedure, and UDF verification complete.

• 28.03.2009 07:22:31-> Ensuring Indexes exist on database 'ERPSTAMM'

• 28.03.2009 07:22:31-> Index verification complete.

• 28.03.2009 07:22:31-> Deploying meta-data for database 'ERPSYSTEM'

• 28.03.2009 07:22:31-> Ensuring Filegroups exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:31-> Filegroup verification complete.

• 28.03.2009 07:22:31-> Ensuring Tables exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Table verification complete.

• 28.03.2009 07:22:34-> Dropping unneeded filegroups for 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Unneeded filegroups dropped on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Ensuring Indexes exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Index verification complete.

• 28.03.2009 07:22:34-> Ensuring Foreign Keys exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Foreign Key verification complete.

• 28.03.2009 07:22:34-> Ensuring Triggers exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Trigger verification complete.

• 28.03.2009 07:22:34-> Ensuring Assemblies exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:34-> Assembly verification complete.

• 28.03.2009 07:22:34-> Ensuring Views, Stored Procedures, and UDFs exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:35-> The view 'SFSUserPermissionInfo' was created successfully.

• 28.03.2009 07:22:35-> The view 'SFSUserRolePermissionInfo' was created successfully.

• 28.03.2009 07:22:35-> View, Stored Procedure, and UDF verification complete.

• 28.03.2009 07:22:35-> Ensuring Indexes exist on database 'ERPSYSTEM'

• 28.03.2009 07:22:35-> Index verification complete.

• 28.03.2009 07:22:35-> Finished verifying databases on server.

• 28.03.2009 07:22:35-> The meta data conversion to the SQL Server has been completed.

X 28.03.2009 07:22:37-> An error occurred while deploying the data to the server.

X 28.03.2009 07:22:37-> IndexOutOfRangeException

X 28.03.2009 07:22:37-> Der Index war außerhalb des Arraybereichs.

X 28.03.2009 07:22:37->

X 28.03.2009 07:22:37-> Source : MicroFour StrataFrame DBEngine

X 28.03.2009 07:22:37->

X 28.03.2009 07:22:37-> Stack Trace:

X 28.03.2009 07:22:37-> bei MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()

X 28.03.2009 07:22:37->

By Trent L. Taylor - 3/28/2009

I will get that tooltip fixed.  Thanks.

My German is a little rusty....so I am not entirely certain of the message. However, I would like to see if I can reproduce on this side so if possible, could you either post or send me the PKG file that is producing the error?  Thanks.

By Rainer Kempf, RK - 3/28/2009

Hello Trent



I send you the PGK file over PM



thanks



Rainer
By Trent L. Taylor - 3/30/2009

Something must be wrong with the package.  I cannot even download it.  Could you post it on an FTP, web, etc.?  Thanks.
By Trent L. Taylor - 3/30/2009

OK, there are a lot of issues with this package.  So let’s just start with the basics and then work through one at a time.  You most likely imported this table from an existing structure.  There are some errors in regards to this package and the existing structures as well.  For example, in the ERPLAGER database on the komissionsarchiv1 table, there is an index for a column that doesn’t exist.  When an import is done, it ignores errors and will save anyway.  This is done so that you can at least have a starting point to work from.

 

There were probably 80-100 errors past that.  Many were related to not having fields in indexes along with quit a few others.  But I think in this case you are going to be best off starting at the top and working through these one at a time.

By Rainer Kempf, RK - 3/30/2009

Hello Trent



i had Imported Database with Xcase



There was no errors. Strange.



But how you figured out all this problems. Do you have a tool to check such things ????



thank you



Rainer
By Trent L. Taylor - 3/30/2009

I just started looking at the errors ehan I deployed.  The very first one is that there is an index (on the table I mentioned) for a column that doesn't exist within the table.  So this means that where it came from had this error as well, it just may ignore it when deploying.