Error Description:
Talend Openstudio Error in the Oracleinput component that the Guess Schema appears in database connection is failed.
View error details and find the error message roughly meaning that the server does not know the SID we provide.
Error guessing:
The use of an existing connection is selected in the component, and the corresponding OracleConnection component can be executed successfully. The connectiontype selected in the OracleConnection component is also servicename.
However, the use of an existion connection is deselected, and the ConnectionType in the Oracleinput component is found to be SID. Try selecting ConnectionType as ServiceName in the Oracleinput component, then select Use an existing connection and click Guess Schema again.
Success. Reasoning is not supposed to be like this, it may be a bug of Talend.
Talend Openstudio Error in guess Schema in oracleinput component, database connection is failed