Problem with DDT


Author
Message
Rainer Kempf, RK
Rainer Kempf, RK
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: StrataFrame Users
Posts: 55, Visits: 1.4K
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

Attachments
Error.JPG (200 views, 55.00 KB)
error1.GIF (198 views, 21.00 KB)
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
Rainer Kempf, RK
Rainer Kempf, RK
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: StrataFrame Users
Posts: 55, Visits: 1.4K
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
Attachments
error2.GIF (206 views, 13.00 KB)
error3.GIF (197 views, 54.00 KB)
Rainer Kempf, RK
Rainer Kempf, RK
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: StrataFrame Users
Posts: 55, Visits: 1.4K
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->


Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.

Rainer Kempf, RK
Rainer Kempf, RK
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: StrataFrame Users
Posts: 55, Visits: 1.4K
Hello Trent



I send you the PGK file over PM



thanks



Rainer
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Something must be wrong with the package.  I cannot even download it.  Could you post it on an FTP, web, etc.?  Thanks.
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K

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.

Rainer Kempf, RK
Rainer Kempf, RK
StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)StrataFrame Novice (95 reputation)
Group: StrataFrame Users
Posts: 55, Visits: 1.4K
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
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search