Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Facing error 'Login timeout error' while configuring ADW data connection in FDIP instance
I am trying to configure ADW database in FDIP instance in connection area, after giving all the details (username, password, service instance and wallet) it os getting errored out with below error:
Test connection failed. Review connection properties.
More Details
Login timeout specified by DataSource.setLoginTimeout(int) or by the oracle.jdbc.loginTimeout property has expired- Internal Server Error
Note:My FDIP instance is in another domain and ADW is in another domain
Answers
-
@ShyamKumarTech06 - Could you please confirm if you are trying to establish the connection to ADW via OAC > Create Connection? Additionally, is this a different ADW from the one provisioned with FDI? Thank you!
0 -
Could you please confirm if you are trying to establish the connection to ADW via OAC > Create Connection?
No, we are trying to establish connection to ADW via data configuration > Manage Connection in FDIP instance.(ot via OAC directly).
Additionally, is this a different ADW from the one provisioned with FDI - Yes this is different ADW from the one provisioned with FDI
0 -
@ShyamKumarTech06 I'll try to move the thread to the correct forum:
0 -
@ShyamKumarTech06 - Please verify whether your ADW is hosted on a private network or a public network. Additionally, ensure that the ADW is reachable and that the ACL rules defined allow requests from FDI. Thanks!
0 -
@ShyamKumarTech06 I understand you are not creating a connection to this ADW not via OAC→Connections but via FDI Connector. But are you able to establish a connection to the same ADW using FDI's integrated OAC Connection? If, no and the same error is observed then please follow @Sumanth V -Oracle's advise and check on those points. But if you are able to make a connection from OAC→Connection and not FDI's ADW connector let us know. We may need a official SR to troubleshoot further.
0 -
@Ashish-Oracle I am able to establish a connection to the same ADW using FDI's integrated OAC Connection successfully.
0 -
@ShyamKumarTech06 - While you are creating the SR seeking assistance on this issue, could you please confirm if you are using the low service name only and in the correct format? In OAC, the service name does not need to be provided separately, whereas in this connector it needs to be explicitly added. Thank you!
0 -
@Sumanth V -Oracle getting below error :
IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=q81r+VuxR6qdloNsWaqDjg==)- Host could not be reached
0 -
@ShyamKumarTech06 - Please let us know when this FDI was provisioned and what is the current version you are on. I tested in the newly provisioned FDI and it works.
0 -
@ShyamKumarTech06 As pointed out by @Sumanth V -Oracle this works as expected and looks like a environment specific ADW Connector issue . I would advise you to log a SR for this and have this further investigated.
0
