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!
|
|
Error Looking up Contacts
Posted: 17 Jul 07 4:03 AM
|
SLX 6.2.6
One of or users is consistently getting an error when looking up contacts in the Sales Client, as follows:
An unusual error has occurred when executing Lookup:LastName. 0x1 @0: Function Lookup:LastName Exception: Access violation at address 00A63B0E in module 'SalesLogix.exe'. Read of address 00000054
I have suggested that they get SLX reinstalled, because other users are OK, but has anyone any idea what causes this?
|
|
|
|
Re: Error Looking up Contacts
Posted: 17 Jul 07 9:21 AM
|
Most likely a reinstall is the answer.
Barring that, have you eliminated it being a data issue by looking up the exact same contact the user is looking up using the same exact method of lookup? Or is it happening for any contact the user is looking up?
John G. |
|
|
|
Re: Error Looking up Contacts
Posted: 17 Jul 07 5:57 PM
|
| ... and logged into SLX as the same user who is having the problem, just from another PC. |
|
|
|
Re: Error Looking up Contacts
Posted: 18 Jul 07 3:20 AM
|
Thanks John and Phil. The user says he even gets an error clicking the Contacts button on the left side of the screen. Not the same, but similar:
An unusual error has occurred when executing View:Contacts. Contact your system administrator 0x1 @0: Function View:Contacts
Exception: Access violation at address 00A63B0E in module 'SalesLogix.exe'. Read of address 00000054
I think a reinstall is in order |
|
|
|
Re: Error Looking up Contacts
Posted: 19 Jul 07 6:39 AM
|
Hmm.. odd. I'd go for the reinstall, but first you might want to look at plug-ins and make sure the user has all the right plug-ins released. I recently had some unusual behavior because of a newer plug-in not being released.
John G. |
|
|
|
Re: Error Looking up Contacts
Posted: 25 Jul 07 4:37 AM
|
The user has had the SLX Client reinstalled, no change. So I changed his login to not use4 Windows Auth and logged on as him, and I can make the errors happen. I am at a loss to figure out what's wrong though.
All plugins as far as I can see are released to 'Everyone'.
He gets errors (and it's only him) however he tries to display a Contact, by clicking the Contacts button, doing a Contacts Lookup, or double-clicking a contact in the Account-Contact Grid.
This double-click gives the most clues. It first gives this error:
SalesLogix
General: Error on line:20
Then he gets:
Basic had an error...
Context: grdAccountContact
@0: Basic Account:Contacts Grid Dbl Click
Status: 0x14
So I added a MsgBox at the beginning of the Legacy Script (Account) Contacts Grid Dbl Click
And the Message displayed. Also the line number changed from 20 to 22 so the problem seems to be in this script. But Line 20 is an end sub, so what's going on? This is the script:
sub main
Dim vAccountID as String
Dim vContactID as String
Dim vAccountName as String
vContactID = QueryGetValue("grdAccountContact", "CONTACTID") 'DNL
if vContactID = "" Then
Msgbox(Localize("No Contact has been selected"))
Exit Sub
end if
vAccountID = CurrentAccountID
vAccountName = GetDataPathValue("ACCOUNT:ACCOUNT") 'DNL
if vAccountName = "" then 'DNL
vAccountName = "Account" 'DNL
end if
CreateTempContactGroupForAccount vAccountName, vAccountID, vContactID
end sub
Also, I tried to Debug this by setting him to Debug on Error, but it doesn't stop. Anyone any ideas what the problem could be? |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 3:28 AM
|
We've seen issues with the CreateTempContactGrooupForAccount function in the past. Try this instead;
' Remove old function
' CreateTempContactGroupForAccount vAccountName, vAccountID, vContactID
vIDs = QueryGetIDs("grdAccountContact")
CreateTempAdHocGroup "CONTACT", vAccountName, vIDs, vContactID
See if that make a difference. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 3:28 AM
|
We've seen issues with the CreateTempContactGrooupForAccount function in the past. Try this instead;
' Remove old function
' CreateTempContactGroupForAccount vAccountName, vAccountID, vContactID
vIDs = QueryGetIDs("grdAccountContact")
CreateTempAdHocGroup "CONTACT", vAccountName, vIDs, vContactID
See if that make a difference. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 4:26 AM
|
| See if that make a difference. |
|
Thanks for the suggestion, but it doesn't, except the line number of the error changes. However, I put diagnostic MsgBox commands all the way through, including before and after
CreateTempAdHocGroup "CONTACT", vAccountName, vIDs, vContactID
And the one before it displays, the one after doesn't, I get the error after a few seconds.
So I added the CreateTempAdHocGroup parameters to the MsgBox text like this:
MsgBox "Diagnostic 6: " & vAccountName & ", " & vIDs & ", " & vContactID
And it looks like this:
Diagnostic 6: Account, C6UJ9A004GOM
C6UJ9A004GVF
...5 more CONTACTIDs each on a new line...
, C6UJ9A004GOM
Does this make sense?
|
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 4:47 AM
|
Hmm, very odd - looks like the account name is missing ???
Try this - this is the full script I use now instead of the normal one
Option Explicit
sub main
Dim vAccountID as String
Dim vContactID as String
Dim vAccountName as String
Dim vIDs as string
vContactID = QueryGetValue("grdAccountContact", "CONTACTID")
If vContactID = "" Then
msgbox("No Contact has been selected")
Exit Sub
End if
vAccountID = CurrentAccountID
' vAccountName = GetDataPathValue("ACCOUNT:ACCOUNT")
' vAccountName = GetPropertyOf ("ACCTDETAIL1:adAccount","Text")
vAccountName = CurrentAccountName
if vAccountName = "" then
vAccountName = "Account"
end if
if len(vAccountID) <> 12 then
msgbox "No account selected"
End If
If len(vContactID) <> 12 then
msgbox "No contact selected"
End If
If vAccountName = "" then
msgbox "No datapath!"
End If
' CreateTempContactGroupForAccount vAccountName, vAccountID, vContactID
' vIDs = DBGridGetSelectedIDs("grdAccountContact")
vIDs = QueryGetIDs("grdAccountContact")
CreateTempAdHocGroup "CONTACT", vAccountName, vIDs, vContactID
end sub
|
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 5:04 AM
|
| Thanks, even that gets the same error. And when the Account IS found it still gets the error. It must be something about the setup of this particular user I reckon, as I can display exactly the same account with no problems. But I can't see what it is about this particular user. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 8:20 AM
|
Just picking this out of Mike's previous post
Hmm, very odd - looks like the account name is missing ???
I'm wondering if an integrity check might turn up something.
My .02
John G. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 8:56 AM
|
I'm tracking this down, slowly. I put Script Debugging to 'Always' for this user, and waded through trying to display a contact, and the error happens AFTER all the scripts have finished.
It seemed to be something in the System:Contacts Detail Form itself, so I released the original (uncustomised) SalesLogix version of it which is 6.22 and that works. Comparing the scripts from that version and our first customised version they are the same. There are quite a lot of changes to the controls on the form in our version, adding, deleting moving etc, but I can't find what's causing the error. I even deleted ALL the controls from our version of the form and it still doesn't work.
This is the strangest error I've found yet. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 1:20 PM
|
| Have you attempted to create the user a new SalesLogix account to try on their own PC to see if the issue goes away? Sometimes SLX user security just goes bad for some reason. |
|
|
|
Re: Error Looking up Contacts
Posted: 26 Jul 07 4:27 PM
|
Originally posted by Jeff Crawford
Have you attempted to create the user a new SalesLogix account to try on their own PC to see if the issue goes away? Sometimes SLX user security just goes bad for some reason. |
|
Thanks, and yes that's what we're going to do. I have spent way too much time on this. Learnt a lot though. |
|
|
|
Re: Error Looking up Contacts
Posted: 27 Jul 07 9:57 AM
|
We found what the problem was with this. Somehow the user had on the Security Tab the Detail View set to <use default view> and we have a customised one. Setting it to use ours made everything work OK.
Very strange error though, and how it got changed for just one user (although we're going to check them all) is a mystery.
Thanks everyone for your help and advice 
Edited for <> |
|
|
|