StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » 1.6.5 DDT Issue

1.6.5 DDT Issue

Geoff Hirst — Thu, 21 Feb 2008 09:22:46 GMT

Chaps,

First up, yesterdays new beta drop doesn't seem to point to a file, it just opens a browser to your home page.

Next, the attached SP, can be entered into the DDT, but you can't then save it after modification. The error is that a truncation would occur. I hope you are able to replicate this.

thanks

Geoff

RE: 1.6.5 DDT Issue

Trent L. Taylor — Thu, 21 Feb 2008 09:22:46 GMT

[quote]I downloaded the latest drop and I still have the issue. So, if my SF DB has lost it's way, whats the best way to move forward and correct this?[/quote]

LOL...nicely put. Well, the first thing that I would do is either install another instance of SQL Server or install the StrataFrame.pkg file to another SQL Server you already have up (not the same SQL Server instance that it is current installed on). The ONLY reason that I would do this is to see if the issue persisted on the new database, if not then I know that my issue is with the structure, otherwise you can go down another path. You can then go into the StrataFrame -> Database Connection option in VS and add another connection to the new server, select it, go into the DDT, create a dummy profile, and see if you still have issues. I am fairly confident that this is your issue because I imported your view without any trouble whatsoever. The other thing I might try is to create a new profile (just a test dummy profile) and see if I could import that procedure....that might give us a clue as well.

RE: 1.6.5 DDT Issue

Geoff Hirst — Thu, 21 Feb 2008 08:27:19 GMT

Hi,

I downloaded the latest drop and I still have the issue. So, if my SF DB has lost it's way, whats the best way to move forward and correct this?

thanks

Geoff

RE: 1.6.5 DDT Issue

Trent L. Taylor — Wed, 20 Feb 2008 09:14:47 GMT

I reposted the update, but there had been a number of other people download it wihtout issue...one thing you might do is close down all other tabs in IE or FireFox and then try again...I have seen that do funny things before.

As for your SPROC...I know you don't want to hear this, but it worked just fine. It almost sounds as though your StrataFrame structure is wrong or has been changed because the only time that you generally see this message is when the text is longer than the field will allow...but we allow MAX on this (which would be over 2.1 GB). You can see the screen shot of the parsed fields within your view once I created the view in my test profile: