Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] EDA Code 35804 and BAD STATUS CODE (-12)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] EDA Code 35804 and BAD STATUS CODE (-12)
 Login/Join
 
Pascal Bellerose
Gold member
posted
Hi,

We have several alert reports launched by Report Caster around 2:00AM.

We also have some other alert reports that are launched by Report Caster every 15 minutes.

Not every nights but at least once a week we get errors between 1:00AM and 4:00AM stating an EDA Code 35804 and a BAD STATUS CODE (-12) received from a remote adapter.

The remote adapter is connected to a Full Function Server (FFS). Both the WFS and the FFS were up and running at the moment we received the error.

We suspect a problem with agents availability on the FFS side. But we don't receive any "No resource for default" notification, as we would normally when there is no more agents available.

Is there a way to collect agents usage on a server an store this statistic for trend analysis?

Thanks

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


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
A couple of things. Statistics are available from the WebFOCUS console, Workpace/Monitor/Statistics.

You could also try scrubbing EDAPRINT for information. This file is stored in /WebFOCUS/ibi/srv76/wfs/bin.

Generally a -12 indicates that there was too much data coming back from the remote server and there was a timeout. I think you would get another error if you were out of agents. If you think that is the case, you could increase your max agents a bit.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Pascal Bellerose
Gold member
posted Hide Post
Statistics are no use because I can't figure out what was the number of agents running at the time the error occured.

As for the timeout issue, the fex returns almost the same number of records each time it is run (every 15 seconds). Normally it runs without a flaw, but sometimes we get the error and not necessarily always for the same report. it could be either one of the alert reports that runs once a day around 2:00AM or it could be one of the alert reports that runs every 15 minutes.

To be more precise, we usually get this kind of error from the "once a day" alert reports. Today is the first time we get it from an alert report that runs every 15 minutes.

Thanks,


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
You can get agent usage out of EDAPRINT.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Pascal Bellerose
Gold member
posted Hide Post
Ginny,

I guess this would need programming a tool that could analyze EDAPRINT and create an history of agents usage.

Other than that, any ideas on how I could have this kind of information? Resource Management for example?

Thanks


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
With WebFOCUS you can write your own tool to analyze edaprint. Here is a sample of the contents.
quote:

08/19/2009 21:28:33 request by cmrpip021868 for explicit connect to agent (DEFAULT)
08/19/2009 21:28:33 connecting cmrpip021868 tscomid=259,sesid=21700
08/19/2009 21:28:33 processing cmrpip021868 u=xxxxxxxx,g=webfocus,l=USR
08/19/2009 21:28:34 request by t3rp1179658 to notify disconnect of sesid=21700
08/19/2009 21:28:34 disconnect cmrpip021868 tscomid=259,sesid=21700
08/19/2009 21:28:48 accepting cmrpip021869 tcp=139.51.76.101:60167
08/19/2009 21:28:48 request by cmrpip021869 for explicit connect to agent (DEFAULT)
08/19/2009 21:28:48 connecting cmrpip021869 tscomid=259,sesid=21701
08/19/2009 21:28:48 processing cmrpip021869 u=xxxxxxxx,g=webfocus,l=USR
08/19/2009 21:28:48 accepting FDS connection tcp=127.0.0.1:60168


Using a custom master and some substringing, etc. you can determine how long an agent was active per session etc. There are also some reports available from the web console but they don't seem to relate to the tscomid.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Pascal Bellerose
Gold member
posted Hide Post
GinnyJakes,

Do you have this kind of report? If so could you post the code so I can submit this to our developers?

Thanks,

Thanks,


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
No, I do not. Sorry.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Pascal Bellerose
Gold member
posted Hide Post
I have an update on the case though:

This morning I received "BAD STATUS CODE (-33)" with a EDA Code 35804.

The only info I found on the error is this case: BAD STATUS CODE (-33)
But it relates to a "LOCAL" adapter.

In my case, it is a remote adapter and the remote server kept sending "NO RESOURCE FOR DEFAULT" notifications (600 emails exactly from 2:10AM to 2:47AM)

It is the same reports that last week were crashing with a BAD STATUS CODE (-12)

Any ideas?


WFS/FFS/DM 7.6.4 / WFS/FFS/DM 7.6.8 / WFS/FFS/DM 7.6.9 / AS400 V5R4M0 / HTML / iSM 5.5sp2
 
Posts: 60 | Location: Kingsey-Falls, Québec, Canada | Registered: May 14, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
-33 User resource limit reached.

You are going to have to log onto the web console for the remote server and see what is going on. Look at agent settings and max settings. Try running your program directly from the web console.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] EDA Code 35804 and BAD STATUS CODE (-12)

Copyright © 1996-2020 Information Builders