Yes, SQL is not case sensitive but SSIS is. Recently we came across an issue which was very difficult to trace and find the root cause. The requirement was to update the sales data for each product. The logic was working fine for all the records and data was getting updated properly except for couple of … Continue reading SSIS is Case Sensitive
Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager to read the data from one of the excel file and load it to a table. After completing the development, we executed the package and it was successfully … Continue reading SSIS: Excel Connection Manager Error “Class not registered”
Recently, we were working on SSIS for ETL(Extract, Transform and Load) to get the data from AX and push to the staging tables. We were using linked server for AX and we were using Windows Authentication for connecting to it. While running the package from SSDT, it got executed successfully. So, we deployed the packages to … Continue reading SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”
Recently, while working on SSIS to get data from AX and putting in our staging tables, we faced a weird compatibility issue between SQL Server and SSDT version we were using. We were using database as SQL Server 2012 and SSDT for VS 2013. After completing our development, while executing the package from SSDT, it … Continue reading SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”
Recently, while working on SSIS, we came across a scenario where we had to assign multiple values to multiple variables to use them in package later. We used "Execute SQL Task" to assign those values to the variables. The SQL query we used, was returning single row with 12 columns. We wanted to store the … Continue reading SSIS: An error occurred while assigning a value to the variable
Now, we can experience enhanced performance of CRM entity page loading in Unified Service Desk(version 3.2 onwards) with the Internet Explorer Pooling feature. Unified Service Desk always maintains a pool of Internet Explorer instances for hosted controls to use. Opening a hosted control using a pooled Internet Explorer instance enhances the performance of the Unified … Continue reading USD: Performance Enhancement of CRM Entity page load
Help improve USD means Unified Service Desk sends information to Microsoft anonymously different data such as: Operating system version and bit type Web browser application and version Unified Service Desk version Number of monitors used and screen resolution of the primary monitor Device processor class and RAM details With the new version of USD released recently(USD … Continue reading USD 3.3: Help Improve Unified Service Desk
Recently, while working on SSIS we came across a situation to use parameters. We wanted to pass 2 parameters. We were using SQL Command as Data access mode in OLE DB Source Editor. After writing the query the below query: select ? from channelmaster where displaychannel=? When we clicked on parameters to provide the parameter … Continue reading SSIS: The parameter type for ‘@P1’ cannot be uniquely deduced; two possibilities are ‘sql_variant’ and ‘xml’
Recently, while developing an SSIS package we got the error "The process cannot access the file '*.ispac' because it is being used by another process". We tried to close SSDT and run it again but, we still got the same error while compiling. Then, after searching over internet, we got the solution: Go to Task … Continue reading SSIS: The process cannot access the file ‘*.ispac’ because it is being used by another process
Recently, while working on USD for one of our customer, we found a strange issue with the USD client application. We had a requirement to open a session when the agent dials a phone number using dialpad or whenever a phone call is made from agent to customer using predictive dialing. We already had CTI … Continue reading USD Product Bug(2.0 and 3.0): Session tab name not visible properly
Very Helpful 🙂
Hello friends, recently I migrated my configurations from USD 2 to USD3. After successful migration I added one action call to scan for data parameters on save event oh hosted control. I created few new hosted control of same type and there save even was working as expected.
Issue: save event was not triggering for CRM Page type hosted control.
Reason: after scratching my head around this issue for i long i thought of comparing this hosted control with other hosted control when save even was working. I create a advance find and added all fields of hosted control entity and added filter to only display details of these 2 hosted controld
- One CRM hosted control for which save event was working fine.
- Other CEM hosted control for which save event was not triggering.
When i was comparing the fields values for both hosted control I found one difference in…
View original post 80 more words
Recently, we were working on SLA. We provided necessary conditions in Applicable When and Success Criteria sections. In Success Actions section, we wanted to update Customer Record(OOB entity "contact" renamed) and clicked on Set properties as shown below: On click of it, we got "Invalid Argument" error as shown: To fix this issue, we copied … Continue reading “Invalid Argument” Error while setting properties in SLA
Recently, while opening USD after connecting to an online instance, we started getting the following error: "You are not authorized to use the application...". To resolve this issue, we assigned USD Agent and UIIAgent security roles to the user and then opened USD. This time it worked. Hope it helps !!!
Recently, we figured out a strange issue with the Real time workflow while designing it. We had designed a workflow on Phone Call entity, which was supposed to run when record status changes as well as on update of few fields on Phone Call. We had selected Execute as the owner of the workflow as … Continue reading Dynamics 365: Real Time Workflow Bug
Recently, in one of our project we were working on Unified Service Desk(USD). We did all the required configurations in our DEV environment. The configurations include Hosted controls, Toolbars, Action Calls, Entity Searches, Agent Scripts, Window Navigation Rules, Scriptlets, Session Lines. These configurations were done by multiple developers. We launched USD connecting to DEV environment … Continue reading Unified Service Desk: Actions not working
Few days back, we had a requirement to use new D365 app for Outlook for one of our customer. After setting up mailbox and Server Side Synchronization(prerequisites for using this lightweight extension), when we clicked on Settings --> Apps for Dynamics 365, we got the below screen: We waited for few minutes and again checked … Continue reading D365 app for outlook error: This app can’t be installed. The manifest file for this app is too large. It must be smaller than 32 KB.
Recently, while accessing a D365 organization on Windows tablet, we were getting the error message "Sorry, something went wrong. Please try again, or restart the app". There was no additional error details given. To get the root cause of the issue, we enabled tracing on the device. Refer this post for enabling tracing. After enabling … Continue reading Sorry, something went wrong. Please try again, or restart the app.
When we encounter issues while using D365 on tablets, enabling tracing on the device helps us to diagnose the issues. The information recorded can be analyzed to identify the source of the issue. Follow the below mentioned steps to enable tracing on the device: Go to Event Viewer(Run --> Type "eventvwr") Expand Application and Services … Continue reading Enable tracing for Dynamics 365 on Windows tablets
Recently, from Visual Studio, after connecting to CRM organization using D365 DEV toolkit, we tried to create a plugin for Contact entity. While creating, we got error message: Value can not be null, Parameter name : path. To fix this issue, we updated the path of D365 plugin registration tool and bin folder as mentioned … Continue reading Value can not be null : Error while creating plugin using D365 dev toolkit
We had a requirement to create email activity with zip file as attachment. Using other file type e.g. xlsx, docx as attachment are simple. However, using zip file as attachment is a bit different. Here's the code to create email activity with zip file as attachment: Hope it helps.