Forum Replies Created
-
Posts
-
VMWare does cost.
You should be able to run on Microsoft’s VPC. I have not had any problems.
If you go to a Launch Event you will get a VPC with BizTalk 2006 all preloaded with VS 2005 and SQL.
Hi,
if I write :
nStatus = System.Convert.ToInt32(xpath(Message_ResponseSelect.parameters, \”count(//Record)\”));
the expression editor doesn’t show an error, but when I deploy and test the solution, normally it should have nStatus = 1, because the Record already exists!!!
But with this test, I have mStatus = 0 😕
I don’t know why !! 🙁
Do you have a suggestion ??
Thank youA.C.
Ooooppppsss..
I mixed my problems … I have to connect with Unix Server as well as Mainframe..
Problem with both is that I have connect with those and pick and drop files ..
Hi,
somebody told me that I should do with xpath, so I’ve seen a sample of
Mr. Stephen W. Thomas, and it doesn’t seem to be very difficult!But I don’t know the syntax!!
So I would like to do that :
When I do a select on a table oracle, I receive a message like those two:
when the select returns something:
<?xml version=\”1.0\” encoding=\”utf-8\”?><patient_omnisResponse xmlns=\”http://testOracle.test/patient_omnis\”>
<Operation1>
<PATIENT_OMNIS>
<Select>
<Record>
<NOPATIENT>1</NOPATIENT>
<NODOSSIER>6</NODOSSIER>
<PATIENT_LNAME>D%u00e9l%u00e8zeeeeeeeee</PATIENT_LNAME>
<PATIENT_FNAME>Seb</PATIENT_FNAME>
<PATIENT_ROOM>135</PATIENT_ROOM>
<PATIENT_BED>2</PATIENT_BED>
</Record>
</Select>
</PATIENT_OMNIS>
</Operation1>
</patient_omnisResponse>– When the select doesn’t return anything:
<?xml version=\”1.0\” encoding=\”utf-8\”?><patient_omnisResponse xmlns=\”http://testOracle.test/patient_omnis\”>
<Operation1>
<PATIENT_OMNIS>
<Select />
</PATIENT_OMNIS>
</Operation1>
</patient_omnisResponse>So I would like to know if there is something in \”Select\”, but I don’t know how to do the test!
Here is my test:
nStatus = System.Convert.ToInt32(xpath(\”count(Message_ResponseSelect.parameters.Operation1.PATIENT_OMNIS.Select.Record.PATIENT_ROOM)\”));
System.Convert.ToString(nStatus);
But it doesn’t work!!
So I tried to write :
nStatus = System.Convert.ToInt32(xpath(Message_ResponseSelect,\”count(Operation1/PATIENT_OMNIS/Select/Record)\”));But the syntax is not correct 🙁
Could you help me please ???
In this test, I would like to test the patient_room, but I can test all the record !!!
I only want to do a test of existence!!
I’ve tested the patient room, because then I would use it to test in which of the 5 decision I go!!! THe decision depends on the number room for example!!!!
Thank you in advance
A.C.Thanks for replying, Steve. The stored proc is ok, I have checked that. If I remove @table variable or #temp_table and replace it with an actual work table, it works fine and I don’t receive the previous error. It makes me think that we can’t use @table variable or #temp_table in stored procs when using SQL Adaptor… is that so?
So,
the problem is not when I receive, but in my Expression form, when I do:
StatusRoom = Message_ResponseSelect.parameters.Operation1.PATIENT_OMNIS.Select.Record.PATIENT_ROOM;
StatusRoom is a variable that I’ve created!
the problem is that if the patient doesn’t exist, the ReceiveMessage is NULL!!!
So I don’t know how to do the test!! 😕
I would like to do a test like this:
\”if the receive message doesn’t exist, then StatusRoom = -1, else StatusRoom = Message_ResponseSelect.parameters.Operation1.PATIENT_OMNIS.Select.Record.PATIENT_ROOM; \”
Maybe should I do with XPath ??? Or with .Net Component ?? but how ?? 🙁
Help me please !! 🙁Thank you in advance
A.C.Hi,
the problem is when I receive, because I can send a request \”Select\”, for instance, I do a select * where IDPatient = IDPatientSource
Then, when I receive the message, if the patient exists, i do an update, and there are maybe 5 different updates, which depend on the value of the variable \”StatusPatient\”, contained in the response message. If the patient doesn’t exists, I simply do an insert !
I would like to do a .netComponent, but I’m not able to do it!
But I’m sure that it’s the best solution!So the big problem of my orchestration is that I don’t know how to do when my response message is null !!!
Thank you
A.C.Are you restarting the Biztalk host service after you redeploy?
If you don’t retart this service the results can be unpredictable
Greg
I have found an interesting solution to pulling specific files into an orchestration –
In my situation,
1) I receive a production order transmission that includes data that is used to derive a specific recipe file reference that contains information that I need to complete my transmission to the execution system.
2) In the orchestration, I pass the received production order to a map that has an external XSLT file (example bellow)
3) This map copies the received message along with a copy of the required file into the same intermediate output file – the schema for this file includes the schema from the first message with the additional structure of the included file(s)
4) The output of the map is the combined files which can be further processed as necessary.My example XSLT that combines the input message with a copy of a referenced file (3 times in this example)
I believe this approach can be extended to accommodate a wide variety of file combinations –
Note this does not use a receive port/pipeline to retrieve the added files, but the file can be the results of other orchestrations that preprocess the data if necessary.
If the file specified by the ‘document()’ reference does not exist, nothing is copied –
So it might be wise to check the output file for the existence of nodes from the referenced file for error management, etc.Example \”CombineFiles.xslt\”
<?xml version=\”1.0\”?>
<xsl:stylesheet version=\”1.0\” xmlns:xsl=\”http://www.w3.org/1999/XSL/Transform\” xmlns:xs=\”http://www.w3.org/2001/XMLSchema\” xmlns:fn=\”http://www.w3.org/2005/02/xpath-functions\” xmlns:xdt=\”http://www.w3.org/2005/02/xpath-datatypes\” xmlns:ns0=\”http://WTest2.SAPPhase2PlusTcMFile\”>
<xsl:output method=\”xml\” version=\”1.0\” encoding=\”UTF-8\” indent=\”yes\”/>
<xsl:template match=\”/\”>
<ns0:AllFiles><!– this first copy duplicates the first source file in the combined output file –>
<xsl:copy-of select=\”*\”/><!– here is a direct file included in the output –>
<xsl:copy-of select=\”document(‘C:\\00006856-3.xml’)\”/><!– or here, an element in the first – source file contains the file
reference to the second file to be included in the output –>
<xsl:copy-of select=\”document(//RecipeFileRef)\”/><!– OR here by using a variable that is derived from elements in the
first source file that derives the name of the file to be inlcuded, etc. –>
<xsl:variable name=\”RcpFile\” select=\”//RecipeFileRef\”/>
<xsl:copy-of select=\”document($RcpFile)\”/></ns0:AllFiles>
</xsl:template>
</xsl:stylesheet>Good Luck!
WadeWell, I’m a little confused if your problem happens before the send or after.
I’m guessing it’s after.
Does the message actually return or are you just not getting a response back?
You might have to change the call to make sure it always returns something or you could front the call with a .net component that does your null logic for you.
Just a thought.
1. I think it is just like the sql adapter – although the adapter probably turns the Xml input into something else. Did you check the sample included with the Oracle Adapter? I do not know if you can do a dynamic select though. The receive adapter wants something to be defined or to call a stored procedure.
2. No, I don’t think you need to use the pipeline concept.
3. I think you should just need add the aspnet to the BizTalk Application Users group. That user needs to have rights to write to the message box.
hi again.
i found the sample exposewebservice for orchestration process, it seems to be the one i’m looking for. actually the documentation for biztalk beta2 2006 has not been updated yet so it still refers to the 2004 version.i’ve a few questions to ask:
1. in the orchestration process when i need to retrieve date from oracle using oracle adapter, does it require that the query result must be in an xml format as it is for sql adapter? sorry i lack of documentation here….
2. it sounds like i don’t need to use a pipeline concept, does it correct?
3. when i run a sample with exposewebservice for orchestration, i assign IIS security as anonymous and i also need to assign aspnet user to sql server in order to make it work, what is the right approach in the real scenario?thanks in advance
I tried and got it successful on Vmware machine. VMware is something similar to Virtual PC. Let me know of any issues.
I followed like this…..Set up a VMware machine with base OS as win2003 server enterprise edition. Installed SqlServer 2005 July CTP.
Installed Windows sharepoint services with Sp2.
Installed Visual Studio 2005 Beta2.I did not face any problem while doing so in this sequence……
Let me know if you face any issues…Regards
Nagendra
