Skip to content
Notifications
Clear all

Persistent 'parsing error' on Office 365 logs - support ticket going nowhere.

56 Posts
54 Users
0 Reactions
130 Views
(@cloud_ops_amy)
Honorable Member
Joined: 7 months ago
Posts: 453
 

>average 6.2 days per cycle

That's a grimly precise number, and I believe it. The "asking if you're still seeing the issue" feels like a universal signal for the ticket stalling.

Your point about the mapping logic being a volatile layer is exactly what I've seen with other sources, like AWS CloudTrail. The published schema is a static reference, but the internal mapper is a live service with its own undocumented constraints. The URL length hypothesis is a great call - I've seen `user_agent` strings cause similar silent breaks when they exceeded some internal buffer.

One thing I'd add: when pulling those 20 raw logs, make sure a few are from *before* the suspected regression date. Showing the same event structure that used to parse successfully alongside the now-failing ones can make the regression case undeniable.


Cloud cost nerd. No, I don't use Reserved Instances.


   
ReplyQuote
(@danm)
Honorable Member
Joined: 3 months ago
Posts: 452
 

Yep, that's the move. I've had the exact same experience with the Sharepoint mapper. One thing I'd add: when you anonymize those logs, make sure you don't strip out the field that's actually causing the new constraint. I once redacted a URL completely and it made the log parse successfully in their sandbox, which sent the ticket into another loop. Keep the structure intact, just swap the values.



   
ReplyQuote
(@harperk)
Honorable Member
Joined: 3 months ago
Posts: 537
 

Oh, that's a perfect trap. I've done the same with user agent strings, swapping them out for a simple "Mozilla" placeholder. Suddenly the 512-character limit they'd quietly introduced wasn't hit and the ticket got bounced back with "unable to reproduce." Now I replace the real value with a dummy string of equal or greater length. The parser needs to choke on the same thing.


Data over dogma.


   
ReplyQuote
(@chrisw2)
Reputable Member
Joined: 2 months ago
Posts: 309
 

Good call on matching the length. I've seen tickets stall because the dummy data didn't trigger the new size constraint, exactly like you said.

One more thing to watch: sometimes it's not just total length, but the count of specific characters like commas or brackets. I got burned once replacing a real JSON snippet inside a field with a lorem ipsum string; the parser was actually counting nested braces and mine didn't have any.


Run it yourself.


   
ReplyQuote
(@cloud_cost_hawk_2)
Honorable Member
Joined: 5 months ago
Posts: 472
 

Oh, that JSON-inside-a-field gotcha is a special kind of pain. I swear the Azure Activity Log mapper had a phase where it was counting backslashes in file paths - dummy data with just forward slashes would fly right through, letting them close the ticket. Now I use a script to replicate the structural complexity of the original value, not just the length. It's the only way to make the parser cough up the real error.



   
ReplyQuote
(@amyw)
Honorable Member
Joined: 2 months ago
Posts: 427
 

That "parsing error" message is so unhelpful, it's almost impressive. Been there with those silent breaks.

I hit the same thing with `SharePointFileOperation` about three weeks back. For me, it was a new `SiteUrl` field appearing with a weirdly encoded ampersand that the mapper choked on. Our other events kept parsing, so it felt exactly like a silent schema shift.

Hang in there with the ticket. In my case, attaching 5 good/bad log pairs with the breaking field highlighted finally got it escalated.


measure twice, ship once


   
ReplyQuote
(@deborahw)
Reputable Member
Joined: 3 months ago
Posts: 358
 

Oh, they absolutely have versioned schemas internally. The question is whether their frontline support has any access to that version history, or if it's locked away in some engineering silo.

That "last updated" date is just a pacifier. It lets them say the docs are current while giving them plausible deniability when the mapping service outruns the documentation. Classic shadow roadmap tactic.


—DW


   
ReplyQuote
(@gracehopper2)
Reputable Member
Joined: 3 months ago
Posts: 388
 

That support cycle is painfully familiar. I had a nearly identical timeline with Azure Activity logs last quarter.

When you send the raw logs, consider adding a summary table at the top of the ticket update. List the event ID, timestamp, and the specific field you suspect (maybe `clientInfo.userAgent` or a particular URL parameter). It sometimes short-circuits the generic "send logs" loop and gets a human to actually look at the comparison.

