AssetWise ALIM - Wiki FOREIGNKEY conflicted, Transmittal Error

FOREIGNKEY conflicted, Transmittal Error

	Product(s):	AssetWise Client
	Version(s):	15.06.01.115
	Environment:	Windows XP 32 bit,Windows XP 64 bit,Windows 2000,Window Server 2008 64 bit,Windows Server 2008 R2,Windows 8
	Area:	N/A
	Subarea:	N\A

Problem

While Validating Transmittal, user faced the error below:

Fig. 1: Error message: INSERT statement conflicted with FOREIGN KEY constraint

Solution

In this failed case, the DB “FOREIGN KEY” constraint error was caused by job ids on split server were not checked in the configuration. Once the required job ids setting(s) were checked in SMC, the issue was fixed.

Original Author:

John Lee

Created by john.lee
When: Tue, Jun 6 2017 6:34 PM
Last revision by john.lee
When: Tue, Jun 6 2017 6:36 PM
Revisions: 2
Comments: 0

Recommended