Forum Replies Created
-
Posts
-
Could you please post an example, how to access a string ressource in an expression within the orchestration?
I can't find any example (maybe my google skills are not high enough :))
Did you find out why it was using that old account though? I'm having a similar issue – have a ghost account I'm seeing in the Originator SID.
Hi, you can try using System.Reflection to access the string values in your resource file from an Expression shape in your orchestration.
Good luck.
Hi Can you go to control panel and repair the Biztalk Installation once . What i can see from your logs is that some files are missing.
try to repair the setup and than configure
load the file in xml doc and than
if (doc.InnerXml.Length != doc2.InnerXml.Length)
{
return false;
}
Ensure the Windows system PATH variable has not changed to excludle or change the BIZTALK path entries.
See this post..will help you.
http://www.dotnetspider.com/…/44792-Consuming-WCF-Service-BizTalk-2010-Orchestration.aspx
yes. i have changed that. i am using this instead in the assignment. use a transform to construct SQLInsertmsg with some dummy values.
sending the actual flat file records to a location. after all this, i am getting No subscribers found. there is a send port for sql insert.
strFileNameWPath = FDGLTransactMsg(FILE.ReceivedFileName);
strFileName = System.IO.Path.GetFileName(strFileNameWPath);
FilecreatedDate = FDGLTransactMsg(FILE.FileCreationTime);
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='Filename' and namespace-uri()='schemas.microsoft.com/…/dbo&]")=strFileName;
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToGLUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='DateCreated' and namespace-uri()='schemas.microsoft.com/…/dbo&]") = FilecreatedDate;
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToGLUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='matchCount' and namespace-uri()='schemas.microsoft.com/…/dbo&]") = true;
If the Input file is not wellformed means it will not match the corresponding Schema and it will fail.
In that case you will need to create another Orchestration subscribing to the failed message and try to fix it using a .Net Helper Class method and reading each line as text and remove the special characters.
thanks…Do u have any idea if the input file is not well formed..in that case how to remove the special chars?
Functoids are used in maps,So you can apply it to a XML node(field) in the map. You cannot directly apply it to the complete file.It will be individual node based. So if you have 10 fields(10 scripting functoid with C# code to remove the special characters) each connected to its own functoid and output to the corresponding field in the Output Schema. If the structure of the Output file is same as input file without special caracters then the Input and Output Schemas in the map will be same as of the incoming file.
i have created a custom functiod using Regex which takes "string" as an input. I wanted to know how to apply this custom functiod to an input file
Why are you using XML Document?
In the message assignment shape just use this.
outmsg=Inmsg;
outmsg(FILE.ReceivedFileName) = Inmsg(FILE.ReceivedFileName);
outmsg(FILE.FileCreationTime) = Inmsg(FILE.FileCreationTime);
