community-content

Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 9,648 total)
  • Author
    Posts
  • in reply to: Picking flat files from Unix Server #12441

    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 ..

    in reply to: Test of existence on a Table \"Oracle\" #12428

    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.

    in reply to: Installation BTS2006 Beta 2 on Virtual PC 2004 #14218

    so you install all this think on the same vmware?
    did the vmware is free?
    Denis

    in reply to: SQL Adaptor question #12417

    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?

    in reply to: Test of existence on a Table \"Oracle\" #12427

    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.

    in reply to: Installation BTS2006 Beta 2 on Virtual PC 2004 #14217

    Nagendra
    thx for the tips. I will try this week and I will let you know

    DN

    in reply to: Test of existence on a Table \"Oracle\" #12426

    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.

    in reply to: Mapping Problem #12396

    Are you restarting the Biztalk host service after you redeploy?

    If you don’t retart this service the results can be unpredictable

    Greg

    in reply to: Pulling specific files through a receive port? #12400

    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!
    Wade

    in reply to: Test of existence on a Table \"Oracle\" #12435

    Well, 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.

    in reply to: Can BizTalk perform a synchronized request? #14248

    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.

    in reply to: Can BizTalk perform a synchronized request? #14245

    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

    in reply to: Installation BTS2006 Beta 2 on Virtual PC 2004 #14216

    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

    in reply to: HAT is not worlking on my virtual server #12339

    I had this problem and installed owc10.exe which I got from the microsoft site. The dll you want is not included in Server 2003 so yoou have to get it from elsewhere ie microsoft. Installing the exe didnt cause me any problems but I would make a copy of the vm before you start just in case

    in reply to: Installation BTS2006 Beta 2 on Virtual PC 2004 #14215

    Hello All

    I would like to install BT2006 Beta2 on VPC2004 with W2003 server
    Could I install it on the same machine ?

    Do you know where I can find step by step Installation guide because the MS installation guide is not very clear.
    Thx for Help

Viewing 15 posts - 9,331 through 9,345 (of 9,648 total)