Error while creating the Define.xml using the define spec in Pinnacle 21 community

Pinnacle 21 Support Define.xml
1
  • Failed define converter process. infos=DefineConversionInfo{dataPackage=DataPackage{standard=Input{value=StandardType{value=Undefined, name=UNDEFINED}, userProvided=true, empty=false}, standardVersion=StringInput{value=, userProvided=false, empty=true}, meddraVersion=StringInput{value=, userProvided=false, empty=true}, sdtmCtVersion=StringInput{value=, userProvided=false, empty=true}, qrsCtVersion=StringInput{value=, userProvided=false, empty=true}, adamCtVersion=StringInput{value=, userProvided=false, empty=true}, sendCtVersion=StringInput{value=, userProvided=false, empty=true}, ndfrt=StringInput{value=, userProvided=false, empty=true}, unii=StringInput{value=, userProvided=false, empty=true}, loinc=StringInput{value=, userProvided=false, empty=true}, whodrug=StringInput{value=, userProvided=false, empty=true}, snomed=StringInput{value=, userProvided=false, empty=true}, projectName=StringInput{value=, userProvided=false, empty=true}, studyName=StringInput{value=, userProvided=false, empty=true}, groupName=StringInput{value=, userProvided=false, empty=true}, dataPackageName=StringInput{value=, userProvided=false, empty=true}, source=FileDS{path=D:\Live Projects\Abbott\ITOP-322-0216_Ganaton\CSR\BDR3\Define\SDTM\define.xlsx, schema=FILE, cleanup=false, valid=true}, standardFilter=Input{value=ALL, userProvided=false, empty=true}, sourceFormatType=Input{value=DEFINE_SPEC, userProvided=true, empty=false}, sourceDelimiter=StringInput{value=, userProvided=false, empty=true}, sourceQualifier=StringInput{value=, userProvided=false, empty=true}, createAlways=Input{value=true, userProvided=false, empty=true}, engineVersion=Input{value=1903.1, userProvided=false, empty=false}, encoding=Input{value=null, userProvided=false, empty=true}, engineFolder=provided, downloadConfig=Input{value=true, userProvided=true, empty=false}, defineVersion=Input{value=Define-XML 2.1, userProvided=true, empty=false}}, excelFile=FileDS{path=D:\Live Projects\Abbott\ITOP-322-0216_Ganaton\CSR\BDR3\Define\SDTM\define.xlsx, schema=FILE, cleanup=false, valid=true}, xmlFile=FileDS{path=D:\vishwateja.maduri\Pinnacle 21\Define xml and specs\define-2025-03-22T00-15-39-330.xml, schema=FILE, cleanup=false, valid=false}}
    define.xlsx (133 KB)
2

Hi @vishwateja.maduri

This error is caused by some malformed Where Clause values on the ValueLevel worksheet. I suggest you review it for the following:

  1. Make sure all Where Clauses are formed with a VARIABLE COMPARATOR VALUE pattern. I see a few which are missing COMPARATOR and VALUES (e.g., DA.DAORRES has a ValueLevel entry with a where clause of “DA.DAORRES.DATESTCD.DISPAMT”)
  2. Make sure the VALUE portion of the Where Clause is wrapped in double quotes when the VALUE contains a space. This will help ensure the value is processed correctly.

I hope this helps,
Trevor