We are upgrading from 6.3 SP1 with the corresponding CRM framework. We are upgrading to 7.2.1 and the Customer Service 721 framework. As part of the CS framework install, the sql modifies the pxattachkey column (here is the sql statement: --execute on the database specified by Data-Admin-DB-Name PegaRULES:
ALTER TABLE SSWMD01.pc_data_workattach MODIFY "PXATTACHKEY" DATE
I have two questions/concerns:
1. The current format is varchar and the fields are filled with values such as 20160831T164107.964 GMT . A date field will have a significantly different format; will altering the format of existing values in this column (66 million rows worth in production) impact functionality/ability to access existing objects?
2. What is the correct format to have in the date field?
What database is this? Do you have any other frameworks installed? I did a quick check and I don't see anything in the CPM 6.3sp1 version that would have added this column as a varchar2 or anything else so I am trying to figure out what added the column in the first place.
We have worked with our db team to get the column updated and will use that approach as we move into the higher environments. Celeste - in answer to your questions we are using Oracle and we have the FSIF, SCMFS, Call and CSFS frameworks as well.