Export of PDF and CSV report does not show correct date range when selected, it defaults to one day when data is exported
search cancel

Export of PDF and CSV report does not show correct date range when selected, it defaults to one day when data is exported

book

Article ID: 414669

calendar_today

Updated On:

Products

VCF Operations for Networks

Issue/Introduction

Aria Operations for Networks has a feature to export PDF and CSV files.

Export of PDF and CSV report does not show correct date range, defaults to one day. For example if  user selects preset values such as 3/7 days range or 15/30 day range defaults to only 1 day.


1. User on GUI Navigates to select entity with custom date range as seen in below screenshot.

   

2. When Export to PDF is selected Config page and the PDF preview window comes which shows the date ranges default to 1 day as seen in below screenshot.
    
     
    

3. When Export PDF is Clicked and pdf file is generated it shows defaulted to day1 as well.

4 Same happen when export to CSV is done where it defaults to exporting 1 day worth of data

5. From logs at location /var/log/arkin/restapilayer/latest_error.log  show below entries.

   For PDF export    

2025-09-17T15:30:24.164Z INFO resources.licenseUsageEnforcement.LicenseUsageEnforcementService dw-202742 - POST /pdfexport isAllAccessBlocked:285 No universal usage enforcement record found while checking access blocked for cid 12593
2025-09-17T15:30:24.239Z INFO vnera.restapilayer.PDFResource dw-202742 - POST /pdfexport exportPDF:72 Going for csrf population
2025-09-17T15:30:24.244Z INFO vnera.restapilayer.PDFResource dw-202742 - POST /pdfexport exportPDF:75 Session validation successful
2025-09-17T15:30:24.250Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:135 Preparing connection header
2025-09-17T15:30:24.251Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 lambda_prepareConnectionHeaders_1:231 Adding header string Origin with value https://###-###-#####.## to local request
2025-09-17T15:30:24.251Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 lambda_prepareConnectionHeaders_1:231 Adding header string sec-fetch-mode with value navigate to local request
2025-09-17T15:30:24.263Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:145 Sending content disposition, Content Name is htmlBlob
2025-09-17T15:30:24.264Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:150 Sent content disposition, now sending actual contents
2025-09-17T15:30:24.283Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:180 Finished sending all data to local service, now checking for the input stream

