ZFSCM900_DROP5_PRE_DMS Errors

Problem:

When running the ZFSCM900_DROP5_PRE_DMS step to drop unneeded views, many steps complete in error:

SQL Error. Error Position: 0 Return: 601 - [Microsoft][SQL Native Client][SQL Server]
Cannot drop the view 'PS_XXXX_XX_XXXX_VW', because it does not exist or you do not have permission.

The end of the log file states ‘Successful Completion’.

Solution:

This is expected behaviour. The MP5 documentation states:

Dropping Views
In this step, if you encounter an error, due to some tables and views previously dropped or already do not exist in the database, please ignore the error, mark this step as Complete and continue with the Maintenance Pack installation. Note that the script log would still mark as Successful completion.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


This site uses Akismet to reduce spam. Learn how your comment data is processed.