11/29/2024 3:27:34 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.
|
|
|
|
Lookup Manager hangs when trying to Add an Opportunity Lookup
Posted: 25 Jun 10 10:57 AM
|
Does anyone have any ideas why the Lookup Manager hangs up when I try to add a Lookup on the Opportunity Table in the Lookup Manager? Everytime I try it hangs up and I have to end process to close the Architect.
I tried just adding the lookup record to the Lookup database table and adding the Lookup menu item but when I test the Lookup item in the client I receive an error message that states the Lookup could not be found.
This is a big problem if I am unable to add lookup to the Opportunity level. I've looked online and through the Knowledgebase and have found nothing. Not sure if there is a connection issue with the database.
Any help would be great. Thanks! |
|
|
|
Re: Lookup Manager hangs when trying to Add an Opportunity Lookup
Posted: 25 Jun 10 3:16 PM
|
The Usual Suspects....
Field Exists, created through SLX DBManager?
Lookup doesn't already exist? The Reverse of the lookup doesn't already exist?
you are logged in as ADMIN into the Architect.....
You can add a plugin, picklist, Join, and a Table in DBManager....
Is/was this item an OOTB system lookup?
Unique LookupID values, non null.
Possibly a SitesKey violation?
What version of SLX?
Can you edit other existing Lookups?
Hunting for Lookups, in all the wrong places (OK to sing along with Mitch on this one!):
-- LOOKUP DUPLICATE CHECKER, no dupes in the database:
SELECT maintable ,
searchfield,
LOOKUPNAME,
COUNT(*) AS [Duplicate Lookup Count]
FROM sysdba.lookup
GROUP BY maintable,
searchfield,
LOOKUPNAME
HAVING COUNT(*) > 1
-- if that query gets results, then get EACH Searchfield:
-- example:
SELECT * FROM sysdba.Lookup
WHERE MAINTABLE = 'ACCOUNT'
AND SEARCHFIELD = 'ACCOUNT:ACCOUNT'
-- and delete the bad Lookup:
-- BUT!!!! don't delete the jSYST values, EVER!
|
|
|
|
Re: Lookup Manager hangs when trying to Add an Opportunity Lookup
Posted: 28 Jun 10 10:34 AM
|
RJ, sorry for the delay in replying.
1. Yes, field exists - I created through SLX DB Manager.
2. Lookup does not already exist. Reverse does not already exist.
3. Yes
4. Yes, Yes, Yes, and Yes.
5. No, this was not an OOTB system lookup
6. Yes, there are unique LookupID values, no nulls
7. Unsure how to identify or confirm this one.
8. v7.2, no patches or Hotfixes have been applied.
9. Yes |
|
|
|
Re: Lookup Manager hangs when trying to Add an Opportunity Lookup
Posted: 28 Jun 10 12:58 PM
|
Have never run 7.20000000 other than Beta testing....we're on 7.22 HF's through 22 (and they are up to 42!).
I've added a few dozen lookups.....including the duplicates/tripli/quad lookups on the same Table.field (you can refer to lookups by Caption, LookupName, et al to differentiate the Field.....)
My advice based on 13 years with SLX: upgrade as far as you can.....hunt specifically for hot fixes that affected the Lookups..... |
|
|
| |
| |
|
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!
|
|
|
|
|
|
|
|