 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| BIUC01 Server crash??? | Login/Join |
| Platinum Member |
hi friends , One of my reports was running fine till yesterday. Today , suddenly an unexpected error occured when i tried to run the report. Unknown error occurred. Agent on reporting server BIUC01 may have crashed. Please investigate reporting server log. ERROR: This is the error. Then i checked the Master file of the report in the Metadata, cross-checked the spellings of segname and file name in it. Everything was right and in order. Am i missing something here?? Please advice.. I searched the forum for server crashes and was not able to figure out anything. WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | ||
|
| Virtuoso |
Server crashes may happen for just about a zillion reasons. Without further investigation nothing specific can be said about these situations. What I would do in this case is first restart the server (it ran OK yesterday) and nothing has changed (where did I here that phrase before....). So maybe the server situation changed for some reason, restarting it will set it back to what it was before. If that does not help, then start taking things out of your procedure to find out which piece of code is the problem. When you found that piece of code, and if it still is not clear why it may be crashing, try switch on tracing and hope that the trace contains enough information to find out what the problem is. Sorry that I can't be any more specific... GamP
| |||||||||
| ||||||||||
| Platinum Member |
hi gamp , Thanks a lot for your help. Now the weird part , few mins back our ETL team loaded the data into the tables. So this report is fetching the data. We are using two filters in this report. Whenever the filter condition does not satisfy , we display a user - friendly message ..saying blah blah. Please try again. But here, whenever the filter condition is not satisfied. Unknown error occurred. Agent on reporting server BIUC01 may have crashed. Please investigate reporting server log. ERROR: This error crops up again. Please advice.. Is there any way to handle this error through FOC_ERR variable..?? WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Virtuoso |
Again, crashes are happening for te weirdest reasons. And, once an agent has crashed, there is no more processing going on in this agent. So no, FOC_ERR is not available any more, because the agent that was running the request died. Try tracing. It may shed some light. GamP
| |||||||||
| ||||||||||
| Platinum Member |
hi gamp , I am not able to get any clue using trace.. Is there any alternative to trace?? I used ECHO = ALL.. still no clue ... WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Virtuoso |
Try SET XRETRIEVAL=OFF This allows the server to parse code without actually doing any data retrieval. Sometimes this allows me to see the code that will run and related error messages without actually crashing the agent when it tries to retrieve data. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Platinum Member |
hi fellas, Is there a possibility that this error is due to a code problem?i have done enough research on this and not able to resolve this issue?? thank you very much WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Virtuoso |
Arvind, If your fex has many DEFINE, TABLE, MATCH commands I would try the "salami" approach. Put -EXIT after the first END and see what happens. As long as all goes well, move to the next END command. At some point you will crash again. Then you might be able to determine if there is a coding problem or a data problem. Good luck! Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
Arvind, One more thing, as it's not clear that you understand tracing. ECHO = ALL is not tracing per se, it only gives you what code is being parsed and how. To turn on tracing you need to bring up the Client Server console and turn tracing components on there. Don't forget to turn tracing off afterwards as you don't want to have zillions of trace files clogging up your server(s). T
| |||||||||
|
| Platinum Member |
hi danny , tony Thanks a lot for your replies , I found out that the following where conditions are causing probs for me..These where conditions are used as listboxes in the report. WHERE PRIMARY_BPO EQ &BPT.(OR(FIND PRIMARY_BPO IN T_ORA_APPL_PLN_V)).PRIMARY_BPO.; WHERE LIFECYCLE_STAGE EQ &STATT.(OR(FIND LIFECYCLE_STAGE IN T_ORA_APPL_PLN_V)).LIFECYCLE_STAGE.; These where conditions is populated using dynamic data . But when a static where condition is used . For eg WHERE LIFECYCLE_STAGE EQ 'Maintain'; Then this error does not occur. Is there any alternative to these dynamic where clauses?? Thank you very much WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Platinum Member |
hi , I found the issue causing this error . i am getting this error in a cross tab report . In the report , we calculate the count and % count of all the BPOs in different lifecycle Stages. For the calculation of % , the count is coming in the denominator. When the count is zero for a particular case , it becomes infinity. The divide by zero problem is causing this server crash error i think .. Is there any way to resolve it ??? i am also doing research from my end..would really appreciate some guidance.. Thank you very much WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Platinum Member |
Yes. Do an IF statement to check if the denominator is 0. If it is, do not perform the calculation, and assign 0 or something to the field instead. Sean ------------------------------------------------------------------------ PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode | |||
|
| Platinum Member |
hi fellas , Thanks a lot for your help , the issue is resolved finally. It was done by Webfocus Admin.   Cheers WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Platinum Member |
hi friends , I am facing this issue again. Whenever i do SET EMPTYREPORT = ON for a cross - tab report and when the user selects the values in the listbox such that the values do not satisfy the condition , I get the below error Unknown error occurred. Agent on reporting server BIUC01 may have crashed. Please investigate reporting server log. ERROR: Unknown error occurred. Agent on reporting server BIUC01 may have crashed. Please investigate reporting server log. ERROR: Please advice Thank you very much WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Member |
May be some block of code is going in to infinite loop. Check all the conditions one by one and try to print them. | |||
|
| Platinum Member |
hi srinivask, When i remove SET EMPTYREPORT = ON , the report works fine.. and the user friendly message is displayed when the search criteria is not matched. So what could be the problem when i add the SET clause ?? Please advice WebFOCUS 714 Windows XP Output: HTML,PDF,Excel | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |