Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

SAP connector and MSEG table load

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)

2 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

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.

Not applicable

Amir,

Have you resolved you issue trying to extract data from the MSEG table in SAP?  I'm running into a very similar issue