Hi,

What's wrong in this code, when i have the TEST_RESULT field in the heading, whole server got hung, YES the server got hung.

I'm in 8.1.05.

  
TABLE FILE CAR
SUM SALES COUNTRY NOPRINT
ACROSS COUNTRY
COMPUTE TEST_RESULT/A30 = 'pass' ; 
HEADING
"Test Results <TEST_RESULT " -* this line is the culprit
END

Are you able to reproduce?

This message has been edited. Last edited by: <Emily McAllister>,

Weird.

I got this on 8.1.05 too:

 
  <?xml version="1.0" encoding="UTF-8" standalone="no" ?> 
- <ibfsrpc _jt="IBFSResponseObject" language="EN" localizeddesc="Abnormal termination of reporting server agent (Crashed or extreme operator kill)" name="runAdHocFex" returncode="32027" returndesc="IBFSException 32027: local error" subreturncode="0" subsystem="" type="simple">
- <ibfsparams size="7">
  <entry key="fexContent" value="TABLE FILE CAR 
SUM SALES COUNTRY NOPRINT 
ACROSS COUNTRY 
COMPUTE TEST_RESULT/A30 = 'pass' ; 
HEADING 
"Test Results <TEST_RESULT " -* this line is the culprit 
END" /> 
  <entry key="comp_pass" value="****" /> 
  <entry key="args" value="<?xml version="1.0" encoding="UTF-8" standalone="no"?><rootObject _jt="HashMap" loadFactor="0.75" threshold="12"></rootObject>" /> 
  <entry key="nodeName" value="__null" /> 
  <entry key="path" value="IBFS:/WFC/Repository/vesir218/std_reports/dev" /> 
  <entry key="applications" /> 
  <entry key="comp_user" value="__null" /> 
  </ibfsparams>
- <ibfserrorvalues size="3">
  <entry key="appName" value="vesir21815" /> 
  <entry key="edaNode" value="UNICODE" /> 
  <entry key="MSG" value="local error" /> 
  </ibfserrorvalues>
  </ibfsrpc>

 

Logged in the case with IBI, will update here if i get any updates.

Do you need the COMPUTE after the ACROSS?


This works:

 
TABLE FILE CAR
SUM SALES
COMPUTE TEST_RESULT/A30 = 'pass' ;  NOPRINT
 COUNTRY NOPRINT
ACROSS COUNTRY
HEADING
"Test Results <TEST_RESULT " -* this line is the culprit
END


 

There are a few things I don't understand about this example. Why do you SUM COUNTRY and then NOPRINT? Could you tell us what you're trying to accomplish?

I'm managing the infrastructure here, so the user(developers) is complaining about this issue, not sure about the COMPUTE field.
Please go ahead and remove COUNTRY from NOPRINT, see what you get in 8.1.05

If your developer is typing this code in, then he should consider doing it the way Ricardo suggested: SUM xxxx COMPUTE yyy BY zzz ACROSS abcd

If this is something the GUI is generating, then you should ask him how he managed to do it step by step and report the problem to IBI. Even though sometimes you can get away with putting the syntax in different order, ideally, coding it the documented way is how you avoid this problem.

If you are going to create a COMPUTE for use in a Heading, you need to hold the data 1st. COMPUTE is a row-based column created AFTER the data is pulled.
If there is a constant to go into the Heading, use DEFINE, not COMPUTE

I totally understand that I could make it work just by tweaking the code, agreed with you ALL. It makes sense if the reporting server crashes, imagine the server has got hung and back to normal after 15 to 20 minutes.

I agree. Bad code shouldn't crash the server; it should issue an error. In this particular case, I'm still wondering if this code was generated by the GUI or if your developer typed it in. I'm guessing he typed it in. Either way, it should be reported to IBI so they can address the crash.

If you comment out the HEADING, you'll see that the COMPUTEd column goes after the ACROSS, which is probably the intended behaviour for this TABLE request.

I imagine that the COMPUTE was designed to return something like 'fail' under certin conditions, with the heading displaying the 'total' result as either 'pass' or 'fail'. That would be a useful implementation and should not hang the reporting server (it does so on 8104 too).

Rifaz,
I repro'ed and also experienced the hang (didn't wait, rebooted).
1. I would notify IBI: there is no reason for this to cause a hang.
2. I would tell the user that there is no sense to his/her request.

However if it really is necessary then use a HOLD file, something like this:

TABLE FILE CAR
SUM SALES COUNTRY NOPRINT
ACROSS COUNTRY
COMPUTE TEST_RESULT/A30 = 'pass' ; 
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD
END
TABLE FILE HOLD
PRINT 
-REPEAT #VALS FOR &I FROM 1 TO 5;
-SET &J=IF &I LE 9 THEN '0' | &I ELSE &I;
E&J
-#VALS
TEST_RESULT NOPRINT
HEADING
"Test Results <TEST_RESULT " 
END

Points taken
1. To use the meaningful heading display (or) to understand the intention of having a heading display like above.
2. Logged in the case with the IBI already.

Thanks All

Hi,

Do you have case opened for this ?

Even we are facing the same problem with pdf output. There is no issue with WF7 but WF8104 is getting hung and taking max of CPU utilization. There is a outstanding porduction issue on this. If you have iputs here please do share.
Did moving the Awaiting response. Thank you.
With Rgards;
Rao

WebFOCUS 7.7.05 and 8.x
Windows, All Outputs

No luck, you can tweak the code as a workaround in 8104. Case is in Product Division