As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

Import failed for entityId :

Hi I am getting below error while creating new graph DB ? I am importing the data using .csv file and Facility id is the first column and it has unique value

Config i gave in initDB
[attrtypes]
facilityId = @type:string
facilityAreaCode = @type:string
serviceAreaCode = @type:string
facilityName = @type:string
regionCode = @type:string
countryCode = @type:string
city = @type:string
iataCode = @type:string

[nodetypes]
facilityDetails = @attrs:facilityId,serviceAreaCode,facilityAreaCode,facilityName,regionCode,countryCode,city,iataCode @pkey:facilityId

Sample data that i am using for import

ADLGTW ADL GTW Adelaide Gateway AP AU NETLEY ADL
PERGTW PER GTW Perth Gateway AP AU PERTH INTERNATIONAL AIRPORT PER
DRWGTW DRW GTW Darwin Gateway Facility AP AU COCONUT GROVE DRW
MELPFM MEL PFM Port Melbourne AP AU PORT MELBOURNE MEL

2019-01-04T11:39:25.571+08:00 Info servermain tgimport.c:438 - Begin import for file: facilityDetails.csv
2019-01-04T11:39:25.604+08:00 Error servermain tgdbmgr.c:936 - Import failed for entityId :.
2019-01-04T11:39:25.604+08:00 Error servermain tgimport.c:1053 - [facilityDetails.csv:500] [223] [TGIndexUniqueConstraintViolation] [Node batch import failed]
2019-01-04T11:39:25.624+08:00 Error servermain dbcatloader.c:326 - Failed to import: TGIndexUniqueConstraintViolation
2019-01-04T11:39:25.624+08:00 Info servermain tgdbmgr.c:347 - Closing Database manager. Flushing pages to disk, and synchronizing control pages
2019-01-04T11:39:25.625+08:00 Info servermain tgpagemgr.c:809 - Flushed pmgr@idx cache. Synced 6 entries to disk.
2019-01-04T11:39:25.629+08:00 Info servermain tgpagemgr.c:809 - Flushed pmgr@data cache. Synced 23 entries to disk.
2019-01-04T11:39:25.646+08:00 Info servermain tgdbmgr.c:354 - Database manager closed
2019-01-04T11:39:25.646+08:00 Error servermain initdb.c:84 - Failed to create Database :TGIndexUniqueConstraintViolation

1 Comment

Hi sahsharm,

Can you tell me which version of TIBCO Graph DB are you using?

 

sbangar - Jul 26, 2019 - 3:48pm
+ Add a Comment