Skip to main content
Waters

Error "Error encountered:Conversion from type 'DBNull' to type 'String' is not valid." appears in the NuGenesis Archive Agent log file - WKB59021

Article number: 59021

SYMPTOMS

  • No Empower data is archived into NuGenesis 8 SR-2

ENVIRONMENT

  • NuGenesis 8 SDMS
  • NuGenesis 8 Data Adapters Release 3
  • Empower 3

CAUSE

The project has a blank SampleName.

FIX or WORKAROUND

Install DAR3-HF2 on the Empower Remote DCOM server to resolve this issue.

ADDITIONAL INFORMATION

The following messages appear in the Archive Agent's log file "Program Files (x86)\NuGenesis 8.0\AA\NGSDMS80AAActivity.log":

Message........: 2018-11-30 11:40:35: Beginning execution of archive request 1.
Message........: 2018-11-30 11:40:35: Server: NUG, Project: Empower, Template: EmpClient.
Message........: 2018-11-30 11:40:41: Archive scan with no files archived for command id 1. {"NUG","Empower","EmpClient"} {"Waters Corp.","Empower-3 Projects","0"}.{Summary : (Total Scanned Files = 0)(Start Time = 11/30/2018 11:40:35 AM)(End Time = 11/30/2018 11:40:41 AM)(Total Time = 0h 0m 6s)}.
"E ","2018/11/30 11:41:04 AM ","13 ","13 ","Error encountered:Conversion from type 'DBNull' to type 'String' is not valid. :: \\WB-EMP-CL\SDMSarchive\EMP3\Recovery Trial 20181108\:1047 ","Waters.SDMS.WindowsService ","clsEmp2PreProc ","NGWriteResultInfoToFile ","1 ",""
"E ","2018/11/30 11:41:04 AM ","5 ","5 ","Value cannot be null.
Parameter name: o: ","Waters.SDMS.WindowsService ","clsEmp2PreProc ","NGPerformConvTasks ","1 ",""
Message........: 2018-11-30 11:41:02: EMC: PerformPreProcess error.
"M ","2018/11/30 11:41:04 AM ","0 ","0 ","Archived Project:[EMP3.Recovery Trial 20181108]  "," "," "," ","0 ",""
Message........: 2018-11-30 11:41:04: Archive scan summary for command id 1: {"NUG","Empower","EmpClient"} {"Waters Corp.","Empower-3 Projects","0"} {Summary : (Command ScanPath = \\WB-EMP-CL\SDMSarchive)(Total Scanned Files = 22)(Total Archived Files = 22)(Total Bytes = 16909359)(Start Time = 11/30/2018 11:40:41 AM)(End Time = 11/30/2018 11:41:04 AM)(Total Time = 0h 0m 23s)(Errors = 0)}.
Message........: 2018-11-30 11:41:04: Next scheduled runtime for archive request 1 is 2018-11-30 11:40:42.

 

id59021, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SDMS, SDMS8, SDMS8NU, SUP, SUPISDMS, SUPNG

Not able to find a solution? Click here to request help.