9 Troubleshooting
When I log in, Oracle Fusion Analytics Warehouse doesn't load properly.
When you log out, be sure to close all Oracle Fusion Analytics Warehouse sessions and close your browser before logging in as another user. You can have one session of Oracle Fusion Analytics Warehouse open at a time within the same browser.
I see a performance decrease when using Mozilla Firefox.
If you use Mozilla Firefox and notice a decrease in the performance of the cloud service, then ensure that the Remember History option is enabled. When Firefox is set to not remember the history of visited pages, then web content caching is also disabled, which greatly affects the performance of the service. See Firefox documentation for details on setting this option.
After I complete a production to test refresh of my source (for example, Oracle Fusion Cloud Applications), why isn't the data in Oracle Autonomous Data Warehouse associated with my Oracle Fusion Analytics Warehouse instance synchronized with the source?
When you complete a production to test refresh on Oracle Fusion Cloud Applications, the data in Oracle Autonomous Data Warehouse associated with your Oracle Fusion Analytics Warehouse instance may be different than what is in Oracle Fusion Cloud Applications. To ensure that the data in Oracle Autonomous Data Warehouse and Oracle Fusion Cloud Applications is synchronized, the recommendation is to reset and reload the data source. See Reset and Reload the Data Source.
The data warehouse reset process is taking a long time.
- Review and update the access control list for the Oracle Autonomous Data Warehouse instance. See SEC Configure an Access Control List with Autonomous Database.
- Enable the data pipeline. See Disable Data Pipeline.
When I change a data source, the data configuration bundle didn't update the data for that source.
- Create a full data config bundle.
- Reset the warehouse.
- Change the source.
- Deploy the bundle.
- Alternatively, you can do a full data reset and reload.
Note:
If you do a full data reset and reload, the system reloads all data from the selected sources from the initial extract date. You can't run any other job while this is in progress and this could take a long time to complete.
When I migrate from the development or test instance to a production instance, I don't see the data immediately.
- Create a full data configuration bundle on your development or test instance.
- Create an environment bundle on your development or test instance..
- Export these two bundles as files.
- Import these files into your production instance.
- Deploy the full data configuration bundle on your production instance and wait for all pipelines to complete.
- Deploy the environment bundle on your production instance.
The data security assignment upload is failing.
- Verify that the users whose data security assignments you’re uploading are assigned the groups that are associated with the security context.
- Verify that the groups that are associated with the security context are mapped to the applicable application roles.
- Verify that the security object member values are valid by ensuring that the security object code and security object member values are mapped correctly in the file that you uploaded. If they aren’t mapped correctly, then you must correct the mapping and re-upload the file using the Uploads tile on the Console. See Upload and Download Data Security Assignments.