oracle send port problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › oracle send port problem

Viewing 1 reply thread
  • Author
    Posts
    • September 20, 2006 at 9:11 AM #15759
      community-content

        I’ve been thru a few biztalk 2006 tutorials and have had success.
        Now I’m trying to configure a oracle send port using the sample solution OneWaySend.

        Somehow I don’t have the send port OracleDBOneWaySP  or oracle configured right.
        When I do a file drop the receive port works ok but I get the errors …

        “The adapter failed to transmit message going to send port…” and “…error transmitting message…” and
        “…the method does not exist…”.

        My database name is COND and the ODBC SYSTEM DNS datasouce name is COND…
        so I have a target namespace of …

        http://schemas.microsoft.com/%5BOracleDb://COND/COND/Tables/sample_clients%5D

        I am able to connect to the oracle db via sqlplus and insert into table sample_clients.
        Also the ODBC “test connection” button says the connection is good.

        How can I check Biztalk??
        (I’m weak on biztalk,services and such… so speak simply)

        Thanks,
        Eleanor

      • September 20, 2006 at 9:10 PM #15772
        community-content

          Well, not really sure what your problem is.  But when I was working with the Oracle Adapter in the past it hard codes the DSN name and procedure names in the auto generated schema. 

           

          So, as a starter you might want to try to regenerate your schema if you think those setting might be wrong. 

           

          In the past, when I saw that type of error is was because the schema was wrong.

           

          Hope this helps.

          • September 26, 2006 at 11:11 AM #15851
            community-content

               I had a couple of problems….

              The error 'method does not exist' was caused by the fact I hadn't ….
              added generated item
              added adapter metadata
              oracle database … created for the the sendport that I had previously defined

              The namespace wasn't quite right, should have been …

              h ttp://schemas.microsoft.com/[MyOracleDbAdapter://MYDATABASE/MYBIZTALKSCHEMA/Tables/SAMPLE_XCHANGE]

              Last, I did validate the schema, generate instance and then validate instance.

               

              • November 22, 2006 at 11:44 AM #16499
                community-content

                  Was your problem resolved?

                  Your namespace should have been more like:

                  http ://schemas.microsoft.com/[MyOracleDbAdapter://<DataSourceName>/<OracleSchema>/Tables/SAMPLE_XCHANGE]

                  If you generate a new schema check that against the one you have now.  Once someone changes the Oracle database instance or user/schema it can have "negative" affects on your generated schemas.  I've had to make sure that each environment (Dev, Test, Prod) has the same Oracle schema configuration so I don't need to re-generate my schemas for each. (Which would be bad) 🙂  Synonyms might solve this but I haven't tested.

                  BizTron

                  • July 15, 2008 at 11:18 PM #20168
                    community-content

                      make sure that you have DSN data source in the windows ODBC connection manager

            • Author
              Posts
            Viewing 1 reply thread
            • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.