Troubleshooting Applications
The Applications page has been enhanced now. The application displays new error messages or warning messages related to application integration.
Connection Failure
Symptom
The system displays a warning message to indicate that it is a test connection failure. This screenshot displays the Test Connection Failure warning message:
Such warning message occurs due to the following reasons:
the Database as a service connection is invalid or not configured in OAC
the user name for Database as a service configuration contains Uppercase characters.
OAC returns 500 HTTP status code.
Solution
Change the current configuration and then try to establish the connection again.
Configuration Issue Exists Between ORDS and DBaaS
Symptom
The system displays a warning message due to configuration issue between Oracle REST Data Services (ORDS)and DBaaS.
Solution
Change the current configuration and then try to establish the connection again.
Number of Columns Exceed 1000 Warning Message
Symptom
In case of BICS/OACS/DBaaS configurations, the maximum fields you can add for an entity is limited to 1000. If you try to add more fields, the system displays a warning message.
This screenshot displays the warning message indicating that the number of columns cannot exceed 1000.
Solution
Try to keep the number of fields within the maximum limit.
Host Unreachable Message
Symptom
In BICS, OAC, and DBaaS channels, the host must be reachable within seven days. If the host is not reachable for more than seven days, the system displays an error message.
Solution
Make sure that the host is reachable within 7 days.
Integration Not Working
Symptom
The integration doesn't work. In other words, the Daily Extract files are not generated.
Solution
Review whether you have changed a label or type of a property that is configured for an application. Review whether you have changed a table or column that is created as part of an integration. The integration fails if any of these is true.