I have a strange problem with a webqueryopen agent which I can’t find anything similar about anywhere on the forums.
The agent itself creates some HTML and writes it to a rich text field.
In my testing all worked fine, I get the results I expect.
On the live web server I get an ‘Agent done’ message when opening the form.
I have 2 servers on my live system, one for the web and one internal only. There’s a replica on each server, the internal one, accessed over http works fine. The web server, accessed over ssl doesn’t, giving the error message.
So, the only difference is the presence of an SSL certificate (from what I can tell). The server performs SSL redirection.
Any ideas why this might happen? I have decent error handling and there are no errors, just that the web server gives me the Agent done message.
Thanks
Dan
Subject: FIXED
Seemed to be a problem with the agent being called the same as the form. Not sure why it was working on one server and not the other. Oh well, learn something new every day…
Subject: RE: FIXED
If two design notes have the same name/alias and you do not use a server command to distinguish them (like ?OpenForm versus ?OpenAgent), the one with the lowest NoteID “wins” – and that depends on the order the notes were added to a particular replica. (Ran across that myself a few years back and tested extensively to find a pattern.)
Subject: RE: FIXED
Thanks Stan, that makes perfect sense. I did just have formName?Open as the url, so exactly what you said.
Dan
Subject: Update - something else happening
OK, so this is really weird.
I’ve gone into the design of the db (not using the template even), and removed the webqueryopen agent completely.
On my web server it still tries to run it (I get a log of it). On my replica on the internal server it doesn’t run as planned.
I’ve done a fixup, compact and updall but that doesn’t help.
HELP!
Subject: RE: Update - something else happening
Dan,
You can’t just delete the WebQueryOpen agent. You also have to delete the reference to it in the WebQueryOpen event on the form.
Ken
Subject: RE: Update - something else happening
That’s what I meant, sorry. I removed the line in the webqueryopen on the form and it didn’t stop it from running…
Subject: RE: Update - something else happening
Dan,
If you have two databases that are replicas and you make a design change in one of them, you have to force replication with the other DB, otherwise it is still functioning with the old code.
Ken
Subject: RE: Update - something else happening
You might want to read my response above to see what was actually happening, and why the error was occuring in one replica/copy and not the other.