StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Trigger Deployment tr_Schema column not found

RE: Trigger Deployment tr_Schema column not found

Trent L. Taylor — Tue, 06 Jul 2010 18:06:43 GMT

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?

Trigger Deployment tr_Schema column not found

dgsoft — Tue, 06 Jul 2010 18:06:43 GMT

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.

RE: Trigger Deployment tr_Schema column not found

Greg McGuffey — Tue, 06 Jul 2010 17:50:43 GMT

Did you check other places for errant DLLs? And just to check, you did update the StrataFrame db when doing the upgrade right?

RE: Trigger Deployment tr_Schema column not found

Greg McGuffey — Tue, 06 Jul 2010 17:35:09 GMT

I'm check into this.

RE: Trigger Deployment tr_Schema column not found

Keith Chisarik — Tue, 06 Jul 2010 12:18:46 GMT

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.

RE: Trigger Deployment tr_Schema column not found

Keith Chisarik — Tue, 06 Jul 2010 11:13:40 GMT

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.

RE: Trigger Deployment tr_Schema column not found

Trent L. Taylor — Mon, 30 Nov 2009 07:43:44 GMT

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.

RE: Trigger Deployment tr_Schema column not found

Rogerio Mauri — Sun, 29 Nov 2009 12:10:04 GMT

Problem continues in the last version.

RE: Trigger Deployment tr_Schema column not found

dgsoft — Mon, 15 Jun 2009 08:05:35 GMT

Thanks for answer :) Yes.. I post it before. just don't found it later :)) I thought post was deleted

RE: Trigger Deployment tr_Schema column not found

Trent L. Taylor — Mon, 15 Jun 2009 06:47:54 GMT

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: [url=http://forum.strataframe.net/FindPost23424.aspx]http://forum.strataframe.net/FindPost23424.aspx[/url].

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