JDBC Query Activity errors with "Element SERVICEORDERNUMBER is not allowed as a child of Record because the {content type} is Empty" when returning records

[Dio -]

HI

I have a JDBC Query Activity the executes a simple query however after executing the query, it throws the following error:

14:11:14.071 ERROR [bwEngThread:In-Memory Process Worker-7] c.t.b.p.g.L.n.implementation.Log - Activity output data validation error. The output data from activity [PendingTable] in process [schduler], module [DAdapter.implementation] does not conform to the activity output schema. Element ID is not allowed as a child of Record because the {content type} is Empty. Element OPCO is not allowed as a child of Record because the {content type} is Empty. Element CORRELATIONID is not allowed as a child of Record because the {content type} is Empty. Element SERVICEORDERNUMBER is not allowed as a child of Record because the {content type} is Empty. Element PPPUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element PPPPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element WIFIUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element WIFIPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element SERIALNUMBER is not allowed as a child of Record because the {content type} is Empty. Element ONTMODEL is not allowed as a child of Record because the {content type} is Empty. Element PACKAGE is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER1 is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER2 is not allowed as a child of Record because the {content type} is Empty. Element CHANGEONT is not allowed as a child of Record because the {content type} is Empty. Schema=

schema-element({http://www.tibco.com/namespaces/tnt/plugins/jdbc+7041cc7d-c2d0-4348-8d8f-3684021940ed+output}resultSet) {http://genxdm.org/typed/local-types}type-8

Sequence

schema-element(Record) {http://genxdm.org/typed/local-types}type-9

Sequence

 

Data=2PTRpvm:0a1283h-0pvm:0a1283h-0usernamepasswordusernamepasswordELCLB2F6B2B4G240WFGPON_FE_00107864658590 FaultDetails=PendingTableActivity output data validation error. The output data from activity [PendingTable] in process [schduler], module [DAdapter.implementation] does not conform to the activity output schema. Element ID is not allowed as a child of Record because the {content type} is Empty. Element OPCO is not allowed as a child of Record because the {content type} is Empty. Element CORRELATIONID is not allowed as a child of Record because the {content type} is Empty. Element SERVICEORDERNUMBER is not allowed as a child of Record because the {content type} is Empty. Element PPPUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element PPPPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element WIFIUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element WIFIPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element SERIALNUMBER is not allowed as a child of Record because the {content type} is Empty. Element ONTMODEL is not allowed as a child of Record because the {content type} is Empty. Element PACKAGE is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER1 is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER2 is not allowed as a child of Record because the {content type} is Empty. Element CHANGEONT is not allowed as a child of Record because the {content type} is Empty. Schema=

schema-element({http://www.tibco.com/namespaces/tnt/plugins/jdbc+7041cc7d-c2d0-4348-8d8f-3684021940ed+output}resultSet) {http://genxdm.org/typed/local-types}type-8

Sequence

schema-element(Record) {http://genxdm.org/typed/local-types}type-9

Sequence

 

Data=<resultSet xmlns="http://www.tibco.com/namespaces/tnt/plugins/jdbc+7041cc7d-c2d0-4348-8d8f-3684021940ed+output"><Record xmlns=""><ID>2</ID><OPCO>PTR</OPCO><CORRELATIONID>pvm:0a1283h-0</CORRELATIONID><SERVICEORDERNUMBER>pvm:0a1283h-0</SERVICEORDERNUMBER><PPPUSERNAME>username</PPPUSERNAME><PPPPASSWORD>password</PPPPASSWORD><WIFIUSERNAME>username</WIFIUSERNAME><WIFIPASSWORD>password</WIFIPASSWORD><SERIALNUMBER>ELCLB2F6B2B4</SERIALNUMBER><ONTMODEL>G240WF</ONTMODEL><PACKAGE>GPON_FE_001</PACKAGE><TELEPHONENUMBER1>0786465859</TELEPHONENUMBER1><TELEPHONENUMBER2 /><CHANGEONT>0</CHANGEONT></Record></resultSet>Schduler/PendingTablecom.tibco.bx.core.faults.BxException: Activity output data validation error. The output data from activity [PendingTable] in process [nokia-ont-discovery.ONTSchduler], module [nms-nokia.implementation] does not conform to the activity output schema. Element ID is not allowed as a child of Record because the {content type} is Empty. Element OPCO is not allowed as a child of Record because the {content type} is Empty. Element CORRELATIONID is not allowed as a child of Record because the {content type} is Empty. Element SERVICEORDERNUMBER is not allowed as a child of Record because the {content type} is Empty. Element PPPUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element PPPPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element WIFIUSERNAME is not allowed as a child of Record because the {content type} is Empty. Element WIFIPASSWORD is not allowed as a child of Record because the {content type} is Empty. Element SERIALNUMBER is not allowed as a child of Record because the {content type} is Empty. Element ONTMODEL is not allowed as a child of Record because the {content type} is Empty. Element PACKAGE is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER1 is not allowed as a child of Record because the {content type} is Empty. Element TELEPHONENUMBER2 is not allowed as a child of Record because the {content type} is Empty. Element CHANGEONT is not allowed as a child of Record because the {content type} is Empty. Schema=

schema-element({http://www.tibco.com/namespaces/tnt/plugins/jdbc+7041cc7d-c2d0-4348-8d8f-3684021940ed+output}resultSet) {http://genxdm.org/typed/local-types}type-8

Sequence

schema-element(Record) {http://genxdm.org/typed/local-types}type-9

Sequence

 

Data=<resultSet xmlns="http://www.tibco.com/namespaces/tnt/plugins/jdbc+7041cc7d-c2d0-4348-8d8f-3684021940ed+output"><Record xmlns=""><ID>2</ID><OPCO>LTR</OPCO><CORRELATIONID>pvm:0a1283h-0</CORRELATIONID><SERVICEORDERNUMBER>pvm:0a1283h-0</SERVICEORDERNUMBER><PPPUSERNAME>username</PPPUSERNAME><PPPPASSWORD>password</PPPPASSWORD><WIFIUSERNAME>username</WIFIUSERNAME><WIFIPASSWORD>password</WIFIPASSWORD><SERIALNUMBER>ELCLB2F6B2B4</SERIALNUMBER><ONTMODEL>G240WF</ONTMODEL><PACKAGE>GPON_FE_001</PACKAGE><TELEPHONENUMBER1>0786465859</TELEPHONENUMBER1><TELEPHONENUMBER2 /><CHANGEONT>0</CHANGEONT></Record></resultSet>

at com.tibco.bx.core.BxSystemImpl.customizeValidationException(BxSystemImpl.java:2337)

at com.tibco.bx.util.BxValidationHelper.validate(BxValidationHelper.java:34)

at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.validateOutput(BxExtensionBehavior.java:125)

at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.doExternal(BxExtensionBehavior.java:268)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleModelEvent(BxActivityBaseBehavior.java:1126)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleModelEvent(BxActivityBaseBehavior.java:1)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:204)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleEvent(IpmEventDirectorBase.java:111)

at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.execute(WorkItemAbstract.java:177)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:170)

at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

 

I have removed and recreated the JDBC activity and the result is the same.

The underline DB is SQLServer 14