TerminateReason

For query expression

SELECT Date, To, From, Subject

the key

Subject

was not found.

Last errorResponse is:

Key Subject 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, Date

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

Some function keys (used on existing keys) are:
AVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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/_/183/Start = 2025-07-02 15:33:51.722
ExecuteOne/_/183/Query = SELECT Date, To, From, Subject
ExecuteOne/_/183/CountBefore = 1
ShouldTerminate/_/183/Text = For query expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ATo0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey To 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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 expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ATo0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey To 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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/_/183/Text = For query expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AFrom0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey From 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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 expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000AFrom0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey From 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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/_/183/Text = For query expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASubject0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey Subject 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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 expression0x000D0x000A0x000D0x000ASELECT Date, To, From, Subject0x000D0x000A0x000D0x000Athe key0x000D0x000A0x000D0x000ASubject0x000D0x000A0x000D0x000Awas not found.0x000D0x000A0x000D0x000ALast errorResponse is:0x000D0x000A0x000D0x000AKey Subject 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, Date0x000D0x000A0x000D0x000ASome new key functions (available for all entity classes) are:0x000D0x000ACOUNTP(), COUNTPREC(), GETTYPE(), TOPROPERTYSTREAM()0x000D0x000A0x000D0x000ASome function keys (used on existing keys) are:0x000D0x000AAVG(), COUNT(), DATE(), DAYOFWEEK(), DISTINCT(), DOUBLE(), FIRSTLINE(), HOURMINUTE(), INT(), JOIN(), LENGTH(), MAX(), MIN(), MONTH(), QUARTER(), SUM(), TMB(), TOTALHOURS(), TOTALMINUTES(), TYPE(), 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/_/183/CountAfter = 1
ExecuteOne/_/183/Finish = 2025-07-02 15:33:51.723
ExecuteOne/_/183/ElapsedTime = 00:00:00.001
ExecuteOne/_/183/Text = ------------------------------------------------------

Generated 2025-07-02 15:33:52.023 UTC