- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Native
Client][SQL Server]The CREATE UNIQUE INDEX statement terminated because a
duplicate key was found for the object name 'dbo.PS_PORTAL_CSS_RUN' and the
index name 'PS_PORTAL_CSS_RUN'. The duplicate key value is (PSEM, permsync).
[Mic
CREATE UNIQUE CLUSTERED INDEX PS_PORTAL_CSS_RUN ON PS_PORTAL_CSS_RUN
(OPRID, RUN_CNTL_ID)
Error: Unable to process create statement for PORTAL_CSS_RUN
SQL Spaces: 0 Tables: 5743 Triggers: 0 Indexes: 6841 Views: 0
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
OokieDookie
Bonjour,
Repérez et supprimez les valeurs dupliquées dans les colonnes d'index :
SELECT OPRID, RUN_CNTL_ID FROM PS_PORTAL_CSS_RUN GROUP BY OPRID, RUN_CNTL_ID HAVING COUNT(*) > 1
"big" wrote:
Bonjour, je reçois cette erreur :
- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.PS_PORTAL_CSS_RUN' and the index name 'PS_PORTAL_CSS_RUN'. The duplicate key value is (PSEM, permsync). [Mic CREATE UNIQUE CLUSTERED INDEX PS_PORTAL_CSS_RUN ON PS_PORTAL_CSS_RUN (OPRID, RUN_CNTL_ID) Error: Unable to process create statement for PORTAL_CSS_RUN SQL Spaces: 0 Tables: 5743 Triggers: 0 Indexes: 6841 Views: 0
Avez-vous une solution ? D'avance merci.
Bonjour,
Repérez et supprimez les valeurs dupliquées dans les colonnes d'index :
SELECT OPRID, RUN_CNTL_ID
FROM PS_PORTAL_CSS_RUN
GROUP BY OPRID, RUN_CNTL_ID
HAVING COUNT(*) > 1
"big" wrote:
Bonjour,
je reçois cette erreur :
- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Native
Client][SQL Server]The CREATE UNIQUE INDEX statement terminated because a
duplicate key was found for the object name 'dbo.PS_PORTAL_CSS_RUN' and the
index name 'PS_PORTAL_CSS_RUN'. The duplicate key value is (PSEM, permsync).
[Mic
CREATE UNIQUE CLUSTERED INDEX PS_PORTAL_CSS_RUN ON PS_PORTAL_CSS_RUN
(OPRID, RUN_CNTL_ID)
Error: Unable to process create statement for PORTAL_CSS_RUN
SQL Spaces: 0 Tables: 5743 Triggers: 0 Indexes: 6841 Views: 0
Repérez et supprimez les valeurs dupliquées dans les colonnes d'index :
SELECT OPRID, RUN_CNTL_ID FROM PS_PORTAL_CSS_RUN GROUP BY OPRID, RUN_CNTL_ID HAVING COUNT(*) > 1
"big" wrote:
Bonjour, je reçois cette erreur :
- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.PS_PORTAL_CSS_RUN' and the index name 'PS_PORTAL_CSS_RUN'. The duplicate key value is (PSEM, permsync). [Mic CREATE UNIQUE CLUSTERED INDEX PS_PORTAL_CSS_RUN ON PS_PORTAL_CSS_RUN (OPRID, RUN_CNTL_ID) Error: Unable to process create statement for PORTAL_CSS_RUN SQL Spaces: 0 Tables: 5743 Triggers: 0 Indexes: 6841 Views: 0