Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PropertiesGet + BaseItemGet
#1
Hi Team!

After the upgrade of ASG RD to 12.0.6420.1 Al the users are getting errors:

An error occured on executing an sql statement
PropertiesGet
Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

---------------------------

  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.TdsParserStateObject.TryProcessHeader()
  at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
  at System.Data.SqlClient.TdsParserStateObject.TryReadUInt32(UInt32& value)
  at System.Data.SqlClient.TdsParserStateObject.TryReadPlpLength(Boolean returnPlpNullIfNull, UInt64& lengthLeft)
  at System.Data.SqlClient.TdsParser.TryReadPlpUnicodeChars(Char[]& buff, Int32 offst, Int32 len, TdsParserStateObject stateObj, Int32& totalCharsRead)
  at System.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
  at System.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)
  at System.Data.SqlClient.SqlDataReader.TryReadColumnData()
  at System.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
  at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
  at System.Data.SqlClient.SqlDataReader.GetSqlString(Int32 i)
  at CloudAdminDataAccess.SqlDataAccessor.GetStringFromReader(SqlDataReader reader, Int32 columnIndex)
  at CloudAdminDataAccess.SqlDataAccessor._PropertiesGet(Guid userId, Guid itemId, Guid rolePropertyId)


An error occured on executing an sql statement
BaseItemGet
ParentItemId

---------------------------

  at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
  at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
  at CloudAdminDataAccess.SqlDataAccessor.GetBaseItemFromReader(SqlDataReader reader)
  at CloudAdminDataAccess.SqlDataAccessor.BaseItemGet(Guid itemId, Guid userId)


Are these issues related to the update of ASG or is this just on SQL?
Reply


Messages In This Thread
PropertiesGet + BaseItemGet - by deblaerer - 18-09-2019, 11:38 AM
RE: PropertiesGet + BaseItemGet - by DevOma - 18-09-2019, 12:14 PM
RE: PropertiesGet + BaseItemGet - by deblaerer - 18-09-2019, 12:27 PM
RE: PropertiesGet + BaseItemGet - by DevOma - 18-09-2019, 12:57 PM
RE: PropertiesGet + BaseItemGet - by deblaerer - 18-09-2019, 02:25 PM
RE: PropertiesGet + BaseItemGet - by DevOma - 18-09-2019, 02:27 PM
RE: PropertiesGet + BaseItemGet - by Jorgen - 18-09-2019, 03:25 PM
RE: PropertiesGet + BaseItemGet - by DevOma - 18-09-2019, 03:44 PM
RE: PropertiesGet + BaseItemGet - by Jorgen - 14-10-2019, 10:14 AM
RE: PropertiesGet + BaseItemGet - by DevOma - 14-10-2019, 03:39 PM



Users browsing this thread: 1 Guest(s)