community-content

Forum Replies Created

Viewing 15 posts - 571 through 585 (of 9,648 total)
  • Author
    Posts
  • in reply to: Biztalk 2010 Questions #25733

    Hi,

    From here: https://www.microsoft.com/biztalk/en/us/system-requirements.aspx#Software_Prereq

    SQL Server 2005 SP2 or 2008 Microsoft SQL Server is a relational database server capable of efficiently processing high volumes of data. For optimal performance, we recommend that you use Enterprise Edition of SQL Server 2008. Note:In order to fully use the BizTalk Server 2009 SDK, or deploy BizTalk Server applications from a Visual Studio development environment, you must also install the SQL Server Development Tools. Note:Using SQL Server Express Edition in a production environment is not recommended. The Express edition does not include certain features needed by BizTalk Server.

    This issue is got to do with certificates configurations both from the sender and receiver sites…ensure you follow a step-by-step process to ensure that all certificates are installed correctly on your server personal and other people stores and same at the receiving server.

     

    Wilfred

    in reply to: UTF Encoding #25729

    Hello Ram.

    Sounds great – good to know another workaround for this! Thanks for sharing it.

    Wolfgang 

    in reply to: UTF Encoding #25728

    Hi Wolggang,

    Thanks a lot for the reply. I am using VS 2005 and here I couldn’t find the field called “Code Page” in the property of the <schema>.

    But i still managed to solve the problem, I was using a receive pipeline to remove the namespace. There I add the below  line.

     

    Now its working for me.

    byte[] outBytes = System.Text.Encoding.Unicode.GetBytes(outputMessageText.ToString());

    Thanks a lot.

    in reply to: UTF Encoding #25727

    Hi Ram.

    Ok I see it could be a little bit different because I run VS 2008.

    I open the schema in VS.

    On the left side I see my schema structure with all the nodes in this schema.

    The first node is called <Schema>.

    I select this node and than I go to the properties of this node.

    In the properties area there is a field called “Code Page”.

    There I can change the Format of my schema, e.g. like UTF-8

    Perhaps you can right mouse click on the <Schema>-node and choose properties to get the properties you need.

    Is this working for you?

    Wolfgang

    in reply to: UTF Encoding #25726

    Hi Wolfgang,

    I didn’t find the property. Can you please let me know the exact property name and what has to be changed?

    Thanks for the early response.

    Regards,

    Ram

    in reply to: Filename with Incrementing Counter #25725

    Excellent, thanks for the responses.

    Sorry forgot to mention I’m restricted to 10 characters including the prefix. The stored procedure route best fits the requirements.

    Would you normally make the call to the stored procedure through the SQL adapter? Or do you use alternate methods?

    Cheers

    Hi.

     

    Go to the construct message shape an check in the properties the field “Messages Constructed”, that there is the right message selected you want to use in the construct message shape.

    cheers

    Wolfgang

    in reply to: UTF Encoding #25723

    Hello Ram.

    You can change the UTF code in the schema properties down by the area called “flat file”. Open your schema in VS and got to the first node called “<schema>”. Then go to the properties and change the code page. I haven’t tried it before, but this is the only way I could find.

    I hope this helps.

    Wolfgang

    in reply to: Custom Extension XML #25722

    Took me  a while to rebuild my 2010 environment with the latest BizTalk 2010 beta.
    You are right, I get the same behaviour in this environment, definitely looks like a bug with the beta. this is a bug in the beta

    The compiler has detected that you are trying to use a message that may not have been constructed. A message is constructed in a Construct message shape or a receive shape. One possibility is you have followed a logic path that does may not construct the message.

    in reply to: Looping Files #25718

    Hi,

    What you need – it is to build an Aggregator. I think there’s a sample in BizTalk SDK/Samples – how to build one. You can also receive files unordered and to set order after you receive all your files. (Meanwhile save them in SQL, as binary blobs, wtih identificators of some kind – guid for example). When all files received (how do you know that all of them arrived? By names? By amount? By time?) – get them already ordered with stored procedure. In this way you dont have to keep an instance of orchestration in the air (though it will be dehydrated).

    in reply to: Filename with Incrementing Counter #25717

    Hi,

    In one of my projects we implement such pattern: we need a unique number, which is build of three groups. AA BBB CCCCCCC,

    Where AA is some process type, BBB subprocess type, CCCCCCC – is autoincremental number.

    When I need this number – I pass as parameters AA and BBB, and in stored procedure call to another stored procedure which inserts dummy value to table for autoincrement. (Also you can delete that row after getting number). The autoincremented number is 7 digits.

    When I get that number, I convert is to string, and both received parameters are concatenated (not to get added mathimatically, i.e. 123 45 I want as 12345 and not 168) as strings too. The resullt I convert back to BIGINT (long in .Net, Int64 in BizTalk).

    By this practice I get uniquie numbers, easily and managed. When you create your file – just let this number to be name of your file. If you need to give string name – instead of numeric parameters – add strings.

    in reply to: Filename with Incrementing Counter #25716

    Hi.

    I use a GUID in an orchestration to write the file into a separat folder. And the same GUID into a Database so I find the right dataset to the file I read in.

    And I can write each file in the same folder. If you don’t need to use a counter starting by 1 and so on … these are two lines of code in the orchestration.

    In the expression shape use: RSP_GUID = System.GUID.NewGUID();

    In the Message Assignment Shape use: message(FILE.ReceivedFileName) = “RSP” + “RSP_GUID” + “.xml”;

    I hope this helps.

    cheers

    Wolfgang 

    in reply to: Filename with Incrementing Counter #25715

    If you want your application to scale, then SQL Server is the best place to do this. Using multi-threaded host instances on multiple machines will require some mechanism for locking your iterator. I have in the past, used a table with a single column and single row  and a stored proc like this:

    DECLARE

     

    @increment INT
    — need an explicit transaction to make the select and update serializable
    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
    BEGIN
    TRANSACTION
    — ensure that any constraint violations or other errors cause a rollback
    SET XACT_ABORT ON
    — maintain an exclusive lock on the data until the end of the transaction
    SELECT @increment = MAX(Increment) FROM Iterator WITH (TABLOCKX)
    UPDATE SaleId SET Increment = @increment + 1
    SET XACT_ABORT OFF
    COMMIT
    TRANSACTION

     

Viewing 15 posts - 571 through 585 (of 9,648 total)