DDT did not import all of the stored procedures

StrataFrame Forum

Back

DDT did not import all of the stored procedures

Author	Message
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 6.9K	No problem....just glad it got you going.
	Reply Like 1
Jeff Pagley	Jeff Pagley posted 16 Years Ago Post Details Share Post
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
	Reply Like 1
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
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. Attachments DatabaseDTK.zip (164 views, 975.00 KB)
	Reply Like 1
Jeff Pagley	Jeff Pagley posted 16 Years Ago Post Details Share Post
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
	Reply Like 1
Jeff Pagley	Jeff Pagley posted 16 Years Ago Post Details Share Post
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
	Reply Like 1
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
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.
	Reply Like 1
Jeff Pagley	Jeff Pagley posted 16 Years Ago Post Details Share Post
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
	Reply Like 1
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
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
	Reply Like 1
Jeff Pagley	Jeff Pagley posted 16 Years Ago Post Details Share Post
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.aspx Thanks, Jeff
	Reply Like 1
Trent Taylor	Trent Taylor posted 16 Years Ago Post Details Share Post
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.
	Reply Like 1