TerminateReason

Query executed with a result of 23 items but too many keys (too many columns) resulted (254609 keys was found).
The limit (chosen somewhat arbitrarily) is 1000.
The system is therefore unable to generate a HTML table.
Some of the keys are:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

AllLogEntriesForThisQuery

ExecuteOne/_/22/Start = 2024-04-27 10:47:23.746
ExecuteOne/_/22/Query = ORDER BY OrderDate.YearMonth()Id DESC
ExecuteOne/_/22/CountBefore = 23
ShouldTerminate/_/22/Text = For query expression0x000D0x000A0x000D0x000AORDER BY OrderDate.YearMonth()Id DESC0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.YearMonth()Id0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate.YearMonth()Id not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: Potential foreign key traversals 'OrderDate.YearMonth()Id' was not understood, starting from initialType 'DimAccountCollection'.0x000D0x000AInvalid MemberEntityKey because of: Property 'OrderDate' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.OrderDate' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetOrderDate' not defined for DimAccountCollection0x000D0x000A0x000D0x000A0x000D0x000AThe current type is DimAccountCollection.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000ADimAccountCollectionId, -1-, -10-, -100-, -101-, -11-, -12-, -13-, -14-, -15-, -17-, -18-, -19-, -2-, -20-, -21-, -22-, -23-, -24-, -25-, -26-, -27-, -28-, -29-, -3-, -30-, -31-, -32-, -33-, -34-, -35-, -36-, -37-, -38-, -39-, -4-, -40-, -41-, -42-, -43-, -44-, -45-, -46-, -47-, -48-, -49-, -5-, -50-, -51-, -52-, -53-, -54-, -55-, -56-, -57-, -58-, -59-, -6-, -60-, -61-, -62-, -63-, -64-, -65-, -66-, -67-, -68-, -69-, -7-, -70-, -71-, -72-, -73-, -74-, -75-, -76-, -77-, -78-, -79-, -8-, -80-, -81-, -82-, -83-, -84-, -85-, -87-, -88-, -89-, -9-, -90-, -91-, -92-, -93-, -94-, -95-, -96-, -97-, -98-, -99-0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A
TerminateReason = For query expression0x000D0x000A0x000D0x000AORDER BY OrderDate.YearMonth()Id DESC0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AOrderDate.YearMonth()Id0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey OrderDate.YearMonth()Id not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: Potential foreign key traversals 'OrderDate.YearMonth()Id' was not understood, starting from initialType 'DimAccountCollection'.0x000D0x000AInvalid MemberEntityKey because of: Property 'OrderDate' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.OrderDate' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetOrderDate' not defined for DimAccountCollection0x000D0x000A0x000D0x000A0x000D0x000AThe current type is DimAccountCollection.0x000D0x000AProbably the wrong key was used as criteria, or the key name was misspelled.0x000D0x000A0x000D0x000ASome possible correct keys are:0x000D0x000ADimAccountCollectionId, -1-, -10-, -100-, -101-, -11-, -12-, -13-, -14-, -15-, -17-, -18-, -19-, -2-, -20-, -21-, -22-, -23-, -24-, -25-, -26-, -27-, -28-, -29-, -3-, -30-, -31-, -32-, -33-, -34-, -35-, -36-, -37-, -38-, -39-, -4-, -40-, -41-, -42-, -43-, -44-, -45-, -46-, -47-, -48-, -49-, -5-, -50-, -51-, -52-, -53-, -54-, -55-, -56-, -57-, -58-, -59-, -6-, -60-, -61-, -62-, -63-, -64-, -65-, -66-, -67-, -68-, -69-, -7-, -70-, -71-, -72-, -73-, -74-, -75-, -76-, -77-, -78-, -79-, -8-, -80-, -81-, -82-, -83-, -84-, -85-, -87-, -88-, -89-, -9-, -90-, -91-, -92-, -93-, -94-, -95-, -96-, -97-, -98-, -99-0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AABS(), 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:0x000D0x000AMEDIAN, TERTILE, QUARTILE, QUINTILE, SEXTILE, SEPTILE, OCTILE, DECILE, DUODECILE, HEXADECILE, VENTILE, PERCENTILE, PERMILLE0x000D0x000A0x000D0x000A0x000D0x000AHINT: Use 'STRICT OFF' in order to force execution of query (ignoring this problem).
ExecuteOne/_/22/CountAfter = 23
ExecuteOne/_/22/Finish = 2024-04-27 10:47:23.749
ExecuteOne/_/22/ElapsedTime = 00:00:00.003
ExecuteOne/_/22/Text = ------------------------------------------------------

Generated 2024-04-27 10:47:24.014 UTC