Archive for the ‘Blogs I Follow’ Category

Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

 

I am sure if were in the non-English countries, you might need to use code pages other than CP1252 to support your characters, and 1256 would your right choice for example if you been in Arab speaking countries, but this makes a problem when it comes to Analysis Cubes installation.

Once you install the Analysis Cubes and finish all wizard issues you feel like things are becoming easy and will proceed to start your job getting your cubes inititalized and then you will be start getting below errors:

Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “INTERID” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC02020F4    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The column “CMPNYNAM” cannot be processed because more than one code page (1252 and 1256) are specified for it. 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x800470C8    
Source: Copy Data from Results to CompanyMaster Task OLE DB Destination [22]    
Description: The external columns for component “OLE DB Destination” (22) are out of synchronization with the data source columns. The external column “CompanyID” needs to be updated.  The external column “CompanyName” needs to be updated. 
End Warning 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004706B    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: “component “OLE DB Destination” (22)” failed validation and returned validation status “VS_ISBROKEN”. 
End Error 

Progress: 2015-03-23 10:18:58.26    
Source: Copy Data from Results to CompanyMaster Task     
Validating: 50% complete 
End Progress 

Error: 2015-03-23 10:18:58.26    
Code: 0xC004700C    
Source: Copy Data from Results to CompanyMaster Task SSIS.Pipeline    
Description: One or more component failed validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC0024107    
Source: Copy Data from Results to CompanyMaster Task     
Description: There were errors during task validation. 
End Error 

Error: 2015-03-23 10:18:58.26    
Code: 0xC00220E4    
Source: Run Company     
Description: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run.  . 
End Error 

Warning: 2015-03-23 10:18:58.26    
Code: 0x80019002    
Source: DynamicsGP_TWO_to_DynamicsGPWarehouse_Package_Master     
Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. 
The Execution method succeeded, but the number of errors raised (6) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.  End Warning  DTExec: The package execution returned DTSER_FAILURE (1). 
Started:  10:18:57 AM 
Finished: 10:18:58 AM 
Elapsed:  0.842 seconds. 
The package execution failed. 
The step failed.

Obviously it is all about the first error, different code pages are exist and therefore your data cannot be copied from the production database to the data warehouse, going further with investigations I been able to get around this error by unifying the code page in my packages, and this is by simply allowing a flag in cubes SSIS packages to use the default code page “AlwaysUseDefaultCodePage” to be “True” and your issues will no longer be shown:

image

Now the challenge here you need to extract the packages from the MSDB store, to your Visual Studio and perform this change, save your package and re-import this back to your MSDB, this will need to be done to the following packages:

DynamicsGP_DynamicsGPWarehouse_FiscalPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_GLBudgets.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDAGroups.dtsx
DynamicsGP_DynamicsGPWarehouse_GLMDATransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_GLTransactions.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemCurrentQuantity.dtsx
DynamicsGP_DynamicsGPWarehouse_ItemMaster.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingPurchaseOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PendingSalesOrders.dtsx
DynamicsGP_DynamicsGPWarehouse_PurchaseOrderDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesDetail.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesPerson.dtsx
DynamicsGP_DynamicsGPWarehouse_SalesTerritory.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalExpense.dtsx
DynamicsGP_DynamicsGPWarehouse_TotalRevenue.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingDetails.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriodAmounts.dtsx
DynamicsGP_DynamicsGPWarehouse_AgingPeriods.dtsx
DynamicsGP_DynamicsGPWarehouse_CheckbookRegister.dtsx
DynamicsGP_DynamicsGPWarehouse_CompanyMaster.dtsx

Luckily, I found a script that makes this easier, it allows you to extract all your SSIS packages from MSDB to file system instead of pulling these one by one, it will save the packages to a folder on your “C:” drive, and all what you need to do then is copying these to your visual studio and start changing the flag, below the script:

