sending data to MQ

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
new_ds_man
Participant
Posts: 18
Joined: Tue Jul 08, 2008 1:12 pm

sending data to MQ

Post by new_ds_man »

Hi all,

I have been encountering the below issue while trying to send an XML file to MQ.

XML file:

<?xmlversion="1.0"?><Request><REQUEST_REFID>440</REQUEST_REFID><REQUEST_TIMESTAMP>20090708013036</REQUEST_TIMESTAMP><FORCE_ENG_FLAG>Y</FORCE_ENG_FLAG><ISSUE_TO_ISSUE_FLAG>Y</ISSUE_TO_ISSUE_FLAG><PROJECT_ACRONYM>MCA</PROJECT_ACRONYM><MARKET_MODEL><VEHICLE_LINE>CAU</VEHICLE_LINE><MODEL_YEAR>2006</MODEL_YEAR><MARKET_CODE>WANAB</MARKET_CODE><TIMING_POINT_START_CODE>S4P6AH</TIMING_POINT_START_CODE></MARKET_MODEL><EFFECTIVE_DATES><MAIN_DATE>20090601</MAIN_DATE><BACKWARD_DATE>20090501</BACKWARD_DATE><FORWARD_DATE>20090701</FORWARD_DATE></EFFECTIVE_DATES><NORMAL_PROCESSING><NO_OPTION_FAMILIES>AAG</NO_OPTION_FAMILIES></NORMAL_PROCESSING><ADHOC_PROCESSING><ADHOC_REQUESTADHOC_REFID="1185"><BASE_MODEL_FEATURES>AAA88AAE88CA#88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1186"><BASE_MODEL_FEATURES>AAA88AAE88CA#88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1187"><BASE_MODEL_FEATURES>AAA88CA#88DR-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1188"><BASE_MODEL_FEATURES>AAA88CA#88DR-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1189"><BASE_MODEL_FEATURES>AAA88CA#88EN-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1190"><BASE_MODEL_FEATURES>AAA88CA#88EN-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1191"><BASE_MODEL_FEATURES>AAA88CA#88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1192"><BASE_MODEL_FEATURES>AAA88CA#88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1193"><BASE_MODEL_FEATURES>AAA88CA#88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1194"><BASE_MODEL_FEATURES>AAA88CA#88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1195"><BASE_MODEL_FEATURES>AAA88CA+88SE+88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1196"><BASE_MODEL_FEATURES>AAA88CA+88SE+88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1197"><BASE_MODEL_FEATURES>AAA88DR-88EN-88TR-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1198"><BASE_MODEL_FEATURES>AAA88DR-88EN-88TR-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1199"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1200"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1201"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88YZS88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1202"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88YZS88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1203"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1204"><BASE_MODEL_FEATURES>AAA88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1205"><BASE_MODEL_FEATURES>AAA88DR-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1206"><BASE_MODEL_FEATURES>AAA88DR-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1207"><BASE_MODEL_FEATURES>AAA88DR-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1208"><BASE_MODEL_FEATURES>AAA88DR-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1209"><BASE_MODEL_FEATURES>ADS88BS-88VS-88YZA88YZS88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1210"><BASE_MODEL_FEATURES>ADS88BS-88VS-88YZA88YZS88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1211"><BASE_MODEL_FEATURES>ADS88BS-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1212"><BASE_MODEL_FEATURES>ADS88BS-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1213"><BASE_MODEL_FEATURES>BS-88DR-88VS-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1214"><BASE_MODEL_FEATURES>BS-88DR-88VS-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1215"><BASE_MODEL_FEATURES>BS-88EN-88VS-88YZA88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1216"><BASE_MODEL_FEATURES>BS-88EN-88VS-88YZA88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1217"><BASE_MODEL_FEATURES>BS-88EN-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1218"><BASE_MODEL_FEATURES>BS-88EN-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1219"><BASE_MODEL_FEATURES>BS-88VS-88YZA88YZS88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1220"><BASE_MODEL_FEATURES>BS-88VS-88YZA88YZS88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1221"><BASE_MODEL_FEATURES>BS-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1222"><BASE_MODEL_FEATURES>BS-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1223"><BASE_MODEL_FEATURES>CA#88DR-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1224"><BASE_MODEL_FEATURES>CA#88DR-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1225"><BASE_MODEL_FEATURES>EN-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1226"><BASE_MODEL_FEATURES>EN-88VS-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST></ADHOC_PROCESSING></Request>


while sending the above to the Q, job is running fine ....but it is throwing a warning saying that the above file is truncated to :

<?xmlversion="1.0"?><Request><REQUEST_REFID>440</REQUEST_REFID><REQUEST_TIMESTAMP>20090708013036</REQUEST_TIMESTAMP><FORCE_ENG_FLAG>Y</FORCE_ENG_FLAG><ISSUE_TO_ISSUE_FLAG>Y</ISSUE_TO_ISSUE_FLAG><PROJECT_ACRONYM>MCA</PROJECT_ACRONYM><MARKET_MODEL><VEHICLE_LINE>CAU</VEHICLE_LINE><MODEL_YEAR>2006</MODEL_YEAR><MARKET_CODE>WANAB</MARKET_CODE><TIMING_POINT_START_CODE>S4P6AH</TIMING_POINT_START_CODE></MARKET_MODEL><EFFECTIVE_DATES><MAIN_DATE>20090601</MAIN_DATE><BACKWARD_DATE>20090501</BACKWARD_DATE><FORWARD_DATE>20090701</FORWARD_DATE></EFFECTIVE_DATES><NORMAL_PROCESSING><NO_OPTION_FAMILIES>AAG</NO_OPTION_FAMILIES></NORMAL_PROCESSING><ADHOC_PROCESSING><ADHOC_REQUESTADHOC_REFID="1185"><BASE_MODEL_FEATURES>AAA88AAE88CA#88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><ADDITIONAL_FEATURES>A9C03BS-AEVS-E1YZA88</ADDITIONAL_FEATURES></ADHOC_REQUEST><ADHOC_REQUESTADHOC_REFID="1186"><BASE_MODEL_FEATURES>AAA88AAE88CA#88DR-88EN-88YZA88YZT88</BASE_MODEL_FEATURES><OPTION_FEATURES>000NPA2WAC</OPTION_FEATURES>


Any ideas on why Datastage is truncating the XML.....there are no carriage returns (new lines) in the file. It is in one single line and my MQ stage has been set to "ONE ROW PER MESSAGE".
Is there a setting in MQ stage that i need to change...?

Thanks in advance.
Top
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:
Contact JRodriguez

Post by JRodriguez »

Take a look at the length in theMQ input column definition ... if the data type is char and the length of your input XML content is greater then it will be truncate it
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Top
new_ds_man
Participant
Posts: 18
Joined: Tue Jul 08, 2008 1:12 pm

Post by new_ds_man »

Thanks JRodriguez,
I resolved the issue......I made the display size the same as column size, which had less number of bytes prior.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”