There is already an object named 'PK_Prior' in the database
search cancel

There is already an object named 'PK_Prior' in the database

book

Article ID: 161301

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

 The stored procedure spgetlocalisedstrings uses a primary key for a temp table, this temp table is not dropped for some reason and this causes the system to not be able to create the primary key

 There is already an object named 'PK_Prior' in the database

Cause

 temp data table is not being dropped 

Resolution

This issue has been addressed in ITMS 7.6 release; however a workaround to this is to update the stored procedure with the attached "spgetlocalizedstringsmodified.sql"   file.


Applies To

 ITMS 7.5, 7.5 sp1

Attachments

spgetlocalizedstringsmodified.sql get_app