[ROOT] / app / bef / Controller / EditController / ~std / QueryProgress

QueryProgress

QueryProgress

KeyValue
_DescriptionContains, in addition to result, also log information about execution of API query
WHERE DimProductId EQ '353'

Individual query expressions are:
WHERE DimProductId EQ '353'

Note that the ordinary result (from an ordinary exceution of query) is stored in Result which is 'invisible' from ordinary PropertyAccess.
AllLogEntriesForThisQueryExecuteOne/_/4/Start = 2025-10-19 10:45:11.335
ExecuteOne/_/4/Query = WHERE DimProductId EQ '353'
ExecuteOne/_/4/CountBefore = 4
ShouldTerminate/_/4/Text = For query expression0x000D0x000A0x000D0x000AWHERE DimProductId EQ '353'0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimProductId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AIrrelevant to call TryGetP for this class (PValue0x003CBoolean0x003E). Parameters: k: DimProductId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations. 0x000D0x000ACompoundKey.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, DimAccount, DimCurrency, DimCustomer, DimDepartment, DimEmployee, DimGeography, DimOrganization, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimReseller, DimSalesReason, DimSalesTerritory, FactCallCenter, FactCurrencyRate, FactFinance, FactInternetSale, FactInternetSaleReason, FactProductDescription, FactResellerSale, FactSalesQuota, FactSurveyResponse0x000D0x000A0x000D0x000ASome 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 expression0x000D0x000A0x000D0x000AWHERE DimProductId EQ '353'0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ADimProductId0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AIrrelevant to call TryGetP for this class (PValue0x003CBoolean0x003E). Parameters: k: DimProductId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations. 0x000D0x000ACompoundKey.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, DimAccount, DimCurrency, DimCustomer, DimDepartment, DimEmployee, DimGeography, DimOrganization, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimReseller, DimSalesReason, DimSalesTerritory, FactCallCenter, FactCurrencyRate, FactFinance, FactInternetSale, FactInternetSaleReason, FactProductDescription, FactResellerSale, FactSalesQuota, FactSurveyResponse0x000D0x000A0x000D0x000ASome 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/_/4/CountAfter = 0
ExecuteOne/_/4/Finish = 2025-10-19 10:45:11.335
ExecuteOne/_/4/ElapsedTime = 00:00:00.000
ExecuteOne/_/4/Text = ------------------------------------------------------
CreateHints-True-
CurrentStrictnessON
Limit-1000-
QueriesWHERE DimProductId EQ '353'
StrCurrentTypePRich
TerminateReasonFor query expression

WHERE DimProductId EQ '353'

the key

DimProductId

was not found.

Last errorResponse is:

Irrelevant to call TryGetP for this class (PValue<Boolean>). Parameters: k: DimProductId (type IP). The reason you are not allowed to do this is that this class only contains a single value (of type Boolean). It is therefore unable to handle more complex operations.
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, DimAccount, DimCurrency, DimCustomer, DimDepartment, DimEmployee, DimGeography, DimOrganization, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimReseller, DimSalesReason, DimSalesTerritory, FactCallCenter, FactCurrencyRate, FactFinance, FactInternetSale, FactInternetSaleReason, FactProductDescription, FactResellerSale, FactSalesQuota, FactSurveyResponse

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).
UseCache-False-

9 items


Generated 2025-10-19 12:24:39.720 UTC