Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

Re: Functoids

BizTalk 2006

This group is for all content related to BizTalk Server 2006. This includes a forum, samples, videos, labs, and tools. Most of the content here also applies to other versions of BizTalk beyond 2006.

Functoids

  • rated by 0 users
  • This post has 9 Replies |
  • 1 Follower
  • hi,

    After configuring the Database functoid,do I need to build the project or validate map.While building the project i get

    But i am getting the Error:the 3rd and 4th parameter in database functoid ,which represent the table name and column name must be a constant parameters.

    please help

    Guhan

    Edit
  • I dont think so you need to build the project or Validate the Map.

    I normally used to directly test the Map...

    3rd and 4th parameter shd be constant  for sure.

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

  • While Testing the map i get the error "Root element is missing"  in SchemaMap_output.xml.

     please help

    Edit
  • You can refer this article of mine.

    http://biztalkblogs.com/nishil/archive/2006/12/21/1543.aspx

    Can you just let us know as wht were you trying to do.....

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

  • Hi,

    I am working on this task

    1. Creating a mapping – XML to XML

     

    ·         Use the following  sample schemas  :

     

    a.      SalesSchema.xsd as the source

    b.      POSSchema.xsd as the destination

     

    Note:

    If you don’t have pubs database create the following the database called pubs.

    Create a table called “Titles”

    Create following fields:

     

    Field Name

    Type

    Title_Id

    Integer

    Title

    Varchar(50)

    Price

    Varchar(50)

     

    ·         Mapping details are as follows:

     

    • Link bookID field to pubID Field
    • Link qty field to transQty Field
    • Link salesDate field to transDate field
    • Link price field to transprice field
    • Add a Database lookup functoid and set up its parameters as follows:
      • Lookup Value – Link bookID to Functoid
      • Connection String : Data Source=<Your machine Name>;Provider=SQLOLEDB;Initial Catalog=pubs;UID=sa;pwd=<sa password>;
      • Table Name: dbo.titles
      • Lookup Column name : title_id
    • Add 2 Value Extractor Functoids :

    §         Connection to DB Lookup  - Connect input of this functoid to DB Lookup functoid’s output

    §         Column Name : Price and Title

    • Link the two functoids to listPrice field and Title field in the destination message
    • Add a Multiplication functoid:

    §         Qty and price are input parameters

    §         Link its output to transtotal

     

    i get the error while testing the map

    Function 'ScriptNS0:DBValueExtract()' has failed. Value was either too large or too small for an Int32.

     please help

     

    Function 'ScriptNS0:DBValueExtract()' has failed. Value was either too large or too small for an Int32.

     please help

     

    Edit
  • Hi,

    I am working on this task

    1. Creating a mapping – XML to XML

     

    ·         Use the following  sample schemas  :

     

    a.      SalesSchema.xsd as the source

    b.      POSSchema.xsd as the destination

     

    Note:

    If you don’t have pubs database create the following the database called pubs.

    Create a table called “Titles”

    Create following fields:

     

    Field Name

    Type

    Title_Id

    Integer

    Title

    Varchar(50)

    Price

    Varchar(50)

     

    ·         Mapping details are as follows:

     

    • Link bookID field to pubID Field
    • Link qty field to transQty Field
    • Link salesDate field to transDate field
    • Link price field to transprice field
    • Add a Database lookup functoid and set up its parameters as follows:
      • Lookup Value – Link bookID to Functoid
      • Connection String : Data Source=<Your machine Name>;Provider=SQLOLEDB;Initial Catalog=pubs;UID=sa;pwd=<sa password>;
      • Table Name: dbo.titles
      • Lookup Column name : title_id
    • Add 2 Value Extractor Functoids :

    §         Connection to DB Lookup  - Connect input of this functoid to DB Lookup functoid’s output

    §         Column Name : Price and Title

    • Link the two functoids to listPrice field and Title field in the destination message
    • Add a Multiplication functoid:

    §         Qty and price are input parameters

    §         Link its output to transtotal

     

    i get the error while testing the map

    Function 'ScriptNS0:DBValueExtract()' has failed. Value was either too large or too small for an Int32.

     please help

     

    Function 'ScriptNS0:DBValueExtract()' has failed. Value was either too large or too small for an Int32.

     please help

     

    Edit
  • Need ur mail id

     

    Edit
  • nishil@redifffmail.com

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

  • Function 'ScriptNS0:DBValueExtract()' has failed. Value was either too large or too small for an Int32. Please let me know the workaround for this issue, as I am getting the same error

    Edit
  • Do you know the "value" which it is failing on?

    Is it a genuine Airthmetic overflow error or the lookup is returning a  non Integer value.

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

Page 1 of 1 (10 items)