Hi Richard,
We’re getting some exceptions on our live cloud environment. Any idea how to fix these? We’re getting these errors when we’re publishing/creating any new pages.
Versions:
Umbraco 8.14.1
Deploy 4.1.2
Forms 8.7.5
SEOChecker 2.10.1
System.Data.SqlClient.SqlException (0x80131904): String or binary data
would be truncated in table '3stpwbm2kl5.dbo.SEOChecker_ConfigurationIssues', column 'ErrorDescription'. Truncated value: 'The robots.txt file contains:<br/><br/>
User-agent: *<br/>
Disallow: /<br/><br/>
And doesn''t conta'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at NPoco.Database.ExecuteNonQueryHelper(DbCommand cmd)
at NPoco.Database.Execute(String sql, CommandType commandType, Object[] args)
at SEOChecker.Core.Repository.ConfigurationIssues.ConfigurationIssuesRepository.(ConfigurationValidationError )
at SEOChecker.Core.Repository.ConfigurationIssues.ConfigurationIssuesRepository.Save(List`1 result)
ClientConnectionId:6dee149a-6244-4423-9b0c-59dc9e32c184
Error Number:2628,State:1,Class:16
Error number 2:
System.NullReferenceException: Object reference not set to an instance of an object.
at SEOChecker.Core.Umbraco.DocumentWrappers.UmbracoDocumentBase..(DocumentProperty )
at System.Linq.Enumerable.WhereListIterator`1.MoveNext()
at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
at SEOChecker.Core.Umbraco.DocumentWrappers.UmbracoDocumentBase.GetPropertyValue[T](String propertyAlias, Boolean recursive, String culture, String segment)
at SEOChecker.Core.Umbraco.DocumentWrappers.UmbracoDocument..ctor(IContent doc, IContextInfo info, String culture, String segment)
at SEOChecker.Core.Helpers.UmbracoDocumentHelper.GetFirstPublishedChildNode(IContextInfo contextInfo, String culture, String segment)
at SEOChecker.Validators.ConfigurationValidators.TrailingSlashValidator.a4jtdxsbngyptnqmwcxshq8hfkwl5ufr (List`1 , IContextInfo )
at SEOChecker.Core.Validation.ConfigurationValidators.ConfigurationValidator.Validate()
![enter image description here][1]
Thanks in advance!
[1]: https://our.umbraco.com//media/upload/c29d8845-c156-4f5e-91c6-2c782a869ac6/error.JPG
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/106780-seochecker-exceptions