Advanced query Invalid column index

  
Having a strange situation: Advanced query runs w/o any problems when running it with a test-value in design-time. Therefore I may conclude that the output structure's attributes are matching the query-attributes (the right number, correct data-type). Strangly enough, after deploying and in run-time I'm getting this "invalid column index"-error. What could be the possible reason for this?
Message:
 
Error in advanced query GetEVW_CONTRACT in GetEVW_CONTRACT in ArvalEClient (SELECT {CONTRACT_GEG}.CONTRACTNR,            {CONTRACT_GEG}.CALC_BASIS_VOLGNR,            {CALC_BASIS}.KENTEKEN,            {CALC_BASIS}.DAT_KENTEKEN,            {MERK_GEG}.MERK_NAAM || ' ' || {CALC_BASIS}.OMSCHRIJVING omschr_merk_type,            {MERK_GEG}.TYPE_MERK,            {MERK_GEG}.MERK_NAAM,            {MODEL_GEG}.MODEL_NAAM,            {VOERTUIG_GEG}.KLEUR_CARROS,            {VOERTUIG_GEG}.KLEUR_BEKLED,            {CALC_BASIS}.CDE_SRT_BRSTF,            {CALC_BASIS}.MOTOR_EMISSIE,            {CALC_RES}.BEDR_TAX_1 fiscale_klasse,            {CALC_RES}.BEDR_TAX_3 co2_tax_per_maand,            {CALC_BASIS}.CDE_LABEL_ENERGIE,            {CALC_BASIS}.CATPRS_EXBTW,            {CALC_BASIS}.CATPRS_INBTW,            {CALC_BASIS}.BEDR_ACC_FABR,            ({VOERTUIG_GEG}.PRS_FISCAAL - {CALC_BASIS}.CATPRS_INBTW) bedr_acc_fabr_incl, --BEDRAG FABRIEKSOPTIES INCL BTW/BPM                                                        {CALC_BASIS}.BEDR_ACC_NORM,                     --BEDRAG ACCESSOI ...): Invalid column index
 
Stack:
 
outsystems.hubedition.runtimeplatform.DataBaseException: Error in advanced query GetEVW_CONTRACT in GetEVW_CONTRACT in ArvalEClient (SELECT {CONTRACT_GEG}.CONTRACTNR,            {CONTRACT_GEG}.CALC_BASIS_VOLGNR,            {CALC_BASIS}.KENTEKEN,            {CALC_BASIS}.DAT_KENTEKEN,            {MERK_GEG}.MERK_NAAM || ' ' || {CALC_BASIS}.OMSCHRIJVING omschr_merk_type,            {MERK_GEG}.TYPE_MERK,            {MERK_GEG}.MERK_NAAM,            {MODEL_GEG}.MODEL_NAAM,            {VOERTUIG_GEG}.KLEUR_CARROS,            {VOERTUIG_GEG}.KLEUR_BEKLED,            {CALC_BASIS}.CDE_SRT_BRSTF,            {CALC_BASIS}.MOTOR_EMISSIE,            {CALC_RES}.BEDR_TAX_1 fiscale_klasse,            {CALC_RES}.BEDR_TAX_3 co2_tax_per_maand,            {CALC_BASIS}.CDE_LABEL_ENERGIE,            {CALC_BASIS}.CATPRS_EXBTW,            {CALC_BASIS}.CATPRS_INBTW,            {CALC_BASIS}.BEDR_ACC_FABR,            ({VOERTUIG_GEG}.PRS_FISCAAL - {CALC_BASIS}.CATPRS_INBTW) bedr_acc_fabr_incl, --BEDRAG FABRIEKSOPTIES INCL BTW/BPM                                                        {CALC_BASIS}.BEDR_ACC_NORM,                     --BEDRAG ACCESSOI ...): Invalid column index   at osarvaleclient.actions.ActGetEVW_CONTRACT$FuncActGetEVW_CONTRACT.queryGetEVW_CONTRACT(Unknown Source)
    at osarvaleclient.actions.ActGetEV... -Env-
 eSpaceVer: 54 (Id=17886, PubId=19704, CompiledWith=8.0.1.8) RequestUrl: http://osdev01.dev/ArvalEClient/Overzichten.jsf?Name=AUTOSINCONTRACT (Method: GET) ClassLoader: weblogic.utils.classloaders.ChangeAwareClassLoader@265b01a5 finder: weblogic.utils.classloaders.CodeGenClassFinder@257d26cb annotation: ArvalEClient@ArvalEClient.war(643498405) FilePath: /ArvalEClient/MainOverzichten.jsp Locale: nl-NL DateFormat: dd-MM-yyyy PID: 23918 ('23918@osdev01.dev', Started='5/20/14 7:54:50 AM', Priv=810Mb, Virt=1024Mb) TID: 656 Thread Name: [ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)' JRE: R28.2.5-20-152429-1.6.0_37-20120927-1915-linux-x86_64
Bas Vermeulen wrote:
Problem solved: within the advanced query a function was used preceded by <schema-name>. Obviously the schema-prefix is causing the trouble in run-time, not in design-time.