Questions about this article, topic, or product? Click here. 

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
  • When:
  • Last revision by
  • When:
  • Revisions: 2
  • Comments: 0
Recommended
Related
Communities
Support and Services
Training and Learning
Social Media