apr 4 blog

PowerShell and MSMQ – Copy messages between NON Transactional MSMQ queues

Use this script if you want to copy the messages you have in your message queue, this is only working with NON Transactional queues: # Load required dll #Setting parameters from prompt param( [string]$vQueueSourceName, [string]$vQueueDestinationName ) #Source Queue if ( [System.String]::IsNullOrEmpty($vQueueSourceName) ) { write-host “You must provide a source queue name, format like: ‘.private$sourceQueue'” exit…

Read more

apr 3 blog

PowerShell and MSMQ – Move messages between queues

Use the script below to move MSMQ messages between queues, this script will move all messages in the source queue # Load required dll [Reflection.Assembly]::LoadWithPartialName(“System.Messaging”) #Set Up Queues $vQueueFromName = “.private$scriberetry” $vQueueFromTo = “.private$scribein” #$vQueueFromName = “.private$test_in” #$vQueueFromTo = “.private$test_new” $qFrom = new-object System.Messaging.MessageQueue $vQueueFromName $qTo = new-object System.Messaging.MessageQueue $vQueueFromTo Write-Host (“COUNT OF MESSAGES IN…

Read more

apr 2 blog

PowerShell and MSMQ – Create XML message directly into MSMQ

By using the script below you can easy create a message directly into the message queue system in Windows – it’s great for debugging and testing of integrations is you need to test a Scribe DTS package [Reflection.Assembly]::LoadWithPartialName(“System.Messaging”); $queueName = ‘.Private$t_test2′; ##Define you MSMQ here! $msgLabel = ‘Message label'; ##Define your label here! $queue =…

Read more

apr 1 blog

Powershell – Execution of scripts is disabled

If you received an error similar the one below when trying to execute PowerShell Scripts: File >>FILENAME< is disabled on this system. Please see “get-help about_signing” for more details. At line:1 char:2 + & <<<< ‘.>>FILENAME<<.ps1′ + CategoryInfo : NotSpecified: (:) [], PSSecurityException + FullyQualifiedErrorId : RuntimeException   Then open your Powershell prompt and execute…

Read more

mar 16 anders jeppesen blog Microsoft CRM Microsoft CRM 2011 Scribe scripts T-SQL

Monitor Microsoft CRM Async log with Scribe

Use the script below to monitor the entries you have in the async log – you can make some rules based on how many days it have been waiting etc. SELECT TOP (10000) MAIN_FilteredAsyncOperation.name, MAIN_FilteredAsyncOperation.operationtypename, MAIN_FilteredAsyncOperation.statuscodename, (SELECT DATEDIFF(DAY, startedonutc, GETDATE()) FROM FilteredAsyncOperation WITH(NOLOCK)WHERE asyncoperationid = MAIN_FilteredAsyncOperation.asyncoperationid) AS DayDurationInQueue ,CONVERT(char(10),startedonutc,126) AS DateEnteredQueue FROM FilteredAsyncOperation AS MAIN_FilteredAsyncOperation…

Read more

mar 15 blog

Spot on why we should blog and share our knowledge!!!

Check the link and get inspired: http://blogs.c5insight.com/Home/tabid/40/entryid/324/Blogging-Naturally-make-it-a-part-of-your-day.aspx

Read more

mar 14 anders jeppesen blog Microsoft CRM Scribe

Nice free tool for MSMQ handling including seaching inside the content of the messages

I have been using this Tool for some time now when I needed to build and debug Scribe solutions and needed to create test data quite easy. There is 4 key featues I find awesome: Easy browsing through the MSMQ on the server or on a remote server Option to push a XML directly into the…

Read more

mar 13 anders jeppesen blog Microsoft CRM Microsoft CRM 2011 Scribe scripts T-SQL

HOW TO Lookup Scribe CRM adapter error messages in MSMQ based integration

OOTB it’s not possible to see the complete error message from the CRM API if you get an error in your integrations using the Scribe Console API. But the call stack is in the system, hidden inside the SCRIBEINTERNAL database. WHO TO: Open the SCRIBEINTERNAL database from SQL Studio Manager Navigate to views and Query…

Read more

mar 12 blog

MS CRM – Move data between environments easy

Check this tool if you need to move CRM data between PROD / QA / TEST and DEV!!! http://mscrmtoolkit.codeplex.com/

Read more

mar 11 blog

MS CRM 2011 – Solution deployment tool

Found this nice deployment Tool – check it out: http://thedynamicscrmblog.wordpress.com/2013/02/09/crm-solutions-importexport-tools/ Download link: http://crm2011importexport.codeplex.com/

Read more