Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Integration Service

TABLE OF CONTENTS

WCF GET DATA using Integration Client

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedFeb 28, 2025
  • 8 minute read

Unable to retrieve data From Microsoft Excel 2013 or 2016

Description: When you try to access data from a Microsoft Excel 2013 file through Integration Client, after you click Get Data, the message No data is available for the request is displayed.
For Microsoft Excel 2016, the message displayed is The file is already opened or being processed by another process.

Resolution:

Install the 32-bit version of Microsoft Access Database Engine 2010 Redistributable to fix the driver issue.

Note: The 32-bit version of the software must be installed irrespective of the bitness of your computer.

Unable to retrieve Data of ABOM_Published DB View for AVEVA Diagrams

Description: If you have connected to an AVEVA™ Diagrams data source and tried to retrieve data from the ABOM_Published DB view for the AVEVA Schematics module, no data is retrieved and an error message No data is available for the request is displayed. This issue has been observed when Microsoft Visio was not installed on the computer on which AVEVA™ Integration Service is installed.

Resolution:

Install Microsoft Visio on the same computer as AVEVA™ Integration Service.

User is not able to access the AVEVA Instrumentation project in the Integration client in Cloud UE environment.

Description: This could be caused by a project access rights issue.

Resolution:

  • If the project is using AD authentication, the domain account SVC_IED_AIS should be created as a user (as per the Admin Guide).

  • On the SQL server, the domain SVC_IED_AIS user should have IDOUsers database role membership on the appropriate E&I SQL database:

  • If this is a Cloud UE Environment, all the integration related services should be started as the service account SVC_IED_AIS:

  • Please check the AVEVA Instrumentation Data Service is currently running with the service user [User who created AI project] in services.msc.

  • Please ensure that the user wants to access Instrument Tables is added to the security manager of the AVEVA Instrumentation database.

Unable to retrieve get tables in Integration Client for AVEVA™ Enterprise Resource Management product

Description: AVEVA Integration Service is unable to contact the AVEVA ERM API or there is a problem with the deserialization of the AVEVA ERM response.

Resolution: Try the following:

  • Populate the ERM Data extraction query with at least one optional parameter. To do this

    1. Go to the 12010 screens

    2. Find and select the query

    3. Click the edit query button

    4. In the new screen, click create parameter

    5. Create a dummy non-mandatory parameter

    6. Save the parameter

    7. Execute the query

    8. Save the query.

  • Restart the Multi consumer service.

  • Check with ERM Admin to verify that the ERM DataExtraction API is running.

Pipelines data published from AVEVA™ Engineering is not displaying in Integration Client.

Description: This issue could be because of DB view/procedure or a PML error

Resolution: To identify the cause, try the following:

  • Launch the product on the AVEVA™ Integration Service server machine.

  • Try retrieving data directly from the DB view/procedure.

  • Try running pipelines.pml in the Engineering module in a command window without any pml error.

Unable to retrieve data for the Dabacon Product - error System.timeOutException

Description: Sometimes, when you try to retrieve data from a table that contains complex PML expressions/filtering conditions or contains large amounts of data, after running for a long time, the process stops, and the data may not be returned. The message Unable to retrieve data from the service: Please check log file for details is displayed on the Integration Client and on the client application. A message similar to the following is logged to the log file:

System.TimeoutException: The HTTP request to 'http://<machinename>:<portnumber>/InterOpIntegrationWinService' has exceeded the allotted timeout of 0x:00:00. The time allotted to this operation may have been a portion of a longer timeout.

Resolution: This issue occurs because of a timeout error. The Service stops the process when a timeout is reached. To resolve this, you must increase the timeout limit. To increase the timeout limit:

  1. Open the AVEVA.IntegrationService.Settings.config file available at the installation location of Integration Client.

  2. For the Service Time Out parameter, increase the value to according to your requirements. The value must be specified in minutes. The default value is 180.

  3. Save the file.

"Get Tables" returns error in Integration Client for Oracle Product

Description: There is a limitation in AVEVA Integration Service so that it only lists the tables and db views that the logged in user owns. This means that AVEVA Integration Service can't list any views in another schema.

Resolution: The simple workaround is to create a user with minimal privileges and grant access of the tables/views to that user. Then grant the CREATE VIEW privilege to this user. This user can then create a db view that queries the other table/db view.

For example:

One user called c##dan. This user owns the tables that need to be visible in AVEVA Integration Service.

Another user c##bob. This user has only CONNECT and CREATE VIEW privileges.

Logged in as admin:

CREATE USER c##bob IDENTIFIED BY bob DEFAULT TABLESPACE users quota unlimited ON users;

GRANT CONNECT, CREATE VIEW TO c##bob;

GRANT SELECT ON c##dan.pipes TO c##bob;

Then, logged in as c##bob, create a db view called "pipes" as follows:

