7/8/2025 5:29:02 PM
|
| |
| 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 general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Administrator quits on startup
Posted: 15 Mar 07 12:09 PM
|
fiogf49gjkf0d Has anyone seen an issue where Administrator shuts down immediately after opening?
I log in, none of the toolbars items "pop up" on mouseover, and after about two seconds administrator shuts down unexpectedly. I usually try it several times and it finally works. I've also noticed that if I login and immediately launch another instance and log in again, one of the two instances usually stays open. (Don't ask me why I thought to try that. My wife says she'd like a lawn chair and glass of lemonade while she camps out in my brain.  )
Anyone seen this behavior and/or know of a work-around? I've seen it happen on both our test and dvlp environments and it's really aggravating.
Thanks,
Jeff
|
|
|
|
Re: Administrator quits on startup
Posted: 16 Mar 07 2:57 AM
|
fiogf49gjkf0d Oh yeah - for a long time !!
The best way to minimise it (note: not 100%) - is to set the startup to Bundles rather than Users. |
|
|
|
Re: Administrator quits on startup
Posted: 16 Mar 07 8:35 AM
|
fiogf49gjkf0d Per Sage you can also try the following. Delete the conection on your server using connection manager and recreate using the same name. Then delete the connection from the app by clicking the elipses on the login screen and then delete it from the data link manager list then uninstall administrator, reboot and reinstall administrator. Then recreate the app connection in data link manager when you launch Administrator.
This works sometimes and not others but worth a try. |
|
|
|
Re: Administrator quits on startup
Posted: 18 Mar 07 3:55 PM
|
fiogf49gjkf0d Originally posted by Jeff Ballard
Has anyone seen an issue where Administrator shuts down immediately after opening?
I log in, none of the toolbars items "pop up" on mouseover, and after about two seconds administrator shuts down unexpectedly. I usually try it several times and it finally works. I've also noticed that if I login and immediately launch another instance and log in again, one of the two instances usually stays open. (Don't ask me why I thought to try that. My wife says she'd like a lawn chair and glass of lemonade while she camps out in my brain. )
Anyone seen this behavior and/or know of a work-around? I've seen it happen on both our test and dvlp environments and it's really aggravating.
Thanks,
Jeff
|
|
This sometimes is caused by messed up SectableDefs, resynctabledefs, Global Joindata, and/or someting messed up in hierarchy.
Ques: in every case is the main sitecode of the db's the same?.. If so, I'd suggest you test each deb by clearing out the local cache in your pc (down the ...all users path) between each db and see if the problem can be localized. Then check the integrity of the above metadata tables.
98% + of the time this has worked for me.
--
rjl |
|
|
|
Re: Administrator quits on startup
Posted: 18 Mar 07 10:34 PM
|
fiogf49gjkf0d Doesn't that happen sometimes if the system has a user that reports to itself? I've seen that before, check to make sure there are no users that report to themselves (the admin user shouldn't report to anyone, so make sure the field is null for admin)
Doesn't something like that also happen if you have circular joins or something too? |
|
|
| |
|
Re: Administrator quits on startup
Posted: 19 Mar 07 11:54 AM
|
fiogf49gjkf0d Bob,
When you say integrity of sectabledefs and resynctabledefs, anything more specific? I ran
SELECT * FROM SECTABLEDEFS S WHERE NOT EXISTS (SELECT TABLENAME FROM RESYNCTABLEDEFS R WHERE S.TABLENAME = R.TABLENAME)
to find items in sectabledefs that don't have a matching table in resynctabledefs. I found several tables which are already on the "drop" list (competitor_contact, competitorcustomer, competitorproudct, productcost, productprice, productpricelevel, productsite, productsubstitute, productunit). One of them, site, is missing it's entry in sectabledefs and I'll fix that.
Are there any other tests for integrity? Do I need to look at the information_schema.tables to see if I'm missing tables when compared to resynctabledefs? I know that will turn some things up, as we have tables created outside of SalesLogix that are in the DB, but there's nothing we can do about that.
I did have one recursive join - not sure how it got there, as we removed those before we upgraded last year. It's gone now and it didn't solve the issue, so there's something still out there.
As far as the main sitecode in the db's the same - are you referring to remotes? If so, we have no remotes and no remote offices - just one main database.
Your (and Ryan's) help is appreciated!
Jeff
|
|
|
|
Re: Administrator quits on startup
Posted: 19 Mar 07 2:16 PM
|
fiogf49gjkf0d Ryan,
I should probably know this, but what are the tables to determine if a user reports to themselves? Is it basically this:
select * from usersecurity where userid = managerid
If so, there's only 1 record there, and that's for ADMIN in both the userid and managerid fields which would go against what you're saying. I find the same record in the eval or blank database, so I'm wondering if I've got the right tables - probably not.
Thanks,
Jeff
|
|
|
|
Re: Administrator quits on startup
Posted: 19 Mar 07 3:42 PM
|
fiogf49gjkf0d Hi Jeff,
The query is right (managerid). I was thinking that the admin user reported to NULL, but I apparently was wrong - that's not the case in my own SLX database (Admin reports to Admin) and it starts up fine.
So it looks like you're ok there, not a "reports to" problem. |
|
|
|
Re: Administrator quits on startup
Posted: 19 Mar 07 4:22 PM
|
fiogf49gjkf0d Hi Jeff - I've come to this thread late, but it seems that the assumption has been made that the db you are accessing is somehow to blame. Is this the case - can you confirm that logging on to the eval db works fine? |
|
|
|
Re: Administrator quits on startup
Posted: 19 Mar 07 5:04 PM
|
fiogf49gjkf0d Phil,
I don't log on to the eval DB very often, but the few times I have logged onto the eval DB, I don't recall it happening. I'll try every now and then to log on to the eval DB to see what happens - particularly after it fails logging into the customer DB.
Jeff
|
|
|
|
Re: Administrator quits on startup
Posted: 21 Mar 07 8:39 AM
|
fiogf49gjkf0d Originally posted by Jeff Ballard
Bob,
When you say integrity of sectabledefs and resynctabledefs, anything more specific? I ran
SELECT * FROM SECTABLEDEFS S WHERE NOT EXISTS (SELECT TABLENAME FROM RESYNCTABLEDEFS R WHERE S.TABLENAME = R.TABLENAME)
to find items in sectabledefs that don't have a matching table in resynctabledefs. I found several tables which are already on the "drop" list (competitor_contact, competitorcustomer, competitorproudct, productcost, productprice, productpricelevel, productsite, productsubstitute, productunit). One of them, site, is missing it's entry in sectabledefs and I'll fix that.
Are there any other tests for integrity? Do I need to look at the information_schema.tables to see if I'm missing tables when compared to resynctabledefs? I know that will turn some things up, as we have tables created outside of SalesLogix that are in the DB, but there's nothing we can do about that.
I did have one recursive join - not sure how it got there, as we removed those before we upgraded last year. It's gone now and it didn't solve the issue, so there's something still out there.
As far as the main sitecode in the db's the same - are you referring to remotes? If so, we have no remotes and no remote offices - just one main database.
Your (and Ryan's) help is appreciated!
Jeff
|
|
Jeff,
There are a lot of tests you need to run to verify the metadata integrity.. There's a mess of postings on this kind of stuff in the Partner's NG as well. This stuff goes back years.
In fact, I've developed some tools and procdures for doing analysis/repair to Slx db's. We've been totally successful in diagnosing/repairing 100% of the db's we've worked on.
All I can say is you are on the right track.. but it's a long road.. I know.. I've spent years on this kind of stuff..
--
rjl
|
|
|
|
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!
|
|
|
|
|
|
|
|