Service Desk Practitioners Forum
cancel

HPOVSD5.10 - CI Relation

Highlighted
osbert
Respected Contributor.

HPOVSD5.10 - CI Relation

Hi all,

I'm having trouble importing CI to CI relation un a SD5.10 installation. The message I receive is:

warning: While processing rel (id=1):
com.hp.ov.obs.impl.ext.ExternalException: This instance of rel can not be processed, because not all primary keys values have been provided.

The xls file is as follows:
from --- type --- to
PC0001 - runs --- SO0001

The xml file creates with no errors. My ini file is:
[DSN]
NAME=rel
USR=
PWD=

[SYSTEM]
LOG=TRUE
XML=TRUE
LOG_FILE=Z:\Shared\carga\todo\rel.log
XML_OUTPUT_FILE=Z:\Shared\carga\todo\rel.xml
APPLICATION_NAME=rel
ENCODING=ISO-8859-1

[CLASSES]
NAME=rel

[rel]
SOURCE=rel
ATT=[from],[type],[to]
COLUMNS=[from],[type],[to]
LOADTABLE=TRUE

Thanks for your help

Osbert
3 REPLIES
AndrewB
Super Contributor.

Re: HPOVSD5.10 - CI Relation

Hi Obert,

are you getting this message when the ini is extracting from your datasource and creating the xml file or when the import mapping is happening? If it is during the import mapping process then I would check how you have set up that mapping. That is where you set the primary keys, etc.

Hope that helps - Andrew
osbert
Respected Contributor.

Re: HPOVSD5.10 - CI Relation

Thanks Andrew

The message is during the import mapping process. I attached the printscreens. The primary keys are set, still, the import process gives an error.

Thanks in advance
osbert
Respected Contributor.

Re: HPOVSD5.10 - CI Relation

The problem was solved. What I did was to change the xls headers, ini and import mapping to upper case. And the "Reference to" field is needed otherwise triggers the next error: JDBC error: msg=ORA-01722: invalid number.