Category: Microsoft Dynamics 365

Maximum File Size Exceeded while using Export to Excel in Dynamics 365 CE


We got this error while trying to export around 70K data through export to excel in Dynamics 365 CE.

Log file gave us detail of the error i.e. Excel file exceeded size lime of 4 MB.

One workaround is to export small set of data (page wise) by applying some order criteria (either in the Grid or through Advanced Find)

Or better use the wonderful Export to Excel tool in XrmToolBox

https://dreamingincrm.com/2015/05/30/new-xrmtoolbox-plugin-export-to-excel/

It took few mins to export the records in excel and the file size was close to 19 MB.

Hope it helps..

Update/Upsert operation is not supported in non-transaction mode error in Dynamics 365 for Sales Connector of Informatica Cloud


Few weeks back while working on a migration project in which we were using Informatica Cloud’s Dynamics 365 for Sales connector, we used to get the below error while trying to perform the Upsert operation in Batch.

“In CRM WRITER_1_*_1> CCI_WRITER_1000 [ERROR] Update/Upsert operation is not supported in non-transaction mode. “

For this we had raised a support ticket with Informatica. The response we got was that this feature will be available in the new IICS Platform.

So recently we migrated to IICS from ICS and were glad to see this feature available i.e. “performing Upsert operation in Batch“.

Few other enhancements in the connector includes

Get all the details here

https://kb.informatica.com/proddocs/Product%20Documentation/6/CDI_Spring2018_ConnectorReleaseNotes_en.pdf

Hope it helps..

How we try to speed up IT projects and why it doesn’t work


I had to reblog this !

Hosk's avatarHosk's Dynamic Blog

Code not in production has no value and you don’t know if it will work, get it live in the shortest time possible #HoskCodeWisdom

How does a project get to be a year behind schedule? One day at a time. Fred Brooks

Code not being used by users is worth nothing, you to get a return on investment of creating the code only when it is being used in production by users.
People get lost in the fog of a project and forget its purpose is to create software which helps a business achieves its goals and do the activities which makes the business money.

The goal of IT projects is to create software to help a company deliver its business goals. To help the employees finish tasks and the company to be profitable.

No one cares about technology, employees want to keep their job and the business to be profitable. Technology is…

View original post 1,672 more words

“Cannot update a published workflow definition” exception in Dynamics 365


We would get this exception if we try updating an Activated Workflow using Update Request.

So basically, if we need to update the activated\published workflow i.e. Activate or Deactivate it or change the Owner of the workflow, we would need to use the SetState and Assign Request. If we try doing it using the UpdateRequest we will the above error message.

Perform specialized operations using Update

Also, we noticed that if we try changing the state from Deactivated to Activated through Update Request, it will not change the State to Activated and it will not throw an exception as well.

However, if we use Update to Change the Owner for the deactivated workflow, it works fine.

Hope it helps..

Thirty two “Microsoft’s Very Passionate” professionals thanked with giant “WALL-OF-LOVE” at Microsoft Summit!!


Happy to see my pic there. Thanks to Peter Laker and Microsoft’s Face API .

https://www.linkedin.com/pulse/thirty-two-microsofts-very-passionate-professionals-thanked-laker/

(one more reason to smile often 🙂 )

 

Sharepoint Metadata Manager and Attachment Extractor–New version released!


Newer version of the tool”SharePoint Metadata Manager and Attachment Extractor” – the best tool for managing SharePoint Document(s) within Dynamics 365 by Debajit (MVP)

Debajit's avatarDebajit's Dynamic CRM Blog

We are delighted to announce the release of the next version of our tool – Sharepoint Attachment Extractor and Metadata Manager. For readers who are new to this tool, this tool enables you to upload documents to Sharepoint with multiple metadata as well as host of other features like

    • Allows you to create and edit Metadata related to files from CRM. This version allows up to five metadata fields per entity and also provides the option to restrict the metadata values to a specific set of values or free text.
    • Dynamic adding and removal of the SharePoint section on the form of an entity just through configuration page that comes with the tool. Also you can place the SharePoint section on multiple forms for the entity.
    • Upload up to five files at one go along with the option to enter metadata for each file. Also size limit of file not…

    View original post 216 more words