Error adding new item to database in an empty table.
Campus solution 9.20.025
PeopleTools 8.56.14
Database Type: MS SQL Server
I am very new to PS development. I am creating a very simple component with single effective dated table described here. I have creaed a page where the field CODE is at level 0 and remainder of the fields are in a scroll at level 1. The component search record is MyTable.
MyTable
CODE -- KEY 1, Searchable = Y.
DESCRIPTION
EFFDT -- KEY 2, Searchable = N. Default = %date
EFF_STATUS -- Default value 'A'
To add a new record, I use the 'Add New Value' tab on the Search page which brings me to the page I created to enter decription, effdt, and status. I enter description and leave the defaults for the effective date (1/1/1901) and status (A). When I hit save, I get error message "Data being added conflicts with existing data. (18,2) When adding a new item to the database, the system found a conflicting item already exists... " whenver I am creating a new code. It happens even when MyTable is emply and there are no rows in it.