Grant Read is ignored as it is not supported in Oracle 11g.
Transformations can be created, but not altered at this time.
Ordering issue -→ Checked in the fix to properly sequence drops and fix the Aggrandize issue.
Partial Deploy Grants - testing on fdglp01 now, but looks like it is working
Transforms aren't being dropped in the rebuild operation
testJava test is failing on 12c partial - it works on full. I almost got it on Partial, but not quite.
Grants to objects other than Tables - should test them as well.
Column object grants or not baselined or deployed
Invalid Types are not baselined.
Queue support is added in this release. Queues bring their Queue Tables, Schedules, Subscribers, and grants with them.
...
Queue Agents are not supported.
Grants to objects that are renamed?
Should we just remove Job support from this release? Job schedule and Job Program support is added in this release. Select the Job object type to build and deploy them. Actual Jobs are not supported due to date issues.
Source:
Wed Jul 18 13:57:19 CDT 2018 - 1 - INFO - flexagon.fd.plugin.core.utils.FlexSqlUtils.executeFlexSqlFile - Executing SQL statement:
[BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'AT_P12_1531940235144.UPDATE_SALES',
job_type => 'STORED_PROCEDURE',
job_action => 'AT_P12_1531940235144.UPDATE_SALES_SUMMARY',
start_date => '28-APR-08 07.00.00 PM Australia/Sydney',
repeat_interval => 'FREQ=DAILY;INTERVAL=2', /* every other day */
end_date => '20-NOV-08 07.00.00 PM Australia/Sydney',
auto_drop => FALSE,
comments => 'My new job');
END;]
SQL executed successfully.
Baseline fails with error:
Wed Jul 18 13:57:21 CDT 2018 - 1 - SEVERE - flexagon.ff.common.core.exceptions.FlexCheckedException.init() - java.sql.SQLDataException: ORA-01843: not a valid month
flexagon.ff.common.core.exceptions.FlexCheckedException: java.sql.SQLDataException: ORA-01843: not a valid month
at flexagon.fd.plugin.database.utils.FlexRunSQLHelper.executeCreateBaseline(FlexRunSQLHelper.java:323)
at flexagon.fd.plugin.database.utils.FlexRunBaseline.runBaseline(FlexRunBaseline.java:512)
at flexagon.fd.plugin.database.operations.FlexOracleDBCreateBaseline.execute(FlexOracleDBCreateBaseline.java:92)
That is why it is commented.
Maybe it is best to just comment out Jobs entirely and remove it from the project property for now?
Transformations - These are counted as queues currently. Probably should add a new output for them. - I added a new output store for them, but I didn't put it in the plugin.xml and map it out. I can do that if we want to.
All customers will drop fddb schema and recreate it. Object Tables are not supported at this time (example of this DDL: CREATE TABLE SCHEMA_NAME.TABLE_NAME OF SCHEMA_NAME.USER_DEFINED_TYPE ( CONSTRAINT PK_TABLENAME PRIMARY KEY (name)) OBJECT IDENTIFIER IS PRIMARY KEY;
It is necessary to drop the fddb schema and recreate it to upgrade to the 6.0 version. All prior builds will be in an unusable state , and shouldn't be reused.