CSV Generated In OAS DV Has Error Message And No Data: 'Invalid queryID string' (Doc ID 3004818.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.

Symptoms

On : 2022 (6.4) version, Analytics

When generating any CSV export in Data Visualization (/dv) a file gets generated, however the file does not have the expected data.

Instead, the following is written into the exported csv file:

<!DOCTYPE HTML>

<html dir="ltr" lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="Content-Language" content="en"><link href="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/s_Alta/master/custom.css" type="text/css" rel="stylesheet"><link href="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/sk_Skyros/b_mozilla_4/htmlglobals.css" type="text/css" rel="stylesheet"><noscript><link href="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/sk_blafp/b_mozilla_4/noscript.css" type="text/css" rel="stylesheet"></noscript><link href="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/sk_Alta/b_mozilla_4/pagedialog.css" type="text/css" rel="stylesheet"></head><body class="masterOBIEE ErrorBody"><div>

<script type="text/javascript" src="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/b_mozilla/common.js"></script><div class="ErrorMessage">Invalid queryID string</div><div style="margin-top:2pt" onclick="SAWMoreInfo(event); return false;"><img class="ErrorExpanderImg" border="0" alt="" src="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/sk_blafp/common/errorplus.gif" align="absmiddle">  Error Details<div style="margin-left:15px;display:none" compresssrc="https://[server]:[port]/analytics/res/v-Bg1gS1142QA/sk_blafp/common/errorminus.gif">
<div class="ErrorCodes">Error Codes: <span dir="ltr">GKEIW7NN</span></div>Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads
</div></div></div></body></html>

Users are able to download the data in PDF successfully but not in CSV.

CSV can be successfully exported in /analytics.

Changes

First time trying to export in existing OAS instance.

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.