DDT did not import all of the stored procedures


Author
Message
Jeff Pagley
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
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

Replies
Jeff Pagley
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
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
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
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
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
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 (186 views, 975.00 KB)
Jeff Pagley
Jeff Pagley
Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)Advanced StrataFrame User (641 reputation)
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
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
No problem....just glad it got you going.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Jeff Pagley - 17 Years Ago
Greg McGuffey - 17 Years Ago
Jeff Pagley - 17 Years Ago
Greg McGuffey - 17 Years Ago
Jeff Pagley - 17 Years Ago
Dustin Taylor - 17 Years Ago
             Where do I find the log?
Jeff Pagley - 17 Years Ago
Dustin Taylor - 17 Years Ago
             I have attached the latest log.
Jeff Pagley - 17 Years Ago
Dustin Taylor - 17 Years Ago
Jeff Pagley - 17 Years Ago
Jeff Pagley - 17 Years Ago
Dustin Taylor - 17 Years Ago
Jeff Pagley - 17 Years Ago
Jeff Pagley - 17 Years Ago
Dustin Taylor - 17 Years Ago
Jeff Pagley - 17 Years Ago
Trent L. Taylor - 17 Years Ago
Jeff Pagley - 17 Years Ago
                         Well, Dustin actually gave you the answer you needed back on 9/5/2008....
Trent L. Taylor - 17 Years Ago
                             That solved the problem. Now what about the DDT import issue that...
Jeff Pagley - 17 Years Ago
                                 Honestly Jeff, I don't know what your issue would be on the stored...
Trent L. Taylor - 17 Years Ago
                                     I apologize that it seems to be just me havingthese issues. As I said,...
Jeff Pagley - 17 Years Ago
                                         Hi SF Team, What is the status onmy DDTimport issue? In my previous...
Jeff Pagley - 17 Years Ago
                                             This was a very strange scenario, but I have posted a fix. We are...
Trent L. Taylor - 17 Years Ago
                                                 Hi Trent, I am sure glad it was not me doing something wrong causing...
Jeff Pagley - 17 Years Ago
                                                     No problem....just glad it got you going.
Trent L. Taylor - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search