PI Transport Problem Using File System

[Former Member]

We are facing a unique problem while Transporting objects from our Dev Landscape to our Quality Landscape.

The error we get when we try to Import the *.tpz file into the Quality Landscape is

[NWMss][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__XI_PVISRELATION__1B479A0C'. Cannot insert duplicate key in object 'dbo.XI_PVISRELATION'.

The problem as far as we can understand is because our quality system was built as a copy from the dev system.

Any suggestions as to what could be the exact problem or any solutions will be appreciated.

Thanks and Best Regards,

Kanwal

Edited by: Kanwaljit Singh on Dec 17, 2007 7:33 PM

[VijayKonam · Accepted solution]

Is this happenning in repository? Check if the software component is already imported or the name space exists already under SWCV. In any case.. delete them.. and then try to import..

VJ

[Former Member · Accepted solution]

All the SWCVs and namespaces are already there in Quality as it was built from a snapshot of Dev.

The problem comes once we make a change in Dev and want to import in Quality. We tried deleting the namespace and recreating but we still get the same problem.

Kanwal

[VijayKonam · Accepted solution]

WHy do you want to recreate them after deleting them? Leave this to the import mechanism..!! It should automatically create the SWVC ans name spaces under it provided if the SLD has the valid entries imported from the DEV system.

VJ

[Former Member]

Thanks VJ, the solution worked. I was trying to delete individual namespaces till now which was not useful but once I delete the whole SWCV and reimport it works perfectly.

Thanks once again.

Kanwal