We have a site that is encountering the following error when trying to launch the BRW (OI 9.4):

Error: connection to OI host failed

We haven't been able to connect to investigate directly. However, the client reports that the OEngineServer (which is running from the command line) does show activity when the report is ran. No errors are reported and EngineStarted is *true*.

Suggestions on what to look for?

Don Bakke

SRP Computer Solutions, Inc.

We have a site that is encountering the following error when trying to launch the BRW (OI 9.4):

Error: connection to OI host failed

We haven't been able to connect to investigate directly. However, the client reports that the OEngineServer (which is running from the command line) does show activity when the report is ran. No errors are reported and EngineStarted is *true*.

Suggestions on what to look for?

Don Bakke

SRP Computer Solutions, Inc.

Hi, Don. What does their brw cfg record look like? Remember to check both the global and app specific records…

Do they have a sufficient number of licenses to accommodate both their users and the brw consumption of another license?

Depending on how the brw is trying to communicate to OI, you might then have to also make sure the port is open for the engine server.

Those are the things to check first.

Thanks,

- Bryan Shumsky

Revelation Software, Inc.

Hi Bryan,

Hi, Don. What does their brw cfg record look like? Remember to check both the global and app specific records…

There is only one CFG_OIBRW record and it is keyed to this app:

<1> localhost

<2> 8088

<3> 

<4> 

<5> 

<6> RTI_BRW_FILTER

Do they have a sufficient number of licenses to accommodate both their users and the brw consumption of another license?

This is on a test server so only one developer is testing it at a time and this license supports 40 users.

Depending on how the brw is trying to communicate to OI, you might then have to also make sure the port is open for the engine server.

The firewall is turned off. netstat shows that port 8088 is LISTENING. The Process ID that owns this connection is the same Process ID that appears in the Task Manager for the process "OpenJDK Platform binary (32 bit)".

Also, as previously noted, when running the BRW there is activity that appears in the console. It is obvious that _some_ connection has been made. For instance, I see the settings coming through, the "About to create engine", the "About to create queue", "EngineStart is *true*", "Returning …", and "Writing response …" commands being displayed.

Since my original post, I've been able to connect to see for myself what is happening. All of the above is what I was able to confirm first hand.

I've played around with other CFG_OIBRW settings. If I use Direct Connect mode, I do get the BRW report preview to appear and no errors are returned. However, the report is completely empty. Even the labels don't appear.

If I open the report in the BRW Designer and do a Test Run or a Preview, I get the whole report.

Don Bakke

SRP Computer Solutions, Inc.

Hi, Don. Apologies, when I first read the posting I thought it said there was NOT any activity in the engine server window.

Do they attach tables dynamically in their app?

- Bryan Shumsky

Revelation Software, Inc.

Hi, Don. Apologies, when I first read the posting I thought it said there was NOT any activity in the engine server window.

Do they attach tables dynamically in their app?

- Bryan Shumsky

Revelation Software, Inc.

Bryan, no worries. I had wondered the same thing, but no, they do not dynamically attach tables. To keep things simple, the report is bound to a sample table with only one record. This table is defined in the DBT.

Don Bakke

SRP Computer Solutions, Inc.

Anything "special" about this sample table? Any mfs or anything?

Conversion code on the dictionary (s)?

- Bryan Shumsky

Revelation Software, Inc.

Anything "special" about this sample table? Any mfs or anything?

Conversion code on the dictionary (s)?

- Bryan Shumsky

Revelation Software, Inc.

Not that I can tell. It is a copy of a producton table so there are a lot of data and calculated columns. However, there is no MFS and there are only two columns with any kind of conversion. Both are MD2. The report itself is also just a test report. Only 5 data fields and a label.

I'll create a new test table from scratch and see if that makes a difference.

I can't shake the feeling that the connection error is related to the blank report. I also played around with the UTF8 switch and when UTF8 is enabled, I get a different error in my code:

Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. (An established connection was aborted by the software in your host machine)

Perhaps this is expected, but I wanted to share just in case.

Don Bakke

SRP Computer Solutions, Inc.

Bryan and I took this issue offline. After much trial and error we discovered that the problem was due to the absence of the "mode=" setting in the eserver.cfg file.

The reason this setting was removed was because the client assumed that the absence of this setting would be treated the same as "mode=" (i.e., mode is set to nothing). That is not altogether correct. The absence of a mode setting is supposed to default mode to 0, rather than nothing. Even so, Bryan believes that the OEngineServer should have still worked better than it did. In his OI 10 environment it does. In a couple of my OI 9 environments it doesn't.

So, the moral of the story is to always keep the "mode=" setting in your eserver.cfg file, at least with OI 9.

Don Bakke

SRP Computer Solutions, Inc.

View this thread on the Works forum...