9/28/2024 6:19:15 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 using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.
|
|
|
|
WAPI/DBGetValue:Access violation at address 018EE634 in module 'slxweb.dll'. 
Posted: 21 Jan 07 8:47 AM
|
fiogf49gjkf0d I am modifying the 'genopportunity' action in the v7 web client. This is the script that sends email from the opportunity snapshot. I am debugging with the event viewer - outstanding. I have added a function which gets some additional product info if a condition is met.
Is the error:
WAPI/DBGetValue:Access violation at address 018EE634 in module 'slxweb.dll'.
caused by my code? Or is this some kind of config/slx error? Here is my function:
Function CheckMulti(sOppid)
Dim strSql
Dim dbHandlem
oppid = sOppid
strSql = "Select cop.PRODUCT_STAGE, cop.EXTENDEDADJUSTEDPRICE "
strSql = strSql + "From OPPORTUNITY_Product op, C_OPPORTUNITY_PRODUCT cop "
strSql = strSql + "Where op.OPPORTUNITYID = '" + oppid + "' "
strSql = strSql + " AND op.OPPPRODUCTID=cop.OPPPRODUCTID"
dbHandlem = DBOpenSQL(strSql, True)
If LogixErrorCode>0 Then
print LogixErrorText & strSql
Else
DBMoveTo dbHandlem, "Last"
DBMoveTo dbHandlem, "First"
....more stuff
When I run the SQL in query analyzer if runs fine.. any thoughts? Thanks |
|
|
|
Got it
Posted: 21 Jan 07 2:20 PM
|
fiogf49gjkf0d Error further up in script - tough to debug in webclient land. Thanks |
|
|
|
Re: Got it
Posted: 21 Jan 07 3:34 PM
|
fiogf49gjkf0d Steve,
Not sure how you're debugging, but do make use of the "senderror" statement (if you're not). If you're not familiar with it, the format is:
senderror string
Basically, you can use any string and it will write it to the event viewer. So if I added this to an action:
senderror "jeff - value of var1: " & var1
it would write an event in the event log that says "jeff - value of var1: hello" if the value of var1 is "hello".
It's about the only way to debug a server side action.
Thought I'd post that in case you didn't know and maybe help someone who hasn't used it before.
Jeff
|
|
|
|
Re: Got it
Posted: 21 Jan 07 3:43 PM
|
fiogf49gjkf0d Thanks Jeff. I actually started using Print last last week to accomplish a similar response in the event viewer. Is there a difference or just another way of doing it? Thanks for the tips. I appreciate them all. |
|
|
|
Re: Got it
Posted: 22 Jan 07 7:52 AM
|
fiogf49gjkf0d Steve,
I didn't know "print" had been fixed, actually. It got broken in 6.2.3 (I've got an install of 6.2.6, I'll test to see if it's fixed there) but senderror had the same effect of printing to the event viewer so I started using that. But it does have the same effect of printing to the event viewer, although senderror is supposed to redirect you to the "we apologize for the inconvenience" page with your custom message - but it only does that if you "Exit Sub" on the action right after the senderror. Print is supposed to just print to the event log.
Jeff
|
|
|
|
Re: Got it
Posted: 25 Jan 07 10:53 AM
|
fiogf49gjkf0d Is 6.2.6 the promised time zone service pack? What does it contain? |
|
|
|
Re: Got it
Posted: 25 Jan 07 11:31 AM
|
fiogf49gjkf0d Yep, 6.2.6 has the TZ fixe(s) in it. It also has the reworked DLL that won't buy it on a multi-processor machine.
Here's a list of the files changed between 6.2.3 and 6.2.6 Beta 1 (that's what I'm upgrading a customer from). Below the files, I've also listed the changed/added actions, aliases & queries. My disclaimer for anyone reading this is that I may have missed something, I may have added something, so you will need to do your own evaluation to determine if what's actually changed, as well as to figure out how the changed items affect your customizations. I'm not responsible for any mistakes to anyone, other than my employer & customer! Use at your own risk. 
GroupTranslator.dll
Interop.GroupTranslator.dll
WebHost.dll
OwnerAssign.aspx
QueryBuilderMain.aspx
Multiple "ASPScripts\help" Files
opprptwin.aspx
opprptwin.js (new)
ShowReport.aspx
viewReport.aspx
viewReport.js (new)
slxwebmm.dll
slxweb.dll
actaddrecdaily.htm
actaddrecmenu.htm
actaddrecmonthly.htm
actaddrecweekly.htm
actaddrecyearly.htm
actcompmeet.htm
actcompperson.htm
actcompphone.htm
actcomptodo.htm
actinfo.htm
actrecurconf.htm (new)
litreqadd1.htm
caldailyforact.htm
calendardayview.htm
calendarmonthview.htm
calendarweekview.htm
calmonthlyforact.htm
calweeklyforact.htm
timepicker.htm
mainpage.htm
topnav.htm
passexpired.htm
actaddrecdaily.htm
actdel.htm
actedit.htm
actinfo.htm
alarmset.htm
campaignresponseadd.htm
campaignresponseedit.htm (new)
litreqadd1.htm
litreqadd2.htm
mergeinfo.htm
newfeatures.htm
slxcont.htm
slxhow.htm
slxhowmarketing.htm (new)
slxhowoverview.htm
slxtrade.htm
slxtroub.htm
templatesover.htm
slxcaldataaccess.htc
slxdayactgrid.htc
slxdayhourlycal.htc
slxfullmonthcal.htc
slxtimelessactgrid.htc
slxweekdailycal.htc
timeDisplay.htc
actcomp.js
addactivity.js
groupmanager.js
groupmanagervb.vbs
recactcontrol.js
salestopnavVB.vbs
timeobjs.js
spoppgridfrm.htm (SalesProcess package)
spoppstatsfrm.htm (SalesProcess package)
SLXActiveMail.cab
web aliases changed:
actrecurskip (new)
useractconfraw (new)
web actions changed:
addactivity
addconacc
addcontact
changepass
compactivity
deleteactivity
externalloginglobals
global
isadvancedsalesweb
iscustportalinstalled
spcompletestep
spmovestageto
updateactivity
changepassinfo (new)
web queries changed/added:
actcurmembers
Jeff
|
|
|
|
Re: Got it
Posted: 25 Jan 07 11:41 AM
|
fiogf49gjkf0d Thank you. Any chance you can ID the changes from 6.2.4 to 6.2.6? |
|
|
|
TZ Patch
Posted: 25 Jan 07 12:38 PM
|
fiogf49gjkf0d What is the status of the daylight savings patch for v7? Is this out yet? |
|
|
|
Re: Got it
Posted: 25 Jan 07 1:25 PM
|
fiogf49gjkf0d Kerry,
Sorry, but I went directly from 6.2.3 to 6.2.6, so I can't tell what changed from 6.2.4 to 6.2.6.
Jeff
|
|
|
|
Re: Got it
Posted: 25 Jan 07 1:42 PM
|
fiogf49gjkf0d Thanks. Hopefully installing 6.2.6 will not require significant customization changes. |
|
|
|
Re: TZ Patch
Posted: 25 Jan 07 2:12 PM
|
fiogf49gjkf0d Originally posted by Steve Knowles
What is the status of the daylight savings patch for v7? Is this out yet? |
|
The fixes are contained in SP1 for v7. This was released two days ago. Not sure if it shows on the support site yet, haven't checked. |
|
|
|
Re: Got it
Posted: 25 Jan 07 3:00 PM
|
fiogf49gjkf0d Kerry,
Actually, it just occurred to me that the easiest way to ID the changes is look at the time stamp on the files. If you install 6.2.6, you'll see that the files for 6.2.6 have a time of 6:26 a.m. 6.2.5 files are 6:25 am, 6.2.3 files have a time of 6:23 AM, etc. Basically, the time on the file will tell you what version & SP it was implemented. Of course, it's possible a file was not time stamped right, but looking at that might give you and idea of which templates have changed. You'll still have to compare aliases, actions & queries, but the files should be pretty easy.
I'd look for you but am short on time right now.
Jeff
|
|
|
|
Re: Got it
Posted: 21 Feb 07 12:24 PM
|
fiogf49gjkf0d Jeff , now to the most important question..
How is the slxweb.dll beahaving with 6.2.6? Is it more stable.We did the processor affinity and still there are some issue for some accounts at some time..I am going to a meeting in another hour for discussing this.i know there are going to be a million questions about this (it is little political too..thatz why those million questions).So am i safe in saying that when 6.2.6 is upgraded, this problem is going to go away?
I already have 4 sites with 4 app pools with 4 CPUs handling a cust portal of ~200 users...)Also if i put 6.2.6 can i bring down the number of sites to 1? |
|
|
|
Re: Got it
Posted: 21 Feb 07 3:07 PM
|
fiogf49gjkf0d Its totally fixed our issues - I just swapped out the dlls and didnt do the full upgrade (obviously this is agianst the rules though!) Web is MUCH quicker too. |
|
|
|
Re: Got it
Posted: 21 Feb 07 3:16 PM
|
fiogf49gjkf0d Nandu,
It's not in production yet, so I can't tell you from that perspective. Our attempts to break it the way we did before all failed, though. We did see something odd and we know what caused it, sort of.
Our customer has an external process (they have no remotes) that inserts data. The customer forgot to have this external process insert into ACCOUNTSUMMARY. As they were testing the upgrade, they kept getting strange errors, such as "WAPI/PostRecord: The statement has been terminated: Cannot insert the value NULL into column 'SECCODEID", table SYSDBA.ACCOUNTSUMMARY, column does not allow nulls...."
What's bizarre as that this error occurs when executing a custom action that is updating some address info - there's no reference to accountsummary (or account) at all and the account it's trying to update accountsummary for is not related to the contact/account the action was being executed for. Truly bizarre.
So I run SLXProfiler and sure enough, it's trying to update accountsummary. Well, we insert the missing accountsummary records. Everything works - and strangely enough, the DLL is no longer trying to update accountsummary. Not even selecting against it like it had been before we inserted the missing records.
This error occurred in several different web actions, but not all. It almost seems like the DLL is doing a background check every now and then to see if accountsummary is OK. But we can't explain why it broke.
The customer's test environment has the same missing accountsummary records, but 6.2.3 doesn't complain.
Personally, I think that the codebase for the webdll is so patchwork after so many years, that we'll never figure out what happened. Particularly since Sage will (rightfully) say that the accountsummary records should be there.
So in answer to your question it seems better, but there's some weird behavior we've seen, caused by bad data. As for will the problem go away, I'm not sure. And as for can you bring it down to 1 site? Not sure of that, either.
Jeff
|
|
|
|
Re: Got it
Posted: 28 Feb 07 2:16 PM
|
fiogf49gjkf0d Wanted to post an update for all. The customer went live on 6.2.6 today; it was a long, strange trip.
The upgrade began at 6 p.m. last night. After all the backups were done and the executables were upgraded, but before the SP6 bundles were applied, the server was rebooted. And then, it all went wrong - fortunately not with the SalesLogix web DLL (for once). A piece of hardware in the SAN went out, causing the slx web server (amongst many others) to suddenly not work (couldn't even boot). After several hours the network infrastructure folks got the hardware replaced on the SAN and the upgrade resumed. Finally, about 1:30 a.m., we came back from the hotel and began testing and all looked well. We found one issue that is in a heavily customized area (involving te GetGroupSQL WAPI and our own parsing of the SQL [not the OLEDB providers] in a custom web action) that has been there since 6.2.3 almost a year ago, but was only discovered last night. It's obviously not a showstopper since it was only found last night - on a fluke by a tester "trying something".
Not a peep out of the users today, which is unusual and a good thing. That said, we still have the processor affinity in place - we'll undo that in the next few days. We wanted to get a feel for the stability with it still in place.
So, the initial signs in production look promising. We'll have to see how it goes after we undo processor affinity, but our testing wasn't able to break it, where we could with the 6.2.3 DLL. So there's hope.
I'll post again when we undo the processor affinity, but wanted to pass along the initial [positive] results.
Jeff
|
|
|
|
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!
|
|
|
|
|
|
|
|