jan 21 anders jeppesen blog Microsoft CRM Microsoft CRM 2011 Scribe T-SQL

Issues when importing attachments with Scribe to CRM?

I became aware that when doing a normal Query against a SQL database with my binary attachment data like SELECT * FROM ATTACHMENTS It only took the first 128K of data from the column with the binary….that’s an issue when there is attachments in the size of 5+ MB :-). The solution was to break…

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 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

dec 8 anders jeppesen Microsoft Windows Server

Boost network tranfer between windows server

Hi, I found a couple of easy tweaks optimizing the traffic when copying files between servers, in my lab it helped my throughput by 50%!. First add these keys to your registry: HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters Value =DisableTaskOffload Type = DWORD Data = 1 Value =EnableTCPChimney Type = DWORD Data = 0 Value = EnableTCPA Type = DWORD…

Read more

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

Check for missing index on SQL database

To get an indicator on the missing index’s on your SQL you can use the script below. It’s taken from this the MS BlogURL: http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx SELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) AS improvement_measure, ‘CREATE INDEX [missing_index_’ + CONVERT (varchar, mig.index_group_handle) + ‘_’ + CONVERT (varchar, mid.index_handle) + ‘_’ + LEFT (PARSENAME(mid.statement,…

Read more

jul 21 anders jeppesen base64 blog Microsoft CRM Microsoft CRM 2011 PI / XI SAP SAP PI SAP XI Scribe unicode

Scribe Integration using unicode and MSMQ queues

SCENARIO The issue with Scribe and unicode is right now that it’s not supported using the standard engine. That means that for example Russian and Polish letters will be auto converted into ANSI which in many cases becomes nonsense….but wait…..continue reading and you will get the solution on to solve this and still being able…

Read more

jul 16 anders jeppesen integration Microsoft CRM 2011 PI / XI SAP SAP PI SAP XI Scribe unicode

Scribe Integration between Microsoft CRM 2011 and SAP XI or PI

SCENARIOThe customer required 2-way integration between Microsoft CRM 2011 and SAP XI (During the project XI was upgraded to PI without impact on the Scribe solution).In this case we have SAP as master data for the Accounts and Products, and CRM as calculation engine for the payout to their partners.To have the same communication format…

Read more

jun 10 anders jeppesen code Scribe scripts vbs

VBS Script for moving files to a network share with credentials

Hi, I have made this script who is moving all files in folder A into folder B or a network share. The special thing here is that you are able to logon to the share is you don’t have a trust between domains or if it’s to unix, samba, etc. shares. If the destination and…

Read more

maj 15 anders jeppesen Microsoft CRM Microsoft CRM 2011 office Outlook 2003

[MICROSOFT DYNAMIC 2011] Nice to know about client rollout (Made to kick start the IT department)

Hi All, I have made a simple document regarding Microsoft Dynamic CRM 2011 Roll-out it will also apply to Microsoft Dynamic 4.0. It’s based on informations collected from other articles and based on my work with Microsoft CRM. I hope you will enjoy. This is the link to the PDF: http://www.anjep.dk/WEB/Upload/Microsoft_CRM_2011_Nice_to_know_about_the_client_to_kickstart_the_IT_department_V1.0.pdf /Anders Jeppesen

Read more