Re: [U2] Error connecting to Universe using Web Service Developer Tool
Jason: When I tried the WSD several years ago I needed a connection pooling license, otherwise the connection wouldn't work. I'm not sure this is still required but it was when I tried it. Secondly, I may have had some problems with casing, so make sure that's ok too. HTH, Bill Jason Lin said the following on 2/16/2010 5:48 PM: Jason: When I tried the WSD several years ago I needed a connection pooling license, otherwise the connection wouldn't work. I'm not sure this is still required but it was when I tried it. Secondly, I may have had some problems with casing, so make sure that's ok too. HTH, Bill Jason Lin said the following on 2/16/2010 5:48 PM: Hi. I tried to use the Web Service Develper tool to connect to our Universe database (ver 10.1.2 running on HP-UX B.11.0) and I kept getting RPC error unable to load the subroutine on the server. I have verified that the unirpc daemon is running and it is using the default port # 31438. Programs we created using Uniobject.net work just fine. Does anyone know what type of configuration issues we may have? Any information would be appreciated. Thank you Jason ___ 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
Re: [U2] Error connecting to Universe using Web Service Developer Tool
Quoting Bill Haskett wphask...@advantos.net: Jason: When I tried the WSD several years ago I needed a connection pooling license, otherwise the connection wouldn't work. I'm not sure this is still required but it was when I tried it. Secondly, I may have had some problems with casing, so make sure that's ok too. HTH, Bill Bill, I don't know if connection pooling license is the issue here. We are running Unvierse 10.1.2 and the client tool is version 10.3 so there may be some compatibility issue. Nevertheless, Uniobject.net works so I will have to use that for now. BTW, was WSD a easy to use tool to develop web service in Universe? My current solution is to develop ASP.NET web service and use Uniobject.net to query Universe database. Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer
Hi Jason, Our OS is windows and we really haven't had a problem, it has been really stable. When you setup the soap server, and after you entered the host connection, did you test the database connection? Did it error out then or was it a successful connection? Rudy Date: Tue, 16 Feb 2010 17:48:43 -0800 From: Jason Lin temp...@ucla.edu To: u2-users@listserver.u2ug.org Subject: [U2] Error connecting to Universe using Web Service Developer Tool Message-ID: 20100216174843.68341z8geh8di...@mail.ucla.edu Content-Type: text/plain; charset=UTF-8 Hi. I tried to use the Web Service Develper tool to connect to our Universe database (ver 10.1.2 running on HP-UX B.11.0) and I kept getting RPC error unable to load the subroutine on the server. I have verified that the unirpc daemon is running and it is using the default port # 31438. Programs we created using Uniobject.net work just fine. Does anyone know what type of configuration issues we may have? Any information would be appreciated. Thank you Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer
I have seen this before. Check all the permissions such as c:\ibm\uv\bin\uvtemp Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer Tool
Personally i use asp.net and uniobjects.net to do web services, the reason being it is very simple this way and ultimately extendable, but also my web layer is in iis and this is where i want my webservices to sit, not some 'other' http server ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin Sent: 17 February 2010 20:11 To: U2 Users List Subject: Re: [U2] Error connecting to Universe using Web Service Developer Tool Quoting Bill Haskett wphask...@advantos.net: Jason: When I tried the WSD several years ago I needed a connection pooling license, otherwise the connection wouldn't work. I'm not sure this is still required but it was when I tried it. Secondly, I may have had some problems with casing, so make sure that's ok too. HTH, Bill Bill, I don't know if connection pooling license is the issue here. We are running Unvierse 10.1.2 and the client tool is version 10.3 so there may be some compatibility issue. Nevertheless, Uniobject.net works so I will have to use that for now. BTW, was WSD a easy to use tool to develop web service in Universe? My current solution is to develop ASP.NET web service and use Uniobject.net to query Universe database. Jason ___ 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
Re: [U2] Error connecting to Universe using Web Service Developer
Quoting David Jordan da...@dacono.com.au: I have seen this before. Check all the permissions such as c:\ibm\uv\bin\uvtemp Regards David Jordan Jordan, We are running HP-UX but I don't think we have any permission issues with temp directories used by Universe. Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer
Also, make sure that 31438 is open on the firewall for the server. Norm On Wed, Feb 17, 2010 at 3:16 PM, Cooper, Rudy rudy.coo...@sagepub.com wrote: Hi Jason, Our OS is windows and we really haven't had a problem, it has been really stable. When you setup the soap server, and after you entered the host connection, did you test the database connection? Did it error out then or was it a successful connection? Rudy Date: Tue, 16 Feb 2010 17:48:43 -0800 From: Jason Lin temp...@ucla.edu To: u2-users@listserver.u2ug.org Subject: [U2] Error connecting to Universe using Web Service Developer Tool Message-ID: 20100216174843.68341z8geh8di...@mail.ucla.edu Content-Type: text/plain; charset=UTF-8 Hi. I tried to use the Web Service Develper tool to connect to our Universe database (ver 10.1.2 running on HP-UX B.11.0) and I kept getting RPC error unable to load the subroutine on the server. I have verified that the unirpc daemon is running and it is using the default port # 31438. Programs we created using Uniobject.net work just fine. Does anyone know what type of configuration issues we may have? Any information would be appreciated. Thank you Jason ___ 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
Re: [U2] Error connecting to Universe using Web Service Developer Tool
Quoting Symeon Breen syme...@gmail.com: Personally i use asp.net and uniobjects.net to do web services, the reason being it is very simple this way and ultimately extendable, but also my web layer is in iis and this is where i want my webservices to sit, not some 'other' http server ... Symeon, Good to hear that I'm not the only one thinking about using asp.net and uniobject.net together instead building web service directly in Universe. At least I get to enjoy using Visual Studio and not the Java based Eclipse tool. Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer
Quoting Norman Bauer normanba...@gmail.com: Also, make sure that 31438 is open on the firewall for the server. Norm Norm, I don't think the server has block port 31438 because Uniobject.net works just fine assuming that uniobject communicates with unirpc daemon over port 31438. Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Hash.Help
Our UniVerse system has been slow over the last few weeks. It seems to take approx one second to launch any program. It just hangs there for a second. So... I tried to resize VOC... and obtained the following error (at the bottom). Help would be appreciated. --Bill *--- --- HASH.HELP VOC File VOC Type= 17 Modulo= 1237 Sep= 2 06:42:48pm 17 Feb 2010 PAGE1 Of the 5053 total keys in this file: 5 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 4479 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 560 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their entirety. The smallest modulo you should consider for this file is 859. The smallest separation you should consider for this file is 4. The best type to choose for this file is probably type 17. RESIZE VOC 17 1237 4 RESIZE: Error on VOC. File not resized. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer Tool
Quoting Symeon Breen: Personally i use asp.net and uniobjects.net to do web services ... Jason wrote: Good to hear that I'm not the only one thinking about using asp.net and uniobject.net together instead building web service directly in Universe. Jason, you're certainly not the only one. I am also much less inclined to use DBMS-specific tools like the U2 web services than something more standard like ASP.NET. It's a bonus that it only takes a couple minutes to create new inbound services, and outbound calls to remote services. It's sort of a no-brainer for most purposes. Seriously, I do web services all the time in just a few minutes each, and I can only shake my head at the difficulties people express here with such things. I have a video on our website showing ways to do web services with ASP.NET: nospam.pleaseNebula-RnD.com/products/gallery.htm My connectivity tool of choice is mv.NET, which is used in the video, but for this purpose one can easily use UO.NET instead. For reference, I've blogged on this topic a great deal: remove.this.partNebula-RnD.com/blog And I wrote articles on the topic back when few people in this market knew much about it or cared: remove.thisNebula-RnD.com/articles/ Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Hash.Help
Resizing the VOC is only for the non quiche eating real manly admins. I have found that the only way to do this is remotely via q-pointers from another account - and make sure you have triple backups, belts, braces (suspenders) and safety nets, parachutes and back-doors easily accessible. Cheers JR -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, February 17, 2010 6:50 PM To: U2 Users List Subject: Re: [U2] [UV] Hash.Help We are running UV 10 on HP-Ux Itanium. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, February 17, 2010 6:48 PM To: U2 Users List Subject: Re: [U2] [UV] Hash.Help Our UniVerse system has been slow over the last few weeks. It seems to take approx one second to launch any program. It just hangs there for a second. So... I tried to resize VOC... and obtained the following error (at the bottom). Help would be appreciated. --Bill *--- --- HASH.HELP VOC File VOC Type= 17 Modulo= 1237 Sep= 2 06:42:48pm 17 Feb 2010 PAGE1 Of the 5053 total keys in this file: 5 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 4479 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 560 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their entirety. The smallest modulo you should consider for this file is 859. The smallest separation you should consider for this file is 4. The best type to choose for this file is probably type 17. RESIZE VOC 17 1237 4 RESIZE: Error on VOC. File not resized. ___ 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
Re: [U2] [UV] Hash.Help
Bill from your stat report, it's doubtful that this is your problem. Your VOC appears to be more or less sized fine. Even were it very badly sized, one second seems long. I would consider that something in your system is eating CPU like a wild hog. That's more likely to be the culprit. Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer Tool
If you don't have a connection pooling license on your UV server, turn it off in U2 WSDT. See page 113 in the webservices.pdf. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin Sent: Wednesday, 17 February 2010 12:49 PM To: u2-users@listserver.u2ug.org Subject: [U2] Error connecting to Universe using Web Service Developer Tool Hi. I tried to use the Web Service Develper tool to connect to our Universe database (ver 10.1.2 running on HP-UX B.11.0) and I kept getting RPC error unable to load the subroutine on the server. I have verified that the unirpc daemon is running and it is using the default port # 31438. Programs we created using Uniobject.net work just fine. Does anyone know what type of configuration issues we may have? Any information would be appreciated. Thank you Jason ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer Tool
On 2/17/2010 4:14 PM, Tony Gravagno wrote: I have a video on our website showing ways to do web services with ASP.NET: nospam.pleaseNebula-RnD.com/products/gallery.htm My connectivity tool of choice is mv.NET, which is used in the video, but for this purpose one can easily use UO.NET instead. For reference, I've blogged on this topic a great deal: remove.this.partNebula-RnD.com/blog And I wrote articles on the topic back when few people in this market knew much about it or cared: remove.thisNebula-RnD.com/articles/ Symeon, I will take a look at those web pages. Thanks for the information. Jason ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
