Re: [U2] ITYPE BASIC use?
Funny you ask that, since in the manual they use a D-type as an example. Wally Terhune wrote: Is dict item F01 actually a compiled I type dict item? Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Karl Pearson [ka...@ourldsfamily.com] Sent: Friday, January 08, 2010 12:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] ITYPE BASIC use? I have a client who would like to use the uniVerse ITYPE function but the HELP (HELP BASIC ITYPE) documentation is wrong. For example, here's a sample piece of code, which duplicates the HELP code sample: 6 DONE = 0 7 8 open DICT,CONF to D.CONF else stopm No DICT CONF file 9 read DICT.ITYPE from D.CONF,F01 else DICT.ITYPE = 'Not Found' 10 11 open CONF to CONF else stopm No DICT CONF file 12 select CONF 13 14 loop 15 readnext KEY else DONE = 1 16 until DONE do 17 read REC from CONF,KEY then 18 print KEY:' has CustNO': ITYPE(DICT.ITYPE) 19 print stop? 20 input ANS,1 21 if upcase(ANS) = 'Y' then stop 22 end 23 repeat 24end Executing this code results in this error: Line 18, ITYPE called with bad data item Any thoughts? TIA, --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Prayer for Obama, et al: http://scriptures.lds.org/en/ps/109/8#8 (~) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UOJ The RPC Failed on Unifile.write()
I have a test UOJ program communicating to a backend Unidata/AIX server that seems to work fine with the exception (pun intended) of UniFile write. The file opens fine, we can read the record fine, but when attempting to update the record, we get this: asjava.uniobjects.UniFileException: The RPC failed at asjava.uniobjects.UniFile.write(UniFile.java:1288) at Test.main(Test.java:46) Here's the offending code: 43 UniFile uFile = uSession.open(PRODUCT); 44 UniDynArray record = new UniDynArray(uFile.read(001!JM7012CK-6EU-F)); 45 record.replace(73,TEST TEST TEST); 46 uFile.write(001!JM7012CK-6EU-F,record); Probably something stupidly simple; any ideas? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
File permissions? Charles Shaffer Senior Analyst NTN-Bower Corporation Kevin King precisonl...@gmail.com Sent by: u2-users-boun...@listserver.u2ug.org 01/11/2010 08:24 AM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:[U2] UOJ The RPC Failed on Unifile.write() I have a test UOJ program communicating to a backend Unidata/AIX server that seems to work fine with the exception (pun intended) of UniFile write. The file opens fine, we can read the record fine, but when attempting to update the record, we get this: asjava.uniobjects.UniFileException: The RPC failed at asjava.uniobjects.UniFile.write(UniFile.java:1288) at Test.main(Test.java:46) Here's the offending code: 43 UniFile uFile = uSession.open(PRODUCT); 44 UniDynArray record = new UniDynArray(uFile.read(001!JM7012CK-6EU-F)); 45 record.replace(73,TEST TEST TEST); 46 uFile.write(001!JM7012CK-6EU-F,record); Probably something stupidly simple; any ideas? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
If your Unifile is also a SQL Table, and the data you put into 73 is illegal for that table, it will cause a write failure as the SQL checking will not allow you to write it. John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 11 January 2010 14:25 To: U2 Users List Subject: [U2] UOJ The RPC Failed on Unifile.write() I have a test UOJ program communicating to a backend Unidata/AIX server that seems to work fine with the exception (pun intended) of UniFile write. The file opens fine, we can read the record fine, but when attempting to update the record, we get this: asjava.uniobjects.UniFileException: The RPC failed at asjava.uniobjects.UniFile.write(UniFile.java:1288) at Test.main(Test.java:46) Here's the offending code: 43 UniFile uFile = uSession.open(PRODUCT); 44 UniDynArray record = new UniDynArray(uFile.read(001!JM7012CK-6EU-F)); 45 record.replace(73,TEST TEST TEST); 46 uFile.write(001!JM7012CK-6EU-F,record); Probably something stupidly simple; any ideas? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
File permissions are wide open. I am intrigued however by the SQL mention. The file in question is defined in the VSG under a separate SQL name (PRODUCT_1). And oddly enough I keep getting a RPC parameter mismatch error when I try to view the mapped attributes with the VSG. Certainly the VSG definitions aren't used by UOJ are they? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
We find that even in a simple, running on Unix, Databasic program, if you try to write illegal data to a SQL table then you get a WRITE FAILURE error, so we guess that the SQL integrity checking is working even on a direct write from any source. John Woollam | Group Financial Systems | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 11 January 2010 15:02 To: U2 Users List Subject: Re: [U2] UOJ The RPC Failed on Unifile.write() File permissions are wide open. I am intrigued however by the SQL mention. The file in question is defined in the VSG under a separate SQL name (PRODUCT_1). And oddly enough I keep getting a RPC parameter mismatch error when I try to view the mapped attributes with the VSG. Certainly the VSG definitions aren't used by UOJ are they? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
Well, I finally got the file mapping to view in the VSG, and the field being updated is a simple 30 character alphanumeric. Just for grins I changed the program to read the record and write it instantly without changing anything, and the RPC error persists. I wonder if this might have something to do with the version of Unidata running on that server? When I type version @ TCL I get this: UniObjects... 5.2 Yes The current account is version 6.1. Weird, huh? I think the production box for this site is 6.1 and they reloaded this dev instance from production after a hard disk fail. And we're using a reasonably current UOJ version; could that discrepancy explain the issues? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
Follow up: I created a new file and was able to write a new record into the new file from UOJ with no problems at all. Both files are static hashed. Thinking maybe there could be some SQL implication I copied the VOC pointer to a new name and tried accessing the data via that name and the RPC error persists. Both the old file and new file are in the same directory, same permissions, same ownership, and I can read and write to the new file but not the old one. Any other things I could check? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
What about the write permissions on the file in VSG? You can run updatevoc from a shell to clean up the version mis-match. Hth Colin Alfke Calgary, Canada -Original Message- From: Kevin King Sent: January 11, 2010 8:21 AM To: U2 Users List Subject: Re: [U2] UOJ The RPC Failed on Unifile.write() Follow up: I created a new file and was able to write a new record into the new file from UOJ with no problems at all. Both files are static hashed. Thinking maybe there could be some SQL implication I copied the VOC pointer to a new name and tried accessing the data via that name and the RPC error persists. Both the old file and new file are in the same directory, same permissions, same ownership, and I can read and write to the new file but not the old one. Any other things I could check? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
The only privileges on the file are OWNER, and even connecting as the owner of the file doesn't change the error. So just for grins I setup PUBLIC with all privileges and ... no change. Again, I'm trying to connect to PRODUCT but in the VSG it's called PRODUCT_1 if that makes any difference? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UOJ The RPC Failed on Unifile.write()
Mystery solved! And of course, it had nothing to do with UOJ at all. The file had an index defined which was calling an SB+ subroutine (SB.SMART.QUERY). Once that field was removed from the index the updates are proceeding according to plan. Thanks everyone for your nudging and advice! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ITYPE BASIC use?
Mecki: At least the documentation in the UD BASIC manual uses a virtual attribute in the example. :-) Bill Mecki Foerthmann said the following on 1/11/2010 12:05 AM: Funny you ask that, since in the manual they use a D-type as an example. Wally Terhune wrote: Is dict item F01 actually a compiled I type dict item? Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Karl Pearson [ka...@ourldsfamily.com] Sent: Friday, January 08, 2010 12:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] ITYPE BASIC use? I have a client who would like to use the uniVerse ITYPE function but the HELP (HELP BASIC ITYPE) documentation is wrong. For example, here's a sample piece of code, which duplicates the HELP code sample: 6 DONE = 0 7 8 open DICT,CONF to D.CONF else stopm No DICT CONF file 9 read DICT.ITYPE from D.CONF,F01 else DICT.ITYPE = 'Not Found' 10 11 open CONF to CONF else stopm No DICT CONF file 12 select CONF 13 14 loop 15 readnext KEY else DONE = 1 16 until DONE do 17 read REC from CONF,KEY then 18 print KEY:' has CustNO': ITYPE(DICT.ITYPE) 19 print stop? 20 input ANS,1 21 if upcase(ANS) = 'Y' then stop 22 end 23 repeat 24end Executing this code results in this error: Line 18, ITYPE called with bad data item Any thoughts? TIA, --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Prayer for Obama, et al: http://scriptures.lds.org/en/ps/109/8#8 (~) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Listserv Archives
I'm trying to search the archives for U2-users, but am having no luck. I'm following the link to the archives from the U2UG website (u2ug.org [logged in]-Join Email List-Message Archives), and get a search page, but when I try to execute a search, I'm getting webpage cannot be found error. Is anybody else able to get search results? Katie Morgan Datatel Programmer/Analyst Linfield College Integrated Technology Services 900 SE Baker St McMinnville, OR 97128-6894 kmor...@linfield.edu 503.883.2714 (if you can't reverse the logic, reverse the rest of the world.) -maryc on the Datatel Users Community Forums ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Listserv Archives
You can try searching here instead, http://old.nabble.com/U2-(UniVerse---UniData)-f800.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Katie Morgan Sent: Monday, January 11, 2010 2:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Listserv Archives I'm trying to search the archives for U2-users, but am having no luck. I'm following the link to the archives from the U2UG website (u2ug.org [logged in]-Join Email List-Message Archives), and get a search page, but when I try to execute a search, I'm getting webpage cannot be found error. Is anybody else able to get search results? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users