How to update my DDT package after latest update


Author
Message
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Yeah BigGrin



You've obviously never lived in California* Wink



This is when the apparent motion of Mercury appears to be going backwards, i.e. the opposite direction as the motion of the other planets. You have to view it for a night or two to see this. In astrology, if I remember correctly, it is a time when things are turned upside down in your life. For me it is more of a catchy phrase. When I wrote it, I didn't realize that Mercury is actually in retrograde right now! w00t



Do a quick search on Google for more info Hehe





* OK, I'm overstating/generalizing the state of mind of those living in the beautiful state of California...and it is beautiful. But there are lots of opened minded people there and this is were I learned about Mercury in retrograde, so there Tongue
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Mercury is probably in retrograde or something!

BigGrin

Is this some horoscope thing?

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Okey dokey...After looking at the DDT, the missing view on another SQL Server...I could see nothing wrong. So, I just deployed again...and it worked. Crazy



Mercury is probably in retrograde or something!



Thanks for you help guys!
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
LOL...sounds good Smile
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Before deploying them all back again, did you clear your DDT "Object Name History"?




Arg...those pesky history items (and I knew about that...really I did BigGrin ). There they were, in all their glory...all the entries for deleting the security tables. I removed them and it's working now BigGrin Good catch Ivan!



I have one more issue, which is one of my views not being distributed. I'm not sure why yet, but I can't figure it out...I'll be back!
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)Strategic Support Team Member (3.6K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Greg.

Before deploying them all back again, did you clear your DDT "Object Name History"?

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I'm not sure how this got so mangled.  Just for grins, if you deploy this to a new database instead of trying to update an existing one, does it get created?
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
OK, I removed all the SFS tables and views from my DDT profile. I then add security tables back in. There were no data packages listed at all. I was then able to create a package. I then attempted to deploy it to my dev server (thank god).



It removed ALL the SFS tables (bad), and SFS views. It then didn't add them back, and started pucking because there were no tables for the relationships or views.



Oh, I'm having fun.... Angry



I've attached the log file.
Attachments
RamsSecurity_results14.log.txt (184 views, 28.00 KB)
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.5K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Woah....yeah, I meant JUST from your DDT profile...NOT the server!!! Smile




Yeah, during my morning constitutional, the light bulb went off (mind clears in these moments). Tough day yesterday. I'm about to attempt removing them from the DDT. I'll let you know how it turns out.
Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
If I delete them (the security tables)...won't all the data be gone? Like all the permissions and roles?

Woah....yeah, I meant JUST from your DDT profile...NOT the server!!!  Smile

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search