[community-content]

Hello Nick. 

Thanks for your response. The example and link that you provided were a great help.

I was just trying to figure out that if I were not to be backingup the Biztalk databases and they became corrupt, what would the cost be.  For example, would I just need to re-install biztalk\configure and re-apply my application.  What additional information would be lost?

 Thanks, Steven

[community-content]

Richard Seroter has a good entry on his blog giving an overview of the BizTalk 2006 Oracle adapter:

http://seroter.wordpress.com/2007/03/12/a-walk-through-the-biztalk-2006-oracle-adapter/

Nick. 

[community-content]

Hi Anon,

Just to confirm, this is the assembler (i.e. you're sending) that is taking 10 minutes and not the disassembler (receiving?)

Can you give an indication as to how big the Xml file is you're trying to turn into a flat-file?

Cheers, Nick. 

[community-content]

Steven,

Maybe I'm not quite reading your question correctly, but the SQL Server databases are a core, fundamental part of the BizTalk setup. Without them BizTalk would not run; if you were to lose the databases you simply would not have a BizTalk environment.

Furthermore, you need to run the BizTalk backup jobs and not just 'normal' SQL Server backup/maintenance jobs because of the need to add transaction log marks across all of the affected databases. The 'Backup BizTalk Server' job performs this task for you (but it does need to be configured!). More information can be found at: http://msdn2.microsoft.com/en-us/library/ms962212.aspx

In our BizTalk environment, we perform fully daily backups and hourly transaction log backups and keep the files on-site for two days. Anything older is archived to tape and stored off-site.

Hope that helps?

Nick.
 

[community-content]

These settings are on the schema – I have not provided details on how to resolve the mapping issue (my schema post is apparently under moderation!)

 

Nick. 

[community-content]

I've kind of work out part of this issue now although Im not sure if I'm going about it the right way !!

I created a pipelline with a flat file schema, I can now get the send and receive ports to convert the flat file into an xml document, only issue I have now is that the flat file consists of multiple records but I always end up with. Once I have XML the rest should be ease (I Hope 🙂 )

 a) Only One Record
b) All the data from the end of the first record to the end of the file in the last field of the XML created.

 Input file is (Tab seperated Fields)

product_id stock_on_hand committed being_receipted in_transit on_order first_available_stock manufactured bundled last_updated
ACE0307 0 0 0 0 0 10 Days   07-12-2006 00:08:17
ACE0486 0 0 0 0 0 10 Days   07-12-2006 00:08:17
ACE0488 0 0 0 0 0 10 Days   07-12-2006 00:08:17
ACE9223 0 0 0 0 0 10 Days   07-12-2006 00:08:17
ACE9237 0 0 0 0 0 10 Days   07-12-2006 00:08:17

This is what I end up with

<?xml version="1.0" encoding="utf-8" ?>

– <Root xmlns="http://Schemas_NB.NB_IM_PRODSTOK_V2">

– <Record xmlns="">

  <f1>product_id</f1>

  <f2>stock_on_hand</f2>

  <f3>committed</f3>

  <f4>being_receipted</f4>

  <f5>in_transit</f5>

  <f6>on_order</f6>

  <f7>first_available_stock</f7>

  <f8>manufactured</f8>

  <f9>bundled</f9>

  <f10>last_updated ACE0307 0 0 0 0 0 10 Days 07-12-2006 00:08:17 ACE0486 0 0 0 0 0 10 Days 07-12-2006 00:08:17 ACE0488 0 0 0 0 0 10 Days 07-12-2006 00:08:17 ACE9223 0 0 0 0 0 10 Days 07-12-2006 00:08:17 ACE9237 0 0 0 0 0 10 Days 07-12-2006 00:08:17</f10>

  </Record>

  </Root>

Schema is as follows:

  <?xml version="1.0" encoding="utf-16" ?>

– <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://Schemas_NB.NB_IM_PRODSTOK_V2" targetNamespace="http://Schemas_NB.NB_IM_PRODSTOK_V2" xmlns:xs="http://www.w3.org/2001/XMLSchema">

– <xs:annotation>

– <xs:appinfo>

  <schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />

  <b:schemaInfo standard="Flat File" default_pad_char="" pad_char_type="char" count_positions_by_byte="false" parser_optimization="speed" lookahead_depth="3" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Root" />

  </xs:appinfo>

  </xs:annotation>

