Forum Replies Created
-
Posts
-
First, I’d try setting up 4 Loop shapes going from Shipment, Order, Pack, and Item to the HL record. Just to make sure that doesn’t work. I don’t think it will.
You might be able to do it with some custom XSLT. Set up a ForEach around Shipment, that has a ForEach around Order and so on. Some XSLT’s can not be nested – so I do not remember if ForEach is one of them.
If any case, I’d try using a XSLT Template. You can get some great help at x3schools.com.
Hope this helps.
It looks like you have a send pipeline inside your Orchestration project that is used on a send port. You need to change that back to Pass Through or Xml before you can un-deploy. This tool can help: http://www.biztalkgurus.com/Tools/Development-Helper-Tool.html
It would probably be best to separate your items into 3 projects: Orchestrations, Pipelines, and Maps/Schema.
Hope this helps.
I should’ve stated my situation a bit better. I have 4 ftp receive locations, all of which are monitoring the same ftp, but each location monitors different folders. There will be a variable number of files in each folder that is being monitored. So I could have a variable number of orchestration instances being spawned at 1 time. I was actually thinking about storing the names in a SQL table, I was just trying to see if there was a \”more graceful\” way to go about doing this, but I don’t forsee any. Thanks for the reply!
Have you thought of putting the file names into a table and then running a process every once in a while to pull them out and send the email? We did something like that on a past project.
Otherwise, might be able to use untyped messages (messages without a defined schema) to process all 4 messages in a convoy inside one Orchestration. That kind of adds a lot of extra work though.
Will you always have 4 messages? If so, maybe your 4 Orchestrations could send a “done” message with the file name to another Orchestration that is waiting to get all the messages before it sends an email?
Just some thoughts. Hope this helps.
Well, it really all depends on what exactly you want to do.
Biztalk can integration with SAP through the SAP Adapter. That will be included with Biztalk 2006. Also, integration with SQL is built in through the SQL Adapter.
So, it would really be a matter of getting the data out of SAP via the adapter, mapping it, and putting it into SQL.
I do not know of an Excel Adapter. You might have to export the data as a csv or something Excel can import.
Hope this helps.
Stephen
We have made some progress with this. A colleague has found that by including an xsd in the overall solution more than once, we have the problem, i.e. we effectively have xsd files with the same target namespace. Changing the namespace in copies of the file resolves the problem.
We did this deliberately to minimise the impact of change (or at least give us some flexibility of when things get released).
Specifically, we have a BaseDictionary.xsd that defines a number of common types. These are primarily simple types with restrictions, such as enumerations or regex validation. We shared (using sourcesafe) this dictionary into each schema project that we needed to use the base types, instead of referencing a base project, on the basis we could choose when to update the specific schema project if the base dictionary changes.
The schema projects used in the solution for this thread all use the base dictionary, so each of them have, effectively, their own copy of the basedictionary schema that has the same namespace. If the namespace is changed to be unique, the problem goes away.
So, we now know how to get the map to work, but we need to rethink our approach to the deployment side should things change.
Thanks for your help & suggestions.
Regards
MarkI have been putting off responding to this for a bit
The long and short of it is, I think it is doable but it would take a lot of work. Probably some external tables to store the data.
I think I have seen some items on GotDotNet.com that might help. Something about a sorter adapter.
Hope this helps.
One one of our systems we have missing stat’s category: Biztalk Messaging and Xlang… Could this have anything to do with security? I was logged on as Administrator, and tried making Administrator part of BiztalkAdmin group, but that didn’t help. All the Biztalk:BAS stats are there, and Biztalk:TDDS but not Biztalk Messaging and Orchestration stats. Could this be something gone wrong in install?
Thanks in advance,
Neal Walters
http://Biztalk-Training.comOne of my clients machines has a \”dead HAT\”. We run orchestrations, and run the \”Most Recnet 100 Service Instances\” in HAT, and we have seen anything since about Oct 20th.
We queried the database directly, and it too appears empty. The orchestrations are running fine, the database doesn’t seem to be full, there are no messages in event log.
Any suggestions on where to look next?
Neal Walters
http://Biztalk-Training.comHi ,
i have to tweak some registry settings to see the detail error messages before i got it working
Hi,
yes, you are right, the problem comes from tnsnames.ora, because it doewn’t find any datasource!So you should create a data source from the Oracle Net manager and configure in Microsoft ODBC Administrator !!
Then the connection is ok
kind regards
AC
About the only think I know about Oracle is to got to \\Network\\Admin and update the tnsnames.ora file.
Best of luck.
Hi,
I made a mistake, because I forgot to install Oracle Services for Microsoft Transaction Server.
Now I don’t have this error message any more, but I have a new one 🙁
———————————–
Test connection failed because of an error in initializing provider. ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
———————————-do you know where I have to go for initializing the provider??
Thank you in advance!
A.C.
