StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Problem with DDT

Problem with DDT

Rainer Kempf, RK — Mon, 30 Mar 2009 10:05:58 GMT

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

RE: Problem with DDT

Trent L. Taylor — Mon, 30 Mar 2009 10:05:58 GMT

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.

RE: Problem with DDT

Rainer Kempf, RK — Mon, 30 Mar 2009 09:37:29 GMT

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

RE: Problem with DDT

Trent L. Taylor — Mon, 30 Mar 2009 08:37:03 GMT

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.

RE: Problem with DDT

Trent L. Taylor — Mon, 30 Mar 2009 08:15:03 GMT

Something must be wrong with the package. I cannot even download it. Could you post it on an FTP, web, etc.? Thanks.

RE: Problem with DDT

Rainer Kempf, RK — Sat, 28 Mar 2009 18:47:11 GMT

Hello Trent

I send you the PGK file over PM

thanks

Rainer

RE: Problem with DDT

Trent L. Taylor — Sat, 28 Mar 2009 10:17:55 GMT

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.

RE: Problem with DDT

Rainer Kempf, RK — Sat, 28 Mar 2009 01:27:32 GMT

Hi Trent

Here again some Information of Logfile

[codesnippet]
• 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->
[/codesnippet]

RE: Problem with DDT

Rainer Kempf, RK — Sat, 28 Mar 2009 01:16:58 GMT

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

RE: Problem with DDT

Trent L. Taylor — Fri, 27 Mar 2009 17:21:36 GMT

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.