Skip to main content
To homepage To homepage
Solved

Unable to open project

A
Problem Solver
Forum|alt.badge.img
  • aftabp
  • Problem Solver
  • 121 replies

We are suddenly having issues with opening last saved project in TimeXtender. The error says:

1An error occurred while fetching data from the database.
2Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
3
4Location: Table: SelectionRuleFields
5ForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table..
6

We have tried to go back to the project that we saved before the lastest one. We are able to open that it not able to save it. The errror says:

1An error occurred while saving the project to the database.
2
3An error occurred while fetching data from the database.
4Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
5
6Location: Table: SelectionRuleFields
7ForeignKeyConstraint DataFields_SelectionRuleFields requires the child key values (5b2c48b9-abad-4a3b-a9b2-002fedfc582a) to exist in the parent table..
8

 

Best answer by Christian Hauggaard

Hi ​@aftabp 

Please see support ticket 34912

View original
    Did this topic help you find an answer to your question?

    5 replies

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+5

    Hi ​@aftabp 

    Please see support ticket 34912

    kerry_bespoke
    Contributor
    Forum|alt.badge.img
    • kerry_bespoke
    • Contributor
    • 26 replies
    • September 11, 2025

    ​@Christian Hauggaard  - what is Support Ticket 34912? We are having a similar issue and need it resolved.

    Error: ForeignKeyConstraint ConnectODXDatasources_DataTables required the child key values to exist in the parent table.

    We are on hold with our work at the moment as we are unable to open the instance until this is resolved.

    Kerry // Bespoke Analytics
    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+8
    • rory.smith
    • TimeXtender Xpert
    • 736 replies
    • September 12, 2025

    Hi ​@kerry_bespoke ,

    I assume that number is the ticket opened for that customer. I recently had a similar issue and opened a support ticket for it. Either e-mail support@timextender.com or use https://legacysupport.timextender.com to post a ticket.

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+5

    Hi ​@kerry_bespoke as Rory mentions, ticket 34912 is for another partner/customer.

    I see your colleague Deepali has opened ticket 37282 which I have updated with a response now.

    Going forward, we would appreciate it if you open support tickets for repository issues by emailing support@timextender.com 

    kerry_bespoke
    Contributor
    Forum|alt.badge.img
    • kerry_bespoke
    • Contributor
    • 26 replies
    • September 12, 2025

    ​@Christian Hauggaard OK thank you both for your assistance. We did open a support ticket but had not received a response so was trying the community. I will be sure to just stick with the support tickets for repository issues from now on.

    Kerry

    Kerry // Bespoke Analytics
    Christian Hauggaard

    Most helpful members this week

    Terms and ConditionsCookie settingsAccessibility statement

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings