|
| | | 
StrataFrame User
 
Group: StrataFrame Users
Last Login: Yesterday @ 3:00:03 PM
Posts: 309, Visits: 1,816 |
| | I get the following error whenver I try to save a record in the DDT. any Ideas? 
|
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926 |
| This indicates that the index field had a record that was added that did not have a parent record. This could be due to a failed INSERT or DELETE from a previous record. This is a SQL Server message indicating that the foreign key relationship was not maintained. This should not happen anywhere within the DDT, can you give more specifics? Also, does this happen on every table and every profile or just a specific table or index that youa re trying to save. It would be my guess that the primary key index (which we create dynamically upon the save) may have been removed and previously existed or something of that nature. Any details would be appreciated. Thanks.  |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 3:00:03 PM
Posts: 309, Visits: 1,816 |
| | Trent, It appears to be an issue with Guid Prime keys where ROWGUID is set to true. I'm still checking it out but that looks like what is causing it |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| Paul, could you backup your StrataFrame database and email me the *.bak file. This looks like the same error that Jason Seidell is getting, and he's supposed to be sending me his StrataFrame.bak file, too, but I won't know for sure until I can look at it with the data.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 3:00:03 PM
Posts: 309, Visits: 1,816 |
| | Ben, What is you Email address? |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926 |
| | Paul, I sent you a PM with the information. Thanks. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 04/30/2008 4:02:12 PM
Posts: 2,647, Visits: 1,861 |
| | OK, Paul, we tracked down the problem. The primary key could not be re-created because there is already an index on those tables that is named the same as the primary key that the DDT is trying to recreate. So, we fixed the problem by deleting the index under the table that was PK_[TableName] where the index was not a primary index (if it's the blue rolodex icon, not the yellow key icon). Once you delete the index, modify the structure of the table and save it and the index will be recreated. Let me know it works out for you.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 3:00:03 PM
Posts: 309, Visits: 1,816 |
| | thanks Ben I'll look at it |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 3:00:03 PM
Posts: 309, Visits: 1,816 |
| | |
|