Skip to content

  • About Us
    • Our Team
    • Our Partners
  • Solutions
    • Data Warehousing
    • Big Data
    • Business Intelligence
    • Software Solutions
  • Services
    • Consultancy
    • Training
    • Technical Support
  • Products
    • Heimdall
    • Kronos
    • Cyclops
  • Career
  • TB Blog
  • Contact

Tag metadata asset manager

  • Home
  • IBM InfoSphere Metadata Asset Manager Timeout Error
22 July 2020

IBM InfoSphere Metadata Asset Manager Timeout Error

By Gunes INAL inIBM Information Server Tag datagovernance, dataprocessing, dataquality, ibm, ibmimam, information server, linux, metadata, metadata asset manager, oracle11g, oracle12, sql server, timeout error, windows

Hi ,

Recently two of our clients had same problem, time out error.

When we try to import metadata of databases that we will investigate about personel data GDPR vise , we couldn’t import any tables.

On a SQL Server via ODBC Connector ;

CDIMR3801E Error Occurred when attempting to browse bridge or connector data CDIMR007E. There was an error querying all tables in the <SCHEMA_NAME> schema.

On an Oracle 12C db via Oracle Native Connector.

CDIMR3790E An error occurred while importing data from bridge or connector(CAS/OracleConnector__11).

The solution is the same.

If you use a Windows server for IBM Information Server go to the installation path. Check if timeout parameter set or not. Then you set time out parameter , in this example I set it to 5 minutes which is 300 seconds. But if you import thousands of data you can set it 50 minutes.

C:\IBM\InformationServer\ASBServer\bin>iisAdmin.bat -display -key cas.agent.timeout

C:\IBM\InformationServer\ASBServer\bin>iisAdmin.bat -set -key cas.agent.timeout -value 300

C:\IBM\InformationServer\ASBServer\bin>iisAdmin.bat -display -key cas.agent.timeout

Be careful when you set parameters , I accidently delete once iisAdmin.bat file. If you do that you need to find same file from other installed information server instances.


for more information;

https://www.ibm.com/support/pages/troubleshooting-import-failures-during-connector-imports-very-large-amounts-metadata

https://www.ibm.com/support/knowledgecenter/SSZJPZ_11.7.0/com.ibm.swg.im.iis.mmi.doc/topics/c_overview.html

Logo

info@techbros.com.tr
GarantiBBVA Partners - Mecidiyeköy, Fulya mah. Büyükdere Cad. No:42, Doğuş İş Hanı / Kat:5, 34394 İstanbul

Recent Posts

  • Check Point VPN on MacOS Error
  • IBM InfoSphere Metadata Asset Manager Timeout Error
  • InfoSphere Optim Error: Client-Side OCI Error id=OCI_NO_DATA
  • Some Great Resources About Data Warehousing #1
  • Oracle Query for Sessions