Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: 8.1 SNC02 Trigger Issue

Thanks Paul, my ultimate concern would be something like Replace Data, Imports etc. all starting to fail due to the triggers now in place. Things may start to get a bit messy & quickly with sites if they don't realise the impact if the triggers.
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC02 Trigger Issue

[ Edited ]

Thanks Paul!

 

Since the vast majority of folks do not have X3.. then which ones can we safely shut down (and not turn on again)..?

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 79
Registered: ‎06-25-2009

Re: 8.1 SNC02 Trigger Issue

The Account triggers are currently only use by X3.  All others are needed for Outlook and Google Integrations.

 

Thanks

Paul Zeimet
Development Manager
Infor CRM
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC02 Trigger Issue

Thanks Paul,

 It's important that we group the triggers so that we can shut down all the ones that do not apply to a given installation.

 

Is there a further break between Google and Outlook integrations?

 

Also.. I assume the EL (current ones) were not included.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 79
Registered: ‎06-25-2009

Re: 8.1 SNC02 Trigger Issue

RJ, the Outlook and Google triggers are the same.  You are correct, I did not include the EL triggers since they are an add-on and not part of base.

 

Thanks

Paul Zeimet
Development Manager
Infor CRM
Employee
Posts: 79
Registered: ‎06-25-2009

Re: 8.1 SNC02 Trigger Issue

Thanks Mike, I will definately take this under consideration.

 

 

Paul Zeimet
Development Manager
Infor CRM
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC02 Trigger Issue

Thanks Paul. This will help us all big time!

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Nickel Contributor
Posts: 47
Registered: ‎05-25-2011

Re: 8.1 SNC02 Trigger Issue

Thanks guys for the very informative discussion here. We were also bit by the contact triggers on batch updates to Contact table (1.8 million+ rows, I guess we could have waited until christmas 2043 before they would finish...if they finished at all, since the log file was growing like crazy). This is a big one, and i'm not sure the triggers have been "publicized" properly, at least we were not aware of them, and we have quite a bit of experience in Saleslogix 8.x environments...

Bronze Super Contributor
Posts: 152
Registered: ‎02-01-2011

Re: 8.1 SNC02 Trigger Issue

I'd like to throw in my two cents to mention that the new triggers caused some problems for us when using 3rd party tools to do data imports. We couldn't figure out why our ETL was on track to take several days based on the throughput we were seeing until we disabled the triggers. A big fat gotcha when doing an import.

Andy Freeman
TrellisPoint, LLC
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: 8.1 SNC02 Trigger Issue

IMHO - we have just touched the tip of the iceberg when it comes to the performance problems being caused by (all these) OOTB SQL triggers.

 

There's just three choices right now:

    A - Have Outlook integration and suffer from the SQL triggers

    B - Drop Outlook integration and have a system that just might work as well as it did in the past.

    C - Hope Saleslogix/Swiftpage will com up w/a solution... soon!

 

Anyone?

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html