Splunk Search

[INGEST_EVAL] Regex replace stops after 1000 chars

tobias_stegmann
Observer

Hi,

I'm trying to convert a hex string to readable ascii text at index time, inspired by this solution: https://answers.splunk.com/answering/204869/view.html

This works fine at search time but I need it at index time, because I have to extract the timestamp from the hex string. But at index time replace(X,Y,Z) seems to stop/break after exactly 1000 charachters using INGEST_EVAL.

To accomplish this I have the following stanzas:
transforms.conf

[test_hex]
INGEST_EVAL = raw_ascii=replace(_raw,"([0-9A-Fa-f]{2})","%\1")

props.conf

[test_eval]
TRANSFORMS-hex = test_hex

So e.g., if I index following event:

0x01234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009

The field raw_ascii looks like this:

0x%01%23%45%67%89%10%11%12%13%14%15%16%17%18%19%20%21%22%23%24%25%26%27%28%29%30%31%32%33%34%35%36%37%38%39%40%41%42%43%44%45%46%47%48%49%50%51%52%53%54%55%56%57%58%59%60%61%62%63%64%65%66%67%68%69%70%71%72%73%74%75%76%77%78%79%80%81%82%83%84%85%86%87%88%89%90%91%92%93%94%95%96%97%98%99%10%01%01%10%21%03%10%41%05%10%61%07%10%81%09%11%01%11%11%21%13%11%41%15%11%61%17%11%81%19%12%01%21%12%21%23%12%41%25%12%61%27%12%81%29%13%01%31%13%21%33%13%41%35%13%61%37%13%81%39%14%01%41%14%21%43%14%41%45%14%61%47%14%81%49%15%01%51%15%21%53%15%41%55%15%61%57%15%81%59%16%01%61%16%21%63%16%41%65%16%61%67%16%81%69%17%01%71%17%21%73%17%41%75%17%61%77%17%81%79%18%01%81%18%21%83%18%41%85%18%61%87%18%81%89%19%01%91%19%21%93%19%41%95%19%61%97%19%81%99%20%02%01%20%22%03%20%42%05%20%62%07%20%82%09%21%02%11%21%22%13%21%42%15%21%62%17%21%82%19%22%02%21%22%22%23%22%42%25%22%62%27%22%82%29%23%02%31%23%22%33%23%42%35%23%62%37%23%82%39%24%02%41%24%22%43%24%42%45%24%62%47%24%82%49%25%02%51%25%22%53%25%42%55%25%62%57%2

...Which is exactly 1000 characters.
Using the same replace statement at search time it works fine:

