Unhandled Error Occurred After Entering Shipping Instructions In Material Specification (Doc ID 2205349.1)

Last updated on NOVEMBER 25, 2016

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 6.1.1.5 and later
Information in this document applies to any platform.

Symptoms

An unhandled error occurred while saving a Raw Material Specification. Error is raised after clicking on Save button after entering the relevant details in Shipping Instructions textbox which is under Material Attributes section.

ERROR
-----------------------
ErrorType: Primary| ErrorCount: 2| App: NPD| SessionId: 770a42c7-824d-36e7-9689-7556263a3660| UserId: administrator| IsNewSession: False| ServerID: 172.20.1.209| Misc: |
Exception: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.DataAccessException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.: select * from npdActDocumentCollaborations2 where fkActivity = '32230025ed1b-572e-4d52-80d9-d07770cd4ec1' ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out
  --- End of inner exception stack trace ---
  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.SqlDataReader.TryConsumeMetaData()
  at System.Data.SqlClient.SqlDataReader.get_MetaData()
  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)


Steps to reproduce:

  1. This issue occurred when a user tried to save data of the textbox Shipping Instructions and data entered by the user has some special characters in it. When these special characters are removed from the textbox , then data is saved.
  2. No changes are done in configuration.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms