Forum Replies Created
-
Posts
-
Figured it out!!
It was a problem with the PATH environment variable, we restored it back to what it was before the Sybase installation, but didn't reboot the server. Rebooting the server solved the problem. Here is the part of PATH env. variable that was responsible for this:
;%SystemRoot%\System32\Wbem;
Regards,
Sajid.
Rseroter,
I tried writing to the event log immediately and I can capture the field on a successful lookup only. On a failed lookup it's blank. Here's the stored procedure:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[TranslateLegacyCustomerNumber]
(
@LegacyCustomerNumber nvarchar(255)
)
AS
SET NOCOUNT ON;
SELECT LegacyCustomerNumber,
SAPCustomerNumber,
CustomerName
FROM CustomerTranslation
WHERE LegacyCustomerNumber = @LegacyCustomerNumber
FOR XML AUTORETURN
Ok. But can't you just write to the event log immediately after the lookup to see what the document (or field) contains? Why wait until the decision shape to print the data out?
FYI, you'll only want to promote a field if you're using it to route messages through the engine. That is, if you want a subscription on a send port that says "Customer.State == CA", then you need "State" to be promoted. If you simply want to use "Customer.Zip" in an orchestration, distinguish the field only.
Rseroter,
actually the field is promoted AND distinguished; not sure if that is completely correct since what I've seen on the subject is limited. Haven't been able to write the value (yet) to the event log since I can only grab it when the lookup is successful.
Why are you using the promoted values and not distinguished fields? What happens if you write out the value (BILLTO) to the event log? What's in there when the blank occurs?
Hi Neal,
In your chosen application, if you click on the"Policies" folder, right click and choose "Add Policy", you should see a list of available rule sets to add to your application.
Well here is a little info for you,
WebSphere MQ (formerly MQ Series) is the flagship Queuing product from IBM, currently it is the number 1 queuing product of the world, in its 6.0 version. It obviously ensures the guaranteed and once only delivery, persistent messages, installs on more then 80 platforms. It has API's in almost all major languages like C#, java etc.
The great thing is that BizTalk Server 2006 comes with an in-the-box adapter for it, though it can only connect to MQ Series on a Windows platform, hope that'll improve as well in the future versions.
Thats a kind of basic info for you, if you need to ask anything specific, feel free to ask…
Regards,
Sajid.
good day Gopi,
this would be trivial in Mercator, but it is more challenging in Biztalk mapper.
what you can do is use a scriptoid attached to a cumulative to read in all the order IDs and store them in a global dictionary as keys. this will give you a hash of all orders that can be used as a set of unique order ids.
then you can have another scriptoid output each unique order ID and use it in a logical tests in an evaluation where you loop through all orders only meeting a true case when you have a match with the provided unique order number.
it is difficult to explain, but you might be able to phanaggle it to work. To reduce the algorithm, here it is
– get all unique order ids
– drive shipments output loop with orders input loop
– only allow shimenetorder to be created when
– there are more unique order IDs left
For each shimenet order, you are looping through all shipments and
– only allow package id to be created when there is a match between the order id in the source shipment and the scriptoid-provided unique order id
It will take an extreme amount of experience with the mapper to pull this off. Maybe someone else has a better idea. This example illustrates one of the things about Biztalk mapper that makes me uncomfortable – it forces you to drive loop iterations off of "features of the input data" rather than for business reasons. Either that or write a .net app to pre-sort the data before you map it – but that would just be an admission of BizTalk being a poor mapping tool, wouldn't it?
– wa
Hi All,Please ignore the previous post, bit of junk data got added…I am in deployment phase of my small BTS 2006 ApplicationI need to create SQL Databases with tables (with data) and stored procedures during the installation or import process.I dont want to run the script seperately to creating the database and other tables… after the installation or import of BTS MSI.i am having an idea of calling the SQL script using osql during installation using pre-processing script option in BTS 2006 resources,is there any other way of achieving this ?Hey Neal,
All that goodness is now in the Admin Console. You configure tracking for ports/orchestration there, if you add rules to an "application", then you can right click and add tracking. No need to use HAT for configuration anymore.
