Forum Replies Created
-
AuthorPosts
-
June 1, 2010 at 7:54 AM in reply to: why can’t I enable a location on request-response receive port? #24854
Greg,
I think I found the problem although I have not had chance to look for solution yet.
When I send Select Query request to database, the send shape requires an initial message. I don’t have one. I used NULL in the expression in Message Assignment shape to initialize the message.
I’m currently working on another project and may not be able to work on this BizTalk for a while. I’ll appreciate it if you have some advice on how to initialize the send message.
Thanks.
Lynn
Any specific reason why you had to set Event Max Row Count: 5?
Hi Greg,
I have sent you the mail.
After receiving please revert
Thanks
Ramjeet
Can you email me your map to greg.forsythe [at] gmail.com
Hi Greg,
thanks for your reaction. I construct the message because of the compile time error, that this message is not constructed. What do you mean with [quote user="greg.forsythe"]
… it could be that there is a code path that uses the SAP response message, that can be performed without calling the send port to SAP
[/quote]
How can I avoid the error, that “Message has not been initialized in construct statement”?
Here a overview about my message flow throug the orchestration
Shape Message Port Receive SiebelRequest unidirektional receive Transform SiebelRequest->SAPRequest none Send SAPRequest Send-Receive-Port (Request) Receive SAPResponse Send-Receive-Port (Response) Transform SAPResponse->SiebelResponse none Send SiebelResponse unidirektional send Thanks.
Ulf
Hi ,
Please find the Output as:
<TestCRMServiceResponse xmlns=”http://tempuri.org/”><TestCRMServiceResult><smart xmlns=””><Data><header></header><body><UserProfileDto><MSISDN>919127010047</MSISDN><Balance>-7640</Balance><IMSI>405881000000051</IMSI><SIMStatus>A</SIMStatus></UserProfileDto></body></Data></smart></TestCRMServiceResult></TestCRMServiceResponse>
And the Input xml as :
<TestCRMServiceResponse xmlns=”http://tempuri.org/”><TestCRMServiceResult><smart xmlns=””><Data><header><ACTION_ID>QueryProfile</ACTION_ID><REQUEST_ID>0012008111700001</REQUEST_ID><returnMsg>Successful</returnMsg><returnCode>0</returnCode></header><body><UserProfileDto><ActiveStopDate>2010-08-03</ActiveStopDate><L_PostOffice></L_PostOffice><BrandName>AS SUK Pricing Class</BrandName><MSISDN>919127010047</MSISDN><FirstCallDate>2010-04-15 16:45:10</FirstCallDate><BalDtoList><BalDto><Balance>-7640</Balance><UpdateDate>2010-05-05 12:22:19</UpdateDate><AcctResName>Basic Balance</AcctResName><ExpDate>2010-08-03 00:00:00</ExpDate><EffDate>2010-03-25 00:00:00</EffDate><AcctResCode>0</AcctResCode><BallID>1134791</BallID></BalDto></BalDtoList><RefillBlockReason>0</RefillBlockReason><DefLang>1</DefLang><L_Pincode></L_Pincode><Genter></Genter><DisableStopDate>2010-11-01</DisableStopDate><L_State></L_State><CustomerName>919127010047</CustomerName><Salutation></Salutation><LastRecharge>0</LastRecharge><IMSI>405881000000051</IMSI><PricePlanCode>400003</PricePlanCode><SIMStatus>A</SIMStatus><SIMSubStatus></SIMSubStatus><L_LocalAddress></L_LocalAddress><LastRechargeDate>2010/05/05 12:22:19</LastRechargeDate><L_City_Town_Village></L_City_Town_Village><DOB></DOB><L_District></L_District><PricePlanDtoList><PricePlanDto><ExpDate>2010-08-02 12:22:19</ExpDate><CreatedDate>2010/05/05 12:22:19</CreatedDate><EffDate>2010-05-05 12:22:19</EffDate><PricePlanName>AS Per Sec Plan</PricePlanName><PricePlanIndex>4001</PricePlanIndex></PricePlanDto></PricePlanDtoList></UserProfileDto></body></Data></smart></TestCRMServiceResult></TestCRMServiceResponse>
Hi,
I am using the BizTalk default mapper in the Transform shape for this.
Thanks
Ramjeet
Any chance of posting these xml samples again, try opening the file in notepad so you are cutting and pasting text only. Looks like some problem pasting the Xml.
Hi,
My output schema is as below:
0) fix(e,”cb”);}
if (e.className==”di”){if (e.children(0).innerText.indexOf(“\n”)>0) fix(e,”db”);}
e.id=””;
}
function fix(e,cl){
e.className=cl;
e.style.display=”block”;
j=e.parentElement.children(0);
j.className=”c”;
k=j.children(0);
k.style.visibility=”visible”;
k.href=”#”;
}
function ch(e){
mark=e.children(0).children(0);
if (mark.innerText==”+”){
mark.innerText=”-“;
for (var i=1;i<e.children.length;i++)
e.children(i).style.display="block";
}
else if (mark.innerText=="-"){
mark.innerText="+";
for (var i=1;i</TestCRMServiceResponse>and Input is this one :
0) fix(e,”cb”);}
if (e.className==”di”){if (e.children(0).innerText.indexOf(“\n”)>0) fix(e,”db”);}
e.id=””;
}
function fix(e,cl){
e.className=cl;
e.style.display=”block”;
j=e.parentElement.children(0);
j.className=”c”;
k=j.children(0);
k.style.visibility=”visible”;
k.href=”#”;
}
function ch(e){
mark=e.children(0).children(0);
if (mark.innerText==”+”){
mark.innerText=”-“;
for (var i=1;i<e.children.length;i++)
e.children(i).style.display="block";
}
else if (mark.innerText=="-"){
mark.innerText="+";
for (var i=1;i<ACTION_ID>QueryProfile</ACTION_ID><REQUEST_ID>0012008111700001</REQUEST_ID><returnMsg>Successful</returnMsg><returnCode>0</returnCode></header><ActiveStopDate>2010-08-03</ActiveStopDate><L_PostOffice /><BrandName>AS SUK Pricing Class</BrandName><MSISDN>919127010047</MSISDN><FirstCallDate>2010-04-15 16:45:10</FirstCallDate><Balance>-7640</Balance><UpdateDate>2010-05-05 12:22:19</UpdateDate><AcctResName>Basic Balance</AcctResName><ExpDate>2010-08-03 00:00:00</ExpDate><EffDate>2010-03-25 00:00:00</EffDate><AcctResCode>0</AcctResCode><BallID>1134791</BallID></BalDto></BalDtoList><RefillBlockReason>0</RefillBlockReason><DefLang>1</DefLang><L_Pincode /><Genter /><DisableStopDate>2010-11-01</DisableStopDate><L_State /><CustomerName>919127010047</CustomerName><Salutation /><LastRecharge>0</LastRecharge><IMSI>405881000000051</IMSI><PricePlanCode>400003</PricePlanCode><SIMStatus>A</SIMStatus><SIMSubStatus /><L_LocalAddress /><LastRechargeDate>2010/05/05 12:22:19</LastRechargeDate><L_City_Town_Village /><DOB /><L_District /><ExpDate>2010-08-02 12:22:19</ExpDate><CreatedDate>2010/05/05 12:22:19</CreatedDate><EffDate>2010-05-05 12:22:19</EffDate><PricePlanName>AS Per Sec Plan</PricePlanName><PricePlanIndex>4001</PricePlanIndex></PricePlanDto></PricePlanDtoList></UserProfileDto></body></Data></zsmart></TestCRMServiceResult></TestCRMServiceResponse>You should receive the SAP response message from your request response port to SAP. You should not construct this message in the orchestration.
If you are gettin a compile time error that the message is not constructed it could be that there is a code path that uses the SAP response message, that can be performed without calling the send port to SAP
May 31, 2010 at 5:56 AM in reply to: why can’t I enable a location on request-response receive port? #24843Do you get an error?
Can you enable the receive location, which then fails.
Or are you unable to enbale the receive location all.If the map tests OK, then it shoud be correct. One possibility is the message being mapped does not match its schema.
Can you save the actual message to a file and test the map using this file?
Are you using orchestrations or a messaging only solution?
Hi Greg,
After getting to the second Hyperlink its giving me the <extensionobjects/> only….
I have tested the map and the returned xml is fine as per my requirement then i am not sure what is happening as the final xml that is being dropped to my FILE location is empty when i process through the map.
what i am doing wrong.
Please suggest as error to opening the XML at the file location is “XML document must have top level element”.
Thanks
Ramjeet
A delimiter marks the boundary between records or fields.
For example
In a text file each line can be delimited by the carriage return, line feed.
line1 CRLF
line2 CRLFYou cannot see the CRLF characters in a text editor, but if you open the file in binary mode you will see 0x0D and 0x0A characters at the end of each line.
In a csv file, each field is delimited by a comma.
field1, field2, field3.The delimiter tells the parser when to stop reading one record or field and when to start the next one.
When validating a map using the BizTalk Mapper the only output is an Xsl file (the compiled map) and an extensionobjects xml file.
The extensionobjects xml file contains references to external .Net assemblies that are called from within the map. If you’re are not using any scripting functoids that reference external assemblies this file is empty.
In the output window of Visual Studio there should be 2 hyperlinks – the first for the Xsl file and second for the extnsionobjects file.
-
AuthorPosts