ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 161301

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

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