[bug] works only in debug mode

[bug] works only in debug mode

  
Hello,

I found a possible bug that stopped my work.
I have an action "action A" which returns a Structure with several fields.
One of those fields is a record list, and its always filled with null values!
(but with the correct size!)

However, in DEBUG mode and with a breakpoint in action A, this list is
successfully filled.

SS v.4.0.1.28
hub server is on a remote virtual machine.

Thank you.
Hello,

From your description, it seems the problem is in the action itself and not the execute action like you described.
Is the record list of the output structure being filled from the values of a simple query?
If so try, as a workarround, try to add this to the description of the query:
#assert fields all

Hope this helps.
Rui Eugénio
Hi,

"From your description, it seems the problem is in the action itself and not the execute action like you described."
But that way it wouldn't work *only* in debug mode as it worked.

"Is the record list of the output structure being filled from the values of a simple query?"
Yes.

"If so try, as a workarround, try to add this to the description of the query:
#assert fields all"
I tried that and it works now! :)
Using both debug and run modes.

Thank you very much!
Well,
It seems this solution was temporary, since it works only in a random way
which I'm not getting the pattern :(
Hello,

When you insert that comment did a warning started to show up?
If so, the problem is related to query optimization and is the reason why it works when debuging. When debuging an eSpace no query optimizations are done.
There was a previous bug when doing an assign from a query to a output variable of an action, which seens to me that is your case?
What version of Hub Server are you using?
Cheers,
Rui Eugénio
Hello,

"When you insert that comment did a warning started to show up?"
Yes, something like: "forcing SQL to assert..." (only when publishing, not running)

"What version of Hub Server are you using?"
HubServer v. 4.0.1.8

Thanks
Hello,

As I suspect this is an old bug that as been resolved already. If you can, please upgrade your version of hub server.
As a workaround, you can try to pass the output record list in a seasion variable for example.
Cheers,
Rui Eugénio
Thanks! I will update the server then.