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!
|
|
help!!! Notes/History has disappeared
Posted: 01 Sep 09 10:52 AM
|
It started last week. I have done no customizations to the form Notes-History. But when i try to access the Notes/History tab on the account form I get an error:
An error occurred executing active form script (Account:Notes-History)
Error in include script (SYSTEM:NOTES HISTORY COMMON): Error calling method AXFormChange
Insufficient or invalid join data
at line 479, char 5
This just started happening. I tried to track the problem using VS debugger tool with no luck. Is there something that happened to the database recently that could have caused this. As of right now i have not been able to figure out what it might be. Any help on this would be greatly appreciated.
The users can view the notes via the Notes tab. But they are unable to view the notes via Notes-History, which gives them the ability to see who wrote the note and to edit a particular note.
|
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 11:20 AM
|
Hi Paul, as with yours we have also made no customisations to the Notes-History so thought it may help to paste the AXFormChange code from ours so you can compare it with yours. Please find it in the script of your Notes-History plugin.
Sub AXFormChange(Sender)
splMain.Size = splMain.Size - 1
splMain.Size = splMain.Size + 1
memNotes.Clear
' This Procedure sets filtering and forces grid to load
If (grdHistory.BindId = "") Then
Exit Sub
End If
CommonCheckboxChange grdHistory
lblRecordsShown.Caption = Application.Translator.Localize("Records shown: ") & grdHistory.Recordset.RecordCount
memNotes.Text = HistoryChangeNode(grdHistory.GetCurrentField("HISTORYID")) 'DNL
cboUser.Text = Application.Users.Item(Application.BasicFunctions.CurrentUserID).Name
cboDays.Text = cboDays.Items(0)
End Sub |
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 11:27 AM
|
The complain is not coming from the Notes-History tab itself but from the "Notes History Common" script.
What version of SalesLogix are you running?
At least on Version 7.2, this line is where the SQL Statement is assigned to the Grid, so it seems as if somehow the SQL statement is bad:
grdHistory.SQL.Text = strGridSQL 'line 479
I would suggest that you either add a message box to display the sql statement before assigning it to the grid, or run the profiler (depending on the version of SLX it may show the error, but not display the failed SQL statement) so that you could troubleshoot what is wrong with the statement. |
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 11:35 AM
|
thanks. My script is exactly the same. The error happens in the CommonCheckboxChange grdHistory subroutine
specifically right before the end of the sub:
grdHistory.SQL.Text = strGridSQL
grdHistory.Active = True <------------ RIGHT HERE
If grdHistory.Recordset.RecordCount <> 0 then
grdHistory.Selection.Add(grdHistory.GetCurrentField)
End If
EnableDisableButtons
lblRecordsShown.Caption = Application.Translator.Localize("Records shown: ") & grdHistory.Recordset.RecordCount
'grdHistory.Active = False 'Since we dynamically build the SQL - we want to force this Procedure to manually Refresh the grid
End Sub |
|
|
| |
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 11:42 AM
|
I'm running 7.2 I have been working on the idea that there is something wrong in the Sql Statement. but its the exact same one that was running fine til a week ago. which i havent changed at all namely
SELECT A1.HISTORYID, A2.TEXT A2_TEXT, A1.COMPLETEDDATE, A1.USERID, A1.CONTACTNAME, A1.RESULT, A1.DESCRIPTION FROM HISTORY A1 INNER JOIN PICKLIST A2 ON (A1.TYPE=A2.ID) WHERE ((A1.TYPE<>262162) OR (A1.USERID='UserID') AND (A1.ACCOUNTID IS NOT NULL AND A1.ACCOUNTID <> '')) AND (A1.ACCOUNTID = :BindID)
That is what makes finding the source of the error so maddening.
|
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 11:50 AM
|
Don't get the SQL Statement from the Grid.
You have to get it from the Code.
If you review the Notes History Common script, you will notice that the SQL Statement is generated dynamically based on what checkboxes are set, etc. So, you need to add a Message Box to it, then execute the same steps that cause it to break and capture the Statement as it was going to be executed at that time.
|
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 12:09 PM
|
here is the script dynamically generated by the code
SELECT A1.HISTORYID, A2.TEXT A2_TEXT, A1.COMPLETEDDATE, A1.USERID, A1.CONTACTNAME, A1.RESULT, A1.DESCRIPTION FROM HISTORY A1 INNER JOIN PICKLIST A2 ON (A1.TYPE=A2.ID) WHERE ((A1.TYPE<>262162) OR (A1.USERID='UserID') AND (A1.ACCOUNTID IS NOT NULL AND A1.ACCOUNTID <> '')) AND (A1.ACCOUNTID = :BindID)
AND (TYPE <> 262156) ORder by A1.CompletedDate Desc
When i copy the above code to SSMS and replace the BindId with the actual accountid.. it runs fine and i get a recordset with 2 rows. |
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 12:23 PM
|
Are you testing this as Admin?
Otherwise this may not be the exact statement as executed by SalesLogix.
(Also, we don't know if SLX is properly replacing the BindID either), so your next step would be to test with the SLX Profiler.
The profiler should show you the SQL Statement before and after the parser handled it, thus allowing you to view what may be wrong with it.
|
|
|
|
Re: help!!! Notes/History has disappeared
Posted: 01 Sep 09 1:44 PM
|
| I owe you a beer. I used the slxProfiler and discovered that the table Joindata was empty. How it got empty i have no idea. Luckily I had another copy of the test database and was able to repopulate the joindata table in the production database. and notes history is back. yippee. |
|
|
|