7 Troubleshooting

Here are solutions to some of the common issues that may come across while using Oracle GoldenGate Studio.

Topics:

7.1 Positioning of Docked Windows

Issue: Multiple docked windows like Projects Navigator, Component pallets, and so on are misplaced and do not fit the main application window properly.

Solution: Navigate to the Window menu and click Reset Windows To factory Settings.

7.2 Performance Issues While Using Oracle GoldenGate Studio

Issue: Severe performance issue when you use Oracle GoldenGate Studio.

Solution: Ensure that the repository is installed in the same LAN.

7.3 Privilege Issue with Oracle GoldenGate Studio

Issue: Only SUPERVISOR user have object level privilege.

Solution: To prevent contention against the same set of objects, it is recommended that Projects and Solutions are well planned in terms of who is working on the same objects.

7.4 Syntax Errors with Generated Code

Issue: Syntax errors are present.

Solution: Check the version and database values of the data servers assigned to the deployment profiles generated Code is compatible with the assigned data servers.

Next, check to see if the code can be successfully parsed by the Oracle GoldenGate Core product. If the syntax is successfully parsed by that tool, then the Oracle GoldenGate Studio and Core files are compatible.

If it is not successfully parsed and the error is not in the mapping syntax, then you can contact Oracle Support.

7.5 Not Able to Add Resources

Issue: Not able to set add resources by using the drag-and-drop option.

Solution: Ensure that you are dropping the resources to correct targets and to the solution editor links instead of Mapping Group to Deployment Profile links. You can add physical resources only to the Deployment Profile view. The Big Data System and Teradata are target only databases. You can drag-and-drop target only databases as a source database in the mapping editor. This is possible as mapping is a logical concept and no check is performed by Oracle GoldenGate Studio.