Archive Directory Slow to Open – Powershell Moves Files to Dated Subdirectories

With BizTalk, we often archive files in a sub directory. Personally, I would rather archive to a SQL database with a database column, but that takes a little more architecture and sales. So in the meantime, many clients continue to write files to disk. There are frequently clean-up jobs that delete files over x days […]

BizTalk EDI Error – Number of included segments do not match

Error Error encountered during parsing. The X12 transaction set with id '0001' contained in functional group with id '850009661', in interchange with id '850009661', with sender id '9333516114     ', receiver id '956837686      ' is being suspended with following errors: Error: 1 (Miscellaneous error)   4: Number of included segments do not match Below is an the last […]

Error: “Invalid queue path name” Exception using MSMQ Remote Queue

If you are getting the error “Invalid queue path name” from C# or other language, it could be that when reference a remote queue, you need to add the “FormatName:DIRECT:OS:” on the front, Instead of: MyServer\private$\MyQueue Prefix it as shown below FormatName:DIRECT=OS:MyServer\private$\MyQueue For more details, see “Manabu Tokunaga blog” or “Stack Overflow”

C# Format Date for Oracle

Short blog today, below is working C# code I ran today to format and update a date in an Oracle database. My first attempt using just DateTime.Now resulted in error “ORA-01861: literal does not match format string”.

commSQL.CommandText = "UPDATE PollingTable " +
" SET DATE_POLLED = '" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + "'" + 
" WHERE ... ";