Support Article
pxCommitDateTime column does not exist
SA-53116
Summary
Error on enabling 'Use last updated time as start' checkbox in a BIX extract.
Error Messages
Status
Failed
Percent complete
Total number of records processed
0
Error message
No Instance found in the database
Could not process : pxCommitDateTime column does not exist
Steps to Reproduce
- Create a BIX extract rule.
- Select the Destination as Database
- Enable 'Use last updated time as start' checkbox on the BIX extract.
- Run the BIX extract
Root Cause
A defect or configuration issue in the operating environment.
The BIX extract invokes tables that do not contain pxCommitDateTime and pxSaveDateTime columns.
Resolution
Include the pxCommitDateTime and pxSaveDateTime columns in the tables that the BIX extract invokes. Alternatively, run delta extracts that invoke the tables without using pxCommitDateTime and pxSaveDateTime columns. This can be implemented by the below steps.
- Navigate to the Filter Criteria of the BIX extract
- Disable the Use last updated time as start checkbox
- Add a new filter. Set the field to .pxCreateDateTime, operator to Is Greater Than and VALUE to Last Extraction Time.
Tags:
Published April 13, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.