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

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

jan 23 Microsoft CRM 2011

Microsoft CRM 2011 Maintenance Job Editor

Nice tool to take care of the default maintenance job in CRM http://crmjobeditor.codeplex.com Thanks to http://www.codeplex.com/site/users/view/seanmcne  

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

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

maj 10 anders jeppesen integration Microsoft CRM Microsoft CRM 2011 SAP Scribe unicode

Scribe MVP – What's next :-)

So this is the day with the great news, I’m now a Scribe MVP The reason for my absence on the blog is also because of Scribe asI have been working on a huge integration between:– Microsoft CRM 2011 and SAP– Microsoft CRM 2011 and the National Health Insurance in Poland.We are almost done now and should…

Read more

jan 13 anders jeppesen base64 Microsoft CRM 2011 SAP Scribe T-SQL unicode

Scribe and Microsoft CRM

Hello All, It’s a while since I last had written something – but I’d like to share some experience about Scribe which I have worked a lot with the last few months on various projects. Project 1:I have completed a standard data migration for a Polish afdelig of a larger drug company, however I ran…

Read more