Kbase P20625: Actuate displays wrong dates - windows
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/04/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows 32 Intel
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
FACT(s) (Environment):
Actuate
SYMPTOM(s):
Actuate date problem
OIBroker running on Windows server
Dates are displayed with the wrong values (e.g. 31 March 1996 displays as 03 July 1998).
CAUSE:
The Progress OIB and OID processes which Actuate uses to connect to Progress databases use the default Progress startup parameter file ("$DLC/startup.pf").
Actuate can't read Progress international parameters like -E and -d, Actuate rely on the O/S settings when printing the result of a field.
So, if this file contains the "-d" or "-E" parameters (which set date format and European numeric format), Actuate not function correctly
FIX:
If you need to run both Progress clients and Actuate client with
international settings, you should avoid that Actuate processes use the same pf file that Progress use.
This is the way to do it:
PROCEDURAL APPROACH:
====================
In your startup.pf which resides in your DLC directory, you keep your international parameters.
1) Copy the startup.pf to a startup-oib.pf and remove those settings in that file.
2) Make a .cmd file like:
SET DLC=C:\DLC
SET PATH=%PATH%;%DLC%;%DLC%\bin
SET PROOIBRK=%DLC%\bin\oibrkr32.exe
SET PROOIDRV=%DLC%\bin\oidrvr32.exe
SET PROSTARTUP=%DLC%\startup-oib.pf
REM To allow OID to access the database via SHM move to DB directory
cd c:\working-dir
%DLC%\bin\oibrkr32.exe -SV -S act-serv -H localhost -N tcp
exit
3) Use this .cmd file to start your OIB environment and then you can set any "view" format in Regional Settings on your O/S.
ANOTHER APPROACH, USING Proctrl:
================================
1- Make a new entry under "OtherTasks" in Proctrl.
2- Call the cmd.exe in "Executable Name" like c:\winnt\system32\cmd
3- Set the working dir (same as database dir)
4- Call the Oib.cmd (the file explained above) from "Startup Parameters":
/c start <path>\Oib.cmd
Now you can mark the Autostart box and if you have the same on your database in Proctrl you only need to start ProSrvc (Start on Proctrl) to start your entire setup.