Last updated on MARCH 14, 2013
Applies to:
Oracle Transportation Management - Version 6.0 to 6.0.4 [Release 6]Information in this document applies to any platform.
***Checked for relevance on 14-Mar-2013***
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
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