Trigger Deployment tr_Schema column not found


Author
Message
dgsoft
dgsoft
StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)
Group: StrataFrame Users
Posts: 93, Visits: 236
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.

Attachments
StrataFrameBug.JPG (184 views, 44.00 KB)
Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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. Smile Thanks.



dgsoft
dgsoft
StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)StrataFrame Novice (123 reputation)
Group: StrataFrame Users
Posts: 93, Visits: 236
Thanks for answer Smile Yes.. I post it before. just don't found it later Smile) I thought post was deleted
Rogerio Mauri
Rogerio Mauri
StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)StrataFrame User (251 reputation)
Group: StrataFrame Users
Posts: 205, Visits: 629
Problem continues in the last version.

Rogério Mauri Smile

Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
Keith Chisarik
Keith Chisarik
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
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.

Keith Chisarik
Keith Chisarik
Keith Chisarik
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
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.

Keith Chisarik
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (2.7K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I'm check into this.
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (2.7K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Did you check other places for errant DLLs? And just to check, you did update the StrataFrame db when doing the upgrade right?
Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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?

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