 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Can't run or delete portal due to "Duplicate Key" Error
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Can't run or delete portal due to "Duplicate Key" Error Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] Can't run or delete portal due to "Duplicate Key" Error | Login/Join |
| Platinum Member |
We were having trouble importing a CM package with a single portal in it from one 8104 environment to another, and somehow the package took, but we can't run the portal, or rename it, or even delete it because of the following error:  Obviously, that's not a very helpful error, and I don't know if this is a configuration error that is causing this, or what to do to troubleshoot this.This message has been edited. Last edited by: <Kathryn Henning>, Prod: 8.2.0.4 OS:Windows 10 Output:AHTML, Excel 2007+ The life of a designer is a life of fight against the ugliness. | ||
|
| Expert |
We have had this issue in content and portals. WE usually have to delete the offending item whether it is a fex or portal on the site you are importing to. What we have found is if you rename a fex or portal, not the description, but the fex or bip name, this error happens. Seems the import looks for the internal key, and a name and a missmatch happens. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Silver Member |
So I work with J Hines. We are migrating to a new server. I had gone in before to edit a portal and it disappeared upon save. When trying to import a new version of the portal from an existing server it gave me a sql insert error. There wasn't anything to delete so I created a new portal with the same name so that I could import the cm package. From there it brought back the original plus the one I created. Now we can't delete either of them. Is there a way to correct this? 8.1.0.4 Windows 7 Excel, AHTML, HTML,PDF | |||
|
| Expert |
In this case, what we have done is to look for the duplicate keys in the repository and delete one of them. This is a little risky, and I would advise backing up the repository prior to deleting anything. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
could you please share which repository table we need to look for duplicate. | |||
|
| Expert |
The table is WF_REPOSOBJ, and there may be dependencies as well. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Platinum Member |
Our admin apparently solved this by basically deleting everything in repository database. I'm not sure if it could have been solved with something less drastic, because it took a while to migrate user, rules, etc back over from the other environment, but we eventually got this sorted out. Prod: 8.2.0.4 OS:Windows 10 Output:AHTML, Excel 2007+ The life of a designer is a life of fight against the ugliness. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Can't run or delete portal due to "Duplicate Key" Error
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED] Can't run or delete portal due to "Duplicate Key" ErrorCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |