Venodr specific functions are not working in report studio

[santosh.yelugoi]

Hi All,

Good Morning !!!!

Here I have two data sources both are Oracle.

For one of the data source I am using vendor specific functions i.e. from Oracle. Its working fine without any issues.
For another data source the vendor specific functions are not working.Its throwing error like the query using Local Processing.

When I checked in the Framework manager side for data sources properties. for both data sources query processing is as: Limited Local.

Could you please try to resolve this issue.

Regards,
Santosh :'(

[raj_aries]

Hi santosh,

Just a thought..

Did you include atleast one dataitem from the package that usesn second datasource in the report. Also, please tell me what are the functions/calculation that you included for the dataitem

Regards
Raj

[santosh.yelugoi]

Hi Raj,

I am using two queries and i have done Unison for those two in to 3rd query.
And I am finding for each week Monday and friday for this each week i want to shaow some revenue.


So for Monady I have used below logic:
next_day([Date]-7,'MONDAY')

And Friday I have used below logic:


case
when to_char([Date],'D')='5' then [Date]
else
next_day([Date],'FRIDAY')
end

and the I have used below concatination for show  a week as below:

[Monday]||' '||[Friday]

and the i have applied some format to above concatination to show each week row as in attached format:
'Week ending'||' '||substr([Week],-9,2)||'.'||substr([Week],-6,3)||'.'||substr([Week],-2,2)



All above things are working when I tried to execute on single query, but I am unable to execute on Union query as it is throwing an error as below:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function "to_char" is being used for local processing but is not available as a built-in function, or at least one of its parameters is not supported.


Could you please tell me why its not working on Union Query.

Regards,
Santosh