Upgrade failing with LRM-00116: syntax error
search cancel

Upgrade failing with LRM-00116: syntax error

book

Article ID: 87670

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Error Message :
LRM-00116: syntax error at '/' following '='"

When upgrading Applications Manager, the upgrade fails with a "Fatal Error occurred" message.  Aw_install.log shows that the failure occurs during the "Importing STATIC" portion of a Applications Manager upgrade, and an "LRM-00116" error is thrown. Below is an example of the error.
 
LOGIN=<username>/<password>@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521))(CONNECT_DATA=(SID=<SID>)))
Importing STATIC
del tmp*.dat
Could Not Find C:\%AW_HOME%\map\tmp*.dat
IMPEXP IMPORT STATIC
function=IMPORT
Processing IMPORT
Import Cleanup Started
delete_aw_export_file
Import Cleanup Complete
Building Import file C:\%AW_HOME%\tmp\STATIC.7372 from C:\%AW_HOME%\import\STATIC.exp
LRM-00116: syntax error at '<username>/<password>' following '='

SQL*Loader: Release 11.x.x.x.x - Production on Thu Sep 1 12:44:35 2016


Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

SQL*Loader-100: Syntax error on command-line
Could not complete sqlldr with C:\%AW_HOME%\tmp\STATIC.xxxx
err=256
The system cannot find the file specified.
*************** Import Failed **********************
Fatal Error occurred - check the log C:\%AW_HOME%\install\aw_install.log

This error is generated when the net connect value in the %AW_HOME%\site\awenv.ini file is listed with the full connection string value instead of an expected SID or Service Name value. This An example below.

[email protected](DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1521))(CONNECT_DATA=(SID=<SID>)))

 

Environment

OS: Windows

Cause

Cause type:
Configuration

Resolution

This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Additional Information

Workaround :
Re-running the installation after editing and deleting the net connect value allows the install to complete successfully.