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

**URL:** <https://forum.certara.com/t/error-while-creating-the-define-xml-using-the-define-spec-in-pinnacle-21-community/2114>\
**Category:** Define.xml\
**Created:** [March 22, 2025, 12:16am UTC](https://forum.certara.com/t/error-while-creating-the-define-xml-using-the-define-spec-in-pinnacle-21-community/2114 "2025-03-22T00:16:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vishwateja.maduri](https://avatars.discourse-cdn.com/v4/letter/v/8491ac/32.png) [@vishwateja.maduri](https://forum.certara.com/u/vishwateja.maduri)\
**Post date:** [March 22, 2025, 12:16am UTC](https://forum.certara.com/t/error-while-creating-the-define-xml-using-the-define-spec-in-pinnacle-21-community/2114/1 "2025-03-22T00:16:03Z")

</div>

- 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](https://forum.certara.com/uploads/short-url/lsXQGElh4pa5u5o7UojnDGagEAu.xlsx) (133 KB)

---

<div class="post-metadata">

**Author:** ![Trevor\_Mankus](https://sea1.discourse-cdn.com/certara/user_avatar/forum.certara.com/trevor_mankus/32/2650_2.png) [@Trevor\_Mankus](https://forum.certara.com/u/Trevor_Mankus)\
**Post date:** [March 26, 2025, 2:35pm UTC](https://forum.certara.com/t/error-while-creating-the-define-xml-using-the-define-spec-in-pinnacle-21-community/2114/2 "2025-03-26T14:35:26Z")

</div>

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