I have created a Master Child report where my FEX is generating N number of hold files which are render as many HTML table block like below

- - - Master record
Department ID| Name |Location
1000 | Software | UK

- - - Detail records
Employee ID | Name | Salary
234622 | TNAYAK|2000
286575 | AJANA |2400

- - - Master record
Department ID| Name |Location
1001 | Hardware | USA

- - - Detail records
Employee ID | Name | Salary
289224 | PBERA |2500
286546 | MHOTA |2400

....etc



I am gettting the message "No Querry information to decode" after HTML load finished.

I am using WebFOCUS version 7.6.1

any solution ??

Thanks in advance!

This message has been edited. Last edited by: <Kathryn Henning>,

When you re-run the procedures, are you getting the output?

Can you repro with one of the sample files like CAR

Are you running this from the text editor view?

If it's a very long fex and you have the variable &QUERY_STRING enabled it tries to put the entire contents of your fex into that variable. When it reaches the limit you get that error.

Try running it from the list of procedures instead of text view. If the problem is caused by the above, it should run without issue.

I have written below FEX code for my report


SQL SQLORA SET SERVER &&CONNECTION_NAME
SQL SQLORA
EX PRC_MASTER '&ID','&a' ,'&b' ;

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HOLD1
END


SQL SQLORA SET SERVER &&CONNECTION_NAME
SQL SQLORA
EX PRC_CHILD '&ID','&a' ,'&b';

TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS HOLD2
END

I faced the same due to IE settings & organisational restrictions for SSL. So, please answer to the questions asked earlier.

Is your stored procedures adhering to IBI rules?

This message has been edited. Last edited by: Rifaz,

I have resolved the problem using pagig in the reporting page