Forum Replies Created
-
Posts
-
You can use the Route Message on Error functionality available in BTS2006.
If a message fails in the pipeline, the message is not suspended but published into the message box. It un-promotes? all the current promoted properties and set a series of ErrorMessage promoted properties.
You can use a send port to subscribe to these messages and write them to another directory, alert someone, return to sender, etc, etcHi Richard,
I get the following error when i do the dtc test.
Platform:Windows 2003
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from local registry:
Security settings for DTC under Windows 2003
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :false
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
AccountName :NT Authority\NetworkService
NetworkDtcAccessOutbound :true
TurnOffRpcSecurity :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :falseIP Configure Information
Host Name . . . . . . . . . : power1
DNS Servers . . . . . . . . :
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : yes
NetBIOS Resolution Uses DNS : noEthernet adapter {F7DF68EE-81B6-4E20-8B18-BD145CF2C796}:
Description . . . . . . . . : Intel(R) PRO/1000 F Server Adapter
Physical Address. . . . . . : 00-0E-0C-84-45-32
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970Ethernet adapter {1CDD80C7-F2CF-49B9-8C61-EEDF58BFCF65}:
Description . . . . . . . . : Intel(R) PRO/1000 MT Dual Port Network Connection #2
Physical Address. . . . . . : 00-04-23-B3-9F-81
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for POWER1
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
12-07, 10:37:18.142–>Start DTC connection test
Name Resolution:
xeonsql–>192.168.124.254–>XEONSQL
12-07, 10:37:19.673–>Start RPC test (POWER1–>xeonsql)
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
–>RPC pinging exception
–>1753(There are no more endpoints available from the endpoint mapper.)
RPC test failedPlease help, many thanks
Hi Richard,
This is the error i am receiving. Please help!
Platform:Windows 2003
Windows 2003,sp1 environment is detected:
Reading MSDTC settings from local registry:
Security settings for DTC under Windows 2003
NetworkDtcAccess :true
NetworkDtcAccessAdmin :true
NetworkDtcAccessClients :false
NetworkDtcAccessTransactions:true
NetworkDtcAccessTip :false
XaTransactions :true
AccountName :NT Authority\NetworkService
NetworkDtcAccessOutbound :true
TurnOffRpcSecurity :true
FallbackToUnsecureRPCIfNecessary:false
AllowOnlySecureRpcCalls :falseIP Configure Information
Host Name . . . . . . . . . : power1
DNS Servers . . . . . . . . :
Node Type . . . . . . . . . :
NetBIOS Scope ID. . . . . . :
IP Routing Enabled. . . . . : no
WINS Proxy Enabled. . . . . : yes
NetBIOS Resolution Uses DNS : noEthernet adapter {F7DF68EE-81B6-4E20-8B18-BD145CF2C796}:
Description . . . . . . . . : Intel(R) PRO/1000 F Server Adapter
Physical Address. . . . . . : 00-0E-0C-84-45-32
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970Ethernet adapter {1CDD80C7-F2CF-49B9-8C61-EEDF58BFCF65}:
Description . . . . . . . . : Intel(R) PRO/1000 MT Dual Port Network Connection #2
Physical Address. . . . . . : 00-04-23-B3-9F-81
DHCP Enabled. . . . . . . . : no
IP Address. . . . . . . . . :
Subnet Mask . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . :
DHCP Server . . . . . . . . : 255.255.255.255
Primary WINS Server . . . . : 0.0.0.0
Secondary WINS Server . . . : 0.0.0.0
Lease Obtained. . . . . . . : Thu Jan 01 00:00:00 1970
Lease Expires . . . . . . . : Thu Jan 01 00:00:00 1970++++++++++++lmhosts.sam++++++++++++
++++++++++++hosts ++++++++++++
127.0.0.1 localhost++++++++++++++++++++++++++++++++++++++++++++++
DTCping 1.9 Report for POWER1
++++++++++++++++++++++++++++++++++++++++++++++
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
12-07, 10:37:18.142–>Start DTC connection test
Name Resolution:
xeonsql–>192.168.124.254–>XEONSQL
12-07, 10:37:19.673–>Start RPC test (POWER1–>xeonsql)
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @303
–>RPC pinging exception
–>1753(There are no more endpoints available from the endpoint mapper.)
RPC test failedMany thanks
Hello,
Thanks Greg, I really appreciate the tip you gave – it worked. I had previously tried using the looping functoid but had also connected the invoice header to it and that output twice the number of output records with incorrect fields.
I had also simplified my input file to get the BizTalk running. It actually looks like this:
Header record
Invoice A header record
Product 1 for Invoice A record
Serial Number record for Product 1
Product 2 for Invoice A record
Invoice B header record
Product 1 for Invoice B record
I.e. Each product record may be followed by a Serial number record. There is also a line item number field on both the Product and Serial Number record to match the two records. All records have a tag identifier.
In the BizTalk map, when I connect the serial# field to the appropriate field in the output record it uses the data from the first Serial number record for all other products in the same invoice. I also tried connecting the Serial Number record to the looping functoid but that produced incorrect result.
How do I show the Product and Serial Number relationship in the mapping?
If the Product quantity is greater than 1 then I would like also like to produce n output records where Product quantity = n (similar to a for each loop). Can this be achieved in BizTalk mapping?
As my questions indicate I’m very new at BizTalk! Are there tutorial/samples available?
Cheers
Stable
I think I'm a little dizzy today. I went to Martijn blog and have got all my answers there. It explains that I need to change the Class to Decode and then put a flat file disassembler. Thanks for your efforts. I'll give that a go.
Cheers
Rob
Hi Greg,
the Unzip Component will only be placed the the Disassemble stage. If I try and place it in the Decode it wont let me. Do i need to do something with my receive pipeline to allow the Custom Component to be placed in the Decode stage. I have the component assembly in the right directory and had no problem adding to the tool box in VS2005.
Thanks and regards
Rob
You need to place the component assembly in the C:\Program Files\Microsoft BizTalk Server 2006\Pipeline Components directory.
Create a receive pipeline, add your custom compnent to the tool box in VS2005 and then drag the component into the Decode stage of the pipeline
The flat file schema wizard allows you to select the codepage (encoding) of the source/target schema. If you don't find the exact one you expect, there are ways around it, fortunately. First, consider how the flat file disassembler recognizes the encoding of an incoming flat file:
http://www.winterdom.com/weblog/2005/09/08/SelectingTheEncodingUsedWhenParsingFlatFiles.aspx
Once you know that, it's easy to see how to tell it to use a given encoding to interpret an incoming file. If the usual spots don't list the encoding you want, chances are you might be able to use my FixEncoding pipeline component in the decoding stage of your receive pipeline to select a different encoding.
Finally, you need to understand how the FlatFile Assembler finds out the encoding to write the flat file into, for that, check here:
http://msdn2.microsoft.com/en-us/library/ms964120.aspx
Hope this helps!
I think you need to do this conversion inside a pipeline.
Tomas talks about this a lot. Check out http://www.winterdom.com. He has some samples on the site he posts in a blog post a while ago.
Oh, the solution is a little harder. You’ll have to do what I described inside a custom pipeline and set the email body inside the pipeline.
It would be easier to do inside an Orchestration and that would be the right place for this type of logic, in my opinion.
Almost sounds like this could be an SSO problem? Did the user running the host get removed from the SSO group? Not sure they are in a SSO group now that I think of it… in any case, did anyone mess with SQL Permission Settings on the tables?
That should work. Check to make sure you haven’t made any changes to the schema after is was auto generated by the wizard (is was auto generated right?). Then, ensure your schema is deployed and host is restarted. Also, make sure your connection string is correct.
If all else fails, I’d try regenerating the schema again.
