Troubleshooting PI APS

The required support DLL PIGenericNames.dll is not present or not registered

This error indicates that the %PIHOME%\Library\PIGenericNames.dll file is either missing or unregistered. To register the file, open a Command Prompt as administrator, change directories to the %PIHOME%\Library directory, and type in the following command:

Regsvr32 PIGenericNames.dll

The required support DLL PISpt.dll is not present or not registered

This error indicates that the %PIHOME%\Library\PISpt.dll file is either missing or unregistered. To register the file, open a Command Prompt as administrator, change directories to the %PIHOME%\Library directory, and type in the following command:

Regsvr32 PISpt.dll

The current primary archive does not have enough available primary records

Full error message:

The current primary archive does not have enough available primary records (is not large enough) for any new points, so APS will not attempt to create any more points during this sync loop. (PerformASynchronization)

This error means that there are no free primary records in the current primary archive, so no new points can be created. The solution is to create a larger archive and to shift into that archive.

You attempted to open a database that is already opened exclusively

Full error message:

Error -2147467259: Error from Microsoft JET Database Engine: You attempted to open a database that is already opened exclusively by user 'Admin' on machine 'strider'. Try again when the database is available. [pJetEngine->CompactDatabase() in CompactDatabase()] (CompactDatabase) from call pAPSPoints2->CompactDatabase() in FinishSync

This error is probably caused by the PI APS Configuration Utility competing with the Synchronization Engine for the APSPoints.mdb file. When this message is issued, the synchronization scan has finished successfully. The Synchronization Engine was unable to compact the APSPoints.mdb file to reduce the file size. However, the contents of the APSPoints database file are undamaged and the only consequence is that the file may be larger than actually necessary. The solution is to exit from the PI APS Configuration Utility prior to the next synchronization scan so that the Synchronization Engine is able to obtain exclusive access.

Error -2147220428: Failed to create point on server

Full error message:

Error -2147220428: Failed to create point on server. [-11053] No More Available Records in This Archive(FatalError) from call m_ptrPIPoints->Add (<tagname>) in PerformASynchronization

This error means that there are no free primary records in the current primary archive, so no new points can be created. The solution is to create a larger archive and to shift into that archive.

Error -2147220428: Extended error info returned: Failed to create point on server. [-10401] No Write Access - Secure Object(FatalError) from call m_ptrPIPoints->Add (<tagname>) in PerformASynchronization

The Synchronization Engine does not have write access to the point database (PIPOINT) in the PI Server, so no new points can be created. The information for the new point is stored in the APSPoints database and the optional create log file. Either change the logon account for the Synchronization Engine service to an account that has write access to the PI point database, or change the PI Server security for the PIPOINT table to give write access to the Synchronization Engine.

Error -2147024891: No Write Access

Full error message:

Error -2147024891, Extended error info returned: Insufficient permission to access or complete operation.[-10401] No Write Access - Secure Object from call ptrStateSets->Add in CreateDigitalSet

This error means that the Synchronization Engine does not have write access to the digital sets table (PIDS) in the PI Server. The Synchronization Engine was attempting to create a new digital set to support the creation of a new digital point. The new digital point was not created. The information for the new point is stored in the APSPoints database and the optional create log file. Either change the log on account for the Synchronization Engine service to an account that has write access to the PIDS table, or change the PI Server security for the PIDS table to give write access to the Synchronization Engine.

Conflicting attribute: FatalError => [-10401] Unknown error

This message only appears in the synchronization log file. Full error message:

Conflicting attribute: FatalError => [-10401] Unknown error

This error means that the Synchronization Engine does not have write access to a PI point that it was attempting to edit. The tag name of the PI point is in a preceding message. Depending on PI Server version, change the PtSecurity attribute or the PtOwner, PtGroup, and PtAccess attributes to give write access to the Synchronization Engine.

Index creation fails on APSPoints database

If the PI APS Configuration Utility asks if indices should be created for an APSPoints database and clicking the Yes button results in an error message, the most likely cause is stale data in the database. Select Manage Database on the Tools menu. If the offer to create indices is repeated, click No to proceed to the Manage APSPoints Database dialog box. Use the Purge buttons in this dialog box to delete the contents of the available points, PI Point Edits, and PI Point Deletes tables. Close the dialog box. Select Manage Database on the Tools menu again. The offer to create indices should reappear and clicking Yes should always work on empty APSPoints tables.