Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Check Connector log file and see if you find any details there. Also check SAP System logs to identify issues. I found sometime better to create a view in SAP and get that view contents rather than doing a "join" query from QV.
Amir,
Have you resolved you issue trying to extract data from the MSEG table in SAP? I'm running into a very similar issue