SPAGOBI-1870 - Studio Fails to import External Data Set where query has single quotes wrapping a parameter

[KnowageServiceAcc]

Details

Key	Value
Key	SPAGOBI-1870
Type	Bug
Status	Open
Priority	Major
Resolution
Affects	5.0.0
Fix
Components	SERVER/Core, SERVER/Reporting/BIRT, STUDIO
Labels	analytical_drivers, birt, dataset, parameters, studio

People

Key	Value
Assignee	Alberto Ghedin
Reporter	David Harrison

Dates

Key	Value
Created	2014-09-18T23:07:00.000+0200
Updated	2014-10-08T15:10:09.000+0200
Resolved	n.d.

Description

Problem:
In Short, I'm not able to pass alpha-numeric (as Strings, Generics, RAW) parameters, using an External Data Set.
As an attempted work-around for SPAGOBI-1869, I tried passing string parameters as Generics or Raw types, rather than Strings.

Problem Description
If a Data Set's SQL query has a parameter wrapped in single quotes, then when you use SpagoBI Studio and BIRT report designer to attach to that data set, it fails with an error and it not able to import or use the data set.

If a Data Set's SQL query has a Generic parameter wrapped in single quotes, then when you use SpagoBI Studio and BIRT report designer to attach to that data set, it fails with an error. We're trying to avoid the inconsistent String wrapping/unwrapping by specifying a parameter type without strings and handling the single quote string encapsulation ourselves.

Query:
SELECT 1 val1, '$P{param_val}' valParam
Parameter:
param_val, type generic

Preview on the data set works in the SpagoBI web UI
However, attempting to retrieve that data set definition in Spago Studio 5.0 fails with an error.

"Failed to prepare the query executionf or the data set : GET val w arg r2"
Impossible to prepare query
impossible to retrive spagobi's dataset list

See the attached error-write up with screenshots and detailed logs for details

Comments

no comments