In this application when a page submits a request, it calls a
procedure. I matched up the request logs with the phantom orders and
checked the IP addresses making the requests. They were msnbot! After
duplicating the phantom loads I did a search on Bing and found the URL
for the procedure that adds the load. You can not log into the system
from the URL, but authentication is checked after the blank record is
appended. You also have to call the URL with a parameter with the robot
does but Bing does not. There is a robot.txt in each folder but it
appears that msnbot does not respect that. Looking at the requests, it
appears that msnbot calls the url anywhere from two to over 100 times
right in a row! They just happen to catch these urls immediately after
the request.
The solution will include up front authentication for each request as
well as insert instead of append & gather.
Thanks for all of your ideas & help!
Until next time! ;^)
Jeff
---------------
Jeff Johnson
[email protected]
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
On 02/22/2013 07:20 AM, Jeff Johnson wrote:
I have a very strange problem. It is an application that uses append
and gather. June of last year their system started creating orders
with blank information in them. Mainly dispatcher. They call them
phantom orders. There is no rhyme or reason for them to appear, but
40% of their overall orders since then. They wrote a routine to zero
out the numbers and delete them but it is annoying because they show
up and then the purge routine removes them and the users see this.
There are about 100 users.
The only thing that I found that is unusual is that the order table
was indexed on every field with the invoice field descending. Could
this cause problems when adding new records?
Thanks in advance,
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
