Essbase data load rule and SQL interface error

Summary

Object not found when running a SQL interface based rule

Content

Hello,

We have the following error when executing both a SQL interfaced based Data Load Rule or Data Build Rule.

1. We define a connection toward ADW which validates OK

2. We define a data source, the query is recognized and works OK

3. We create a script (rule) : database / inspect / scripts / rule, rules is set up and validates OK

4. We load data using the DLR KO

Error while executing SQL "Select 
    'C' || fc.compte as indicateur,
    'M' || TO_CHAR(fc.date_ecriture, 'MM') as mois,
    fc.cod_section as section,