2639011 - BPC-MS:Error when executing Data Manager package: ExecuteNonQuery: CommandText property has not been initialized

When executing a Data Manager Package, the following error is displayed in the results:

ExecuteNonQuery: CommandText property has not been initialized

Upon inspecting the tbllogs, the following error is found:

==============[System Error Tracing]==============

[System  Name] : DM

[Message Type] : ErrorMessage

[Job Name]     : DumpLoad.RunDumpLoad

[DateTime]     : 05/02/2018 09:12:49

[UserId]       :

[Exception]

    DetailMsg  : {System.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initialized

   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at OSoft.Services.Platform.SysAdminDataBaseDM.SQLDataHelper.ExecuteNonQuery(String sQuery)

   at OSoft.Services.Platform.SysAdminDataBaseDM.DataSwitch.ExecuteNonQuery(CommandType commandType, String sQuery)

   at OSoft.Services.Application.DataMgr.Task.Main.DataBaseNonCom.ExecuteNonQuery(String sQuery)

   at OSoft.Services.Application.DataMgr.Task.Main.DumpLoad.ImportIntoCube(Boolean bToFac2)

   at OSoft.Services.Application.DataMgr.Task.Main.DumpLoad.RunDumpLoad(String& strQuickImportStatus)}

==============[System Error Tracing  End ]==============

The error occurs only with certain models.

• SAP Business Planning and Consolidation version 10.x for Microsoft

KBA , EPM-BPC-MS , Microsoft Version , Problem