5/5/2024 3:30:00 AM
|
| |
| 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!
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.
|
|
|
|
Problems with upgrade from 6.2 to 7.5
Posted: 09 Jul 09 3:26 AM
|
We've encountered a very interesting problem while upgrading our 6.2 SLX database to 7.5 (Oracle 9.2.0.8.0 => Oracle 9.2.0.1.0). Now, the following code execution takes from 10 to 15 minutes:
Set MainView = Application.MainView.Add("Family:SomePlugin", 0, false).
Though, after making the new form "Family:NewPlugin" and copying functionality from "Family:SomePlugin" to it (common copy-paste technology , code
Set MainView = Application.MainView.Add("Family:NewPlugin", 0, false)
executes almost instantly. Obvious question - why? Where's the problem? Because it's very "time consuming" to remake every old form manually... Are there any suggestions? |
|
|
|
Re: Problems with upgrade from 6.2 to 7.5
Posted: 09 Jul 09 8:26 AM
|
I am not an Oracle expert, but since you have also made changes to your backend, I would suggest that you try to rebuild Indexes, Pages, etc at least for the Plugin table.
This is one of the reasons why I typically recommend not to do both an Application and DB Upgrage together, there are too many moving pieces and it makes things harder to troubleshoot.
If I was a betting man, I would put my money on the DB being the culprit.... |
|
|
|
Re: Problems with upgrade from 6.2 to 7.5
Posted: 30 Sep 09 5:29 AM
|
We have about 8000 manually created groups (plugins with types 23 and 8) excluding some legacy ones from Sage. Removing them from PLUGIN table (or transferring to temporary backup table) restores system’s normal work. But if we transfer them back – that leads to massive system slowing-down.
It works as following: we try to call for any form using string
Set objMainView = Application.MainViews.Add(«AnyForm»,0, False),
then the SalesLogix.exe process starts occupying more then 50% of the CPU resources and the processing of this string takes from 15 seconds to 10 minutes, which is unreasonably long.
If we keep SalesLogix started and delete our groups from PLUGIN table – nothing changes. But if we restart SaleslLogix after it, then system returns to normal work, opening of any form using
MainViews.Add… takes approximately 1-5 seconds and loads CPU less then on 10%, which is quite appropriate.
As we managed to learn, the problem is not in a database, but in Saleslogix mechanisms. If we use Application Server 7.2 (instead of 7.5) to connect to the database – no problems raises.
If anyone has any suggestions - please, share them.
|
|
|
|
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!
|
|
|
|
|
|
|
|