Adding a data source

Unable to add a data source for E3D Fix 35 to AVEVA Integration Service 3.1.2

Description: In the Integration Settings Editor selecting E3D 2.1 and selecting Add Configuration you must enter a Datasource Name and then select Get Projects. The Get Projects dropdown remains blank and you cannot add the datasource.

Resolution: You must change the Newtonsoft.json version to 12 in the AVEVA.IntegrationService.DabaconAgent.exe.config file.

Unable to add a data source in AVEVA Integration Service settings editor - Error “Already having the DataSource with same name” displayed.

Description:

Data source name must be unique. You cannot have a duplicate name.

Resolution:

• When adding a data source using AVEVA Integration Service setting editor, the default name is given by the application. You must modify the name so that it is unique and save it. AVEVA recommends that you add one data source at a time and save it instead of adding multiple data sources and saving all.

• You can follow a naming convention like ProductName_Project_MDB Or LOC (E3D_APS_ALL_HYD).

Unable to add a Dabacon data source in AVEVA Integration Service settings editor - Error “Unable to open the Attribute data file- FNF: File not found” displayed.

Description: While trying to add a Dabacon data source, an error message similar to the following is displayed: Unable to open the Attribute data file- FNF: File not found %AVEVA_DESIGN_EXE%/attlib.bat. The error occurs when you click Get Projects while adding the configuration for the data source.

Resolution:

To resolve the error, do the following:

• In the installation folder of the data source, open the eVars.bat file.

• Add the following statement to the file:

  SET AVEVA_DESIGN_EXE=<ProductInstallationPath>

  Category - Get Data Integration Client

Unable to view projects while adding a Dabacon data source in AVEVA Integration Service settings editor

Description: While adding a Dabacon data source, the Projects list is empty after clicking Get Projects. Unable to view/get projects for AVEVA Engineering, E3D Application.

Resolution: Make sure the following requirements are met:

• The licensing parameters of both AVEVA™ Integration Service and the products are the same. Product and AVEVA Integration Service use the same licence and connect authority URL. Add the connect authority URL in Aveva.Connect.Authentication. See the Settings.xml in product installation folder.

• The service is running on the service user account.

• The projects are installed in the location where the product is configured.

• Are you able to open the product on the AVEVA Integration Service server machine.

• Is your service running with domain user.

• Check how the Project.bat file is set up?

Unable to add a Dabacon data source in the AVEVA Integration Service settings editor - customized evars.bat for different E3D data sources.

Description: You are not able to select a different Dabacon datasource defined in a different evars.bat, only the file that is in the installation folder.

Resolution: This is working as designed, there is no option available.

Unable to save a data source in AVEVA Integration Service Setting Editor - Error “All datasources are not saved successfully. Check log file for error.”

Description: All data sources are not saved successfully error occurs when clicking Save in AVEVA Integration Service settings editor. This error occurs when the AVEVA Integration Config API or the AVEVA Integration Service REST API end point not working.

Integration Service Logs

{"TimeStamp":"2024-03-11 13:21:08","Level":"Error","FileName":"null","ModuleName":"TestAPIConnection","LineNumber":"0","EventId":"746182","HostName":"[host name]","Message":"'https://interopied04.aveva.com:8080/' does not have trusted SSL Certificate, please ensure the API is SSL/TLS secure\n","ExceptionType":"WebException","InnerException":"","StackTrace":" at System.Net.HttpWebRequest.GetResponse()\r\n at AVEVA.IntegrationService.DataSource.DataSourceUtility.TestOnPremiseAPIConnection(String url, String& errorMessage)"}

OR,

{"TimeStamp":"2024-03-11 13:21:24","Level":"Error","FileName":"null","ModuleName":"ReadDatafromConfig","LineNumber":"0","EventId":"null","HostName":"null","Message":"For more information please refer 'C:\\Program Files (x86)\\AVEVA\\Shared\\AISConfig\\Logs' folder","ExceptionType":"WebException","InnerException":"","StackTrace":" at System.Net.HttpWebRequest.GetResponse()\r\n at AVEVA.IntegrationService.DataSource.DataSourceUtility.ReadDatafromConfig(String url, DataSet& dsDataSource)"}

{"TimeStamp":"2024-03-11 13:21:24","Level":"Information","ModuleName":"SubscribeAllDataSources","EventId":"null","HostName":"null","Message":"Subscribing to config datasources are completed."}

Resolution:

• Delete the Connect token already generated. To delete the token go to the following folders and delete the token.

  • C:\Users\<username>\.aveva

  • C:\ProgramData\.aveva

• Check that environment variable AVEVA_SERVICE_AUTHENTICATION_TYPE value is CONNECT if you are using “AVEVA Integration Service on Connect” and NTLM if you are not using it.

• Open AVEVA Integration setting editor,the Connect login prompt will appear and you must choose your account.

  

Configure all the endpoints (Datasource Store URL, Data Store URL, REST URL, webadmin URL) and Start Service. Error should not appear again.