SmartView VBA function HypSubmitData works correctly when run line by line in debug mode but fails i

Summary

SmartView VBA function HypSubmitData works correctly when run line by line in debug mode but fails in run mode

Content

In the Smart view Vba code below, I am trying to load data from multiple worksheets into an Essbase application by making connecting in each worksheet & then loading the  data by using Smart View VBA function HypSubmitData. The code works correctly when I step-in through the code, line by line in the debugger. However, when I try to run the program as a whole (without debugging line by line) HypSubmitData function fails with UpLoad = 4.

As per Smart view error explanations, error code 4 implies “An error specific to the data provider or a generic error that cannot be mapped to a value."