Hi @ismcagdas,
I have written the information in previous message that I have had repaird problem with sql login (app pool login), according to picture:
Due to that only that part of log file is being appended every time:
WARN 2022-01-25 10:48:38,677 [1 ] taProtection.KeyManagement.XmlKeyManager - Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. WARN 2022-01-25 10:48:39,056 [1 ] taProtection.KeyManagement.XmlKeyManager - No XML encryptor configured. Key {37bcc8e3-8cc0-4944-9c91-f3ce9eb2cdef} may be persisted to storage in unencrypted form. WARN 2022-01-25 10:57:46,077 [1 ] oft.EntityFrameworkCore.Model.Validation - Entity 'Edition' has a global query filter defined and is the required end of a relationship with the entity 'EditionFeatureSetting'. This may lead to unexpected results when the required entity is filtered out. Either configure the navigation as optional, or define matching query filters for both entities in the navigation. See https://go.microsoft.com/fwlink/?linkid=2131316 for more information. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'AnnualPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'DailyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'MonthlyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'WeeklyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Duration' on entity type 'FlaskQueueItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Time' on entity type 'FlaskQueueItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Availability' on entity type 'FlaskGroupsUsers'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,120 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Availability' on entity type 'FlaskUserExt'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:46,121 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Amount' on entity type 'SubscriptionPayment'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:57:47,394 [1 ] tion.Repositories.EphemeralXmlRepository - Using an in-memory repository. Keys will not be persisted to storage. WARN 2022-01-25 10:57:47,395 [1 ] taProtection.KeyManagement.XmlKeyManager - Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. WARN 2022-01-25 10:57:47,726 [1 ] taProtection.KeyManagement.XmlKeyManager - No XML encryptor configured. Key {45efd907-513c-4692-9114-c52c9c1a514c} may be persisted to storage in unencrypted form. WARN 2022-01-25 10:59:26,590 [1 ] oft.EntityFrameworkCore.Model.Validation - Entity 'Edition' has a global query filter defined and is the required end of a relationship with the entity 'EditionFeatureSetting'. This may lead to unexpected results when the required entity is filtered out. Either configure the navigation as optional, or define matching query filters for both entities in the navigation. See https://go.microsoft.com/fwlink/?linkid=2131316 for more information. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'AnnualPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'DailyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'MonthlyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'WeeklyPrice' on entity type 'SubscribableEdition'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Duration' on entity type 'FlaskQueueItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Time' on entity type 'FlaskQueueItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Availability' on entity type 'FlaskGroupsUsers'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,643 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Availability' on entity type 'FlaskUserExt'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:26,644 [1 ] oft.EntityFrameworkCore.Model.Validation - No type was specified for the decimal property 'Amount' on entity type 'SubscriptionPayment'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType()', specify precision and scale using 'HasPrecision()' or configure a value converter using 'HasConversion()'. WARN 2022-01-25 10:59:27,985 [1 ] tion.Repositories.EphemeralXmlRepository - Using an in-memory repository. Keys will not be persisted to storage. WARN 2022-01-25 10:59:27,985 [1 ] taProtection.KeyManagement.XmlKeyManager - Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. WARN 2022-01-25 10:59:28,424 [1 ] taProtection.KeyManagement.XmlKeyManager - No XML encryptor configured. Key {75288afb-6cee-472a-9959-f67d30f6e822} may be persisted to storage in unencrypted form.
Now I have only message with WARN's but the problem still exist.
Hi On my production server I set log4net.Production.config on the real path. Now I have logs.txt file generation enabled. I found description of a problem with login to sql server. Yesterday I repaired it. Today I have only few WARN(s), but the problem still exist.
File logs.txt is here: FolderWithLogsFile
