StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Trigger Deployment tr_Schema column not found...Expand / Collapse
Author
Message
Posted 06/15/2009 5:22:49 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 07/16/2010 3:09:01 AM
Posts: 83, Visits: 164
Hi,
I have a problem with Trigger Deployment. I'v got an error message Column tr?Schema not found in table DBETriggers. I had check this table. column is not there.
I check support messages before and Uninstall StrataFrame and Install it again. It does not help.. the error message in any case appears.


  Post Attachments 
StrataFrameBug.JPG (81 views, 44.92 KB)
Post #23487
Posted 06/15/2009 6:47:54 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 07/06/2010 6:04:33 PM
Posts: 6,275, Visits: 6,165
We saw this come up at several locations on the 1.6.7 build. However, through testing, we already know that the 1.7 build coming out will resolve the error. Until then, just add the tr_Schema field back to the DBETriggers table manually as an NVARCHAR(20) column. You had already posted your issue here: http://forum.strataframe.net/FindPost23424.aspx.

Just FYI, there is no reason to cross post. One place is good enough as we get notifications regardless of post location. Thanks.

Post #23488
Posted 06/15/2009 8:05:35 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 07/16/2010 3:09:01 AM
Posts: 83, Visits: 164
Thanks for answer Yes.. I post it before. just don't found it later ) I thought post was deleted
Post #23495
Posted 11/29/2009 12:10:04 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: 06/12/2010 2:27:20 PM
Posts: 149, Visits: 513
Problem continues in the last version.

Rogério Mauri
http://blog.licitec.com.br
Post #25295
Posted 11/30/2009 7:43:44 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 07/06/2010 6:04:33 PM
Posts: 6,275, Visits: 6,165
What version did you try? You may want to make sure that you do not have older SF assemblies in the GAC as this issue has been resolved and is working.
Post #25301
Posted 07/06/2010 11:13:40 AM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 11:19:02 AM
Posts: 867, Visits: 39,067
I am running 1.7.0.7 and just came across this issue, again. Have verified that all assemblies in the GAC are correct. Please advise.
Post #27610
Posted 07/06/2010 12:18:46 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 11:19:02 AM
Posts: 867, Visits: 39,067
PS - adding the field manually worked fine as it has in the past, but if this has been fixed I would like to know why I ran across it.
Post #27611
Posted 07/06/2010 5:35:09 PM
Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Developers
Last Login: Today @ 9:58:04 AM
Posts: 1,836, Visits: 5,608
I'm check into this.
Post #27617
Posted 07/06/2010 5:50:43 PM
Strategic Support Team Member

Strategic Support Team Member

Group: StrataFrame Developers
Last Login: Today @ 9:58:04 AM
Posts: 1,836, Visits: 5,608
Did you check other places for errant DLLs? And just to check, you did update the StrataFrame db when doing the upgrade right?
Post #27618
Posted 07/06/2010 6:06:43 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 07/06/2010 6:04:33 PM
Posts: 6,275, Visits: 6,165
Keith,

The only way that I could see this happening is if there was an older StrataFrame.PKG file and/or assembly that was run against the SF database.  This is the ONLY way I see this happening.  I have checked the distribution several times and it is working.

If you install to a fresh database (new SF installation), does the column get created?

Post #27619
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Trent L. Taylor, Steve L. Taylor, Dustin Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 11:28am

Powered by InstantForum.NET v4.1.4 © 2010
Execution: 0.094. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.