0x%01%23%45%67%89%10%11%12%13%14%15%16%17%18%19%20%21%22%23%24%25%26%27%28%29%30%31%32%33%34%35%36%37%38%39%40%41%42%43%44%45%46%47%48%49%50%51%52%53%54%55%56%57%58%59%60%61%62%63%64%65%66%67%68%69%70%71%72%73%74%75%76%77%78%79%80%81%82%83%84%85%86%87%88%89%90%91%92%93%94%95%96%97%98%99%10%01%01%10%21%03%10%41%05%10%61%07%10%81%09%11%01%11%11%21%13%11%41%15%11%61%17%11%81%19%12%01%21%12%21%23%12%41%25%12%61%27%12%81%29%13%01%31%13%21%33%13%41%35%13%61%37%13%81%39%14%01%41%14%21%43%14%41%45%14%61%47%14%81%49%15%01%51%15%21%53%15%41%55%15%61%57%15%81%59%16%01%61%16%21%63%16%41%65%16%61%67%16%81%69%17%01%71%17%21%73%17%41%75%17%61%77%17%81%79%18%01%81%18%21%83%18%41%85%18%61%87%18%81%89%19%01%91%19%21%93%19%41%95%19%61%97%19%81%99%20%02%01%20%22%03%20%42%05%20%62%07%20%82%09%21%02%11%21%22%13%21%42%15%21%62%17%21%82%19%22%02%21%22%22%23%22%42%25%22%62%27%22%82%29%23%02%31%23%22%33%23%42%35%23%62%37%23%82%39%24%02%41%24%22%43%24%42%45%24%62%47%24%82%49%25%02%51%25%22%53%25%42%55%25%62%57%25%82%59%26%02%61%26%22%63%26%42%65%26%62%67%26%82%69%27%02%71%27%22%73%27%42%75%27%62%77%27%82%79%28%02%81%28%22%83%28%42%85%28%62%87%28%82%89%29%02%91%29%22%93%29%42%95%29%62%97%29%82%99%30%03%01%30%23%03%30%43%05%30%63%07%30%83%09%31%03%11%31%23%13%31%43%15%31%63%17%31%83%19%32%03%21%32%23%23%32%43%25%32%63%27%32%83%29%33%03%31%33%23%33%33%43%35%33%63%37%33%83%39%34%03%41%34%23%43%34%43%45%34%63%47%34%83%49%35%03%51%35%23%53%35%43%55%35%63%57%35%83%59%36%03%61%36%23%63%36%43%65%36%63%67%36%83%69%37%03%71%37%23%73%37%43%75%37%63%77%37%83%79%38%03%81%38%23%83%38%43%85%38%63%87%38%83%89%39%03%91%39%23%93%39%43%95%39%63%97%39%83%99%40%04%01%40%24%03%40%44%05%40%64%07%40%84%09%41%04%11%41%24%13%41%44%15%41%64%17%41%84%19%42%04%21%42%24%23%42%44%25%42%64%27%42%84%29%43%04%31%43%24%33%43%44%35%43%64%37%43%84%39%44%04%41%44%24%43%44%44%45%44%64%47%44%84%49%45%04%51%45%24%53%45%44%55%45%64%57%45%84%59%46%04%61%46%24%63%46%44%65%46%64%67%46%84%69%47%04%71%47%24%73%47%44%75%47%64%77%47%84%79%48%04%81%48%24%83%48%44%85%48%64%87%48%84%89%49%04%91%49%24%93%49%44%95%49%64%97%49%84%99%50%05%01%50%25%03%50%45%05%50%65%07%50%85%09%51%05%11%51%25%13%51%45%15%51%65%17%51%85%19%52%05%21%52%25%23%52%45%25%52%65%27%52%85%29%53%05%31%53%25%33%53%45%35%53%65%37%53%85%39%54%05%41%54%25%43%54%45%45%54%65%47%54%85%49%55%05%51%55%25%53%55%45%55%55%65%57%55%85%59%56%05%61%56%25%63%56%45%65%56%65%67%56%85%69%57%05%71%57%25%73%57%45%75%57%65%77%57%85%79%58%05%81%58%25%83%58%45%85%58%65%87%58%85%89%59%05%91%59%25%93%59%45%95%59%65%97%59%85%99%60%06%01%60%26%03%60%46%05%60%66%07%60%86%09%61%06%11%61%26%13%61%46%15%61%66%17%61%86%19%62%06%21%62%26%23%62%46%25%62%66%27%62%86%29%63%06%31%63%26%33%63%46%35%63%66%37%63%86%39%64%06%41%64%26%43%64%46%45%64%66%47%64%86%49%65%06%51%65%26%53%65%46%55%65%66%57%65%86%59%66%06%61%66%26%63%66%46%65%66%66%67%66%86%69%67%06%71%67%26%73%67%46%75%67%66%77%67%86%79%68%06%81%68%26%83%68%46%85%68%66%87%68%86%89%69%06%91%69%26%93%69%46%95%69%66%97%69%86%99%70%07%01%70%27%03%70%47%05%70%67%07%70%87%09%71%07%11%71%27%13%71%47%15%71%67%17%71%87%19%72%07%21%72%27%23%72%47%25%72%67%27%72%87%29%73%07%31%73%27%33%73%47%35%73%67%37%73%87%39%74%07%41%74%27%43%74%47%45%74%67%47%74%87%49%75%07%51%75%27%53%75%47%55%75%67%57%75%87%59%76%07%61%76%27%63%76%47%65%76%67%67%76%87%69%77%07%71%77%27%73%77%47%75%77%67%77%77%87%79%78%07%81%78%27%83%78%47%85%78%67%87%78%87%89%79%07%91%79%27%93%79%47%95%79%67%97%79%87%99%80%08%01%80%28%03%80%48%05%80%68%07%80%88%09%81%08%11%81%28%13%81%48%15%81%68%17%81%88%19%82%08%21%82%28%23%82%48%25%82%68%27%82%88%29%83%08%31%83%28%33%83%48%35%83%68%37%83%88%39%84%08%41%84%28%43%84%48%45%84%68%47%84%88%49%85%08%51%85%28%53%85%48%55%85%68%57%85%88%59%86%08%61%86%28%63%86%48%65%86%68%67%86%88%69%87%08%71%87%28%73%87%48%75%87%68%77%87%88%79%88%08%81%88%28%83%88%48%85%88%68%87%88%88%89%89%08%91%89%28%93%89%48%95%89%68%97%89%88%99%90%09%01%90%29%03%90%49%05%90%69%07%90%89%09%91%09%11%91%29%13%91%49%15%91%69%17%91%89%19%92%09%21%92%29%23%92%49%25%92%69%27%92%89%29%93%09%31%93%29%33%93%49%35%93%69%37%93%89%39%94%09%41%94%29%43%94%49%45%94%69%47%94%89%49%95%09%51%95%29%53%95%49%55%95%69%57%95%89%59%96%09%61%96%29%63%96%49%65%96%69%67%96%89%69%97%09%71%97%29%73%97%49%75%97%69%77%97%89%79%98%09%81%98%29%83%98%49%85%98%69%87%98%89%89%99%09%91%99%29%93%99%49%95%99%69%97%99%89%99%10%00%10%01%10%02%10%03%10%04%10%05%10%06%10%07%10%08%10%09

Surprisingly enough, if I remove the percent sign and just use replace(_raw,"([0-9A-Fa-f]{2})","\1") (weird way to clone _raw) the field is complete.

I've tried increasing depth_limit in limits.conf but without luck.

Any ideas?

Thanks in advance!

0 Karma

skalliger
Motivator

In limits.conf? DEPTH_LIMIT has to be set in transforms.conf.

Skalli

0 Karma

tobias_stegmann
Observer

Thanks for the hint. There's also a depth_limit in limits.conf. I guess limits.conf is the global one, while transforms.conf is only valid for the stanza.

I've also tried depth_limit in tranforms.conf, but that didn't work either.

0 Karma

skalliger
Motivator

Hm, that is unfortunate. If that doesn't work, I don't have any other ideas. Maybe ask Splunk support about it because I haven't found anything in the specs either. If you get a solution keep us updated. 🙂

Skalli

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...