PSBUILD.SQL using old SQL Definition
edited Apr 12, 2019 4:31PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓
After changing the SQL Definition behind a view and building the view, the PSBUILD.SQL contains the CREATE statement with the original SQL Definition. The PSSQLTEXTDEFN contains two rows for the SQLID. The row where the DBTYPE is blank contains the revised SQL Definition. The row where the DBTYPE is equal to 2 (Oracle) contains the original SQL. This happens when you do either "Build Script file" or "Execute and build script". The "Recreate view if it already exists" option is selected in the Build Settings.
We just upgrade PeopleTools from 8.56.04 to PeopleTools 8.56.12.
What is causing the PSBUILD.SQL to create the CREATE statement with the wrong SQL Definition?
Tagged:
2