;
WITH FOLDERS AS
(
    — Capture root node
    SELECT
        cast(PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
    WHERE
        PF.parentfolderid IS NULL

    — build recursive hierarchy
    UNION ALL
    SELECT
        cast(F.FolderPath + ” + PF.foldername AS varchar(max)) AS FolderPath
    ,   PF.folderid
    ,   PF.parentfolderid
    ,   PF.foldername
    FROM
        msdb.dbo.sysssispackagefolders PF
        INNER JOIN
            FOLDERS F
            ON F.folderid = PF.parentfolderid
)
,   PACKAGES AS
(
    — pull information about stored SSIS packages
    SELECT
        P.name AS PackageName
    ,   P.id AS PackageId
    ,   P.description as PackageDescription
    ,   P.folderid
    ,   P.packageFormat
    ,   P.packageType
    ,   P.vermajor
    ,   P.verminor
    ,   P.verbuild
    ,   suser_sname(P.ownersid) AS ownername
    FROM
        msdb.dbo.sysssispackages P
)
SELECT
    — assumes default instance and localhost
    — use serverproperty(‘servername’) and serverproperty(‘instancename’)
    — if you need to really make this generic
    ‘dtutil /sourceserver localhost /SQL “‘+ F.FolderPath + ” + P.PackageName + ‘” /copy file;”C:Packages’ + P.PackageName +’.dtsx”‘ AS cmd
FROM
    FOLDERS F
    INNER JOIN
        PACKAGES P
        ON P.folderid = F.folderid
— uncomment this if you want to filter out the
— native Data Collector packages
— WHERE
—     F.FolderPath <> ‘Data Collector’

Once you run this on your SQL Server the result will be set of commands like the below, run these commands using CMD and go to find these in your C:Packages folder:

dtutil /sourceserver SERVERNAME /SQL “DynamicsGPWarehousePackage” /copy file;”C:PackagesPackage.dtsx”

Execute these over CMD and find your files on C: drive, select all and paste the files inside your Visual Studio and start your modifications, once done import back updated packages to SQL Integration Services one by one and rerun your job.

Hope that this helps.


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Visit link:
Dynamics GP Analysis Cubes Error: The column "INTERID" cannot be processed because more than one code page (1252 and 1256) are specified for…

March 23, 2015 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 421

Slow Opening Windows In Microsoft Dynamics GP | azurecurve

I recently implemented Microsoft Dynamics GP for a client who is a UK subsidiary of an American company. … Your changes in the AutoComplete Setup window won’t take effect until the next time you log into the company. … Grieve’s about.me View Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

View article:
Slow Opening Windows In Microsoft Dynamics GP | azurecurve

March 18, 2015 · Ian Grieve · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 330

Integration Manager – Cannot Create ActiveX … – azurecurve

… Ian Grieve’s profile on LinkedIn View azurecurve’s Feed on Twitter MVP Profile View azurecurve’s facebook page View azurecurve’s Google+ View azurecurve’s Summary RSS Feed View azurecurve’s Detailed RSS Feed …

Read More:
Integration Manager – Cannot Create ActiveX … – azurecurve

March 17, 2015 · Ian Grieve · No Comments
Posted in: Blogs I Follow Total Views: 276

Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

We wanted to make everyone aware of an issue that we have come across in recent weeks.

There is an issue in the January Hotfix for Microsoft Dynamics GP that is causing SmartList Builder issues when used in the Web Client. Because of the issues in the hotfix, the Table Finder feature in SmartList Builder cannot load and it causes GP in general to fail loading. If you remove SmartList Builder

View article:
Tech Tuesday: SmartList Builder, GP Web Client, and the GP January Hotfix

March 17, 2015 · Nicole Albertson · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 243

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here: https://mbs.microsoft.com/partnersource/northamerica/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade#UpgradePaths.

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process www.Standardprocess.com, for suggesting this to me.

Enjoy!

Leslie

Original post:
Upgrade from GP 2010 to GP 2013 R2

March 17, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 277

Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

Microsoft is running Technet Update at Australian Ballroom and Exhibition Room 14 Carrington Street, Sydney on the 16th of April, 2015. Register for this event here, should be worth your time.

 

Agenda

9:00am – 10:00am

Keynote – Getting to the value of the Internet of Things

Lee Hickin – IoT Commercial Lead, Microsoft Australia 

The Internet of Everything has become a catch-all phrase to describe adding connectivity and intelligence to just about every device in order to give them special functions, from tiny devices that might travel in our bloodstream to fully automated large scale mining operations. Billions of sensors will be shipped each year and the possibilities are endless. But what should be connected? and Why? Come along to this session and hear why businesses should care about the internet of things…….and learn where the real value lies. Microsoft will lay out its vision for how businesses can best take advantage of this growing trend and how it’s cloud and Windows technologies will offer a complete end to end solution

10:00am – 10:30am

Break

Stream 1 – Windows 10

Stream 2 – Microsoft Cloud OS

10:30am – 11:30am

Windows 10 – What does the new OS mean for Enterprises?

Foundation for the Software Defined Datacenter

11:40am – 12:40pm

Windows 10 Security – What’s new?

Extending Enterprise Networks to Azure using ExpressRoute

12:40pm – 1:30pm

Lunch

1:30pm – 2:30pm

Windows 10 – Deployment

Windows Azure Pack Overview

2:40pm – 3:40pm

Windows 10 for Mobile Devices: What’s Next?

Getting started with Microsoft Azure IaaS

3:40pm – 4:00pm

Break  (Close and Prize Draw)

4:00pm – 5:00pm

Networking drinks

See the article here:
Free Windows 10, IoT and Azure Technet event by Microsoft in Sydney

March 17, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 296

Microsoft Convergence Atlanta 2015: GPPC PreGame

Hi everyone and welcome to Microsoft Convergence 2015 from the beautiful city of Atlanta, Georgia, my hometown. I really like that Convergence has called Atlanta home 4 out of the past 5 years – it also makes it pretty convenient for me to attend while sleeping in the best hotel in town: my home!

Microsoft Convergence 2015 welcome banner at Georgia Wold Congress Center

After not much convincing, David accepted my invitation to stay to be a guest for the duration of Convergence. As such, my jobs is to also make sure we get to and from the convention center on time for the numerous commitments we have this week.

On of those commitments involves attending the PreGame 2015 event hosted by Dynamic Partner Connections, held at the Westin Peachtree Plaza hotel. If you are familiar with this Downtown Atlanta landmark, you will remember it was severely damaged during the 2008 Atlanta tornado outbreak and having to replace over 5600 windows during the renovation process.

David Musgrave and Shanna Hensch

After registering for the event, we both caught up some good ol’ friends of ours and had a chance to exchange pleasantries.

From left to right: David Musgrave, John Lowther, Belinda Allen, Kim Peterson, Mariano Gomez, and Bob McAdam

While I had a session to present at PreGame, I took the opportunity to attend a 1:00 PM session, Using CRM, Office 365, Azure, and the cloud to turbocharge sales moderated by Errol Schoenfish.

Errol Schoenfish

In this session the panel conducted an interactive discussion and heard from partners that have accelerated their sales process to accommodate an ever changing sales environment. These partners are also delivering and deploying Microsoft Dynamics GP in a Cloud first world to both new and existing customers.

After the session was over, I quickly returned to the Congress Center to attend the Dynamics GP General Session rehearsal. It’s always exciting to catch up with my many Microsofties from Fargo, North Dakota.

Brian Mayer and Jodi Christiansen

It’s always cool to see the amount of prep work from the Audio and Video engineering technical staff to make these events and presentations go as smooth as possible. The guys are really engaging and always willing to accommodate pretty much any request as it relates to device connectivity and interfacing to the systems.

Add caption

Unfortunately, a confusion in schedules prevented me from participating in the actual rehearsal since tech check was being conducted from 3 – 4 PM, which encroached on my PreGame session at 4:00 PM. So, I left around 3:30 and back to the Westin.

My session, Microsoft Dynamics GP 2015 Installation and Configuration began with sharp at 4:00, with 10 partners in attendance in the room. We walked through the Microsoft Dynamics GP architecture and its evolution to today’s Web Components, including web client and Service Based Architecture. We had a chance to conduct a full install of Microsoft Dynamics GP, working through the different screens, but unfortunately, ran out of time to address Web Client implementation in full. Since Service Based Architecture depends on having a domain environment, we could not install it either. Nonetheless, a good effort was made to explain the process and what can to expect during the installation.

The session went over the allotted 2 hours and ran until 6:30 PM. I really thank the attendees for gutting it out until then. However, this type of class is suited for a half-day or full-day format.

Up next was the partner reception hosted by Microsoft on the 8th floor of the Westin. After partaking and exchanging pleasantries with many fellow business partners in attendance, it was time to attend the MVP Mingle event.

Partner Reception

The MVP Mingle is a partner sponsored event. We count with the support of FastPath, which specializes in security access and segregation of duties monitoring and compliance, and Data Masons, which develops integrated EDI solutions for the Microsoft Dynamics ERP products.

MVP Mingle

The FastPath Team: Jeff Soelberg, Liz Piteo, Nate Boettcher, Trish Boccuti, and Andy Snook

The MVP Mingle was hosted at STATS Food + Drinks, which has some great appetizers and a good selection of local, national, and foreign brews.

Having a 7:30 AM GP General Session rehearsal meant that it was time to wrap up early and drive home to get some rest for the next day.
Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read More:
Microsoft Convergence Atlanta 2015: GPPC PreGame

March 16, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 327