P6 EPPM – Multiple OBS validation queries generate invalid SQL WHERE () on SQL Server

🔹 Environment

• Product: Oracle Primavera P6 EPPM 24.12.0.0
• Database: Microsoft SQL Server
• Operation: OBS validation / delete

🔹 Issue Summary

While performing OBS-related validation (especially during OBS deletion),P6 EPPM generates invalid SQL statements with an empty WHERE clause.

The issue occurs across multiple validation queries and tables, not a single one.

🔹 Common Error Pattern (4 cases)

All observed errors share the same pattern:

SELECT COUNT(*) row_count FROM <table> WHERE ()

Examples from the logs:

1. projwbs

SQLException:SELECT COUNT(*) row_count FROM projwbs WHERE ()

1. projwbs (execution failure)

Failed executing query;SELECT COUNT(*) row_count FROM projwbs WHERE () with params null

1. userobs

SQLException:SELECT COUNT(*) row_count FROM userobs WHERE ()