{{tag>category:"O4W" author:"Richard Richter" author:"bshumsky" author:"Barry Stevens"}}
[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]
==== Create Report Error (O4W) ====
=== At 09 SEP 2021 07:52:58AM Richard Richter wrote: ===
I'm trying to create a report in OI 10.0.8.1 in Windows 10. After clicking on O4W Reporter/Create the Report Definition Wizard opens. I have an existing RList statement that I want to use so I enter the name of the report and the RList in the appropriate boxes. The RList is:
LIST TRAINS WITH TYPE_XLATE [] "locomotive" BY LOCOMOTIVE_TYPE BY DCC BREAK-ON LOCOMOTIVE_TYPE BREAK-ON DCC_XLATE KEY NAME MANUFACTURER_XLATE RAILROAD_XLATE LOCOMOTIVE_TYPE DCC_XLATE CATALOG_NUMBER ROAD_NO T ID-SUPP
I get the following error message: "Error: Invalid Call to O4W_READ (2)".
The RList statement works perfectly in OI. What am I doing wrong?
Richard Richter
----
=== At 09 SEP 2021 08:27AM bshumsky wrote: ===
Hi, Richard. When you go into the O4W Report/Create the Report process, and you put in your TCL statement, do you get the error right away? Or do you go through the whole rest of the report definition process (which should be prompting you for a whole bunch of things, like overall report layout, specific column information, etc.)?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
----
=== At 09 SEP 2021 05:14PM Richard Richter wrote: ===
Hi, Richard. When you go into the O4W Report/Create the Report process, and you put in your TCL statement, do you get the error right away? Or do you go through the whole rest of the report definition process (which should be prompting you for a whole bunch of things, like overall report layout, specific column information, etc.)?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
Hi Bryan,
Hope you had a great vacation.
Right after I enter the TCL statement and click on NEXT I get the message.
Richard Richter
----
=== At 10 SEP 2021 08:49AM bshumsky wrote: ===
Hi, Richard. What is the application you're in when you do this? And, if you go to the Settings/IDE Settings/Engine Server settings in the menu of the IDE in that application, what values do you show for the engine server URL, engine server port, and virtual directory to use?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
----
=== At 10 SEP 2021 09:21PM Richard Richter wrote: ===
Hi, Richard. What is the application you're in when you do this? And, if you go to the Settings/IDE Settings/Engine Server settings in the menu of the IDE in that application, what values do you show for the engine server URL, engine server port, and virtual directory to use?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
I'm in Chrome running the O4W Reporter application Create/Modify OpenInSight for Web: Report Definition Wizard.
Network Settings:
Engine Server URL localhost
Port Number 18088
UTF Port Number 18089
WebServer Port Number 18888
CommandChat Port Num 18889
Virtual Directory to use TRAINS
Richard Richter
----
=== At 11 SEP 2021 08:21AM bshumsky wrote: ===
Hi, Richard. Sorry, I think I was confused - I thought you were starting this by going (in the 10 IDE) new/entity/o4w/o4w report. Instead, it sounds like you're doing this from "outside" the IDE, using a standalone browser - is that correct?
In that case, can you tell me if you're using the built-in web server (you can tell because your URL will probably talk to port 18888), or using IIS? What's the "virtual directory" you're using in your URL?
If you're using IIS, what are your registry settings for OECGI4 for that virtual directory (omitting the password, of course)? If you're using the built-in web server, what are the settings for that virtual directory in the eserver.cfg?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
----
=== At 11 SEP 2021 11:52AM Richard Richter wrote: ===
Hi, Richard. Sorry, I think I was confused - I thought you were starting this by going (in the 10 IDE) new/entity/o4w/o4w report. Instead, it sounds like you're doing this from "outside" the IDE, using a standalone browser - is that correct?
In that case, can you tell me if you're using the built-in web server (you can tell because your URL will probably talk to port 18888), or using IIS? What's the "virtual directory" you're using in your URL?
If you're using IIS, what are your registry settings for OECGI4 for that virtual directory (omitting the password, of course)? If you're using the built-in web server, what are the settings for that virtual directory in the eserver.cfg?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
Good Morning
I didn't know I could do that in the IDE. As it turns out, when I run 10 IDE) new/entity/o4w/o4w report I get the result "login response - 1Login failed-2".
I'm not sure how to differentiate between the built-in server or IIS. The URL is LocalHost.
The IIS registry settings for OECGI4 are:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
The eserver.cfg file contains:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
I hope that helps. If you need any more information, please ask.
Richard Richter
----
=== At 11 SEP 2021 05:27PM Barry Stevens wrote: ===
Hi, Richard. Sorry, I think I was confused - I thought you were starting this by going (in the 10 IDE) new/entity/o4w/o4w report. Instead, it sounds like you're doing this from "outside" the IDE, using a standalone browser - is that correct?
In that case, can you tell me if you're using the built-in web server (you can tell because your URL will probably talk to port 18888), or using IIS? What's the "virtual directory" you're using in your URL?
If you're using IIS, what are your registry settings for OECGI4 for that virtual directory (omitting the password, of course)? If you're using the built-in web server, what are the settings for that virtual directory in the eserver.cfg?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
Good Morning
I didn't know I could do that in the IDE. As it turns out, when I run 10 IDE) new/entity/o4w/o4w report I get the result "login response - 1Login failed-2".
I'm not sure how to differentiate between the built-in server or IIS. The URL is LocalHost.
The IIS registry settings for OECGI4 are:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
The eserver.cfg file contains:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
I hope that helps. If you need any more information, please ask.
Richard Richter
Richard, just a Heads-up for you.
You did not show the eserver.cfg settings, just repasted the registry settings :smile:
----
=== At 11 SEP 2021 08:45PM Richard Richter wrote: ===
Hi, Richard. Sorry, I think I was confused - I thought you were starting this by going (in the 10 IDE) new/entity/o4w/o4w report. Instead, it sounds like you're doing this from "outside" the IDE, using a standalone browser - is that correct?
In that case, can you tell me if you're using the built-in web server (you can tell because your URL will probably talk to port 18888), or using IIS? What's the "virtual directory" you're using in your URL?
If you're using IIS, what are your registry settings for OECGI4 for that virtual directory (omitting the password, of course)? If you're using the built-in web server, what are the settings for that virtual directory in the eserver.cfg?
Thanks,
- Bryan Shumsky
[url=https://www.revelation.com]Revelation Software, Inc.[/url]
Good Morning
I didn't know I could do that in the IDE. As it turns out, when I run 10 IDE) new/entity/o4w/o4w report I get the result "login response - 1Login failed-2".
I'm not sure how to differentiate between the built-in server or IIS. The URL is LocalHost.
The IIS registry settings for OECGI4 are:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
The eserver.cfg file contains:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\RevSoft\OECGI4]
"ApplicationName"="EXAMPLES"
"EngineName"=""
"FileMode"="1"
"FilePath"=""
"OILocation"=""
"ProcedureName"="RUN_OECGI_REQUEST"
"ServerPort"="18088"
"ServerURL"="localhost"
"ShutdownFlags"="1"
"StartupFlags"="65"
"SysDownPage"=""
"UserName"="EXAMPLESO4W"
"UserPassword"=""
I hope that helps. If you need any more information, please ask.
Richard Richter
Richard, just a Heads-up for you.
You did not show the eserver.cfg settings, just repasted the registry settings :smile:
#Thu JUN 17 07:28:03 EDT 2021
Statistics_Output=localhost\:18090
Statistics_Directory=stats
SystemMonitorTime=3600
WebServerDefaultPage=start.htm;start.htm;start.htm;start.htm;start.htm;start.htm;oecgi4.exe/O4W_RUN_DASHBOARD?GRAPHID\=STATS_DASHBOARD_DAY
//CommandPort=18887
WebServerConnection_TRAINS=TRAINS,RPRO4W,Wypsomf1\!,,,,,Trains,,,
Statistics_Output_Disabled=1
WebServerConnection_default=EXAMPLES,EXAMPLESO4W,Wypsomf1\!,65,1,RUN_OECGI_REQUEST,,,1,,
IdleCheck=60
WebServerConnection_examples=EXAMPLES,EXAMPLESO4W,EXAMPLES_O4W,65,1,RUN_OECGI_REQUEST,,,1,,
MaxConnections=0
Procedure_=JD3_LISTENER
Procedure_1=REVCMD_LISTENER
ShutdownFlags=1
WebServerVirtualDirs=o4w;examples;console;TRAINS;CD;DVD
SystemMonitor=RTI_OEMONITOR_CLEANUP,SYSPROG,SYSPROG,SYSPROG;RTI_OEMONITOR_INDEX,SYSPROG,SYSPROG,SYSPROG
EControlPassword=oq19usRJ5UuBvTNyudv/H/7soWoRIq0k
KeepAlive=0
MaxRunTime=0
PortNumber=18088
MaxEngines=10
WebServerConnection_CD=CD,RPR,Wypsomf1\!,65,1,,,I\:\\OINSIGHT10 DATA BACKUP\\9-4-2020\\DVD,1,,
UTFPort_Disabled=1
WebServerPortNumber=18888
Statistics_Input=18090
IdleTimeout=15
WebServerVirtualPaths=o4w;o4w;o4w;o4w;o4w;o4w
Statistics_Input_Disabled=1
MaxUpTime=0
WebServerCGIProcedure=oecgi4.exe;oecgi3.exe
Statistics_ID=MAIN
StartupFlags=65
WebServerConnection_DENT=,,,65,1,,,,1,,
//=Process to run for mode -1,0,2 at 'idle check'
Statistics_Days=14
UserName=
WebServer_Disabled=0
WebServerConnection_DVD=*,*,*,1,1,,,,1,,
WebServerConnection_o4w=SYSPROG,OICONSOLE,*,65,1,RUN_OECGI_REQUEST,,,1,,
CommandPort_Disabled=0
//WebServerConnection_examples=
WebServerDynamicConnections=1
WebServerConnection_console=SYSPROG,OICONSOLE,*,1,1,,,,1,,
WebServerConnection_*=*,*,*,1,1,,,,1,,,,0
Richard Richter
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=FBD53D8D94F55C4496D4F99C1B255700|View this thread on the Works forum...]]