slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Upgrades
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Upgrades | New Thread

View: Search:

Author

Thread: Oracle Upgrade, 6.1 to 7.22, locking when updating Opportunity

Scott Smallbeck
Posts: 62

Oracle Upgrade, 6.1 to 7.22, locking when updating Opportunity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Dec 08 12:48 PM

Following what appears to be a successful upgrade (Still in test!) Saleslogix locks up anytime anOpportunity is updated, no problem creating a new Opportunity. I can do an update query in SQLPlus as SYSDBA, the same query locks up using ExecuteSQL in the Admin.

Oracle Client is 9.2.0.1 running against 10.2.0.3.0 server.

[Reply][Quote]

Scott Smallbeck
Posts: 62

Re: Oracle Upgrade, 6.1 to 7.22, locking when updating Opportunity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Dec 08 12:54 PM

Using SLXProfiler I see there is a trigger firing with the update:

QASYS: call trigger (ACCZZA00P15M), table: OPPORTUNITY

Is this something with SLX or something they have added? I have a message into the DBA.

[Reply][Quote]

Scott Smallbeck
Posts: 62

Re: Oracle Upgrade, 6.1 to 7.22, locking when updating Opportunity Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 17 Dec 08 6:17 PM

Ok, looks like it something to do with logging. When you update an Opportunity record it takes about 20 minutes and finally completes. During this time the SLXLoggingServe service jumps around between 10-30% of resources.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 9:49:16 PM