Forum Replies Created
-
AuthorPosts
-
September 5, 2009 at 8:17 AM in reply to: Help needed to start biztalk EDI application development #23195
Hi Daniel,
With your reference help i am reading some links. I need some help to convert xml file to our orcale database tables. I explain our process
we have receive xml file from customer then convert in to our oracle quotation tables. I am explain my understaing here
1.I have created input port folder (for test purpose)
2. Created Schema for xml templete (customer)
3. Created Orchestration input port (my input dir)
4. If i Map , how can i map xml to orcale DB
I need some clarification : How can i process my receive xml from oracle table. Please help me to proceed.
Many thanks for your help.
Regards
Ram
You could develop a custom library in c# which tests the map and use that custom library in BizUnit. However calling a map is not easy, but I know I seen code for it on the net before, but can’t remeber where…
Hello everyone,
I am completely unaware of the biztalk server but I need to install biztalk server 2009 in the machine that has windows server 2008, where IIS is blocked since Apache is running. Actually the apache is needed theresince some web sites are running that server that uses apache.
Can biztalk run without IIS?? I am following the articles and guides from
to install, and in those articles it is written that IIS is needed for web application infrastructure.
Can somebody help me and give me a way to start.
I removed a couple of the orchestrations that reference this assembly then, deployed the assembly then re-deployed the consuming orchestrations and it worked … so I suppose the error message is accurate … I just don;t know where to configure these connections. In a connection string it would be easy, but how does the BTSTask utility manipulate connection pool settings?
Overall summary:
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The installation media is corrupted. It does not contain the folder ‘1033’.
Start time: 2009-09-03 09:18:00
End time: 2009-09-03 09:18:45
Requested action: InstallMachine Properties:
Machine name: LATHURAJ-PC
Machine processor count: 1
OS version: Windows Vista
OS service pack: Service Pack 2
OS region: India
OS language: %u65e5%u672c%u8a9e (%u65e5%u672c)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: NoProduct features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS Database Engine Services 1033 Express Edition 10.1.2531.0 No
Sql Server 2008 SQLEXPRESS MSSQL10.SQLEXPRESS SQL Server Replication 1033 Express Edition 10.1.2531.0 NoPackage properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0
Installation location: c:\89cc852f4b5df7788185\x86\setup\
Installation edition: EXPRESS_ADVANCEDSeptember 2, 2009 at 6:04 AM in reply to: Reading destination element inside scripting functoid #23187The mapper does not allow access to the destination nodes. This is a restriction of Xslt, not a Biztalk specific restriction.
I am not sure I follow your logicelse If X1=(‘RM’ && !(X1==”KT” || X1==”MT”))
you appear to anding a boolean with a string, should this read
if ((X1 == ‘RM) && !(X1==”KT” || X1==”MT”))
September 2, 2009 at 3:31 AM in reply to: Column values does not work with SharePoint Adapter #23185I also tested to set the configparameters via the orchestration whichs sends the messages to the library, but it does not work here as well…
This is the code I tried:
OutgoingOrder(WSS.ConfigPropertiesXml) = “<ConfigPropertiesXml><PropertyName1>Order Id</PropertyName1><PropertySource1>123</PropertySource1></ConfigPropertiesXml>”;
September 2, 2009 at 3:15 AM in reply to: What the Limitations of BizTalk on Integrating Legacy System Like AS400 #23183BizTalk adapters for Hostsystems comes with Biztalk 2006 will help to connect to AS/400 using MQSC/DB2 adapters. I don’t know much on limitations. I hope this link will help you
cheers,
Nandika
Seems like the problem does not lie with consuming the web reference, but rather with our partner’s firewall. We just don’t seem to be able to hit their address. Keep getting “The underlying connection was closed” errors. Their firewall support guys are going to take a look and get back to us.
September 1, 2009 at 9:58 AM in reply to: Delimiter issue when passing commands in BizTalk FTP send port #23181Hi,
If you have the WSDL from the partner, you should be able to generate the a web reference and web port message in your VS project, just like consuming a SOAP web service.
Good luck!
Daniel.
Hi Jags,
I would recommend that you modify the schema for the incoming XML to take into account those elements and nested records that would missing: you can set Minimum Occurrences property of those elements to zero and/or set the Nillable property on certain nodes to True.
This way, you can accomodate any XML file you referred to in your original post in a flexible manner.
Good luck!
Daniel.
Hi Per,
It could be that the promoted field is not read/write for some reason. Try to make it a Distinguished field and see if that resolves your issue.
Good luck!
Daniel.
Hi,
Use the definition System.String in the following way in your Expression shape:
if (System.String.Equals(<YourVariable>, ‘somestring’))
{
//Your code here
}
Keep in mind that the programming language used in BizTalk environment and Expression shapes is XLANGs, not C#, and is more limited in what you can do with string functionality.
Good luck!
Daniel.
And in addition to using the Performance Counters, when you save the results as an .svc file, it is possible to analyse the values with the PAL (Performance Analysis of Logs Tool) and create reports from your results. Get the tool at codeplex (http://www.codeplex.com/PAL)
This tool has a lot of built-in tresholds which you can use to find painpoints in performance of your machine, BizTalk, SQL, etc…
Kind regards,
Andrew -
AuthorPosts