Error message when you run the Master Package for Analysis Cubes

When running the Master Package for Analysis Cubes, you may receive the following errors:

"Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This error occurs when the number of errors reaches the number specified in.."

"73548784,0x, Executing the query "select 1 from  SystemVersion where CompanyID = ? -..." failed with the following error: "Conversion failed when converting date and/or time from character string.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

There are two methods to resolve the issue:

Method 1

If you are unable to re-deploy Analysis Cubes, then perform the following steps:

1. Open SQL Server Business Intelligence Studio and open a new Integration Services Project.

2. Right-click on SSIS Packages and choose Add Existing Package.

3. Connect to SQL and open the DynamicsGP_DatabaseName_GLTransaction package.

4. Open the Calculate Retained Earning Balances step and change the following:

Original:

' + char(39) + 'Empty' + char(39) + ' as OrigMasterID,' + char(39) + 'Empty' + char(39) + ' as OrigMasterNo,1 as PeriodID,' + char(39) + convert(char(4),@FY) + char(39) + ' as FiscalYear,' + char(39) + 'Empty' + char(39) + ' as [Description],' + char(39) + 'Empty' + char(39) + ' as OrigDocumentNo,' + char(39) + convert(datetime,getdate(),101) + char(39) + ' as DWTimeStamp,0 as SeqNumber, 0 as LinkNumber,

Modified:  

' + char(39) + 'Empty' + char(39) + ' as OrigMasterID,' + char(39) + 'Empty' + char(39) + ' as OrigMasterNo,1 as PeriodID,' + char(39) + convert(char(4),@FY) + char(39) + ' as FiscalYear,' + char(39) + 'Empty' + char(39) + ' as [Description],' + char(39) + 'Empty' + char(39) + ' as OrigDocumentNo,' + char(39) + cast(getdate() as varchar(20)) + char(39) + ' as DWTimeStamp,0 as SeqNumber, 0 as LinkNumber,

Note

The "convert(datetime,getdate(),101)" was changed to "cast(getdate() as varchar(20))".

5. Click File | Save As and save a copy of the package to the desktop.

6. In SQL, rename the current "DynamicsGP_DatabaseName_GLTransaction" package.

7. Right-click on the DynamicsGPWarehouse and choose Import Package.

8. Import the package you just saved and then test running the full job or the master package.

Method 2

If you are able to re-deploy Analysis Cubes, then please contact Microsoft Support to obtain an updated “GLTransactions.dtsx” file. Once you have received the file, perform the following steps:

 1.  Uninstall Analysis Cubes using the steps found here:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/08/02/steps-to-uninstall-analysis-cubes

 2. Install fixed package:

a.  Copy the updated “GLTransactions .dtsx” file received from support, into the following location on the computer where the Analysis Cubes Configuration Wizard is located:

C:\Program Files\Microsoft Dynamics\Analysis Cubes for Microsoft Dynamics GP Server\SQL\SSIS\

b. Choose "Yes" when asked to overwrite. The files in this folder will be used during the installation and imported into SQL server as the SSIS packages.

c. Reinstall Analysis Cubes using the Analysis Cubes Configuration Wizard.

d. Run the Master Package(s) and confirm that you do not receive the same error.