Have you noticed if the failing events all share a specific operation type, like `FileDownloaded` versus `FileUploaded`? That could narrow down which part of the mapper is broken.


ship early, test often


   
ReplyQuote
(@george7)
Honorable Member
Joined: 3 months ago
Posts: 572
 

I always include both. The raw Microsoft log ID anchors it to the source, but Chronicle's internal event ID gives their support a direct pointer to the failed parsing attempt in their own system. I've found that providing both seems to get it past the initial "we can't locate the event" step faster.

For a recent SharePoint issue, the internal ID was what finally let them pinpoint the exact mapper version that was choking. The raw ID alone just led to questions about our log forwarding setup.


Keep it constructive.


   
ReplyQuote
(@annie82)
Reputable Member
Joined: 3 months ago
Posts: 232
 

Ugh, that support cycle is so frustrating. I haven't hit this exact issue yet, but I've gotten the "GENERIC_EVENT" treatment from a different connector. It feels like you're just stuck waiting for their internal mapping to catch up to something that changed on Microsoft's side.

When you mentioned the labyrinth of versioned docs, that really hit home. I'm never confident I'm looking at the right schema either. Do you think there's any way to track which specific log fields started failing, or is it just a total black box until they decide to fix it?



   
ReplyQuote
(@ethanf)
Trusted Member
Joined: 3 months ago
Posts: 62
 

Yeah, the "GENERIC_EVENT" thing makes it feel totally black box. I had a similar wait with Teams logs a while back.

The only way I found to track failing fields was by exporting a small sample of raw logs before they hit the connector and doing a diff when new parsing errors showed up. It's tedious, but sometimes you can spot a new field or format. Have you tried comparing raw JSON from before and after the errors started?



   
ReplyQuote
(@barbaraj)
Reputable Member
Joined: 3 months ago
Posts: 400
 

You're right about naming the field directly. I've found that pinpointing the exact field, and even the suspected data type mismatch, forces a more technical review. For example, stating "the `userAgent` string exceeds the UDM `principal.user.agent` length constraint" often bypasses the first-tier support script.

Between the two methods, I've had more consistent results with the targeted field approach over a full spreadsheet. The spreadsheet provides excellent context for us, but it can overwhelm a support engineer. A focused, technical note like "constraint violation on `network.http.url` due to unencoded query parameters" gives them a specific diagnostic path. The spreadsheet then becomes the supporting evidence if they ask for a broader pattern.


—BJ


   
ReplyQuote
(@consulting_contractor_mike)
Honorable Member
Joined: 6 months ago
Posts: 393
 

Yes, specifically with `SharePointFileOperation` events starting around March 12th. The breaking change appears to be in the `ExtendedProperties` array. Some items now contain a nested JSON object as a string value, where the parser expects a flat key/value. Look for entries where the `Value` isn't a simple string.

You'll need to push the ticket with this exact detail. Attach a raw log snippet where `ExtendedProperties` has an item like `{"Name":"SomeField","Value":"{"nestedKey":"data"}"}`. Without pointing to the specific malformed structure, their frontline will keep running the generic diagnostics.


Mike


   
ReplyQuote
(@heatherm)
Reputable Member
Joined: 3 months ago
Posts: 255
 

Totally agree that the raw logs in a new ticket is the move. I'd just add one tactical note from my last run-in with this: anonymize, but don't *over*-anonymize. If you strip out all field values, they might come back saying the sample's unusable. I leave the structure intact and just hash the actual user principal names or specific file URLs.

Your point about an undocumented constraint is spot on. Last time, it was a new regex pattern silently applied to the `targetResource` field that rejected certain special characters. Took attaching the logs with a side-by-side of a passing and failing value to get it acknowledged as a bug.


Ask me about my RFP template


   
ReplyQuote
(@calebs)
Reputable Member
Joined: 2 months ago
Posts: 318
 

Check the `ExtendedProperties` array in your failing SharePoint events. Around mid-March, Microsoft started nesting JSON objects as string values in that field. The Chronicle mapper chokes on it because it expects flat strings.

You're right, the support loop is useless unless you hand them the exact malformed structure. Quote the specific `ExtendedProperties` item in your next ticket update. Something like `{"Name":"CustomMetadata","Value":"{"key":"value"}"}`. Without that, you'll just keep getting the five-day "investigation" bounce.



   
ReplyQuote
Page 2 / 4