My SYSENV/CFG_OIBRW record looks like:

<1>.

<2>

<3>

<4>65

<5>1

<6>RTI_BRW_FILTER

<7>

<8>

<9>

My Code looks like:

If Continue Then

     * send to the UI for preview ..

     outputName = ""

     reportType = "PRINT"

     bUseGUI = "2"

     activate_save_select(SaveListName)

     If All = True$ Then reportName = "*"

     

     rslt = RTI_BRW_GENERATEREPORT(reportGroup, reportName, outputName, reportType, "", "", bUseGUI, "")

End

At the call to rti_brw reportGroup = "CLIENT_SCREEN" and reportName = "*"

CLIENT_SCREEN is a group with 'CLIENT Screen1', 'CLIENT Screen2', 'CLIENT Screen3' and 'CLIENT Screen4'

The report only builds the first report .. I can run each of the reports separately but not as a group.

What am i doing wrong?

Hi, Dave. Thanks for posting your CFG_OIBRW record. I think it could be one of two things:

1. Generating the "print" output may be problematic for multiple outputs, since OIPI really only outputs one thing at a time. If you ask the output to be generated as PDF, instead, does it work?

2. Otherwise, I suspect it may still be a problem with trying to use the same engine, but I'm not sure. As before, if you issue the same command at TCL (rather than in a stored procedure, which by definition is running and thus 'blocking' the oengine from processing anything else), does it behave the same way?

Please let me know what you find.

Thanks!

- Bryan Shumsky

Revelation Software, Inc.

Where does it put the PDF file? I can't find anything in oi10 root nor is there anything in the brw generate report document

never mind

If i run it through TCL as a pdf I only get the HEADING for the first report. No Data.

If I do a pdf in the proc .. i get the first report printed complete with data but not the other 3

What else can I try?

If i run it through TCL as a pdf I only get the HEADING for the first report. No Data.

If I do a pdf in the proc .. i get the first report printed complete with data but not the other 3

What else can I try?

Two things I can think of.

1. The fact that you only get the heading makes me wonder whether the report is 'crashing' for some reason - but you do say that you can run them each individually, right? Otherwise, I'd suggest (as a test) making a new report group that contained 3 extremely simple reports, just to make sure it wasn't something in the report(s) themselves;

2. Rather than using the direct connection to the OEngine, if you're running an engine server, we could change your CFG_OIBRW to tell it to talk to the engine server. That will definitely "spin up" another, different oengine, and the various questions about "contention" should be eliminated…

- Bryan Shumsky

Revelation Software, Inc.

Tried a new report group with 2 reports very simple. Id and Name. Same results as before where TCL creates a 1 page pdf with no data. Proc creates a 1 page pdf with data. Second report does not appear

Will try to figure out how to call a local engine

Tried using local eserver engine but got no response either Proc or TCL.

SysEnv/CFG_OIBRW

<1><URL> LOCALHOST

<2><PORTNO> 18088

<3>

<4>

<5>

<6>RTI_BRW_FILTER

I got the port number from the startup information that is posted to the window.

2020-03-20 10:21:03:986 - EngineServer started on port 18088

log is giving me this …

Failed to connect to OpenInsight with specified connection parameters - <URL>127.0.0.1/<PortNo>18088/SSOFT/SSOFT/tknB9B237C9C6AE1E4CB67297D9C2063152

log is giving me this …

Failed to connect to OpenInsight with specified connection parameters - <URL>127.0.0.1/<PortNo>18088/SSOFT/SSOFT/tknB9B237C9C6AE1E4CB67297D9C2063152

Hi, Dave.

Since you say this is in the log, do you mean you're running this as the EngineServer service? I think you'll find it's easier to run this in 'debug' mode - if you're using OI 10.0.8, there should be a shortcut called "EngineServerDebug.bat" that can start it up for you in debug mode.

Second, do you have the LITERAL STRING "<URL>" and "<PortNo>" in your fields? They are example/explanations/"help text" of what goes in those fields, NOT the characters you're supposed to type. So if they're present, they should be removed, and field 1 of your CFG_OIBRW should just be "localhost" (no quotes), field 2 should just be "18088" (no quotes).

Let me know how that works out.

- Bryan Shumsky

Revelation Software, Inc.

1) No I am running it from a bat file in dbug mode.

2) I thought about that and removed the URL and PortNo but still with no results

could it be a rights issue trying to log onto the engine?

could it be a rights issue trying to log onto the engine?

Hi, Dave. No, I don't think so; that might stop an oengine from "spinning up", but you should still see some "chatter" in your engine server DOS window (of course, that means the bat file should have a command similar to:

java -jar oesocketserver.jar -d 3)

Instead, maybe you have a firewall that is blocking access on that port?

- Bryan Shumsky

Revelation Software, Inc.

i turned off the firewall and no connection chatter. think i have a bum system.

Last time i tried the monitor web pages worked.

1) Can anyone use the config in the manual to print multiple reports to a local engine. Not a service engine but to the local running engine as doc'd?

1) Can anyone use the config in the manual to print multiple reports to a local engine. Not a service engine but to the local running engine as doc'd?

I was finally able to try this and I'm getting the same results as Dave. I used the EXAMPLES app so I could also replicate the exact same reports (just two for simplicity), configuration, and test code in OI 9. Everything works as expected in OI 9:

1. If I print preview, the first reports previews. I close the preview then the second report previews.
2. If I print to the printer, both reports print automatically.
3. If I print to a PDF file, I get two PDF files (e.g., BRW_1.pdf and BRW_2.pdf).

In OI 10:

1. If I print preview, only the first report previews.
2. If I print to the printer, only the first report prints.
3. If I print to a PDF file, only the first PDF file is produced. However, it does append "_1" as if it knows there should be more than one report.

I also discovered what I think it a new BRW bug in OI 9. I will test further and report in the OI 32 forum. But just FYI: I created my first report, saved it to a group, and stayed in the BRW Designer. I then started a new report but the wizard dialog for picking a data source is empty. I have to close the BRW Designer and re-open it in order for my data sources to reappear.

Don Bakke

SRP Computer Solutions, Inc.

Don, Thanks very much for your testing .. that is the exact results I am getting (not testing in 9 though).

ALSO .. at times I try to create a new report in same group and fields all disappear OR data sources disappear.

Hi, Dave. Sorry for apparently "gaslighting" you - I had it down to test on Monday, and Don has beaten my to it. I'll take a look and see if I can figure out what's broken…

Thanks!

- Bryan Shumsky

Revelation Software, Inc.

I just figured it was social distancing … :smile:

I *know* that something like this will bug you until it is fixed … just let me know if there is anything I can do to help or test or …

View this thread on the Works forum...