How to resolve a data configuration failure with "failed to execute data configuration. Failed to execute query: unspecified error" when retreiving data off a Spotfire Statistica data entry setup
Article ID: KB0138351
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 14.x |
Description
When using a Data Entry Label with Date/Time format with the year represented as YYYY, an incorrect value for the year could be entered. When a "Data Configuration off a Data Entry Setup", which is a query, is Explored or executed, the following error occurs:
The error may appear when creating a "New Data Configuration off this Data Entry Setup":
Some example formats are:
1. Date
2. Custom
Note: The error only appears with data configurations with the "Make Date/Time labels as Date/Time columns" option selected:
Environment
OS: Windows
Resolution
1. If the specific error is unknown, run the query directly in SSMS or SQL Developer. Copy the query and execute the query:
2. If the query fails with a datetime message, like below, then maybe a incorrect entry in the Data Entry Setup sample form:
3. Get all the label ids for each datetime label in Enterprise Manager:
For the example, two ids are needed. The ids in this example are 86 and 87.
4. Run the query below in SSMS or Oracle Developer:
select * from
(
select *,
TRY_CAST(IIF(SUBSTRING(LABVALUE, 1, 10) = '0001-01-01', SUBSTRING(LABVALUE, 12, 8), LABVALUE) as DATETIME) as LabValue_DT_TRY_CAST
from csldat where labelid in (86,87)
) a
where a.LabValue_DT_TRY_CAST is null;
The query will try to change the datetime label value to the DateTime format. If that fails then the LabValue_DT_TRY_CAST will output a null value.
5. The query will provide the samples with the incorrect datetime entry. Below,
6. Modify the sample(s) in data entry:
The data configuration query should now execute successfully.
Issue/Introduction
How to resolve a data configuration failure with "failed to execute data configuration. Failed to execute query: unspecified error" when retreiving data off a Spotfire Statistica data entry setup
