My Oracle Support Banner

Getting 'Letter Place Holder Generation Failed: Contact Your System Administrator' Error When Generating Auto Narrative or Letter (Doc ID 2461764.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 4.2.0 and later
Oracle Life Sciences Argus Safety Japan - Version 4.2.0 and later
Oracle Life Sciences Argus Safety Cloud Service - Version 7.0 and later
Oracle Life Sciences Argus Safety Japan Cloud Service - Version 7.0 and later
Information in this document applies to any platform.

Symptoms

Getting the following error when generating the auto narrative or a letter with a template that contains at least one place holder
  "Letter place holder generation failed. Contact your system administrator."

Steps to Repeat:
1. Login to Argus Safety and go to Argus Console
   a) Configure a new auto narrative template for English
      Argus Console > System Configuration > Common Profile Switches > Case Form Configuration >Case Auto narrative > New
      - [age] year old [SEX] subject was enrolled from [patient_city]
   b) Configure a Letter Template with the following place holders
      -  [age] year old [SEX] subject was enrolled from [patient_city]
2. create a new case with above 3 attributes: 1. age 11 years, 2. sex=Female, and 3. City = Tampa
3. Save the case
4. navigate to the [Analysis] tab and press Generate button under narrative for template configured above
5. It shows the following under narrative:
  "Letter place holder generation failed. Contact your system administrator"
6. Go to Activities tab and generate a new letter with the template configured above
7. It shows the following text in the generated letter
  "Letter place holder generation failed. Contact your system administrator"

Here is an excerpt from the verbose debug log file from the argusvr2.exe:

[EnterpiseID: DEFAULT] 08-Oct-2018, 10:35:41:621, [3], UserId: nepatel, Exception DetailsMessage
ORA-12154: TNS:could not resolve the connect identifier specified Stack Trace
  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
  at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src, OracleLogicalTransaction m_oracleLogicalTransaction)
  at Oracle.DataAccess.Client.OracleConnection.Open()
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
  at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DbCommand command)
  at Microsoft.Practices.EnterpriseLibrary.Data.OracleDataProvider.OracleDatabase.ExecuteDataSet(DbCommand command)
  at Relsys.Persistence.DataAccess.DataAccess.ExecuteDataSet(DbCommand dbCommand)

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.