Article - CS177497
Upgrade is throwing an error 'User does not have permission to run DBCC CHECKIDENT' upon upgrading Database Schema with SQL Server in Windchill Upgrade Manager
Modified: 03-Jul-2017
Applies To
- Windchill PDMLink 9.0 to 11.0
- Microsoft SQL Server
Description
- Upgrade Manager at fails at Upgrade Database Schema phase with the following error.
- 2014-07-10 15:10:42,438 ERROR [pool-4-thread-11] com.ptc.windchill.upgrade.phases.upgradeschema.ExecuteBatch - (com.ptc.windchill.upgrade.dbservices.dbservicesResource/4) wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[DBCC CHECKIDENT('entryNumber_seq', RESEED, 2471348)]. Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: User 'System' does not have permission to run DBCC CHECKIDENT for object 'entryNumber_seq'.
This is a printer-friendly version of Article 177497 and may be out of date. For the latest version click CS177497