– <xs:element name="Root">

– <xs:annotation>

– <xs:appinfo>

  <b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" sequence_number="1" />

  </xs:appinfo>

  </xs:annotation>

– <xs:complexType>

– <xs:sequence>

– <xs:annotation>

– <xs:appinfo>

  <b:groupInfo sequence_number="0" />

  </xs:appinfo>

  </xs:annotation>

– <xs:element name="Record">

– <xs:annotation>

– <xs:appinfo>

  <b:recordInfo sequence_number="1" structure="delimited" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" child_delimiter_type="hex" child_order="infix" child_delimiter="0x09" repeating_delimiter_type="hex" repeating_delimiter="0x0D 0x0A" />

  </xs:appinfo>

  </xs:annotation>

– <xs:complexType>

– <xs:attribute name="f1" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="1" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f2" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="2" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f3" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="3" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f4" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="4" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f5" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="5" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f6" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="6" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f7" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="7" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f8" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="8" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f9" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="9" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

– <xs:attribute name="f10" type="xs:string">

– <xs:annotation>

– <xs:appinfo>

  <b:fieldInfo sequence_number="10" justification="left" />

  </xs:appinfo>

  </xs:annotation>

  </xs:attribute>

  </xs:complexType>

  </xs:element>

  </xs:sequence>

  </xs:complexType>

  </xs:element>

  </xs:schema>

I'm guessing I have a postfix or infix mixed up somewhere but I have tried changing these values with no result

Any help would be appreciated as I am totally stuck !!

[community-content]

Minor correction.

I dint understood frm where Validate Input Instance Type,Generate Instance Output type came in Map.

I suppose ur talking about.

Test Map input=Native

Test Map Output=XML

Test Map Input Instance=Your text file path[input file path].

[community-content]

One final question… Is it possible to use the BAM Excel add-in from a client PC or do you have to have Excel and the add-in on your BizTalk server?

[community-content]

Birgen,

BizTalk will use all of the processors available in a particular server. The Microsoft pricing and licencing FAQ for BizTalk reads as follows:

"BizTalk Server 2006 Enterprise Edition and Standard Edition are both
licensed on a per processor basis. A processor license is required for
each processor on which you install any component of BizTalk Server
(for example, BizTalk Server Rules Engine)."

Essentially you will need a licence for each physical processor. The only way (that I know of) to stop BizTalk running on all four processors on, say a quad box, is to run a virtual environment and have the VM's dedicated to only 2 of the 4 available processors. You may however have issues with MS supporting BizTalk on a VM environment.

Cheers, Nick. 

[community-content]

"The other issue is that what ever I do in specifying the input file for testing the map, it always uses the one biztalk creates."

You need to right-click the schema in Solution Explorer, select Properties and set the Input Instance Filename to the name of you test file. Also check that the Validate Input Instance Type is set to native and that the Generate Instance Output Type is set to Xml to see the Xml representation.

Nick

–

Nick Heppleston | http://www.modhul.com&nbsp;

[community-content]

I think I see where my problem is. If I’m right the cubes are not created until you use Excels BAM add-in and the Tracking Profile Editor. Thanks to Apress and “BizTalk 2006 Recipies” for explaining that one. Could anyone recommend a decent web cast or tutorial on setting this up?

[community-content]

I had the same problem, which depends on the Installation of ServicePack 1 for BizTalk server 2002. If you don't have a XLANG-Database, the SP1 is not able to complete without an error, but the logfile won't help you. You must install the Orchestration in the Setup of BizTalk server, so you have a XLANG-Database, so SP1 can be installed without any errors and the BizTalk server is running fine after the installation of SP1.

I hope my answer will help anybody, please let me know 😉

 

[email protected]

[community-content]

Not enough information provided, nobody can help you. Sorry.

[community-content]

Usually you create your own Send pipeline with a flat file assembler shape.in the assemble stage. Put in your schema in the Document Schemas (Collection) property for the assembler. Deploy and set up the FTP send port using this pipeline.

Hope it works

P-O Strandell

Avega, Sweden

[community-content]

Bibi,

That is correct. You need only one property schema in your BizTalk project.
Having the same prefix in your schemas is no problem.

[Author]

Posts