Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Adding New Project causes INSERT statement conflict with FOREIGN KEY

Adding New Project causes INSERT statement conflict with FOREIGN KEY 5 months 4 weeks ago #18970

We recently upgraded to AETLP v.6.3.4.4 but found today that when adding a new PROJECT we receive the attached error indicating that an INSERT statement conflicted with the FOREIGN KEY constraint FK_OBJECT_TREE_OBJECT_TYPES



We are using SQL Server 2017

I could not tell you when this error first became a problem as we do not have the need to create new projects very often and it would have been several releases ago that we did.

The Project seems to get created and we can then delete it but I am not sure what downstream issues this may present.

Thanks in advance
Attachments:

Please Log in or Create an account to join the conversation.

Adding New Project causes INSERT statement conflict with FOREIGN KEY 5 months 4 weeks ago #18972

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7606
  • Karma: 33
  • Thank you received: 418
Can you see mongodb as a connection?
If not you have to patch your repository as described here towards the end.

www.etl-tools.com/articles/january-etl-update.html
Mike
The following user(s) said Thank You: bruce.gibbins

Please Log in or Create an account to join the conversation.

Adding New Project causes INSERT statement conflict with FOREIGN KEY 5 months 3 weeks ago #18983

Thanks. Seems to be that we missed the repo updates from September 2018 where as we had the ones you mentioned in the January Update.
May I suggest that the YEAR be added to these update pages as the post you mentioned is for "January 2018" I think whereas I raised this in 2019 and incorrectly assumed the January in the URL referred to January 2019.
thanks again

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 287 guests and 3 members online