000039060 - Unexpected error appears when trying to access application records in RSA Archer

Document created by RSA Customer Support Employee on Jul 3, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039060
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer application
RSA Version/Condition: 6.X
IssueCannot open application records giving an unexpected error.
CauseAs per w3wp logs below, the length of a LOB data is exceeding the configured value of 65536 which is Microsoft SQL server's default maximum text replication value.
 

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
  <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
    <EventID>0</EventID>
    <Type>3</Type>
    <SubType Name="Error">0</SubType>
    <Level>2</Level>
    <TimeCreated SystemTime="2020-06-15T14:54:23.9052433Z" />
    <Source Name="Archer.Web" />
    <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />
    <Execution ProcessName="w3wp" ProcessID="3788" ThreadID="109" />
    <AssemblyVersion>6.8.0.1170</AssemblyVersion>
    <Channel />
    <Computer>azrsawebtst01</Computer>
  </System>
  <ApplicationData>
    <TraceData>
      <DataItem>
        <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
          <TraceIdentifier>Archer.Web</TraceIdentifier>
          <LogReferenceId>061520-145423-9052</LogReferenceId>
          <Description>Length of LOB data (69446) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.
The statement has been terminated.
SQL statement: usp_ui_session_state @userToken = '********************************', @requestId = 6778c1ea-df2c-4c60-b7d8-48bca908d9ff, @state = System.Byte[], @date = '6/15/2020 2:54:23 PM'</Description>
          <AppDomain>/LM/W3SVC/1/ROOT-1-132367042497295423</AppDomain>
          <ContextData>
            <BaseUrl>https://nsmarcher-cuat/SearchContent/Search.aspx</BaseUrl>
            <View>NavMenu</View>
            <Report>ReportId: 9466, ReportName: Module Menu Item, ReportType: SearchBased</Report>
            <Module>ModuleId: 485, ModuleName: VMCS Scoring, ModuleStatus: ActiveInProduction, ModuleType: Application</Module>
            <frameWidthHeight>1707,715</frameWidthHeight>
          </ContextData>
          <Exception>
            <ExceptionType>ArcherTech.Kernel.Providers.Data.ArcherDbException, ArcherTech.Kernel.Providers, Version=6.8.0.1170, Culture=neutral, PublicKeyToken=null</ExceptionType>
            <Message>Length of LOB data (69446) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.
The statement has been terminated.
SQL statement: usp_ui_session_state @userToken = '********************************', @requestId = 6778c1ea-df2c-4c60-b7d8-48bca908d9ff, @state = System.Byte[], @date = '6/15/2020 2:54:23 PM'</Message>
            <Source>ArcherTech.Kernel.Providers</Source>
            <StackTrace>   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap)
   at ArcherTech.Kernel.Providers.Data.ArcherSqlDatabase.ExecuteNonQuery(DbCommand command)
   at ArcherTech.Kernel.DataSource.Db.SessionStateDataSource.Save(SessionState state)
   at ArcherTech.Kernel.Managers.SessionStateManager.Save(SessionContext sessionContext, SessionState state)
   at ArcherTech.Web.UI.DBRequestStatePersister.Save(RequestStateHolder holder)
   at ArcherTech.Web.UI.RequestStateManager.AfterProcessRequest()
   at ArcherTech.Web.ArcherTechPage`2.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)</StackTrace>
          </Exception>
        </TraceRecord>
      </DataItem>
    </TraceData>
  </ApplicationData>
</E2ETraceEvent>



 
Resolution
  1. Open SQL Management Studio.
  2. Right-click on the server name.
  3. Choose Properties.
  4. Select "Advanced" options.
  5. Max text replication Size is available under the "Miscellaneous" header.
  6. Change the value from 65536 to -1 which is an indication to no limit or to the value you desire then press OK.

Attachments

    Outcomes