0
Answered

Unable to create Oracle DB agent on IDb v5.3.1 - Error Invalid connection string

Rizwan Ahmed 3 months ago • updated by Matthew Davis (Engineering Manager) 3 months ago 6

We are trying to configure Oracle agent on IdB v5.3.1 Revision #0. Took the sample connection string at https://voice.unifysolutions.net/knowledge-bases/7/articles/2863-oracle-database-agent

as below but IdB does not accept the connection string and raise an error 'Invalid connection string' on "Save Agent"

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostName)(PORT=1251)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=serviceName)));

We want to user a connection string is following format, if that is supported.

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;

Affected Versions:
Fixed by Version:

Answer

Answer

Hey Rizwan,

The second connection string that you've provided works as a valid input into UNIFYBroker. Can you give it a go and see if it connects to the database correctly?

Unfortunately the oracle page for connection strings no longer exists. See this link for an archive of it: https://web.archive.org/web/20130627000544/https://docs.oracle.com/cd/E11882_01/win.112/e18754/featConnecting.htm .

I'll update our documentation page with more relevant information 

Under review

We use the standard libraries, so support whatever they do. Unfortunately the Oracle libraries are poorly documented so it's hard to say exactly what that is.

If the exception is in the logs, could you attach the full exception details? If it's not (e.g. returning the exception to the UI), could you save one that works, stop the service, edit the agent configuration so that it contains what you are after, start the service, it should be in the logs.

Thanks.

Answer

Hey Rizwan,

The second connection string that you've provided works as a valid input into UNIFYBroker. Can you give it a go and see if it connects to the database correctly?

Unfortunately the oracle page for connection strings no longer exists. See this link for an archive of it: https://web.archive.org/web/20130627000544/https://docs.oracle.com/cd/E11882_01/win.112/e18754/featConnecting.htm .

I'll update our documentation page with more relevant information 

Hi guys, 

The second connection string I provided was accepted by the UI. 

However, now we are getting the following exception. Please note that we did installed the driver from https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html and on this server, we have VS installed where we can create a custom program to connect to the Oracle database. Please share if there are any additional steps to make IdB work with Oracle DB? thanks.

20190212,05:45:18,UNIFYBroker,AgentEngine,Warning,"The test of agent Test Oracle failed with message Unify.Framework.UnifyDataException: An exception occurred while creating the connection with the 'Oracle.DataAccess.Client' provider. See inner exception for more information: ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
at Unify.Framework.Data.OracleDataControlExtensions.CreateConnection(String connectionString)
--- End of inner exception stack trace ---
at Unify.Product.IdentityBroker.DatabaseAgent.TestConnection()
at Unify.Product.IdentityBroker.AgentEngine.Test(Guid agentId).",Normal

Unable to find the requested .Net Framework Data Provider. It may not be installed.

The data provider is not visible to UNIFYBroker. Depending on the version of the provider installer that you used and the documentation that you followed, you may need to edit the .config file (https://docs.oracle.com/cd/B28359_01/win.111/b28375/featConfig.htm) or perform a repair install.

Hi Rizwan,

Have you managed to progress this any further?

Answered

Feel free to re-open if you need further information