WHERE DimCurrency.AlternateKey EQ 'EUR'Controller  >   

No result. See details below for possible causes

_Description

Contains, in addition to result, also log information about execution of API query
WHERE DimCurrency.AlternateKey EQ 'EUR'Controller

Individual query expressions are:
WHERE DimCurrency.AlternateKey EQ 'EUR'Controller

Note that the ordinary result (from an ordinary exceution of query) is stored in -Result- which is 'invisible' from ordinary -PropertyAccess-.

Query was prematurely terminated

TerminateReason

For query expression

WHERE DimCurrency.AlternateKey EQ 'EUR'Controller

the key

DimCurrency.AlternateKey

was not found.

Last errorResponse is:

Key DimCurrency.AlternateKey not found
CompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCurrency'.
Some of the keys found where: _Description, AddController, EditController, GQController, RQController

Invalid MemberEntityKey because of: Property 'DimCurrency' not defined in schema for 'PRich' (enum 'PRichP.DimCurrency' does not exist,
and also
EntityMethodKey 'TryGetDimCurrency' not defined for PRich


The current type is PRich.
Probably the wrong key was used as criteria, or the key name was misspelled.

Some possible correct keys are:
PRichId, -~dbg-, -~std-

Some new key functions (available for all entity classes) are:
-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()

Some function keys (used on existing keys) are:
-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()

Some quantile keys (used on existing keys) are:
-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-


HINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).

AllLogEntriesForThisQuery

ExecuteOne/_/9/Start = 2025-11-03 16:57:59.404
ExecuteOne/_/9/Query = WHERE DimCurrency.AlternateKey EQ 'EUR'Controller
ExecuteOne/_/9/CountBefore = 4
ShouldTerminate/_/9/Text = For query expression0x000D0x000A0x000D0x000AWHERE DimCurrency.AlternateKey EQ 'EUR'Controller0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimCurrency.AlternateKey0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimCurrency.AlternateKey not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCurrency'.0x000D0x000ASome of the keys found where: _Description, AddController, EditController, GQController, RQController0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCurrency' not defined in schema for 'PRich' (enum 'PRichP.DimCurrency' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCurrency' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000A-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000A-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()0x000D0x000A0x000D0x000ASome quantile keys (used on existing keys) are:0x000D0x000A-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000AWHERE DimCurrency.AlternateKey EQ 'EUR'Controller0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimCurrency.AlternateKey0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimCurrency.AlternateKey not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimCurrency'.0x000D0x000ASome of the keys found where: _Description, AddController, EditController, GQController, RQController0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimCurrency' not defined in schema for 'PRich' (enum 'PRichP.DimCurrency' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimCurrency' not defined for PRich0x000D0x000A0x000D0x000A0x000D0x000AThe current type is PRich.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000APRichId, -~dbg-, -~std-0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000A-COUNTP-(), -COUNTPREC-(), -GETTYPE-(), -TOPROPERTYSTREAM-()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000A-ABS-(), -AVG-(), -AWFISCALYEAR-(), -COUNT-(), -DATE-(), -DAYOFWEEK-(), -DISTINCT-(), -DOUBLE-(), -FIRSTLINE-(), -HOURMINUTE-(), -INT-(), -JOIN-(), -LENGTH-(), -MAX-(), -MIN-(), -MONTH-(), -QUARTER-(), -SHORT-(), -SINGLE-(), -SUM-(), -TMB-(), -TOTALHOURS-(), -TOTALMINUTES-(), -TYPE-(), -VERYSHORT-(), -WEEK-(), -YEAR-(), -YEARMONTH-(), -YEARQUARTER-(), -YEARWEEK-()0x000D0x000A0x000D0x000ASome quantile keys (used on existing keys) are:0x000D0x000A-MEDIAN-, -TERTILE-, -QUARTILE-, -QUINTILE-, -SEXTILE-, -SEPTILE-, -OCTILE-, -DECILE-, -DUODECILE-, -HEXADECILE-, -VENTILE-, -PERCENTILE-, -PERMILLE-0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
ExecuteOne/_/9/CountAfter = 0
ExecuteOne/_/9/Finish = 2025-11-03 16:57:59.406
ExecuteOne/_/9/ElapsedTime = 00:00:00.002
ExecuteOne/_/9/Text = ------------------------------------------------------


Generated 2025-11-03 16:57:59.407 UTC