No result. See details below for possible causes

_Description

Contains, in addition to result, also log information about execution of API query
WHERE DimProductId EQ '536'Controller

Individual query expressions are:
WHERE DimProductId EQ '536'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 DimProductId EQ '536'Controller

the key

DimProductId

was not found.

Last errorResponse is:

Key DimProductId not found
CompoundKey.errorResponse: Invalid key.

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/_/22/Start = 2024-11-14 05:41:43.936
ExecuteOne/_/22/Query = WHERE DimProductId EQ '536'Controller
ExecuteOne/_/22/CountBefore = 4
ShouldTerminate/_/22/Text = For query expression0x000D0x000A0x000D0x000AWHERE DimProductId EQ '536'Controller0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimProductId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimProductId not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe 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 DimProductId EQ '536'Controller0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimProductId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey DimProductId not found0x000D0x000ACompoundKey.errorResponse: Invalid key.0x000D0x000A0x000D0x000A0x000D0x000AThe 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/_/22/CountAfter = 0
ExecuteOne/_/22/Finish = 2024-11-14 05:41:43.936
ExecuteOne/_/22/ElapsedTime = 00:00:00.000
ExecuteOne/_/22/Text = ------------------------------------------------------

Generated 2024-11-14 05:41:43.937 UTC