Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
91
Tips and Techniques / Re: Creating a log file to trap system failures
« on: October 23, 2019, 10:31:19 AM »
Great!
I hope someone on this planet can do something useful that
Oct 23 16:23 [<sigterm>:0] Segmentation fault
Oct 23 16:23 [<sigterm>:0] - ERR=0 CTL=0 RET=258 LFA=0 LFO=32767
Oct 23 16:23 [<sigterm>:0] - Last path used: /u1/gui/pvx/1400/lib/_cmd/system/paste
Oct 23 16:23 [<sigterm>:0] --- Program stack ---
Oct 23 16:23 [<sigterm>:0] - STK(0) = line 00000 in <no name>
Oct 23 16:23 [<sigterm>:0] --- Files ---
Oct 23 16:23 [<sigterm>:0] - PTH(0) =
Oct 23 16:23 [<sigterm>:0] - PTH(64999) = /u1/tmp/pid-20191023-162327-27356-01.txt
Oct 23 16:23 [<sigterm>:0] - PTH(65000) = *memory*;keydef=[1:1:30:C]+[2:1:30:C]+[3:1:30:C]
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/ab/res/mawimsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/fi/res/fimsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/gd/res/gdmsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/gd/res/_msglib.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] --- Err() Info ---
Oct 23 16:23 [<sigterm>:0] Current Err:12 Prog: Stno: 64999 LFA: 1 LastPath: *udev/WINDOWS (pvxlod.c@782)
Oct 23 16:23 [<sigterm>:0] --- Stack dump ---
Oct 23 16:23 [<sigterm>:0] linux-gate.so.1(__kernel_sigreturn+0) [0xf77a9e50]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804d84a]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804c687]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804b1d6]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804adf3]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804acb5]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804aad4]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x8115bf5]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x8115b59]
Oct 23 16:23 [<sigterm>:0] /lib/libc.so.6(__libc_start_main+0xf3) [0xf7591993]
I hope someone on this planet can do something useful that
Oct 23 16:23 [<sigterm>:0] Segmentation fault
Oct 23 16:23 [<sigterm>:0] - ERR=0 CTL=0 RET=258 LFA=0 LFO=32767
Oct 23 16:23 [<sigterm>:0] - Last path used: /u1/gui/pvx/1400/lib/_cmd/system/paste
Oct 23 16:23 [<sigterm>:0] --- Program stack ---
Oct 23 16:23 [<sigterm>:0] - STK(0) = line 00000 in <no name>
Oct 23 16:23 [<sigterm>:0] --- Files ---
Oct 23 16:23 [<sigterm>:0] - PTH(0) =
Oct 23 16:23 [<sigterm>:0] - PTH(64999) = /u1/tmp/pid-20191023-162327-27356-01.txt
Oct 23 16:23 [<sigterm>:0] - PTH(65000) = *memory*;keydef=[1:1:30:C]+[2:1:30:C]+[3:1:30:C]
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/ab/res/mawimsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/fi/res/fimsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/gd/res/gdmsg.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] - PTH(65003) = /u1/koss/pgm/gd/res/_msglib.de
Oct 23 16:23 [<sigterm>:0] - Keyed file. KEY:<Start of file>
Oct 23 16:23 [<sigterm>:0] --- Err() Info ---
Oct 23 16:23 [<sigterm>:0] Current Err:12 Prog: Stno: 64999 LFA: 1 LastPath: *udev/WINDOWS (pvxlod.c@782)
Oct 23 16:23 [<sigterm>:0] --- Stack dump ---
Oct 23 16:23 [<sigterm>:0] linux-gate.so.1(__kernel_sigreturn+0) [0xf77a9e50]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804d84a]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804c687]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804b1d6]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804adf3]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804acb5]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x804aad4]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x8115bf5]
Oct 23 16:23 [<sigterm>:0] /u1/gui/pvx/1400/pxplus() [0x8115b59]
Oct 23 16:23 [<sigterm>:0] /lib/libc.so.6(__libc_start_main+0xf3) [0xf7591993]
92
Tips and Techniques / Re: Creating a log file to trap system failures
« on: October 23, 2019, 08:01:42 AM »
Can this be applied to the client side as well?
We have an increasing number of issues concerning vanishing processes while doing CSV-imports to Excel. Maybe this can put some light to such situations.
We have an increasing number of issues concerning vanishing processes while doing CSV-imports to Excel. Maybe this can put some light to such situations.
94
Programming / Re: tiny font in *browser
« on: October 11, 2019, 10:09:05 AM »
Oops, that is due to an incorrect V14 installation.
95
Programming / tiny font in *browser
« on: October 11, 2019, 10:01:56 AM »
We create simple HTML-files and let them display in the *browser control.
The contents are as simple as: <html><p>Test Test Test</p></html>
The control uses a very very tiny font, which makes text unreadable.
Is it necessary to use <font> or is it possible to adjust the standard font size for the control somehow?
The contents are as simple as: <html><p>Test Test Test</p></html>
The control uses a very very tiny font, which makes text unreadable.
Is it necessary to use <font> or is it possible to adjust the standard font size for the control somehow?
96
Programming / locale settings in chromium browser
« on: August 29, 2019, 10:34:57 AM »
We use "parseFloat(value).toLocaleString();" in order to display decimal values with german formatting.
On my V14 WindX client I see english formatting.
On my V16 WindX client I see german formatting.
On our TS with a V14 WindX client I see german formatting.
On my colleague's V14 WindX client I see german formatting.
The OS settings for decimal formatting are all set correctly for both of us.
What else may have an effect on the formatting?
Marginalia: None of us sees options in the popup menu due to installation issues.
On my V14 WindX client I see english formatting.
On my V16 WindX client I see german formatting.
On our TS with a V14 WindX client I see german formatting.
On my colleague's V14 WindX client I see german formatting.
The OS settings for decimal formatting are all set correctly for both of us.
What else may have an effect on the formatting?
Marginalia: None of us sees options in the popup menu due to installation issues.
97
Programming / Re: disable chromium nrowser popup
« on: August 19, 2019, 01:31:15 AM »
This is a WindX Plug-in.
The host and the client run V14.
I have 53 PAK files in the locales folder and one of them is en_US.pak.
My testing is done with nomads panels.
The host and the client run V14.
I have 53 PAK files in the locales folder and one of them is en_US.pak.
My testing is done with nomads panels.
98
Programming / Re: disable chromium nrowser popup
« on: August 16, 2019, 01:45:54 AM »
Devon
We're running PxPlus V14 in Simple Client Server mode.
All updates have been applied. Maybe the EXE file is updated, but I don't know.
There is a de.pak file in the locales folder.
We're running PxPlus V14 in Simple Client Server mode.
All updates have been applied. Maybe the EXE file is updated, but I don't know.
There is a de.pak file in the locales folder.
99
Programming / disable chromium nrowser popup
« on: August 15, 2019, 07:52:29 AM »
The chromium browser object displays an empty popup menu.
Is there a way to disable that popup or to display the menu texts?
Is there a way to disable that popup or to display the menu texts?
100
Programming / strange errors 15 with [mysql] connection
« on: July 30, 2019, 03:26:23 AM »
We encounter strange errors 15 with [mysql] connections when rewinding the record pointer.
Indeed there is no error 15, because the MySQL log files show no errors. The KEY() function works in the expected way with many other tables. But some tables show this error.
As far as I can do some try and error tests there seems to be a dependency to the option NONUMADJ. If set to "N" everything is fine, but if set to "Y" the errors occur. We need to work with "NONUMADJ=Y".
Code: [Select]
-}?tcb(32)
16
-}open(1)"data/ab/A0FP01"
-}?pth(1)
[MYSQL]koss;mw01_form_para
-}read record(1,key=$$,kno=0)r$
Error #11: Record not found or Duplicate key on write
Last IO to [MYSQL]koss;mw01_form_para, channel 1
-}? key(1,kno=0)
Error #15: Operating system command failed
Last IO to [MYSQL]koss;mw01_form_para, channel 1
MYSQL:0:
-}?ken(1)
SELECT `formular`,`b_menge`,`l_menge`,`r_menge`,`mg_maske`,`me_x`,`art_nr`,`e_preis`,`ep_maske`,
`pe`,`waehrung`, ..., `use_overlay`,`archivdauer` FROM mw01_form_para WHERE `formular` > '' ORDER BY `formular`
Indeed there is no error 15, because the MySQL log files show no errors. The KEY() function works in the expected way with many other tables. But some tables show this error.
As far as I can do some try and error tests there seems to be a dependency to the option NONUMADJ. If set to "N" everything is fine, but if set to "Y" the errors occur. We need to work with "NONUMADJ=Y".
101
Thin Client/WindX / winsock error
« on: July 26, 2019, 08:19:34 AM »
A customer reports a sporadic winsock error:
[TCP][Winsock]Error status:0 {-1:<UNK>}
Error #15: Operation system command failed
They are running several 24/7 PxPlus programs on a Win10Pro TS and no interactive programs. All programs run PxPlus V14 with SCS and SSL-WindX connections.
After an OK click the program continues.
As there are no new connections made by any of the programs, what can cause this?
[TCP][Winsock]Error status:0 {-1:<UNK>}
Error #15: Operation system command failed
They are running several 24/7 PxPlus programs on a Win10Pro TS and no interactive programs. All programs run PxPlus V14 with SCS and SSL-WindX connections.
After an OK click the program continues.
As there are no new connections made by any of the programs, what can cause this?
102
Wish List / character set option
« on: July 19, 2019, 10:25:21 AM »
I'd like to use a character set option in the OPT part of a [mysql] open statement.
That will enable an application to use its character set against a SQL connection without any need to convert the data iself.
The ODBC-driver for a MySQL-DB supports this already. Perhaps the same option can be used.
That will enable an application to use its character set against a SQL connection without any need to convert the data iself.
The ODBC-driver for a MySQL-DB supports this already. Perhaps the same option can be used.
103
Programming / Re: character set option
« on: July 17, 2019, 02:13:35 AM »
PxPlus keeps the accented character
-}?ken(1)
UPDATE gd03_sgb SET `sgb_nr`='3', `sgb_bez`='Französisch ', `iac`=
'' , `iac3`= '' , `monat_l01`= '' , `monat_l02`= '' , `monat_l03`= '' , `monat_
l04`= '' , `monat_l05`= '' , `monat_l06`= '' , `monat_l07`= '' , `monat_l08`= ''
, `monat_l09`= '' , `monat_l10`= '' , `monat_l11`= '' , `monat_l12`= '' , `mona
t_k01`= '' , `monat_k02`= '' , `monat_k03`= '' , `monat_k04`= '' , `monat_k05`=
'' , `monat_k06`= '' , `monat_k07`= '' , `monat_k08`= '' , `monat_k09`= '' , `mo
nat_k10`= '' , `monat_k11`= '' , `monat_k12`= '' , `tag_l1`= '' , `tag_l2`= '' ,
`tag_l3`= '' , `tag_l4`= '' , `tag_l5`= '' , `tag_l6`= '' , `tag_l7`= '' , `tag
_k1`= '' , `tag_k2`= '' , `tag_k3`= '' , `tag_k4`= '' , `tag_k5`= '' , `tag_k6`=
'' , `tag_k7`= '' WHERE `sgb_nr` = '3'
In MySQL Workbench there is a question mark and that is what PxPlus returns after reading that record.
-}?ken(1)
UPDATE gd03_sgb SET `sgb_nr`='3', `sgb_bez`='Französisch ', `iac`=
'' , `iac3`= '' , `monat_l01`= '' , `monat_l02`= '' , `monat_l03`= '' , `monat_
l04`= '' , `monat_l05`= '' , `monat_l06`= '' , `monat_l07`= '' , `monat_l08`= ''
, `monat_l09`= '' , `monat_l10`= '' , `monat_l11`= '' , `monat_l12`= '' , `mona
t_k01`= '' , `monat_k02`= '' , `monat_k03`= '' , `monat_k04`= '' , `monat_k05`=
'' , `monat_k06`= '' , `monat_k07`= '' , `monat_k08`= '' , `monat_k09`= '' , `mo
nat_k10`= '' , `monat_k11`= '' , `monat_k12`= '' , `tag_l1`= '' , `tag_l2`= '' ,
`tag_l3`= '' , `tag_l4`= '' , `tag_l5`= '' , `tag_l6`= '' , `tag_l7`= '' , `tag
_k1`= '' , `tag_k2`= '' , `tag_k3`= '' , `tag_k4`= '' , `tag_k5`= '' , `tag_k6`=
'' , `tag_k7`= '' WHERE `sgb_nr` = '3'
In MySQL Workbench there is a question mark and that is what PxPlus returns after reading that record.
104
Programming / Re: character set option
« on: July 16, 2019, 02:28:11 AM »
The setting for the database and the tables is:
collation: cp1250_general_ci
characterset: cp1250
Here is an example with the german word for the french language:
-}new
-}open(1,iol=*)"data/gd/sgb03"
-}?pth(1)
[MYSQL]koss;gd03_sgb
-}?opt(1)
server=srvr;user=me;pswd=Passwort;prepare=0;concurrency=OPT_
VALUE;extropt=$ for update;timeout=1;cursorclose=YES;cursor_type=DYNAMIC;isolati
on=COMMITED;autocommit=ON;nonumadj=Y;KEY=sgb_nr;REC=sgb_nr:1+sgb_bez:25+iac,iac3
,monat_l01,monat_l02,monat_l03,monat_l04,monat_l05,monat_l06,monat_l07,monat_l08
,monat_l09,monat_l10,monat_l11,monat_l12,monat_k01,monat_k02,monat_k03,monat_k04
,monat_k05,monat_k06,monat_k07,monat_k08,monat_k09,monat_k10,monat_k11,monat_k12
,tag_l1,tag_l2,tag_l3,tag_l4,tag_l5,tag_l6,tag_l7,tag_k1,tag_k2,tag_k3,tag_k4,ta
g_k5,tag_k6,tag_k7
-}dim sgb$:iol(1)
-}sgb.sgb_nr$="3"
-}sgb.sgb_bez$="Französisch"
-}write record(1)sgb$
-}read record(1,key="3")sgb$
-}?sgb.sgb_bez$
Franz?sisch
collation: cp1250_general_ci
characterset: cp1250
Here is an example with the german word for the french language:
-}new
-}open(1,iol=*)"data/gd/sgb03"
-}?pth(1)
[MYSQL]koss;gd03_sgb
-}?opt(1)
server=srvr;user=me;pswd=Passwort;prepare=0;concurrency=OPT_
VALUE;extropt=$ for update;timeout=1;cursorclose=YES;cursor_type=DYNAMIC;isolati
on=COMMITED;autocommit=ON;nonumadj=Y;KEY=sgb_nr;REC=sgb_nr:1+sgb_bez:25+iac,iac3
,monat_l01,monat_l02,monat_l03,monat_l04,monat_l05,monat_l06,monat_l07,monat_l08
,monat_l09,monat_l10,monat_l11,monat_l12,monat_k01,monat_k02,monat_k03,monat_k04
,monat_k05,monat_k06,monat_k07,monat_k08,monat_k09,monat_k10,monat_k11,monat_k12
,tag_l1,tag_l2,tag_l3,tag_l4,tag_l5,tag_l6,tag_l7,tag_k1,tag_k2,tag_k3,tag_k4,ta
g_k5,tag_k6,tag_k7
-}dim sgb$:iol(1)
-}sgb.sgb_nr$="3"
-}sgb.sgb_bez$="Französisch"
-}write record(1)sgb$
-}read record(1,key="3")sgb$
-}?sgb.sgb_bez$
Franz?sisch
105
Programming / Re: character set option
« on: July 15, 2019, 10:32:36 AM »
I don't think it is a collation thing.
As far as I have read by now it seems to be an issue with the character set been sent by the application. A MySQL- or Maria-DB on an utf8-OS expects utf8 unless you tell him the data uses a different character set. So you need to talk to the "connection". A "set namens 'cp1250'" solves the issue, but I don't have the chance to configure it somewhere, as charset=cp1250 is ignored in the opt-string.
As far as I have read by now it seems to be an issue with the character set been sent by the application. A MySQL- or Maria-DB on an utf8-OS expects utf8 unless you tell him the data uses a different character set. So you need to talk to the "connection". A "set namens 'cp1250'" solves the issue, but I don't have the chance to configure it somewhere, as charset=cp1250 is ignored in the opt-string.