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
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
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
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
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
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
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
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
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 </QUOTE> View this thread on the Works forum...