0

Written by

Sr Application Development Analyst at The Ohio State University Wexner Medical Center

Question Scott Roth · Mar 21

VSCode - trying to use <sql> tag to call SELECT statement

#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #DTL #ObjectScript #VSCode

I was using VSCode to edit a DTL because it seemed easier to copy/paste code from parts of the DTL I was editing. I tried to add <sql> tag and code to call a SELECT statement, but when I compiled I got the following error...

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'GetSourceDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetSourceDocType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'

> ERROR #5490: Error running generator for method 'GetSourceDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetSourceDocType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'GetSourceType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetSourceType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'

> ERROR #5490: Error running generator for method 'GetSourceType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetSourceType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'GetTargetDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetTargetDocType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'

> ERROR #5490: Error running generator for method 'GetTargetDocType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetTargetDocType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'GetTargetType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetTargetType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'

> ERROR #5490: Error running generator for method 'GetTargetType:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(GetTargetType) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR <Ens>ErrInvalidDTL: Invalid DTL

> ERROR #5490: Error running generator for method 'Transform:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(Transform) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'

> ERROR #5490: Error running generator for method 'Transform:osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

ERROR: Ens.DataTransformDTL.cls(Transform) of generated code compiling subclass 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

> ERROR #5030: An error occurred while compiling class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization'

Detected 10 errors during compilation in 0.045s.

Class 'osuwmc.Epic.MFN.DTL.EpicMFN949002Normalization' contains an invalid DTL document:

ERROR <Ens>ErrXMLValidation: Error in XML Validation: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))' while processing Anonymous Stream at line 62 offset 6 %2

Is this just something that isn't available for editing within VSCode?

Product version: IRIS 2024.1

$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2U) Tue Apr 30 2024 16:06:39 EDT [HealthConnect:7.2.0-1.r1]

Discussion (0)0

Log in or sign up to continue

Comments

Brett Saviano · Mar 21

VS Code supports editing a class that extends Ens.DataTransformDTL the same as any other. That error message is reporting that the contents of the DTL XData block are invalid. Did you make your edit the right place?

0 0

Robert Barbiaux · Mar 22

Error message

ERROR #5001: element 'sql' is not allowed for content model '(annotation?,((true,false)|(false,true)|(true)|(false)))'
Indicates the <sql> element in the DTL XData block is in an unexpected location in the xml document, and that expected elements in that location are <annotation>, <true> or <false>. Maybe it is directly under <if> ?

0 0