TerminateReason

For query expression

PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount

the key

SalesAmount

was not found.

Last errorResponse is:

Key SalesAmount not found
CompoundKey.errorResponse: Invalid key.

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

Some possible correct keys are:
DimAccountCollectionId, -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-

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/_/61/Start = 2024-04-30 02:03:45.625
ExecuteOne/_/61/Query = PIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount
ExecuteOne/_/61/CountBefore = 23
ShouldTerminate/_/61/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimReseller.FirstOrderYear0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimReseller.FirstOrderYear not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimReseller'.0x000D0x000ASome of the keys found where: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimReseller' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimReseller' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimReseller' 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 expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimReseller.FirstOrderYear0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimReseller.FirstOrderYear not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimReseller'.0x000D0x000ASome of the keys found where: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimReseller' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimReseller' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimReseller' 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).
ShouldTerminate/_/61/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimReseller.ProductLine0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimReseller.ProductLine not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimReseller'.0x000D0x000ASome of the keys found where: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimReseller' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimReseller' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimReseller' 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 expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimReseller.ProductLine0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimReseller.ProductLine not found0x000D0x000ACompoundKey.errorResponse: Invalid ForeignKey because of: No key found in data storage for foreign type 'ARAdventureWorksOLAP.DimReseller'.0x000D0x000ASome of the keys found where: dt, doc, app, TimestampIsOld0x000D0x000A0x000D0x000AInvalid MemberEntityKey because of: Property 'DimReseller' not defined in schema for 'DimAccountCollection' (enum 'DimAccountCollectionP.DimReseller' does not exist,0x000D0x000Aand also0x000D0x000AEntityMethodKey 'TryGetDimReseller' 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).
ShouldTerminate/_/61/Text = For query expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmount0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmount not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe 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 expression0x000D0x000A0x000D0x000APIVOT DimReseller.FirstOrderYear BY DimReseller.ProductLine SUM SalesAmount0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASalesAmount0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey SalesAmount not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe 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).
StrCurrentType = DimReseller.FirstOrderYear
ExecuteOne/_/61/CountAfter = 2
ExecuteOne/_/61/Finish = 2024-04-30 02:03:45.635
ExecuteOne/_/61/ElapsedTime = 00:00:00.009
ExecuteOne/_/61/Text = ------------------------------------------------------

Generated 2024-04-30 02:03:46.175 UTC