• Error shown in the Event Viewer on all the PVS Target Devices:

           Source: BNDevice
           EventID: 1014
           Unable to update database with new machine account password - The operation completed successfully. (0x0).

• All PVS Target Devices are getting the same error every one hour after the first automatic attempt to reset the machine account password.
• At the same time, Event Viewer on PVS servers are showing following error:

           Source: StreamProcess
           Event ID: 11
           DbAccess error: <-31742> (in DeviceUpdateADInfo() called from SSProtocolAdmin.ccp:459).

• As workaround, the machine account password can be reset manually from the PVS console.
• A set of CDF traces collected on the PVS servers, shows the following error message: "Cannot insert the value NULL into column 'adPassword', table 'ProvisioningServices.dbo.Device'; column does not allow nulls."

Option 1

Upgrade PVS 7.1 farm to PVS 7.12 or the latest version 7.13, since the db schema of PVS 7.1 farm was upgraded to db schema of PVS 7.12, which means that the existing db schema does not belong to existing PVS 7.1 farm anymore.
Refer to documentation to know how to upgrade to PVS 7.13 http://docs.citrix.com/en-us/provisioning/7-13/upgrade.html.

Option 2

Restore the database to a good backup that was created prior to the changes made that caused the issue to start happening, if there were no major changes in the farm since that backup was taken. This is going to allow to restore the db schema of PVS 7.1 farm.

---

Problem Cause

The error message was caused by the db schema of PVS 7.1 farm was upgraded to db schema of PVS 7.12 farm.

How was identified the db schema upgrade ?:

• Looking at the database that PVS 7.1 farm is connected to, the table "dbo.DataBaseVersion" shows that the database schema belongs to PVS 7.12 version. This can happen when attempting to join a PVS 7.12 server to the same PVS 7.1 farm, when prompted to upgrade the db and selecting Yes, the db schema will be upgraded to the db schema of the newer PVS version.

The db schema belongs to PVS 7.12 farm because of two things:

1st:

• In the CDF traces we saw the following error message: "Cannot insert the value NULL into column 'adPassword', table 'ProvisioningServices.dbo.Device'; column does not allow nulls."
• The 'adPassword' field was introduced to the PVS db after PVS 7.11, which means that the 'adPassword' field should not be present in a PVS 7.1 db.

2nd:

• When looking at PVS 7.1 db, on table "dbo.DataBaseVersion" and Select the Top 1000 Rows, it shows Version = 70. Value 70 means that the db schema belongs to PVS 7.12 farm and PVS 7.1.0 db should show Version = 10.