Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Jacqueline Godb
Occasional 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
Honored 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.
//Add this to "OnDomLoad" event