| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CTDP3042E message when using a comma escape scheme |
« View previous topic :: View next topic » |
| Author |
Message
|
| petervh1 |
 Posted: Wed Apr 05, 2023 1:40 am Post subject: CTDP3042E message when using a comma escape scheme |
 |
|
Centurion
Joined: 19 Apr 2010
Posts: 135
|
Hi
Env = 12.0.7
I am trying to map the following data:
| Quote: |
issue_id,sla_id,sla_name,cycle_type,start_time,stop_time,paused,goal_duration,elapsed_time,remaining_time
1534606,5,Time to resolution,Ongoing,2023-03-07T06:58:25Z,,false,,1234,abc"",""def |
I have set up my DFDL xsd as follows:
| Code: |
<?xml version="1.0" encoding="UTF-8"?><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:csv="http://www.ibm.com/dfdl/CommaSeparatedFormat" xmlns:dfdl="http://www.ogf.org/dfdl/dfdl-1.0/" xmlns:fn="http://www.w3.org/2005/xpath-functions" xmlns:ibmDfdlExtn="http://www.ibm.com/dfdl/extensions" xmlns:ibmSchExtn="http://www.ibm.com/schema/extensions">
<xsd:import namespace="http://www.ibm.com/dfdl/CommaSeparatedFormat" schemaLocation="IBMdefined/CommaSeparatedFormat.xsd"/>
<xsd:annotation>
<xsd:appinfo source="http://www.ogf.org/dfdl/">
<dfdl:format documentFinalTerminatorCanBeMissing="yes" encoding="{$dfdl:encoding}" escapeSchemeRef="CommaEscape" ref="csv:CommaSeparatedFormat" separator=","/>
<dfdl:defineEscapeScheme name="CommaEscape">
<dfdl:escapeScheme escapeBlockEnd='""' escapeBlockStart='""' escapeCharacter="" escapeEscapeCharacter="" escapeKind="escapeBlock" extraEscapedCharacters="" generateEscapeBlock="always"/>
</dfdl:defineEscapeScheme>
</xsd:appinfo>
</xsd:annotation>
<xsd:element ibmSchExtn:docRoot="true" name="SLA_cycles_job_i">
<xsd:complexType>
<xsd:sequence dfdl:separator="">
<xsd:element dfdl:terminator="%CR;%LF;%WSP*;" name="header">
<xsd:complexType>
<xsd:sequence>
<xsd:element default="issue_id" ibmDfdlExtn:sampleValue="" name="issue_id" type="xsd:string"/>
<xsd:element default="sla_id" ibmDfdlExtn:sampleValue="" name="sla_id" type="xsd:string"/>
<xsd:element default="sla_name" ibmDfdlExtn:sampleValue="" name="sla_name" type="xsd:string"/>
<xsd:element default="cycle_type" ibmDfdlExtn:sampleValue="" name="cycle_type" type="xsd:string"/>
<xsd:element default="start_time" ibmDfdlExtn:sampleValue="" name="start_time" type="xsd:string"/>
<xsd:element default="stop_time" ibmDfdlExtn:sampleValue="" name="stop_time" type="xsd:string"/>
<xsd:element default="paused" ibmDfdlExtn:sampleValue="" name="paused" type="xsd:string"/>
<xsd:element default="goal_duration" ibmDfdlExtn:sampleValue="" name="goal_duration" type="xsd:string"/>
<xsd:element default="elapsed_time" ibmDfdlExtn:sampleValue="" name="elapsed_time" type="xsd:string"/>
<xsd:element default="remaining_time" ibmDfdlExtn:sampleValue="" name="remaining_time" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element dfdl:escapeSchemeRef="CommaEscape" dfdl:occursCountKind="implicit" dfdl:terminator="%CR;%LF;%WSP*;" maxOccurs="unbounded" name="record">
<xsd:complexType>
<xsd:sequence dfdl:separator="," dfdl:separatorPosition="postfix">
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="issue_id" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="sla_id" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="sla_name" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="cycle_type" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="start_time" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="stop_time" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="paused" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="goal_duration" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="remaining_time" nillable="true" type="xsd:string"/>
<xsd:element dfdl:fillByte="" dfdl:nilKind="literalValue" dfdl:nilValue="%SP;" dfdl:useNilForDefault="yes" name="elapsed_time" nillable="true" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema> |
The DFDL trace shows:
| Quote: |
05 Apr 2023, 11:27:52 info: Offset: 178. Found delimited value 'abc""' for element 'elapsed_time'. The delimiter was ','.
[dfdl = /JIRA_Export/SLA_cycles_job_i.xsd, scd = #xscd(/schemaElement::SLA_cycles_job_i/type::0/model::sequence/schemaElement::record/type::0/model::sequence/schemaElement::elapsed_time), 102]
05 Apr 2023, 11:27:52 info: Offset: 183. Finished processing element 'elapsed_time'.
[dfdl = /JIRA_Export/SLA_cycles_job_i.xsd, scd = #xscd(/schemaElement::SLA_cycles_job_i/type::0/model::sequence/schemaElement::record/type::0/model::sequence/schemaElement::elapsed_time), 64]
05 Apr 2023, 11:27:52 info: Offset: 183. Found separator ',' owned by the 'sequence' group contained within element 'record'.
[dfdl = /JIRA_Export/SLA_cycles_job_i.xsd, scd = #xscd(/schemaElement::SLA_cycles_job_i/type::0/model::sequence/schemaElement::record/type::0/model::sequence), 105]
05 Apr 2023, 11:27:52 info: Offset: 184. Did not find terminator for 'record'. Expected terminator list is '%CR;%LF;%WSP*;'.
[dfdl = /JIRA_Export/SLA_cycles_job_i.xsd, scd = #xscd(/schemaElement::SLA_cycles_job_i/type::0/model::sequence/schemaElement::record), 105]
05 Apr 2023, 11:27:52 error: CTDP3042E: Terminator '%CR;%LF;%WSP*;' not found at offset '184' for element '/SLA_cycles_job_i[1]/record[1]'.
|
I'm not sure what I'm doing wrong in the coding of the escape scheme parameters.
TIA |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
