2 Replies Latest reply: Nov 15, 2016 2:33 PM by Kenneth Scott RSS

    SAP connector and MSEG table load

    Amirali Vastani

      has anyone used the new SAP COnnector and tried to fetch data from the MSEG table? I get the error below when I first fetch from MKPF the header and then fetch from MSEG with only 1 filter on Material Document Year. The reload runs for 6+ hours and then quits.

       

      If I load them in 2 separate qvws then i can do that in shorter time, but when I load them together in 1 qvw MKPF loads but MSEG fails.

       

      The task "SourceETL/SAP_R3_MKPF_MSEG_MaterialDocumentHeaderFinal.qvw" failed. Exception:

      QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> System.Threading.ThreadAbortException: Thread was being aborted.

         at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

         at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         --- End of inner exception stack trace ---

         at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         --- End of inner exception stack trace ---

         at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

         at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)