CREATE VIEW pipes AS SELECT * FROM c##dan.pipes

This db view should now be available to view in AVEVA Integration Service.

To do this for a large number of tables, the SQL can be generated quickly as detailed below:

Logged in as admin, run the following query:

SELECT 'grant select on ' || owner || '.' || table_name || ' to c##bob;' FROM all_tables WHERE owner = 'C##DAN';

This will generate the commands as of below:

grant select on C##dan.ABC to c##bob;

grant select on C##dan.ABC to c##bob;

Then, run the following query:

​SELECT 'create view ' || table_name || ' as select * from ' || owner || '.' || table_name FROM all_tables WHERE owner = 'C##DAN';

Which will generate the commands as of below. These can then be executed by the user c##bob:

/* Execute as c##bob */

create view PIPES as select * from C##dan.PIPES

create view ABC as select * from C##dan.ABC

These should then be visible in AVEVA Integration Service connected with the c##bob user.

Unable to get Excel data having more than 255 Columns.

Description: You are using AVEVA Integration Service to import the data from an Excel file. Currently if the excel file contains 400 data columns, only the first 255 columns data will be imported and the remaining data columns.

Resolution: This is a current AVEVA Integration Service limitation due to a restriction caused by the use of OLEDB.

Error “No Unit operation schema” is displayed in AVEVA Engineering when importing Simulation Data from AVEVA Process Simulation

Description: Opening published simulation data from AVEVA Process Simulation in AVEVA Engineering displays a No Unit operation schema error and, as a result, prevents the simulation data import. There are two known cases for this:

  • When Simulation is not solved properly and published to AVEVA Engineering from AVEVA Process Simulation. In this case streams are not connected (which means they are missing from or to an endpoint). AVEVA Integration Service cannot fetch the data, and returns null to the AVEVA Engineering product. AVEVA Engineering displays No Unit operation schema error to user.

  • AVEVA Integration Service logs say, Object reference not set, Unable to get Data.

Resolution: You must solve the simulation problem and publish to AVEVA Engineering.

Unable to test data source / get data for AVEVA Electrical and AVEVA Instrumentation

Description: Using AVEVA Electrical and Engineering 15.7 with AVEVA Integration Service and AVEVA Instrumentation. After configuring the source and trying to work with the Integration Client, an error occurs. Yor are unable to get data for AVEVA Electrical or AVEVA Instrumentation.

Resolution:

  • Ensure that the windows user for AVEVA Electrical project has appropriate credentials for the Integration client.

  • AEAI middle tiers should be running under the user who created the project.

  • The users needs to be added in security manager to access AEAI project data.

Unable to get data from Integration Client - Extract DB View Data of E3D/Engineering - LaaS Configuration - Error “The service couldn't not process the request, try again later”.

Description: Below error is displayed, when user tries to retrieve data from the AVEVA Engineering product with a LaaS Configuration.

Resolution: AVEVA Integration Service (WCF API) Reading DB View Data of E3D/Engineering when LaaS Configuration.

  • Data retrieval from Dabacom platform products:

    • AVEVA Integration Service retrieves information from Dabacom platform products (for example, AVEVA E3D, AVEVA Engineering) by opening the products in TTY mode.

    • AVEVA E3D, AVEVA Engineering expects AVEVA Integration Service to send the User Access Connect Token (interactive token) when LaaS (License as a Service) is configured.

  • User Access Connect Token Handling:

    • AVEVA Integration Service sends the User Access Connect Token on behalf of User B (Service Log on User).

    • However, AVEVA Integration Service cannot generate the User Access Connect Token (interactive token) itself as it is a non-interactive service component.

    • When a user initiates the service via Integration settings editor (interactively), the User Access Connect Token, or part of it, is securely stored on the server.

  • Starting the Service:

    • When LaaS is configured, AVEVA recommends that you start the service from the Integration Settings editor initially, at least once, to generate and store the interactive Connect Token for future use.

    • Log in to the Integration Server with User B (Service Log on User) to start the service from the Integration Settings editor.

  • Adding Data Source:

    • User A can add a data source by logging on to the Integration Server.

    • User A should start/stop the service from Windows services and not from the Integration Settings editor. Starting the service from the Integration settings editor will replace the previously generated interactive Connect Token with a new one.

  • Data Retrieval:

    • If User A starts the service from the Integration Settings editor and the Service Log on User is User B, AVEVA Integration Service generates the User Access Connect Token on behalf of User B using User A's secrets. If the token cannot be generated, data retrieval from AVEVA E3D/AVEVA Engineering fails when Client User C requests data.

    • When User C requests data for AVEVA E3D/AVEVA Engineering, data will be retrieved only if the above conditions are met

In This Topic
Related Links
TitleResults for “How to create a CRG?”Also Available in