Page 1 of 1

sending data to MQ

Posted: Thu Jul 09, 2009 8:26 am
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.

Posted: Thu Jul 09, 2009 9:12 am
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

Posted: Fri Jul 10, 2009 2:00 pm
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.