|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
Hi SF Team, I am using DDT for the first time. I'm using version 1.6.5.3. After importing the database (SQL Server 2005), there are several stored procedures that are missing. What am I doing wrong? Thanks, Jeff
|
|
|
|
|
Dustin Taylor
|
|
|
Group: StrataFrame Users
Posts: 364,
Visits: 771
|
Do you have a SQL Server 2005 Express instance that you can put the StrataFrame database on? It looks as though the SF database is trying to be exist in SQL 2000 compatibility mode, which could be the issue. Could you move that over to a fresh SQLExpress instance and retry the install? That should give us a clean state rather than going back and forth trying to determine the differences in environment.
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
Hi Justin, I moved the Strataframe database to a new SQLExpress install on another machine. I attempted to run the strataframe installation on the machine with new SQLExpress install and I get the same error!  I have attached the Strataframe.mdf and ldf files for your inspection. I figure the next logical step is for you guys to look at the database to see why it is failing. Obviously I need to get this resolve, before I can run the DDT to import an existing database which was failing to import all of my stored procedures which started this support thread to begin with several days ago. I am anxious to get this fix so that I can start using DDT I purchased a couple of weeks ago for a current project I am working on. Thanks for you prompt attention to this matter. Jeff
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
Jeff, What is the error that you are getting? I would like to have any exceptions, etc. before looking at the attachment so that I have all of the facts in hand...thanks.
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
I have already sent you the Stratafame_results15.txt file on a previous post on this thread. http://forum.strataframe.net/FindPost18934.aspxThanks, Jeff
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
Well, Dustin actually gave you the answer you needed back on 9/5/2008. We attached your database to our local SQL Express and deployed and it failed with the sname error...so we went in to verify that you had set the DB to 2005 compatability mode and it worked. To fix it do the following: - Open up SQL Server Management Studio
- Right-Click on the Select the StrataFrame database
- Click on Properties
- Go to Options
- Set the Compatability Level to SQL Server 2005
- Click OK
- Now attempt to install again and the structures will update properly
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
That solved the problem. Now what about the DDT import issue that started this thread to begin with. The DDT does not import all of my stored procedures. I did take a look at them to see if there is any common characteristics among them that might stop them from importing in and I did not notice anything. As always thank you for the great support! Jeff
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
Honestly Jeff, I don't know what your issue would be on the stored procs if you are on the most recent version of the 1.6.6 beta. All seems to be imported as it should on this side. Make sure that you are on the most recent build and if the problem persists then I guess let us have the mdf and ldf of the database your are trying to import and we will try it on this side.
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
I apologize that it seems to be just me having these issues. As I said, I purchased the DDT to start using on this project and I am trying to use it for the first time. I have attached my database and the strataframe database for your testing. You guys do a great job in supporting your products and I truly appreciate your patience in helping me through this problem. Thank You, Jeff
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
Hi SF Team, What is the status on my DDT import issue? In my previous post I attached my database and the strataframe database for your testing as suggested. You will see my database is simple and small. Thanks, Jeff
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
This was a very strange scenario, but I have posted a fix. We are already starting to roll out new product for the 1.6.7 build, but since this was such a minor change and will not affect everyone, I thought I would just post the fix here. Here was the issue: To improve performance, the DDT would exit when enumerating stored procedures and UDFs when the first system object was found as system objects to not need to be imported. However, under certain, very rare circumstances, legitimate sprocs or UDFs may appear within the collection AFTER the system objects. This is highly unusual, but so as not to have this issue creep up again in the future and since the import is a process in which a developer does not live (as this is generally only done once per database) the lengthier process will be implemented. At any rate, download the attached file and just overwrite your existing databasedtk.exe file. This should be located in the c:\program files\MicroFour\StrataFrame folder.
|
|
|
|
|
Jeff Pagley
|
|
|
Group: StrataFrame Users
Posts: 223,
Visits: 893
|
Hi Trent, I am sure glad it was not me doing something wrong causing you guys a lot of unnecessary work and grief. Secondly, the patch worked!  Thank you, Jeff
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 6.9K
|
No problem....just glad it got you going.
|
|
|
|