Installation or Oracle Transportation Management 6.0 on Solaris (Doc ID 974412.1)

Last updated on MARCH 14, 2013

Applies to:

Symptoms

OTM data content is not being loaded when the create_all.sql script is run or the import_content.sh script is run manually on Solaris installations.

The import_content logs that are created during the installation only have the following information.

Parameters:
Properties directory: /opt/otm60/glog/config/
Connection ID for GLOGOWNER: dbaglogowner
Connection ID for REPORTOWNER: dbareportowner
DBNAME: otm60

After these parameters are displayed the log is suppose to show information for each CSV that is being loaded, similar to this:

Parameters:
Properties directory: /opt/otm60/glog/config
Connection ID for GLOGOWNER: dbaglogowner
Connection ID for REPORTOWNER: dbareportowner
DBNAME: otm60

<CSVUtil>
<Command>ii</Command>
<DataDir>./content_glogowner/</DataDir>
<DataFileName>BILLABLE_INDICATOR.csv</DataFileName>
<ExcludePublic>true</ExcludePublic>
<ProcessCSV>
<xvalidate>true</xvalidate>
<DatabaseGlobalName>SUP60GA</DatabaseGlobalName>
<TableName>BILLABLE_INDICATOR</TableName>
<ColumnList>BILLABLE_INDICATOR_GID,BILLABLE_INDICATOR_XID,DESCRIPTION,DOMAIN_NAME</ColumnList>
<sqlString>insert into BILLABLE_INDICATOR ( BILLABLE_INDICATOR_GID,BILLABLE_INDICATOR_XID,DESCRIPTION,DOMAIN_NAME) values (?,?,?,?)</sqlString>
<ProcessCount>5</ProcessCount>
<ErrorCount>0</ErrorCount>

Running the command manually generated the following error on the screen.

./import_content.sh /otm/otm60/glog/config/ otm60
./import_content.sh: [[: not found
import_content_otm60_20091203_0948.log

Processing glogowner tables...

./import_content.sh: syntax error at line 42: `LOWERTAB=$' unexpected

Cause

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