[community-content]

I have one, what’s your email?

Bryan Corazza
Avanade

[community-content]

Yes, i got the same issue once.

we have a problem of no space in hard disk too…

we clened up some data and same time deleted some database tables we are not using…

stoped the biztalk services…..

and i ran Microsoft given purge script, it worked and cleaned up all tracking data.

Nar-

[community-content]

Check to see that you have the 1.1 version of the .NET framework installed on the web server – and that is enabled in IIS.

[community-content]

I have taught it many times. Hopefully you can get some students perspectives as well. I think the success of the course can depend on the instructor and how he adapts the class to the needs of the students.

I always added some of my own hands-on-labs, and usually include a few hours on the SQL adapter (which the course doesn’t even mention). But this means I have to fly through the last few chapters on BAM, Trading Partners, etc… My thought is to focus on the core features. The students should go play with those a few months then there should be an intermediate or advanced class.

The exercises are little too much \”Click here.. click here\”. Rather than telling you to go create an map that does so and so, they take you through hundreds of \”clicks\” and students usually get lost in the instructions and sometime fail to get the big picture.

I also make my own self-study videos on CD/ROM. See website below. You can save about $2000 plus travel!. I hope to come out with Biztalk 2006 videos and some more intermediate/advanced videos later this year and/or early next year.

[community-content]

You should install Biztalk Server on the client (laptop). I usually do a full install, but there might be a way to just install the minimum tools.

Here’s a quick start install guide for BT2003:
http://blogs.msdn.com/luke/articles/211384.aspx

[community-content]

Ideally, you would use the sample purge jobs provided by Microsoft.

There’s one table you can clean-up manually: dta_DebugTrace.
This table keeps track of run time of every single expression shape in every single orchestration (forever) – until you purge.

You can run this query to see how much history you have by year/month:

use BiztalkDTADB

[code:1:ec90262ef2]select datepart(year,dtTimeStamp),
datepart(month,dtTimeStamp),
count(*) as ‘rowcount’
from dta_DebugTrace
group by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp)
order by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp) [/code:1:ec90262ef2]

To clean up this database, it is suggested you run the following:

[code:1:ec90262ef2]select * from dta_DebugTrace where dtTimeStamp < ‘2006-01-01′[/code:1:ec90262ef2]

Then after confirming the results, change the “select” to a “delete”.
You could try deleting a week or a month at a time, instead of all at once.

[community-content]

and sqlagent is running and so are all the jobs. biztalk backup is also running. I have also scheduled a job which shrinks both these dbs but the size still increases after a little while.

[community-content]

Hi lisa,

After looking at the log file that was produced by the installer, it seems to me that BTSInstaller wasn’t able to deploy the Biztalk Projects in the right order. I have made an alternative solution and that is to put one of the pre-requisite Biztalk Project dll on the Global Assembly Cache and somehow it worked but I still need to test this on other machine just to make sure that the effect is the same for all machines. I’ll let you know if it works on other machine.

Thank you very much 🙂
fred

[community-content]

We reported this problem to Microsoft, here is their solution:

strProcessId = System.Convert.ToString
(YourOrchestrationName
(Microsoft.XLANGs.BaseTypes.InstanceId));

YourOrchestrationName is the TypeName found in the Orchestration Properties.

This has not caused the \”stupid\” problem of the compile errors and having to touch the shape, and move it.

[community-content]

I am building a map that is a conversion from a Biztalk 2002 map. The 2002 map used a 811Schema as the source schema. The 811Schema is somewhat different than the Covast ASC_X12_811_004_010_DEFAULT_X schema in that the 811Schema has HLLoop1, HLLoop2, HLLoop3, HLLoop4, HLLoop5, HLLoop6, each nested inside the other.

The Covast ASC_X12_811_004_010_DEFAULT_X schema has a HL_Hierarchical_Level_S18 instead of the HLLoops

Is there any reference material on the HL_Hierarchical_Level_S18?

[community-content]

Hi Greg,

