none
BizTalk Oracle Adapter Issue where Database Name changes in each Environment RRS feed

  • Question

  • We have using BizTalk 2006 and Oracle adapter.
    We are using the Oracle adapter to poll, execute stored procedures and read from tables/view etc.
    Everything works fine in Development.
    When we deployed to QA we are running into an issue where the database name of the database instance is different in QA.

    For example the database name is Dev in Development environment but it is QA in QA environment.When we deployed our code to QA we change the ODBC DSN to point to the QA database however this is not enough. The error we get is

    Error transmitting message: <SOAP-ENV:Fault xmlnsTongue TiedOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>SOAP-ENV:Client</faultcode><faultstring>Request ID: Unknown
    Exception Type: The method does not exist
    Exception Info:
        Exception occurred:
            Invalid target: XXX_ACTOR_TEMP@OracleDb://CADB/QA/Procedures/XXX_TEMP_TABLE_PK</faultstring></SOAP-ENV:Fault>


    The reason for this is because when we generated the schemas we were pointed to Dev database so the namespace had this annotation

    OracleDb://DSN_NAME/DB_NAME/Procedures/PROC_NAME

    What can I do if DB_NAME changes between the environment? The only option I see is compile the application with different schema for each environment. This is painful.

    Is there any workaround for this issue?



    Wednesday, June 4, 2008 6:09 PM

All replies