Forum Replies Created
-
Posts
-
In BizTalk 2006, I am about to create a map with an \”SQL Adapter\” supplying the \”source schema\” from MS SQL Server, while an EDI document becomes the \”destination schema\”.
If this process is to be done automatically, what event actually puts everything into motion? Would SQL Server start this process? If so, what would it use? A stored procedure? A trigger?
Thank you in advance for your response.
Mike
This is embarressing! I found the Rules Composer exe file in the Recycle Bin. I’ve installed and reinstalled BizTalk more than once so somewhere along the line, I did something wrong. (I’d blame BizTalk but you’d know better)!
Thanks again. Matt.
YES YOU CAN, what is your Source EDI Format(XML or other format)
Are you using any EDI adapters?
Nar-
Hello,
I generated a schema for a wellformed XML document in BizTalk 2006.
I’d like to use this schema (well, in fact 2 schemas with one importing the other) in BizTalk 2004. However, when validating the original XML document, I get an error message :[quote:bcae7a6e62]error BEC2004: Cannot load schema for the namespace ‘http://namespace2’ – Could not find file \”Z:\\ … \\InvoiceAdditionalNL.xsd\”.. An error occurred at file:///Z:/INVOICE.XML[/quote:bcae7a6e62]
So this seams to be a problem with the second namespace in te schemaLocation attribute when validating in BTS2004. The schemaLocation in the XML document is as follows:
[code:1:bcae7a6e62]<Invoice xmlns=\"http://namespace1\"
xmlns:nl=\"http://namespace2\"
xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
xsi:schemaLocation=\"http://namespace1 Invoice.xsd http://namespace2 InvoiceAdditionalNL.xsd\">[/code:1:bcae7a6e62]When I remove the schemaLocation, the document validates fine. In BizTalk 2006, the original XML document validates without any problems.
Anyone who knows how to fix this, or knows a workaround? I receive the documents with the schemaLocation specified as above.
Thanks,
Dirk
Nope, I haven’t seen that one. Might want to check: \”C:\\Program Files\\Microsoft BizTalk Server 2006\\Microsoft.RuleComposer.exe\”
Maybe the exe is there just the shortcut is missing.
[quote:85970ac205=\”nwalters\”]Tomas,
Absolutely correct, I changed the Assembly Name but not the default namespace in the Project Properties.After making such a change – do you have to rerun the regedit/merge again?
[/quote:85970ac205]You shouldn’t need to. It was just about getting resources correctly named into the assembly and ensuring the code can load them. You might want to check with Reflector to ensure everything matches, though.
[quote:85970ac205=\”nwalters\”]
Also, does the Adapter have to go in the GAC. Do you have to have a separate load directory in the regedit file (other than the GAC). I’m guessing this is kind of like why custom pipelines have to be in a special directory?
[/quote:85970ac205]The way the regedit file is configured, you can just deploy it to a directory of your choosing, but make sure the location matches in the regedit file when you register the adapter. Also, note that whatever is in the registry is copied over to the BizTalk MgmtDb when you register the adapter with the Management console, so changing the registry after that won’t do anything unless you remove the adapter and add it back again.
That said, there are ways to configure the adapter registration so that it is loaded from the GAC instead of from a directory. I don’t remember exactly how it goes, but I think the documentation mentions it.
[quote:85970ac205=\”nwalters\”]
Recall that you cannot type directly in the Addres (URI) – you have to click the ellipse and then fill in the next screen. That’s where my problem was. So I typed in null://DummyCorrelationInitPort, then clicked \”OK\”, then the address url had a double null, i.e. \”null://null://DummyCorrelationInitPort\”.
[/quote:85970ac205]
Ahh sorry about that, I guess I didn’t check for the null://. The idea is you just write DummyCorrelationInitPort there and that will be fine.[quote:85970ac205=\”nwalters\”]
Does this \”name of port\” have to be unique (similar to SQL URLs)?
[/quote:85970ac205]That’s the idea, although frankly, this particular adapter doesn’t really care much about it anyway, so I doubt anything bad will happen if you don’t 🙂
Tomas,
Absolutely correct, I changed the Assembly Name but not the default namespace in the Project Properties.After making such a change – do you have to rerun the regedit/merge again?
Also, does the Adapter have to go in the GAC. Do you have to have a separate load directory in the regedit file (other than the GAC). I’m guessing this is kind of like why custom pipelines have to be in a special directory?
[quote:799210c4eb]Regarding the Address (Uri), just put whatever you want like \”null://whatever\”, this is just to give a unique name to the send location (if you use the properties dialog it will add the null:// for you). [/quote:799210c4eb]
Recall that you cannot type directly in the Addres (URI) – you have to click the ellipse and then fill in the next screen. That’s where my problem was. So I typed in null://DummyCorrelationInitPort, then clicked \”OK\”, then the address url had a double null, i.e. \”null://null://DummyCorrelationInitPort\”.
Does this \”name of port\” have to be unique (similar to SQL URLs)?
Thanks again for providing this adapter.
NealIn configuration, I see \”SSO\”, \”GROUP\”, \”MSMQT\” and \”Business Rules Engine\” with Green Check marks.
EDI, HWS Runtime, HWS WebService, BAM Tools and BAM Portal have Red exclaimation points.
The \”Basic Configuration\” button is disabled.
—————————
In the orchestration toolbox, I have \”Call Rules\” available.
—————————
Under Windows Start->BizTalk Server 2006, I see the \”Business Rules Engine Deployment Wizard\” but not the \”Business Rules Composer\”
Any thoughts?
Thanks. Matt.Hi Stephen & Neal,
Thank you very much for your quick and helpful replies.
I’ll be looking into your suggestions and I’m sure I’ll be able to get a great result.
Many Thanks,
FredHello
I use 2 orchestrations. And one Orchest.X calss the other, Orchest.Y.
for this, Orchest.Y’s Receive shape must not be Active. So it needs already initialized correlation sets. But how can I make it?And what should Correlation Properties be? FILE.ReceivedFileName, SOAP.ProxyPort, SOAP.UserDefined…. or what?
Thanks
Hilal
Did you configure it?
Open the Configuration tool under Programs, BizTalk 2006. Check the Rules Engine Composure. Make sure it’s configured.
I have the 2006 Enterprise Edition installed but I can’t find the Rules Composer. Any suggestions? Thanks.
Hi Neal,
Regarding the Address (Uri), just put whatever you want like \”null://whatever\”, this is just to give a unique name to the send location (if you use the properties dialog it will add the null:// for you).
Regarding the other problems, sounds like you might have accidentally screwed something up during the change. If you changed all the namespaces for the classes, make sure you also changed the default namespace for the project, as that affects embedded resources (in particular it affects the XSD resource).
Notice that also the NS constant in NullAdapterMgmt.cs will affect the namespace used to discover the send location XSD definition file (SendPortSchema.xsd) from an embedded resource (see above), so make sure those match.
That should be enough to get things going, I think, but if you have any other problem, just let me know and we can work it out.
I agree with Stephen, using BizTalk for this would not be a good idea. You could use BizTalk to inform the endpoints of the need to do a file transfer, or collect a list of file names to be zipped, or whatever, but if you send this through BizTalk you’re storing all those pictures in the MessageBox, however temporarily, which is a big waste of bandwidth.
