2 Replies Latest reply: Aug 22, 2014 4:01 AM by dragan dujic RSS

    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