Forum Replies Created
-
Posts
-
You may have to go into the SQL 2005 Configuration Utility (Surface Configuration) and enabled \”named pipes\” and enable remote access. It seems like over-kill security, but by default, other machines cannot access your SQL server.
Stefan,
Didi you tried changing System ID from \”00\” to \”01\”, communicate with your SAP Admin Re:01.
hope this works…..
Nar-
[quote:9549b3feca=\”Stefan \”]I think I found an answer…
First: pipeline one should desassemble all the schema related to IDoc to be received
Second: promote one node that would differentiate one IDoc of another
Third : Use this in the orchestration[/quote:9549b3feca]Hi i have the same problem: what ‘s mean the first solution?
Thanks in advanceI may try this to get the filename through WS:
===================================
create one custom pipeline on SOAP send side — promote the context property \”ReceivedFileName\”Create a schema for SOAP Header, only inclued one element \”Filename\”.
Create SOAP Header based on this schema using the wizard.Having another custom pipeline on SOAP receive side — take the value out of soap header and throws back to promoted proptery
===================================
But i don’t know how to store the promoted property value into SOAP Header while submit file to WS. Or maybe i have to set up orchestration?Is the direction i’m going right?
Thanks
MerryI dont know if it is necessarily recommended or not, but sometimes it is definately a needed and thats when you gotta do what you gotta do.
A few things to keep in mind before you attempt to do this though:
– set up your orchestration as \”long running\”, this will allow it to be dehydrated when it gives control to your external code, freeing up resources.
– use the scope shape and add an exception handler that will handle the error response to your web service in case something hits the fan. I know this shouldnt be an issue, but ive had suspended orchestrations deployed as webservices either return a server error to the browser causing a nasty .net screen… or just hanging and causing a timeout.
– if you have the luxury, add an external project to your biztalk solution that lets you do all your functionality in the .net flavor of your choice, add the reference to your biztalk project, and call in an expression shape. (you can code all you want in the expression shape and get as sofisticated as youd like, it is easier and more sane to do it in an external project and calling it from the expression)
——
which brings us to how, if you are going to be editing your message in any way, you will need a message construct shape with a message assignment shape within that… its interesting, it allows you to manipulate your message, be it in DOM or through promoted props or whatever you prefer, but it wont let you code, you will need to add an expression shape. (which does the opposite, code but no msg manip) ** of course you cannot use control statements, if’s whiles etc.. those are in decision shapes 🙂
but, you add a ref to your project that has the methods you need, go to your orchestration properties and add a variable, choose the .NET method that determines that variable type. In your expression, create a new instance of that variable (ie. something = new System.Xml.XmlDocument;) and use it as you would normally.
its that simple.
again, is it recommended, I recommended to my guys if they follow a few guidelines and not choke my server… but i do not know what others have to say.Hope that helps.
Yes I had tried that, but you cannot use forward slashes in the port configuration window – it throws up an error.
But I found the cause. I had a flatfile dissassembler pipeline – which I assumed had been carried over when I created my binding file. It appears that the send file was not bound to that send pipeline. Once I bound it as required it worked perfectly.
Many Thanks
JManHere’s more info to help anybody else find this problem in the future.
These were messages in Event Log:
Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 0
Date: 6/15/2006
Time: 3:08:49 PM
User: N/A
Computer: USGDPWV81NB
Description:
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unable to open shim database version registry key – v2.0.50727.00000.Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5410
Date: 6/15/2006
Time: 3:08:51 PM
User: N/A
Computer: USGDPWV81NB
Description:
An error has occurred that requires the BizTalk service to terminate. The most common causes are an unexpected out of memory error and an inability to connect or a loss of connectivity to one of the BizTalk databases. The service will shutdown and auto-restart in 1 minute. If the problematic database remains unavailable, this cycle will repeat.Error message: Object synchronization method was called from an unsynchronized block of code.
Error source: Microsoft.XLANGs.EngineBizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc{6F61A33D-4419-43A2-853E-4EBEB35A7EE0}For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I had to add this to bottom of BTSNTSvc.exe.config
<startup>
<supportedRuntime version=\”v1.1.4322\” />
</startup>Apparently had some confusion of using some features of .NET 2.0 framework. Apparently is also related to the Listen Shape.
I also had lots of messages in the application event log which helped lead me to this.
I rebooted, and they are still there.
If I try to terminate them again, it says:
One or more service instances could not be terminated. It is possible that the instance(s) has already completed or terminated, or it may have a pending control message.
I still don’t know what to do to kill it so I can redeploy my solution.
i know this my sound rediculous but still i ask –
can a BTS Map be used for assigning values to a field on the input side (the value calculation has to be based on some other values, again from some other fields from the input schema)actually i have this scenario where some of the fields in the input schema have to be \”calculated\” fields.
they should have value assignments based on some other field values inthe input side.
these \”calculated\” fields will then be used elsewhere in the map.is this a feasible scenario??
Now getting
Error 1 SQL exception: \”An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)\”
The SQL server is configured to allow remote connections. SQL Browser service is started.
Ideas?
