Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, November 25, 2024 
 
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 - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Database Administration | New ThreadView:  Search:  
 Author  Thread: DB manager crashing on load
Steve Knowles
Posts: 657
Top 10 forum poster: 657 posts
 
DB manager crashing on loadYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Aug 06 10:23 AM
fiogf49gjkf0d
I am trying to add some fields to a dev DB at my office. When I initialize the DB manager it appears to load everything (the progress bar loads to 100% and says analyzing table:Workarea (I assume because it is alphabetically the last table to load)), then the administrator crashes. The same with the administrator. I have tried this on several different machines conneting to the same database. Has anyone seen this or know how to fix? I ran the integrity checks and fix all problems also.

Thanks Steve K.
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: DB manager crashing on loadYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Aug 06 11:23 AM
fiogf49gjkf0d
I suggesting running a SQL Trace to identify the offending query.

Timmus
[Reply][Quote]
Peter H
Posts: 17
 
Re: DB manager crashing on loadYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 25 Aug 06 12:35 AM
fiogf49gjkf0d
(1) See if there are any Non-SalesLogix Tables in the Database. If there are, one (or more) may have attributes that are giving the db Manager a problem.
(2) See if any colums have been added that were not added via the DB Manager - specifically look for colums where the name may contain a space or non-Saleslogix valid character.

[Reply][Quote]
Jeremy Brayton
Posts: 491
Top 10 forum poster: 491 posts
 
Re: DB manager crashing on loadYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 28 Aug 06 1:05 PM
fiogf49gjkf0d
Have you tried the integrity checker in Administrator? 6.2 I believe includes the "check for circular joins" item which is usually what causes it to hang at 100%. If you're on an earlier version I believe I can dig up the SQL to check the joins if you need it.
[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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/25/2024 8:41:49 PM