Symptoms / Error

  • Data Exchange fails. 

  • Sends documents to manual indexing. 

  • DataExchangeService.log reports "ERROR [08001] [IBM][CLI Driver] SQL30082N  Security processing failed with reason "3" ("PASSWORD MISSING").  SQLSTATE=08001"

Cause

  • This is due to MI2.cfg specifying an ODBC connection and not specifying a password. 

Fix

  • Access 32-Bit ODBC and within the PETRO DSN set and save a valid username and password. 

  • Restart the dataexchange service.

Summary

  • This could be the same in the dataexchange config file, but to date have only seen it in the MI2.cfg file.