2025-10-02T18:45:58.807Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:183 Got inputStream
2025-10-02T18:45:58.807Z INFO vnera.restapilayer.PDFResource pdfexport-exec-0 getPDFStream:196 Input stream is ready, returning the same.
2796 "https://####-###-###.#####.###/foo=bar" "Mozilla/5.0 (Windows NT 10.0 Win64_ x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/###.#.#.# Safari/537.36 Edg/140.0
.0.0" 11202
2025-10-02T18:45:59.579Z INFO storage.config.BaseESClient Thread-448 executeCollect:971 collect: Total Hits = 15 hits, Time taken = 19 ms
2025-10-02T18:45:59.590Z INFO storage.config.BaseESClient Thread-448 executeSearch:500 executeSearch: Total Hits = 15 hits, Time taken = 9 ms
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 runSearchWithMapResult:213 Props list is [intentTypeId, filterRules, name, intentParams]
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [DuplicatedMACAddress]
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Duplicate MAC Address]
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.590Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [NativeVlanMismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Native VLAN Mismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [APPLICATION_FLOW_UTILIZATION]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [
{totalEntitiesCount=0}]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Application Flow Utilization]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [{keyValues=[{valueType=SCOPE_CONDITION, value={"scop
eParamValue": {"name": "Scope", "chosenScopeType": "SCOPE_PREDEFINED_LIST", "scopeTypeValue": "SCOPE_ALL_APPLICATIONS"}, "scopeConditionsValue": {"conditions": {"expression": "OR", "childConditions": [{"condition": {"conditionId": "APPLICATION_FLOW_UTILIZATION_MetricThreshold1", "operator": "DEVIATE", "values": ["MEDIUM"]}, "expression": "LEAF"}, {"condition": {"conditionId": "APPLICATION_FLOW_UTILIZATION_MetricThreshold2", "operator": "DEVIATE", "values": ["MEDIUM"]},"expression": "LEAF"},{"condition": {"conditionId": "APPLICATION_FLOW_UTILIZATION_MetricThreshold3", "operator": "DEVIATE", "values": ["MEDIUM"]}, "expression": "LEAF"},{"condition": {"conditionId": "APPLICATION_FLOW_UTILIZATION_MetricThreshold4","operator": "DEVIATE", "values": ["MEDIUM"]}, "expression": "LEAF"}], "clauseId": "APPLICATION_FLOW_TRAFFIC"}}}, key=application-scope-condition}], key=application-scope-condition}, {keyValues=[{valueType=FIXED_MULTI_CHOICE_SINGLE_VALUE, value=VIOLATION_DURATION_FIVE_MINUTES, key=min-violation-duration}], key=min-violation-duration}]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [PortChannelMemberMismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Port Channel Member Mismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [TrunkPortVlanMismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Trunk VLAN Mismatch]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [DuplicatedIPAddress]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Duplicate IP Address]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value null
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [APPLICATION_FLOW_HEALTH]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [{totalEntitiesCount=0}
]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [Application Flow Health]
2025-10-02T18:45:59.591Z INFO vnera.restapilayer.Py4JServer Thread-448 lambda_runSearchWithMapResult_1:244 Using value [{keyValues=[
{valueType=FIXED_MULTI_CHOICE_SINGLE_VALUE, value=VIOLATION_DURATION_FIVE_MINUTES, key=min-violation-duration}


For CSV Export

2025-09-17T15:51:46.031Z ERROR query.runner.QueryTreeBuilder recursive-batch-operation-exec-3 createSubQueryExpressionNode:656 Too many results 101498 for creating sub query node
2025-09-17T15:51:46.032Z ERROR query.runner.QueryTreeBuilder recursive-batch-operation-exec-3 createSubQueryExpressionNode:681 Caught exception in running subquery intents=[] plural=false aspects=[PROPERTY] ot=FLOW_INFO name=null text=false ((protectionStatus EQ un_protected)) AND ((((exists (srcIpEntity.application)) OR (exists (dstIPEntity.application))) OR (exists (srcK8sInfo.k8sService.application))) OR (exists (dstK8sInfo.k8sService.application))) [ 2025-09-17T15:51:37.317Z, 2025-09-17T15:51:37.317Z ]
com.vnera.query.common.QueryException: Number of results exceeds the supported limit of about 100000 results. Refine the query by adding filter conditions or select a shorter time period.
at com.vnera.query.common.QueryUtils.newQueryException(QueryUtils.java:53) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.createSubQueryExpressionNode(QueryTreeBuilder.java:657) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.buildExprQueryTree(QueryTreeBuilder.java:484) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.buildMetricAndMixedPredicateTree(QueryTreeBuilder.java:390) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.buildQueryTreeBase(QueryTreeBuilder.java:352) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.buildQueryTree(QueryTreeBuilder.java:178) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.planQuery(Runner.java:2334) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.planQuery(Runner.java:2271) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.buildQueryTree(Runner.java:518) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner._executeInternal(Runner.java:831) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.executeNestedQuery(QueryTreeBuilder.java:1020) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder_NestedQueryExpressionRewriter.rewriteNestedQueryBinaryExpression(QueryTreeBuilder.java:1376) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.parser.BooleanExprRewriter.rewrite(BooleanExprRewriter.java:36) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.preProcessNestedQueryExprs(QueryTreeBuilder.java:995) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.preProcess(QueryTreeBuilder.java:245) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.QueryTreeBuilder.buildQueryTree(QueryTreeBuilder.java:166) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.planQuery(Runner.java:2334) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.planQuery(Runner.java:2271) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.buildQueryTree(Runner.java:518) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner._executeInternal(Runner.java:831) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.runner.Runner.execute(Runner.java:787) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.SearchUtils.getQueryResult(SearchUtils.java:377) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.SearchUtils.getQueryResult(SearchUtils.java:344) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.SearchUtils.runSearch(SearchUtils.java:261) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.query.SearchUtils.getSearchCountResult(SearchUtils.java:1139) _[query-0.001-SNAPSHOT.jar:_]
at com.vnera.restapilayer.newhomepage.HomePageUtils.lambda_processInsights_0(HomePageUtils.java:82) _[restapilayer-0.001-SNAPSHOT.jar:_]
at com.vnera.common.RecursiveBatchOperation_ThreadPoolWrapper.lambda_trySubmit_0(RecursiveBatchOperation.java:242) _[common-0.001-SNAPSHOT.jar:_]
at java.util.concurrent.CompletableFuture_AsyncSupply.run(CompletableFuture.java:1768) [_:_]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [_:_]
at java.util.concurrent.ThreadPoolExecutor_Worker.run(ThreadPoolExecutor.java:635) [_:_]
at java.lang.Thread.run(Thread.java:840) [_:_]
2025-09-17T15:51:46.033Z ERROR restapilayer.newhomepage.HomePageUtils recursive-batch-operation-exec-3 lambda_processInsights_0:92 Exception encountered for query - application where endpoint in (list(endpoint) of flows where protectionStatus = 'UN_PROTECTED' and application is set) at timestamp 1758124297317 during get top insights - Too many results () for nested query 'list(endpoint) of flows where protectionStatus = 'UN_PROTECTED' and application is set'. Refine the nested query by adding filter conditions or select a shorter time period.

 


    
    

Environment

VCF Operations for Networks 6.14.1

Cause

Export for PDF and for CSV has been identified as product related issue.

Resolution

VCF Network Operations product Engineering is aware of this issue and working on fixing this in a future version of VCF 9.x

As of now there is No workaround available.

Additional Information

Subscribe to this knowledge article to get updates on this issue.

Powered by Wolken Software