I got below error message while running “Test_SPProjectDatabase” command on Project Server 2013 Database during upgrade process.

=============================================

Category        :       Security
Error              :       True
UpgradeBlocking :  False
Message         :       The following roles are missing from the database: 'PSDataAccess', 'PSReportingSchemaAdmin'

===============================================

Apparently the above roles were not present in the Project Server Database. I resolved the issue by creating these roles manually and by granting them appropriate permissions.

Below is the sql script to create the roles.

================================================

CREATE ROLE [PSDataAccess] AUTHORIZATION [dbo]
GO
CREATE ROLE [PSReportingSchemaAdmin] AUTHORIZATION [dbo]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [dbo] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [draft] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [pub] TO [PSDataAccess]
GO
GRANT UPDATE, DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [ver] TO [PSDataAccess]
GO

GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [dbo] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [draft] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [pub] TO [PSReportingSchemaAdmin]
GO
GRANT DELETE, EXECUTE, INSERT, REFERENCES , SELECT, VIEW DEFINITION ON SCHEMA :: [ver] TO [PSReportingSchemaAdmin]
GO

======================================================