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!
|
|
Strange behaviour after restoring DB
Posted: 13 Feb 07 3:41 PM
|
fiogf49gjkf0d This morning I backed up a clients productionDB and restored on the test system. After running the scripts to make syncing safe etc. I couldn't get into the site. So I deleted the existing website in the webmanager and recreated it. I then reinstalled a bundle of mods that had been working fine - and continue to work fine. No activity mods at all. I could then log in with no problem.
But lo and behold, when I go to schedule an activity I get :
We appologize for the Inconvienience... blah blah
The template "addactivity" cannot be found
In the webmanager I can an action called addactivity. I deactivated and reactivated, ran IISReset. Still same error.
Even stranger, this is now happening on the production system also.. Any suggestions? |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 13 Feb 07 6:48 PM
|
fiogf49gjkf0d Steve,
You stated in "webmanager I can an action called addactivity". I presume you mean you can see an action called "addactivity". Also, just to clarify, have you looked for a template called "addactivity" or just an action? The error message states "template". I'm guessing you've had a very long day.  Of course, every day with the web client is a long day.
I don't have an addactivity in 6.2.6 - can you figure out where it's calling the template addactivity from?
Is this the same problem you had in your thread http://www.slxdeveloper.com/forum.aspx?forumid=4000&postid=5502#5502? Did you ever find a resolution for that? Or is this something different?
Strange how it was working and now it's not. I'm not sure what would have changed. The only thing I can suggest is try tracing things to see if something turns up as to why it's calling the addactivity template.
Jeff
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 2:12 AM
|
fiogf49gjkf0d Try Re-propagating the ado connection (through Web Manager) on both systems then doing an iisreset - Ive had a few funny things like this happen when moving web pages/sites about.
Unless someones been 'tampering' with pages theres no other way it could have just stopped working in the Live environment
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 7:42 AM
|
fiogf49gjkf0d Jeff,
I did indeed mean action, not template. All I could find by that name. This is similar to my previous post. The first post was on a dev machine at my office. When I moved the implementation the clients dev/prodcution servers the problem went away. Then yesterday - a few days before go live this surfaced again. I never resolved on my dev machine because it worked at the client site.. until now.
Nick, I have tried both those things more times than I care to admit. I too have seen many a problem solved(?) by doing this.
I am thinking about wiping the install and starting fresh.. But anything else I could try short of that would be welcome.
Steve |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 8:06 AM
|
fiogf49gjkf0d The only time I've seen something vaguely similar to this is when I didnt install the Service Pack bundles correctly (I forgot the web one), but seeing as Live was working at some point I guess it cant be this. Im assuming Live has had no changes/bundles applied since the error started appearing?
Nick |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 8:19 AM
|
fiogf49gjkf0d I installed SP1 for v7 friday. All tested and ran well until I restored the dev server yesterday.. I reinstalled a bundle of customizations after the restore yesterday and went through and deactivated/activated all my customizations..
Not sure if the activity problem was happening after I installed SP1. I am going to check my bundles. |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 9:22 AM
|
fiogf49gjkf0d Bundles are in place. Also installed sp1 hf1&2. I also deactivated my customizations, deactivated then reactivated everything in the base bundle.. Same results.. |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 11:29 AM
|
fiogf49gjkf0d Steve,
I'm pulling out all the stops on this one. I can't explain it, it makes *no* sense, but I've had it happen to me exactly three times. And it's always the last resort, but it has worked.
I have seen it where the slxweb.dll physical file will constantly serve the same version of a template over and over, regardless of which version you activate, how many times you shutdown, flush, iisreset, reboot, etc. Basically what was happening was I activated a new version (call it version B) of a template, shutdown, flushed, cleared my temp. internet files and yet it kept serving version A. So I did an iisreset; it still served version A. I rebooted, it still served version A even though it was NOT active and I'd cleared everything (cache wise) locally & server side. What's really strange is it would only do this for one specific template - I could create & activate a copy of a different template and that one would work. If I I had multiple people verify that I wasn't seeing things. So we (a group of us began investigating) ultimately replaced the physical copy of slxweb.dll and everything worked.
Basically, the fix involves stopping all the web services, killing any open application pools or component services processes related to SLX. Then physically delete the slxweb.dll. Find another version of the web DLL from a different machine or reinstall from the CD. Then reboot. If you're experiencing what I saw, it will solve the issue.
I have no idea why this has worked - it makes no sense to me as how replacing a copy of the DLL could have changed what version of a template it served. It's almost as if the physical file was corrupted. But I've seen it on three occasions over 6 years.
Jeff
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 12:31 PM
|
fiogf49gjkf0d I'll give that a try. I just deleted my web profile and server in SLX web Manager and IIS. Then I uninstalled and resinstalled slx web components on the server. I didn't wipe out the slx web components folder and all my mods came back - probably should have done this - so I am probably using the same version of slxweb.dll after my uninstall. needless to say problem persists.
I will try your last ditch cure above next. How do I ensure app pools are shut down? In IIS under application pools - do I stop the app pools under by website? I assume for component services I go into component services and stop the slx related components? Just want make sure I do the procedure correctly.
You are obviously a web warrior from way back. I appreciate the insight. I didn't test activities aafter I installed SP1 for slx7 last weekend.. I wonder if it started then..
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 12:48 PM
|
fiogf49gjkf0d Just make sure you don't delete anything in the web components folder that's custom (without a backup first).
To shut down the application pools, you'll have to make sure that no one is using the web client. In IIS Manager, if you're using application pools, you'll see them listed underneath your web server in a folder called "Application Pools". If you expand that folder, there should be one for SalesLogix. Right click and select "Stop". As long as no one is using the web site, it should stay shut down.
If you don't have application pools, it's running as a COM+ application/process. Start-->Administrative Tools-->Component Services. Expand Component Services, Computers, My Computer, and COM+ applications. Find the three for SalesLogix, right-click and select "shut down".
I don't know if that'll cure the problem, but, at this point, what the heck!
Jeff
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 3:14 PM
|
fiogf49gjkf0d Still pain. I tried your procedure to no avail. Then tried again. Uninstalled SLX web components - moved everything out of the SLXWeb folder and put all the .dlls in the Scripts folder in another folder. Resinstalled and got the same results.
I found the addactivity template in another install and put it in the proper folder. Then created an entry for it by browsing to it in the webmanager as a new template. Now I am crapping out at the same place but getting this in the event viewer:
Rendering Stage: Scan Pass
Tag handler:
Access violation a address 0192A1EX in module 'slxweb.dll'. Read of address 000000C
Sigh.. Love that web client eh? |
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 4:25 PM
|
fiogf49gjkf0d Are there any #FIELD tags on it? Is the template a detail template or query template - if it's a query template, there can't be any #F tags. I'd evaluate that and then start commenting out # tags. Even if it is a detail template, I'd start with commenting out the #FIELD tags to see if you can "unbreak" it. You might find the problem that way. There must be a # tag somewhere that's breaking things.
Jeff
|
|
|
|
Re: Strange behaviour after restoring DB
Posted: 14 Feb 07 6:44 PM
|
fiogf49gjkf0d No #F tags. There are #AF, #SYS, #SPOTQUERY, #PL tags.. I ran a find and replace and commented all '<# 'tags to an XX before the #. Same error in event viewer. I made the template straight HTML (hello world style) and it worked just to cross it off the list.
I had created the template in the base package as a query template. I recreated in a custom package as detail page with Activity as the main table. Now the schedule activity screen comes up for all but schedule phone call. So I tried to create a meeting. When trying to save the meeting I got the error:
WAPI/RecordAdd:Access Violation at address 01966BDA in module 'slxweb.dll'. Read of address 00000030
So then I tried to complete an unscheduled activity and found out the template 'actcomp' is missing. Did the same as I did for the other one and found out the Query actcurmembername was not found. Geez Lueez.
Seems like something is corrupt in the registry or db or something. I don't think 'chase the missing template' is the best use of time as it seems to be widespread in the realm of activities. I have no idea how the templates disappeared in the first place.. This happened on a dev server two months ago. I never fixed it because it worked fine at the client site (different server) until recently. I have uninstalled and reinstalled hoping to restore the missing templates, but must need to delete some folders and cleanse the registry to 'reset' the system.
|
|
|
|
Resolved!
Posted: 16 Feb 07 8:41 AM
|
fiogf49gjkf0d I ended up going back in reinstalling the V7.0 web bundle and then the SP1 web bundle and that did it. Very odd as it worked fine before the SP1 bundle was installed. Glad to have this one resolved. Thanks for sticking with me Jeff. Hope to repay the favor someday. |
|
|
|
Re: Resolved!
Posted: 16 Feb 07 1:09 PM
|
fiogf49gjkf0d Not sure what I did, but I'm glad that you got it resolved. The web is *soooo* flaky. Ryan's suggestion of .NET whenever possible is a good one!
Jeff
|
|
|
|
Re: Resolved!
Posted: 16 Feb 07 2:18 PM
|
fiogf49gjkf0d Flaky? A puff pastry is flaky. Drew Barrymore is flaky. I don't what this thing is. My first web implementation is going live next week - heavily customized of course. I can't wait until I get the users up and running and get the web stabilized - I'll be taking a few days off. I hope this thing stabilizes a bit in 7.2. Even the tech support guys usually get a little standoffish when you call about the web.
While you didn't actually solve my problem Jeff, you stuck with me offering some options to try when I was dead ended - and I appreciate that. That is what SLXDEVELOPER and the SLX community in general is and should be about. Rock On! |
|
|
|