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.
Pages: [1]
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]
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?
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 / 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
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
4
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
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
5
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?
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?
6
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'
Pop up titled: User Override
Message says Userid has been overriden By session 'server-name'
7
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?
8
Programming / Remote Debugging via IT
« on: November 07, 2018, 09:49:46 PM »
I am looking for some guidance to run remote debugging through Windx.
My setup is this
Using a PC to develop and the server is a Linux Server.
I can launch Windx and then do a RUN "*it" which opens the local IT program editor but I am at a loss where to go from there.
I try to open a file in the editor and get the file system on the Linux box but when choosing a file to work on I get an error
File Open Error
the file "/pxplus/STARTUP" cannot be opened at this time
Error #13: File access mode invalid
Thanks for any help you can offer.
My setup is this
Using a PC to develop and the server is a Linux Server.
I can launch Windx and then do a RUN "*it" which opens the local IT program editor but I am at a loss where to go from there.
I try to open a file in the editor and get the file system on the Linux box but when choosing a file to work on I get an error
File Open Error
the file "/pxplus/STARTUP" cannot be opened at this time
Error #13: File access mode invalid
Thanks for any help you can offer.
Pages: [1]