NuGenesis Archive Agent 로그 파일에 "The type initializer for 'Oracle.DataAccess.Client.OracleCommand' threw an exception" 오류가 표시됨 - WKB58827
증상
- Empower 데이터가 NuGenesis 8 SR2에 아카이빙되지 않습니다.
환경
- NuGenesis 8 SDMS
- NuGenesis 8 Data Adapters Release 3 HF2
- Empower 3
원인
Empower 클라이언트 및 NuGenesis File Capture 모듈은 동일한 컴퓨터에 설치됩니다. NuGenesis Oracle 클라이언트는 PATH 환경 변수의 첫 번째 항목입니다.
수정 또는 해결 방법
Empower Oracle 클라이언트가 먼저 나열되도록 PATH 환경 변수를 업데이트합니다.
추가 정보
Archive Agent의 로그 파일인 "Program Files (x86)\NuGenesis 8.0\AA\NGSDMS80AAActivity.log"에 다음 메시지가 나타납니다.
Message........: 2018-11-01 15:30:19: Beginning execution of archive request 1.
Message........: 2018-11-01 15:30:19: Server: CBLSRV0002, Project: OQFile_Emp_20181101, Template: Empower Archive.
"E ","2018-11-01 03:30:21 PM ","0 ","0 ","5, The type initializer for 'Oracle.DataAccess.Client.OracleCommand' threw an exception. ","Waters.SDMS.WindowsService ","clsEmp2PreProc ","GetMillenniumAccountPassword ","1 ",""
"E ","2018-11-01 03:30:21 PM ","-1 ","-1 ","Error retrieving Millennium user account password ","Waters.SDMS.WindowsService ","clsEmp2PreProc ","PerformPreProcess ","1 ",""
"E ","2018-11-01 03:30:21 PM ","-1 ","-1 ","error in Remote PreProcess method ","Waters.SDMS.EmpowerDAProxy ","clsMillPreProc ","PerformPreProcess ","1 ",""
"E ","2018-11-01 03:30:21 PM ","-1 ","-1 ","PreProcessor call failed for the remote server: CBLDES0065 ","Waters.SDMS.EmpowerDAProxy ","clsMillPreProc ","PerformPreProcess ","1 ",""
Message........: 2018-11-01 15:30:21: EMC: PerformPreProcess error.
Message........: 2018-11-01 15:30:21: Archive scan with no files archived for command id 1. {"CBLSRV0002","OQFile_Emp_20181101","Empower Archive"} {"Waters Corp.","Empower-3 Projects","0"}.{Summary : (Total Scanned Files = 0)(Start Time = 01-11-2018 15:30:19)(End Time = 01-11-2018 15:30:21)(Total Time = 0h 0m 2s)}.
Message........: 2018-11-01 15:30:21: Next scheduled runtime for archive request 1 is 2018-11-01 15:35:18.
id58827, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SDMS, SDMS8, SDMS8NU, SUP, SUPISDMS, SUPNG, 비밀번호, 사용자 계정, 프로젝트