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:


The screenshot shows Test Connection 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.


This screenshot shows the number of columns warning message.

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.