|
Trent Taylor
|
|
|
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.
|
|
|
|
|
Rainer Kempf, RK
|
|
|
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
|
|
|
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.
|
|
|
|
|
Trent Taylor
|
|
|
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.
|
|
|
|
|
Rainer Kempf, RK
|
|
|
Group: StrataFrame Users
Posts: 55,
Visits: 1.4K
|
Hello Trent
I send you the PGK file over PM
thanks
Rainer
|
|
|
|
|
Trent Taylor
|
|
|
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
|
|
|
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->
|
|
|
|
|
Rainer Kempf, RK
|
|
|
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
|
|
|
|
|
Trent Taylor
|
|
|
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
|
|
|
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
|
|
|
|