PxPlus User Forum

Twitter Twitter Twitter

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.


Messages - JimGwynn

Pages: [1] 2
1
Programming / Segmentation Fault with ODBC SQL Query
« on: August 10, 2020, 05:42:04 PM »
I am getting a segmentation fault when querying an SQL database using the ODBC connection but only when there is a space in the query parameter

Here is my program

0005 BEGIN
0010 LET FROMFILE$="vw_ConcordFullData", SQLUSER$="windx", SQLPASS$="********"
0040 OPEN (HFN,IOL=*)"[ODB]webmssql;"+FROMFILE$+";USER="+SQLUSER$+";PSWD="+SQLPASS$+";NONULLS=1"; LET SQLCHAN=LFO
REM 0070 SELECT * FROM SQLCHAN WHERE MAINCATEGORY$ = "BINDING" ! Works fine
0070 SELECT * FROM SQLCHAN WHERE MAINCATEGORY$ = "BINDING POST" ! Gives Seg Fault
0075 PRINT PARTNUMBER$,@(30),TAXONOMY$
0080 NEXT RECORD
0090 CLOSE (SQLCHAN)

here is the crash dump

Aug 10 14:53 [<sigterm>:50] Segmentation fault
Aug 10 14:53 [<sigterm>:50]  - ERR=0 CTL=0 RET=267 LFA=32767 LFO=32767
Aug 10 14:53 [<sigterm>:50]  - Last path used: [ODB]webmssql;vw_ConcordFullData;
USER=windx;
Aug 10 14:53 [<sigterm>:50] --- Program stack ---
Aug 10 14:53 [<sigterm>:50]  - STK(0) = line 00050 in /home/CDSv67.7bin/SQLTEST
Aug 10 14:53 [<sigterm>:50]    - FILE..... 00070
Aug 10 14:53 [<sigterm>:50] --- Files ---
Aug 10 14:53 [<sigterm>:50]  - PTH(0) = /dev/pts/31
Aug 10 14:53 [<sigterm>:50]  - PTH(32767) = [ODB]webmssql;vw_ConcordFullData;USE
R=windx;
Aug 10 14:53 [<sigterm>:50] --- Err() Info ---
Aug 10 14:53 [<sigterm>:50]        Current Err:15 Prog: /home/CDSv67.7bin/SQLTES
T Stno: 50 LFA: 0 LastPath: SYGERR (pvxsub.c@1433)
Aug 10 14:53 [<sigterm>:50] --- Stack dump ---
Aug 10 14:53 [<sigterm>:50] /lib64/libc.so.6(+0x36400) [0x7f53dfe98400]
Aug 10 14:53 [<sigterm>:50] /lib64/libc.so.6(+0x14cbb0) [0x7f53dffaebb0]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x58288a]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x57a681]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x579a54]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x574c3d]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x46754b]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x40d7ee]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x40d421]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x406a3b]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x405665]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x403fee]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x403bbe]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x403a56]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x403841]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x4e4401]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x4e4339]
Aug 10 14:53 [<sigterm>:50] /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f53dfe8
4555]
Aug 10 14:53 [<sigterm>:50] pxplus() [0x403641]


2
Programming / Syntax checking
« on: June 10, 2020, 12:43:41 PM »
Anyone know of a way to test the syntax of program via an external program.
Example - We are using Jenkins to push our releases and would like to have a shell scrip that pass the program through a syntax check before releasing it. Can be a simple pass fail but would be nice to get the line number back?

3
Thin Client/WindX / Re: SSH Conection Keep alive
« on: March 19, 2020, 04:34:55 PM »
Thanks Mike that did work

For anyone else that may have a similar issue - Here is what we found and what works

We setup SSH access through a Network Load Balancer in AWS. This NLB has a fixed session timeout of 350s

What we did to solve this was Set the +A system parameter to 1.  By default this is set to 10 min causing the NLB to timeout sessions.

With this we did not need to touch any of the the users putty settings.

Thanks Again.

4
Thin Client/WindX / Re: SSH Conection Keep alive
« on: March 19, 2020, 12:40:10 PM »
Here is a better image

5
Thin Client/WindX / Re: SSH Conection Keep alive
« on: March 19, 2020, 12:37:03 PM »
Here is a screen shot of my config

6
Thin Client/WindX / Re: SSH Conection Keep alive
« on: March 19, 2020, 12:30:22 PM »
Mike - When I do that I get this message

User Override
UserID has been overridden by Session 'TEST'

7
Thin Client/WindX / SSH Conection Keep alive
« on: March 19, 2020, 12:00:25 PM »
All - Need some emergency help
As we have moved all of our users to home workers we are experiencing excessive timeouts
Is there anyway using the SSH connection in the client launcher to set the Putty keep alive parameters?

Thanks

8
Programming / Re: Trapping error with DTE()
« on: February 14, 2020, 04:28:10 PM »
Hi:

The error gets trapped, you're just sending it automatically to the next line:

0010 let outdt$="40129C0"
0020 let dt$=dte(mid(outdt$,1,2)+"/"+mid(outdt$,3,2)+"/"+mid(outdt$,5,2):"%Mz/%Dz/%Yl",err=BAD_DATE)
0030 print outdt$
0100 BAD_DATE:! ^100,5
0110 print err
0120 escape

I hope this helps

Regards

Dave

What is happening to me is it does not get to the next lines - Throws and Error #41.

9
Programming / Trapping error with DTE()
« on: February 14, 2020, 03:01:59 PM »
I am attempting to trap error generated by the DTE() command

Example = I know the data is bad but that is what I am trying to catch
0010 LET OUTDT$="40129C0"
0020 LET DT$=DTE(MID(OUTDT$,1,2)+"/"+MID(OUTDT$,3,2)+"/"+MID(OUTDT$,5,2):"%Mz/%Dz/%Yl",ERR=*NEXT)
0030 PRINT OUTDT$

Does not trap Error #41

 



10
Thin Client/WindX / Re: The WindX utility program, *WindX.utl vis SSH
« on: February 10, 2020, 12:25:18 PM »
It is not set

11
Thin Client/WindX / The WindX utility program, *WindX.utl vis SSH
« on: February 09, 2020, 01:01:33 PM »
We are attempting to spawn a new wdx session using
CALL "*WindX.utl;Spawn","/pxplus/STARTUP"

This works without error when client is connected via telnet
But when connecting using SSH we get the following error

1}CALL "*WindX.utl;Spawn","/pxplus/STARTUP"
Error #13: File access mode invalid
Current program is /pxplus/lib/_windx.utl, line 5150

Any ideas what we are doing wrong?




12
Thin Client/WindX / Re: User Override
« on: February 06, 2020, 08:28:20 PM »
For anyone else experiencing this:
What I actually found was if I create a saved session in Putty that is named the same as the server hostname this will happen.
Creating a saved session with a name other then the server host name allows me to have both a putty connection and a WindX SSH connection

13
Thin Client/WindX / Re: User Override
« on: February 06, 2020, 05:43:48 PM »
Thanks Mike
Yes I had a putty session that was setup using an SSH private key. Deleting that session worked.

Thanks

14
Thin Client/WindX / User Override
« on: February 06, 2020, 05:04:26 PM »
Anyone know why users would get the following message when using ssh to connect via the WindX Client?

Pop up titled: User Override
Message says Userid has been overriden By session 'server-name'






15
Thin Client/WindX / Clear screen from bash
« on: October 04, 2019, 07:37:44 PM »
Is there way to issue a clear screen command within the .bash_profile that will clear the windx screen and return to the upper left?

Pages: [1] 2