Hi all, I'm seeing an issue after removing columns from an environment using Remove-PWEnvironmentColumn. Seems that something is left behind in the database after deleting columns that causes adding the column back to the environment with the same name causes an error, from the administrator client and from the cmdlet for Add-PWEnvironmentColumn.
error,
WARNING: Error modifying table: 56051WARNING: Failed to add column 'TEST3'. Error: 56051
#Step 1, Add Environment ColumnsNEW-PWLoginAdd-PWEnvironmentColumn -EnvironmentName "Example Environment" -ColumnName "TEST3" -ColumnType 'text' -ColumnWidth 32
#Step 2, Delete Environment Columns Remove-PWEnvironmentColumn -ColumnName TEST3 -EnvironmentName "Example Environment" -Verbose
#Step 3, Add Environment ColumnsAdd-PWEnvironmentColumn -EnvironmentName "Example Environment" -ColumnName "TEST3" -ColumnType 'text' -ColumnWidth 32
any help would be appreciated,
thanksCraig