Thanks for the response. I did notice that the value of the last positional field in the inbound flat file is shorter than the schema defined. For instance, the last positional field of the Body schema is defined as 30, but the actually flat file data shows only few characters followed by line-feed. I am not sure how the flat file parser interprets it and what schema attributes can do anything about it. I did set \”Allow early termination\” to true, without luck.

The error indicates the parser doesn’t know when to stop parsiing the Body section of the data. It treats the Trailer as Body section, which cause the pipeline validation failed.

I tried both single schema mapping and separate Body/Trailer schema ways, but no luck yet. It could be the issue of schema attribute(s) setting. One is using single Positional Flat File schema with both Body and Trailer schema in it, and map to another XML schema file with only Body in it.
The other is using separate Body and Trailer schema, as well as custom Flat File pipeline. I was able to validate both Body and Trailer instances successfully. However, it error out when I ran through the Receive pipeline.

It seems either way is fine with inbound file having single record and trailer in it, but not with multiple records in Body section of the file.
For example:

1. Inbound file works:
Filed1a Field1b field1c …
EOF

2. Inbound file doesn’t work:
Filed1a Field1b field1c …
Filed2a Field2b field2c …
Filed3a Field3b field3c …
EOF

Any thought?

Thanks in advance,

[community-content]

There is a build order for projects contained within a solution – however it is not necessary to specify deploy order in the Installer since you are working with compiled objects. You will need to bind/start orchestrations in a particular order or if you were deploying them directly from the project – you would need to do this in a particular order, but with the installer it is not needed.

It sounds like you need one installer project – not several if the projects are interdependent. The rule of thumb should be – if they make one complete application – then they should be in one installer project.

First, copy the WHOLE BTSInstaller folder from the SDK folder into your main controlling project. Then add the BTSInstaller project as an existing item to that solution. Change all the properties as you like. Then you will need to Exclude a bunch of files that are not needed. Highlight all of the files listed in the application folder of the installer project EXCEPT BTSIAssemblyOrder.dll, BTSICustomAction.dll, btstd.xml, BindingSchema.xml.

Then you need to add each of the compiled project’s dlls into the application folder of the installer project – starting with the main controlling project dll. This should then automatically bring in the other referenced dlls automatically – but if it doesn’t – all them manually. If any of the projects are VB or C# code – then those should probably be added to a special folder – the Global Assebly Cache folder. The folder can be added to the installer project by right clicking the \”File System or Target Machine\” level in the installer and adding the \”special\” folder. Drag or add those assemblies into the GAC folder.

Build the the BTSInstaller project – then run it either through the provided Setup.exe or you can run it via command line with the option deploy = true – example: \”e:\\temp\\BTSInstaller.msi\” deploy=true

Hope this helps!

[community-content]

The HTTP 401 error is at the IIS level.
Check in IIS for the directory security on the Web Service virtual directory. The easiest fix is to allow anonymous.
Otherwise set the Biztalk send port to have matching security Basic or NTLM with appropriate credentials.

[community-content]

You will have problems if you have no tag identifier for each record. The parser does not know when to expect the trailer record.

You might find it easier to parse the entire message, including the trailer part and remove the trailer using a map.

[community-content]

Is there a possiblity that the installer compiles the project in the wrong order?

For example in my example above: BiztalkProjectA (which contains Orchestrations) calls BiztalkProjectB (which contains also orchestration) and both uses BiztalkProject C(which contains the schemas)

This means that BiztalkProjectC should be deployed first then BiztalkProjectB then BiztalkProjectA. Is there a possibility that the setup deployed the wrong BiztalkProject first thus error occurs? (Meaning BiztalkProjectC is deployed first then BiztalkProjectA then BiztalkProjectB).
If BiztalkProjectA is deployed first than BiztalkProjectB then an error may occur because BiztalkProjectA needs BiztalkProjectB to be deployed first…

Is there anyway to make sure what BiztalkProject or dll needs to be deployed first?

Thanks

[Author]

Posts