Forum Replies Created
-
Posts
-
Im trying to transform a message through custom XSL inside BT mapper.
The output message is empty.
I have very simple case:
This is the incoming xml:<ns0:Employees xmlns:ns0=\”http://CustomXSL.req\”>
<Employee>
<FName>Bill</FName>
<LName>Clinton</LName>
</Employee>
</ns0:Employees>And this is the xsl transform:
<?xml version=\”1.0\”?>
<xsl:stylesheet version=\”1.0\”
xmlns:xsl=\”http://www.w3.org/1999/XSL/Transform\”>
<xsl:template match=\”/\”>
<empoutput xmlns=\”http://CustomXSL.scmout\”>
<xsl:for-each select=\”Employees/Employee\”>
<FullName>
<xsl:value-of select=\”FName\”/>
<xsl:value-of select=\”LName\”/>
</FullName>
</xsl:for-each>
</empoutput>
</xsl:template>
</xsl:stylesheet>the output is:
<?xml version=\”1.0\” encoding=\”utf-8\”?><empoutput xmlns=\”http://CustomXSL.scmout\”></empoutput>
instead of
<?xml version=\”1.0\” encoding=\”utf-8\”?><empoutput xmlns=\”http://CustomXSL.scmout\”><FullName>BillClinton</FullName></empoutput>10x
For information – Client’s server port was set up to receive https, we were sending http (as per instructions!). Amendment seems to have fixed the problem.
I’d still like to rule out the filter issue.
Try removing your filter, and try this one instead:
BTS.MessageType >= A
This should make this send port subscribe to all messages published through Biztalk (is this a flat file receive?)
Then run your test and see if the send port gets the message. If it doesn’t, then the problem is obviously not the filter.
If it does, then the problem is probably with the filter.Neal
Dehydrated basically means that Biztalk has put your orchestraiton to sleep waiting on a response (i.e. it’s memory is written to a database). When it wakes up, we say that it is rehydrated.
What causes dehydration? Usually a Receive statement or maybe a Delay statement (I’ve heard it happens after 2 minutes, but that is just a guess).
Sounds like you might have a correlation issue. The \”delivered not consumed\” means you probably sent a message out and then followed up with a receive to get it back. If the correlation doesn’t match up, the Biztalk receives the message back, but doesn’t know who to give it to (i.e. which orchestration). Use the free BTSSubscriptionViewer included in the Biztalk developer tool or SDK directory. This will show you what your orchestration is correlating on.
So since the message was delivered/not consumed – your orchestration probably is probably sitting on a Receive statement and is still waiting for a proper response.
What are the starter files generated by VS.Net by creating a HWS project from BizTalk Project Templates of Human workflow services?
If i understand correctly then you want to map all the fields in single child element of your schema.
Once you use SQL Adapter it will create a scema of your table you just mentioned then you need to use mapper to create mapping of your table’s fields and your schema single fields.
If your requirement is to mapp all the table fields into a single child element in your schema then you can use String Concat Functoid in the mapper to concat all the fields into single child element.If you need any help let me know.
Regards,
Naseem Siddiquiyes we are using EDI adapter and EDI-X12_3010_850 format is used.
[quote:6d4b2f0739=\”Nar_BTS\”]YES YOU CAN, what is your Source EDI Format(XML or other format)
Are you using any EDI adapters?
Nar-[/quote:6d4b2f0739]
yes we are using EDI adapter and EDI-X12_3010_850 format is used.
[quote:441118426f=\”Nar_BTS\”]YES YOU CAN, what is your Source EDI Format(XML or other format)
Are you using any EDI adapters?
Nar-[/quote:441118426f]
It could be a number of items. Does your flat file validate against the schema? I’m guessing not.
You might want to look at changing the parsing mode to Complexity (set on the <schema> node properties). Also make sure your default delimiter type (i.e. like Post Fixed, Per Fixed, or In Fixed) is set correctly.
Typically I have to do a trial and error approach to fix these types of problems.
Typically when I see that message, I forgot to actually start the Orchestration. You might want to double check to make sure it’s started (and not just enlisted). Also, make sure all your hosts are running.
Are you getting any errors in the event log?
I have not seen this before.
Here are a few things I’d look at:
– Make sure you don’t have deploy checked on your solution when you do a build
– Make sure you don’t have the restart host property on the projects set to true
– Make sure your projects are not too large. I’ve been builds take a long time when I had a lot of maps and schemas in them.Hope this helps.
It might help to take a look at some of the flat file samples and the video I have on this site.
Basically, you need to define three schemas and set this inside the flat file disassembler.
Your header and trailer validation is a little more tricky. If the file was smaller (less then 5 MB or so) I’d probably put the whole message into an Orchestration and run your validation. Otherwise, in the past I have put .net components that I called from the Orchestration to run extensive header trailer validation for larger file.
Hope this helps.
Which Oracle Adapter are you using.
You should be able to call a stored procedure from with the Oracle Adapter
[quote:47d0e79b8d=\”greg.forsythe\”]Are you referring to PL/SQL Bind Variables on an Oracle Adapter?[/quote:47d0e79b8d]
Yes… Sry that i didn’t specify it in the first post 🙄
I’m now considering use of C# class, which method will call stored procedure, but if you have a clue how to use Bind Variables i will be very happy.
