Web Connection
2 wwrequestlog recs with exact same reqid
Gravatar is a globally recognized avatar based on your email address. 2 wwrequestlog recs with exact same reqid
  VFPJCOOK
  All
  Feb 28, 2026 @ 07:15am

Hi Rick,

I am looking at wwrequestlog.dbf. I see 2 records with the exact same reqid value. They are instances where a vendor called the same API endpoint at the same wwrequestlog.time. My endpoint code handled both requests separately, each with it's own unique wwrequestlog.result. The vendor did NOT handle the responses properly. I am trying to determine what actually occurred and believe both requests having the same reqid is a clue. Can you tell me how it can occur that the reqid can be exactly the same value for 2 back to back requests?

Thanks, John

Gravatar is a globally recognized avatar based on your email address. re: 2 wwrequestlog recs with exact same reqid
  Rick Strahl
  VFPJCOOK
  Feb 28, 2026 @ 11:06am

I don't think so. These ID are generated Guids - no chance that these IDs would be repeating - same time or otherwise.

If it shows twice it's likely the second one is an error that's being logged.

Do this and take a closer look:

SELECT ReqId, COUNT(*) FROM wwRequestLog GROUP BY ReqId

Likely there are quite few requests that have more than one entry.

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: 2 wwrequestlog recs with exact same reqid
  VFPJCOOK
  Rick Strahl
  Feb 28, 2026 @ 02:06pm

I did as you suggested. There are 32,000 recs in the table. There are only 2 recs with dup reqid's. Both instances occurred yesterday within 15 seconds. Perhaps it was just a server hiccup. We were having server issues about that time. Don't spend anytime on this. If it becomes an issue I will ask again.

Thanks, John

© 1996-2026