Skip to Content
Former Member
Nov 25, 2015 at 10:31 AM

ExecuteNonQuery: CommandText property has not been initialized


BPC / SQL2012

Hi all

When we try to import data in the DM we get the following error message. It looks like data has been processed but in fact no data is uploaded

Anyone able to assist?

Br Alan

==============[System Error Tracing]============== [System Name] : DM [Message Type] : ErrorMessage [Job Name] : DumpLoad.RunDumpLoad [DateTime] : 11/25/2015 11:25:51 [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 asyncWrite) 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 ]==============


Capture.JPG (16.8 kB)