RE: [U2] UniObjects and Triggers
Saran, I believe this has been a problem for a couple of years at least as I ran into a similar problem at a client site a few years ago. The apllication vendor ended up using a different interface. I believe it is a problem with the underlying implementation of uv/uniobjects. Check with IBM. Phil Walker +64 21 336294 [EMAIL PROTECTED] Gnosys Consulting Limited 11 Woodward Road, Mount Albert, Auckland 1003, New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Saturday, November 20, 2004 10:01 AM To: U2 List ([EMAIL PROTECTED]) Subject: [U2] UniObjects and Triggers We have found some odd behaviour with a new development using UniObjects for Java. UniVerse 10.0.11 on AIX 5.2 with ML_01 We are getting errors when trying to write to a file (standard Type 18) which has a trigger. If we remove the trigger the write is successful but replace the trigger and the process aborts. We cannot see anything useful in the logs. We have been using UniObjects for Java (and VB) for quite some time without problems. We found this on our development machine when all our licences had been used. These processes were not releasing a licence when they aborted. Is this a known issue and if so is there an easy fix? Any information or suggestions will be very useful. Regards Sara Burns Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Help with 'Available memory exceeded' on 8Gig Ram server
Hi Everybody, A crucial job has failed on a client server with the error message 'Available memory exceeded'. The machine has 8Gb RAM and I do not see how this could be happening. I have also noticed that DELETE(ing) or ED(iting) a record more than 16MB will fail with the same error message even when I'm the only user on the system. What UV/Unix tunables must I change to solve this problem if any? Regards, Marco. - Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stopping HP Laser Printer line creep
Al, I had similar issues when moving from line printers to laser. I have UV 10.1.1 and SB+3.4 running MasterPack on Linux AS3. In my environment, I use SB to do the printing of my shipping dockets so I don't have any BASIC programs using PRINTER ON etc... (either SB needs to control printing or BASIC; can't be both). So, playing with form feed settings and number of lines on the report itself in SB+ got it working. If you are using BASIC to do your printing (sounds like you might be), the line creep issue I have seen in the past was either UniVerse and the BASIC program both trying to control paging OR when I were to force a form feed I would forget to suppress the line feed on my print statement (PRINTER ON ; PRINT CHAR(012): ; PRINTER OFF ;PRINTER CLOSE ;*/ note colon after (012) ). If your BASIC program is running the show, make sure the UV SETPTR issues a NO FORMAT (i.e. SETPTR 0,80,59,0,0,1,AT PKLIST,NHEAD,NFMT,EJECT,BRIEF). If you are seeing the output from the SETPTR command on your form, you are probably forgetting the ,BRIEF option which suppresses output of the command and the prompt asking if its OK to set these parameters. Another trick for getting rid of my line printers that were used for reports and not forms was to change the report so that it wrote to the HOLD file. When the report was done I would use BASIC to read the report and wrap it with HTML tags: HTML='htmlpre@REPORT@/pre/html' READ REPORT FROM HOLD,'RPT':@USERNO THEN HTML=CHANGE(HTML,'@REPORT@',REPORT) END If your users are using SBClient (mine are) I used the TU.DOWNLOAD and TU.EXECUTE.SHELL to move the html to the clients PC and open the report automatically for the user in Internet Explorer. They loved this because now they could copy and paste report data or email the report or print to laser using windows. I hope some of these suggestions help. From: [EMAIL PROTECTED] on behalf of Al DeWitt Sent: Fri 11/19/2004 17:59 To: [EMAIL PROTECTED] Subject: [U2] Stopping HP Laser Printer line creep UniData 6.0.12 SB+ 5.2.4 I have a basic program that originally ran on a line printer to print preprinted forms. I am converting it to print on a laser. I'm having problem with line creep. Each succeeding page will begin printing one line lower than the preceding one. I originally had a set-up string set up in the Printer Class in SB+. This didn't help and actually hurt because it was cutting off the first lines of information on the second and succeeding pages. I tried Executing a SETPTR statement in the code, but the SETPTR Verbiage displayed on the page if I placed it after the PRINTER ON stmt and didn't seem to do anything when I placed it before. I have spend way too much time on this little project. Anybody have any suggestions? Going to Optio or Universe is not an option. Al DeWitt Stylmark, Inc. 763-574-8705 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with 'Available memory exceeded' on 8Gig Ram server
I don't know if this is the problem or not but these symptoms can be caused by a UniVerse file that was being RESIZEd and the RESIZE aborted. This can leave the Active Resize bit set for records in the file and cause the 'Available memory exceeded' failure when you try to edit or otherwise access records. Try using uvfixfile or the new UniVerse file tool (can't remember the name off hand). That might tell you if this is a problem. To repair use filepeek at the UNIX prompt and within filepeek execute the RCL command to reset the active resize bits. Probably should be done with no users in the file and I'd make a copy of the file first just in case. Hope this helps! Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Saturday, November 20, 2004 7:54 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] Help with 'Available memory exceeded' on 8Gig Ram server Hi Everybody, A crucial job has failed on a client server with the error message 'Available memory exceeded'. The machine has 8Gb RAM and I do not see how this could be happening. I have also noticed that DELETE(ing) or ED(iting) a record more than 16MB will fail with the same error message even when I'm the only user on the system. What UV/Unix tunables must I change to solve this problem if any? Regards, Marco. - Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT MV-Base
Mark - mvBASE has UCREATE, UOPEN, UREAD, UWRITE, others and definitely UCLOSE. A great source you can read is : SYSPROG,BASICLIB OSCOPY -- here is a snippet from some of my code: ! 18000 * open ! ERRMSG='' UOPEN FILENAME FOR READWRITE TO DOSFILE ELSE UCLOSE DOSFILE ELSE NULL GOSUB 18100 ; * UCREATE END RETURN ! 18100 *UCREATE - if exists shortens the length of the file to ZERO else creates a new file ! ERRMSG='' UCREATE FILENAME TO DOSFILE ELSE ERRMSG=Unable to UCREATE for READWRITE :FILENAME UCLOSE DOSFILE ELSE NULL END RETURN ! 18200 * read ! DONE=0 ; NREC='' ; ERRMSG='' LOOP UNTIL DONE DO UREAD DOSREC FROM DOSFILE FOR 65530 THEN DOSREC = SWAP(DOSREC,CRLF,AM) NREC=NREC:DOSREC END ELSE DONE=1 REPEAT RETURN ! 18300 * write ! ERRMSG='' NREC = SWAP(NREC,AM,CRLF) UWRITE NREC ON DOSFILE ELSE ERRMSG=Unable to WRITE :FILENAME END UWRITE '' ON DOSFILE ELSE NULL ; * see BASICLIB OSCOPY RETURN ! 18400 * close ! ERRMSG='' UCLOSE DOSFILE ELSE ERRMSG=Message during UCLOSE :UERROR() END RETURN ! 18500 * delete ! ERRMSG='' ; GOSUB 18400 ; * close the file 1st UDELETE DOSFILE ELSE ERRMSG=Unable to DELETE :FILENAME END RETURN ! don't forget the UWRITE '' ON DOSFILE have fun! = Computerized Data Mgmt Inc PO Box 3473 Fayetteville, Arkansas 72702 (479) 521-5670 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT MV-Base
Everybody probably already knows this, but just in case - if you do not UCLOSE then the Windows file handle is lost until the next boot. Windows file handles are not usually in short supply but they can get that way in a hurry if there is a daily program that does one or more UOPEN without corresponding UCLOSE. BobJ - Original Message - From: Computerized Data Mgmt Inc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 20, 2004 11:09 AM Subject: Re: [U2] OT MV-Base Mark - mvBASE has UCREATE, UOPEN, UREAD, UWRITE, others and definitely UCLOSE. A great source you can read is : SYSPROG,BASICLIB OSCOPY -- here is a snippet from some of my code: ! 18000 * open ! ERRMSG='' UOPEN FILENAME FOR READWRITE TO DOSFILE ELSE UCLOSE DOSFILE ELSE NULL GOSUB 18100 ; * UCREATE END RETURN ! 18100 *UCREATE - if exists shortens the length of the file to ZERO else creates a new file ! ERRMSG='' UCREATE FILENAME TO DOSFILE ELSE ERRMSG=Unable to UCREATE for READWRITE :FILENAME UCLOSE DOSFILE ELSE NULL END RETURN ! 18200 * read ! DONE=0 ; NREC='' ; ERRMSG='' LOOP UNTIL DONE DO UREAD DOSREC FROM DOSFILE FOR 65530 THEN DOSREC = SWAP(DOSREC,CRLF,AM) NREC=NREC:DOSREC END ELSE DONE=1 REPEAT RETURN ! 18300 * write ! ERRMSG='' NREC = SWAP(NREC,AM,CRLF) UWRITE NREC ON DOSFILE ELSE ERRMSG=Unable to WRITE :FILENAME END UWRITE '' ON DOSFILE ELSE NULL ; * see BASICLIB OSCOPY RETURN ! 18400 * close ! ERRMSG='' UCLOSE DOSFILE ELSE ERRMSG=Message during UCLOSE :UERROR() END RETURN ! 18500 * delete ! ERRMSG='' ; GOSUB 18400 ; * close the file 1st UDELETE DOSFILE ELSE ERRMSG=Unable to DELETE :FILENAME END RETURN ! don't forget the UWRITE '' ON DOSFILE have fun! = Computerized Data Mgmt Inc PO Box 3473 Fayetteville, Arkansas 72702 (479) 521-5670 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT MV-Base
On Fri, 19 Nov 2004 23:36:56 -0500 Mark Johnson wrote: Subject: Re: [U2] OT MV-Base Thank's mate. there is a UCLOSE but to no avail. The docs say something about 'until the file gets released' but gives no suggestion. RELEASE Mark, We use the interoperability commands in our EDI translator on mvBase for many types of automated communications. UCLOSE will close the file unless your process, or some other process, is keeping it open. The only condition I can think of that would take control of the file outside of your code would be the UEXECUTE execution of a Windows executable - eg. ProcommPlus or ws_ftpPro. The file will then remain open until that executable has completed its execution. Some executables will tell you when they're done and some will not. For those that will tell you when they're done, you can use the UWAITFOR option to monitor for completion and, if you want, to take some other action after waiting some designated period of time. You can use the ELSE option after UCLOSE to take an action, and one action you could take is to read the error code using UERROR() that explains why UCLOSE failed. Check the documentation for examples. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 www.sysmarkinfo.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OT MV-Base
In a message dated 11/19/2004 8:55:57 PM Pacific Standard Time, [EMAIL PROTECTED] writes: Thank's mate. there is a UCLOSE but to no avail. The docs say something about 'until the file gets released' but gives no suggestion. RELEASE doesn't do anything. please post the COMPLETE source code :) Thanks --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Help with 'Available memory exceeded' on 8Gig Ram server
Check swap space. I recently saw this text on an AIX 5.2 machine that also had 8GB of RAM. Unfortunately they'd only configured 2.5GB of swap space. A heavy-duty sort/merge needed more than could be delivered. (I didn't follow up whether they'd increased swap space to my recommendation of at least 16GB so can't report whether that was the problem. But I suspect that it was.) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/