Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading ITOB View from SAP

Hello,

I am trying to load ITOB View into one of my applications, but I have Problems with loading the data. I first tried to load all fields with SQL Select * from ITOB; Afterwards I tried only to load 3 fields, but the result is always the same.

That is the script in Qlikview Management console:

2014-07-16 11:02:05) Information: Reloading..........

(2014-07-16 11:03:06) Information: Slow down logging. Log every <300> seconds.

(2014-07-16 11:03:06) Information: Reloading

(2014-07-16 11:08:19) Information: The Source Document reload complete. DocumentPath=D:\Qlikview\45 Development\Übergreifend\01 QVD Extraktor\ITOB.qvw

(2014-07-16 11:08:19) Information: Memory Allocation Delta for this file=9.33 Mb. Available Physical Memory Before Reload=70100.87 Mb. Available Physical Memory After Reload=69024.23 Mb. Total Physical Memory=69024.23 Mb.

(2014-07-16 11:08:20) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\45 Development\Übergreifend\01 QVD Extraktor\ITOB.qvw.

(2014-07-16 11:08:20) Information: Closing the document.

(2014-07-16 11:08:20) Information: Closed the QlikView Engine successfully. ProcessID=11900

(2014-07-16 11:08:22) Error: The task "SAP Extraktor ITOB Tabelle" failed. Exception:

(2014-07-16 11:08:22) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\45 Development\Übergreifend\01 QVD Extraktor\ITOB.qvw.

(2014-07-16 11:08:22) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2014-07-16 11:08:22) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-07-16 11:08:22) Error:    --- End of inner exception stack trace ---

(2014-07-16 11:08:22) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2014-07-16 11:08:22) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-16 11:08:22) Error:    --- End of inner exception stack trace ---

(2014-07-16 11:08:22) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2014-07-16 11:08:22) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2014-07-16 11:08:22) Information: Task Execute Duration=00:20:22.5412344

(2014-07-16 11:08:22) Information: Sending Alert mail

(2014-07-16 11:08:22) Error: Exception=System.FormatException: The specified string is not in the form required for an e-mail address.

(2014-07-16 11:08:22) Error:    at System.Net.Mail.MailAddressParser.ParseDomain(String data, Int32& index)

(2014-07-16 11:08:22) Error:    at System.Net.Mail.MailAddressParser.ParseAddress(String data, Boolean expectMultipleAddresses, Int32& index)

(2014-07-16 11:08:22) Error:    at System.Net.Mail.MailAddress..ctor(String address, String displayName, Encoding displayNameEncoding)

(2014-07-16 11:08:22) Error:    at System.Net.Mail.Message..ctor(String from, String to)

(2014-07-16 11:08:22) Error:    at System.Net.Mail.MailMessage..ctor(String from, String to)

(2014-07-16 11:08:22) Error:    at QDSMain.Support.MailItem.Send(ILogBucket i_LogBucket)

(2014-07-16 11:08:22) Information: TaskResult.status=Finished

(2014-07-16 11:08:22) Information: Notifying all triggers of new state:FinishedWithErrors

(2014-07-16 11:08:22) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2014-07-16 11:08:22) Information: Saving Task Result

Can anyone help?

Thank you and best regards


2 Replies
yfe
Contributor III

Re: Loading ITOB View from SAP

Please provide the QVW logand the SAP connector log.

Not applicable

Re: Loading ITOB View from SAP

Hello,

I managed a workaround with other Tables.

Thank you