Service Desk Practitioners Forum
cancel

Export Configuration Filename error on the SD5.0 Data Exchange Task

Highlighted
Jacqueline Godb
Valued Contributor.

Export Configuration Filename error on the SD5.0 Data Exchange Task

We are in a HP-UX environment, 11i, I believe. I am trying to export some data from an Oracle database, and I keep having the following error:
*************************************************

* Object Server EXPORTER
*
*
*
* Hewlett Packard OpenView
*
*************************************************

Error in opening configuration file
java.io.FileNotFoundException:
"/.ov/data/data_exchange/config/nnmdata_jdbc.ini"
(No such file or directory (errno:2))
at java.io.
FileInputStream.open(Native Method)
at java.io.FileInputStream.
(FileInputStream.java:106)

The file does exist. I also tried it in specifying a directory with no '.', and have the same error.

The following is what I have in the .ini file:

[CONNECTION]
TYPE=JDBC

[JDBC]
NAME=nnm_nodes JDBC
USR=ovdb
PWD=ovdb
DRIVER=oracle.jdbc.driver.OracleDriver
URL=jdbc:oracle:thin:@mgslabmd:1521:ovou

[SYSTEM]
LOG=TRUE
XML=TRUE
DUMP=FALSE
TXT=FALSE
LOG_FILE=/.ov/data/data_exchange/log/nnmdata_jdbc.log
XML_OUTPUT_FILE=/.ov/data/data_exchange/xml/nnmdata_jdbc.xml
APPLICATION_NAME=nnm_nodes JDBC
ENCODING=ISO-8859-1

[CLASSES]
NAME=CLASSNNMDATA

[CLASSNNMDATA]
SOURCE=NNM_NODES
ATT=[TOPO_ID], [IP_HOSTNAME]
COLUMNS=[TOPO_ID], [IP_HOSTNAME]
LOADTABLE=TRUE


Can you help?

Jacqueline
1 REPLY
Jonathon Druce
Acclaimed Contributor.

Re: Export Configuration Filename error on the SD5.0 Data Exchange Task

I have only done one JDBC connection and the URL was quite different to what you have. I used
URL=jdbc:oracle:thin:@(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP)(HOST="fully qualified name")(PORT=1527)) (CONNECT_DATA= (SERVICE_NAME="Database service name)))
USR=Case sensitive as is password

I did not have a Name attribute. Hope this helps.