Forum Replies Created
-
AuthorPosts
-
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.
August 24, 2010 at 12:19 PM in reply to: URL:"http://localhost/BTARNAppCertSend/RNIFSend.aspx?TPUrl=httpsThe remote server returned an error: (500) Internal Server Error. #25731This 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
Hello Ram.
Sounds great – good to know another workaround for this! Thanks for sharing it.
Wolfgang
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.
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
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
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
August 24, 2010 at 5:35 AM in reply to: "unconstructed message" issue when assigning current variables on Orchestration to database #25724Hi.
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
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
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 betaAugust 23, 2010 at 6:31 PM in reply to: "unconstructed message" issue when assigning current variables on Orchestration to database #25720The 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.
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).
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.
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
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 -
AuthorPosts