[U2] Help with Soap and passing certificates in UniBasic
I'm hoping someone can help me out with some Soap and Certificate logic from UniBasic. We have the below code in an application (UniData 7.1.0 on Windows 2003) that has been working great for some time. The problem is the service we are talking to implemented some new code to require certificates or not. As you'll see in the code we were actually performing the addCertificate function. The service and secure soap implementation in UniBasic were not fully understood at the time this code was written. So it was probably not needed before but it worked so mostly no harm no foul. The problem now is with the new service the certificate can either be required or not required. If using a certificate it has to be one issued by the company providing the service. We have actually tried both approaches (with cert and without - commented out lines 98,99) and each time, the call to SOAPSumitRequest just hangs. It may eventually time out but I've never waited that long enough for it to abort. The logic before returned in a few seconds. The company providing the service actually see something weird in their logs. It looks like we make some initial calls to them (other calls being made prior to this logic) and then they see nothing. If I terminate my UniData telnet session then they see the actual request come through. Hope this makes sense. I should also mention that the code that was working for a long time was slightly different below. Instead of RETURN = addCertificate(CERT.PATH, 1, 1, 1, ctx) we were using RETURN = addCertificate(CERT.PATH, 2, 2, 1, ctx) because the old certificate was in DER format and it was a guess on it should be issuer certificate. With the new certificate from the company they used PEM format and they thought we should use the client/server setting. In other words the function call was different because the certificate referenced was different. So my questions are: 1) Do I have to install the certificate in the windows OS stores for certificates? I don't think I do because we didn't do that with the old certificate but I ask because the old certificate was actually one of the base certificates in Windows. 2) Is there anything wrong with the code below besides the basic style of writing? If you need to see more of the code let me know. Is the use of client/server certificate UsedAs value correct. The approach is the company running the service wants to validate we are passing them their certificate they issued us. Note that I generated the CSR from the server using the UniAdmin tool. This was sent to the service company and they generated us a .cer file. I then put this file in the location referenced via the certPath. 3) Has anyone experienced the same sort of logic where you kill the session and then the data goes through. I'm working with the service company to get the logs they are seeing on their end. If I can I'll pass those along. Any help would be greatly appreciated. 086: URL = ITEM.MASTERNET$COMPANY.SERVICE 087: SoapAction = http://company.com/SPS/contracts/SPSService/GetAllPayerPayment Methods 088: Timeout = 3 089: * Create Security Context 090: SecContext = createSecurityContext(ctx, 'SSLv3') 091: IF SecContext=0 THEN 092: * Security Context OK 093: END ELSE 094: CALL SB.PROCESS('ERROR.MSG,3701,Security Context Failure') 095: RETURN 096: END 097: * Set Cert Path 098: CERT.PATH = ITEM.MASTERNET$COMPANY.CERT 099: RETURN = addCertificate(CERT.PATH, 1, 1, 1, ctx) 100: * Add Authentication Rule 101: RETURN = addAuthenticationRule(ctx, 2, VerificationStrength, generous) 102: RETURN = addAuthenticationRule(ctx, 2, PeerName, company.com) 103: * Create the Request 104: Ret = setHTTPDefault(VERSION, 1.1) 105: IF Ret = 0 THEN 106:* Set HTTP Default OK 107: END ELSE 108: CALL SB.PROCESS('ERROR.MSG,3701,Set HTTP Default Failure') 109: RETURN 110: END 111: Ret = SOAPCreateSecureRequest(URL, SoapAction, SoapReq, ctx) 112: *Ret = SOAPCreateRequest(URL, SoapAction, SoapReq) 113: IF Ret=0 THEN 114:* Create Secure Request OK 115: END ELSE 116: CALL SB.PROCESS('ERROR.MSG,3701,Create Secure Request Failed') 117: RETURN 118: END 119: * Submit the Request 120: SetRequest.Status = SOAPSetRequestContent(SoapReq, GETALLPAYERPAYMENTMETHOD S,1) 121: IF SetRequest.Status=0 THEN 122:* Request Content Status OK 123: END ELSE 124: CALL SB.PROCESS('ERROR.MSG,3701,Request Content Status Failed') *--: P 125: RETURN 126: END 127: Ret = SOAPSubmitRequest(SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) 128: IF Ret 0 THEN 129:* Error in SoapSubmitRequest 130: STATUS=getSocketErrorMessage(Ret, errMsg) 131: CALL SB.PROCESS('ERROR.MSG,3701,':errMsg) 132: RETURN 133: END 134: * 135: * 136: * Parse Response Data (RespData) 137: * 138: RESPXML = RespData ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Connection Pooling Statement
I RedBack you would be using WebShares which is basically like Connection Pools. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, September 24, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? Ross Ferris wrote: Doug, I fear that if you look at the terminology and description that IBM (Rocket may change, but somehow I doubt it) use to describe a connection pool, though you may like to think that your connection manager is different, I fear you may fall foul of their definition and if you look at your 175 user system running off 2 licences you can understand why (I assume that the 175 users also use other stuff, rather than everyone using NOTHING BUT your CRM) ___ 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] GOOD NEWS From Susie
You mean pocket rockets (poker reference to two Aces - UniData and Universe). :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Tuesday, September 15, 2009 2:11 PM To: 'U2 Users List' Subject: Re: [U2] GOOD NEWS From Susie Looking at their website, from the number of offices that Rocket has, it looks like they grant some autonomy to the Product/Groups they purchase. This could bode well for Susie and her group if they are given more latitude to do what they need to 'to build a better rocket'. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Tuesday, September 15, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] GOOD NEWS From Susie All, I just got off the phone with Susie Seigesmund. She has assured me that her entire team has been invited to stay together, Rocket didn't just buy the software or the customer list or the channel, they are buying into the people who supported us all along. More news as I have it. Also, watch U2UG.org, as we will be updating teh front page several times in the next few days. - Charles Barouch ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] IBM Certification Test - Administering UniData 7.1
Does anyone know how different the real Certification test is from the practice test for the Administering UniData 7.1 test? I know the format is the same and there are about 1 or 2 additional questions added to the number of questions, but are the questions the same and if not how different are they in general. Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need assistance replicating UniObjects.NET issue
After speaking with our administrator he said: Technically the card and switches are set to Auto-Duplex, which means they are running in Full Duplex mode. One weird things is these transport errors only occur between 1 AM and 6 AM. We receive multiple in that time span but not all at the same time and the same client does not have more than one. For example: 2:01 AM Client A has the issue 2:32 AM Client C has the issue 2:46 AM Client B has the issue 2:59 AM Client D has the issue I should mention that our backups complete before 2AM. The night before they were staggered like this but it all started at 3:00 AM. Here is the interesting thing. We have 5 minute trapping of the listuser on our UniData server. We trap how many connections each client is using (count of udcs by authentication credentials). Every time this transport occurs it occurs when a new udcs connection is being spawned. For example client A may have not connections because the worker process on IIS has shutdown for inactivity. When activity occurs and the worker process spawns the min connection I believe that connection is throwing the transport error. It also occurs when a client has had a min connection of one and then it spawns a new connection and that new connection has the transport error. I believe these new connections are the ones getting the transport error and I don't see the count go up because a new one is spawned as a result of the transport error happening. This is because the logs on the server are only every 5 minutes. Weird. We are bumping up network logging but again we are pretty much done with trying to figure out why and just writing better code to handle the error when it occurs. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, April 22, 2009 1:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need assistance replicating UniObjects.NET issue I presume this is an intermittent error you are getting ? Are you using the latest uodotnet.dll that goes with udt 7.1 ? I see you are on windows, i am not sure if it has the same problems - i know on *nix you have to get the LANG env variable correct. This may happen i suppose if your backend process crashes out, maybe becuae of a corrupt file or the machine is having some sort of problem - it may be worth seeing what else is happening when this happens. If you are capturing the exception in your .net app you can add some further info regarding what processes are running, time date etc into your error log. Is your network card set to full duplex and the switch port it is connected to as well, i have had problems when comms have been in half duplex, and the connection is busy. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: 22 April 2009 02:17 To: u2-users@listserver.u2ug.org Subject: [U2] Need assistance replicating UniObjects.NET issue Does anyone have any insight into how to create the following error. Error Message: IBMU2.UODOTNET.UniXMLException: Unable to read data from th transport connection: An existing connection was forcibly closed by the re host.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. UNIDATA 7.1.0 Windows 2003 I've tried killing the udapislave.exe process associated with the connection and then accessing the connection. I get a similar error but not this one. I've tried to sleep to long but noticed I we don't set the timeout property on the UniObject and the default is no timeout. So it just sits there waiting. I haven't tried unplugging the network cable yet or mimicking some network interruption. Any ideas would be greatly appreciated. Thanks, Glenn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need assistance replicating UniObjects.NET issue
I am getting the error intermittently and in production. We are using the latest DLL on several of the clients that are having the issue, but there are clients using the older version that are also getting the issue. We have not had to do anything with the LANG environment variable for our UniObjects implementation to work. The issue is not happening due to a corrupt file. In our logging we know the queries the transport happened on. I can go into the account and run the UniQuery statement from ECL and it works just fine. I'm not sure about your network card full duplex comment. I've sent your email over to our admin for clarification. The servers are setting in the same rack/switch (big enough pipe). Right now I've pretty much given up on trying to figure out why the exception is occurring and just try to make sure the code will handle the issue more gracefully. So I wanted to try and replicate to make sure our code is good before putting in to production. Thanks for the feedback. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, April 22, 2009 1:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need assistance replicating UniObjects.NET issue I presume this is an intermittent error you are getting ? Are you using the latest uodotnet.dll that goes with udt 7.1 ? I see you are on windows, i am not sure if it has the same problems - i know on *nix you have to get the LANG env variable correct. This may happen i suppose if your backend process crashes out, maybe becuae of a corrupt file or the machine is having some sort of problem - it may be worth seeing what else is happening when this happens. If you are capturing the exception in your .net app you can add some further info regarding what processes are running, time date etc into your error log. Is your network card set to full duplex and the switch port it is connected to as well, i have had problems when comms have been in half duplex, and the connection is busy. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: 22 April 2009 02:17 To: u2-users@listserver.u2ug.org Subject: [U2] Need assistance replicating UniObjects.NET issue Does anyone have any insight into how to create the following error. Error Message: IBMU2.UODOTNET.UniXMLException: Unable to read data from th transport connection: An existing connection was forcibly closed by the re host.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. UNIDATA 7.1.0 Windows 2003 I've tried killing the udapislave.exe process associated with the connection and then accessing the connection. I get a similar error but not this one. I've tried to sleep to long but noticed I we don't set the timeout property on the UniObject and the default is no timeout. So it just sits there waiting. I haven't tried unplugging the network cable yet or mimicking some network interruption. Any ideas would be greatly appreciated. Thanks, Glenn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need assistance replicating UniObjects.NET issue
I tried setting up the logging on our development servers to see how it works but there was really not any information being logged. All I saw was startup type info and logging of the authentication of the user. So only about 3 lines of logs for many queries to the database. Maybe the issue is on my development server it was using the old UniObjects DLL. I'll have to try and correct this to see if I get more logging with the new one. One concern is we have a bunch of clients running on the same server and so I'm not sure how well I'll be able to weed through the debug logs or if there is any performance impact I should be concerned about. Thanks for the feedback. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, April 22, 2009 10:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Need assistance replicating UniObjects.NET issue Glen: Are you logging the UniObjects connection? This may give you some additional information (it usually does for me). To do so you should create a file in the ud71 directory named serverdebug. I put the following line in mine: udcs 9 E:\IBM\ud71\log\udcs\udcs.log As you can see, the output goes to a new directory, ...\ud71\logs\udcs. To turn logging off change 9 to 0 (no quotes). HTH, Bill -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: 22 April 2009 02:17 To: u2-users@listserver.u2ug.org Subject: [U2] Need assistance replicating UniObjects.NET issue Does anyone have any insight into how to create the following error. Error Message: IBMU2.UODOTNET.UniXMLException: Unable to read data from the transport connection: An existing connection was forcibly closed by the re host.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or Unidata version. UNIDATA 7.1.0 Windows 2003 I've tried killing the udapislave.exe process associated with the connection and then accessing the connection. I get a similar error but not this one. I've tried to sleep to long but noticed I we don't set the timeout property on the UniObject and the default is no timeout. So it just sits there waiting. I haven't tried unplugging the network cable yet or mimicking some network interruption. Any ideas would be greatly appreciated. Thanks, Glenn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need assistance replicating UniObjects.NET issue
Does anyone have any insight into how to create the following error. Error Message: IBMU2.UODOTNET.UniXMLException: Unable to read data from th transport connection: An existing connection was forcibly closed by the re host.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. UNIDATA 7.1.0 Windows 2003 I've tried killing the udapislave.exe process associated with the connection and then accessing the connection. I get a similar error but not this one. I've tried to sleep to long but noticed I we don't set the timeout property on the UniObject and the default is no timeout. So it just sits there waiting. I haven't tried unplugging the network cable yet or mimicking some network interruption. Any ideas would be greatly appreciated. Thanks, Glenn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV to SAP migration disaster
OMG. That is hilarious. Thanks for sharing. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Monday, April 20, 2009 3:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster An IBM vendor went to a company I used to work for to try to get them to dump their current Unidata database and switch to DB2, how much new and better it was. One of the advantages he listed was IBM support. So one guy in our IT department told him: You really don't know anything about Unidata do you ? So the vendor asked him what he meant by that. So he told him: Unidata's an IBM product currently supported by IBM. You didn't even know that. What kind of credibility can you expect to have in listing DB2's advantages Unidata if you didn't even know that ? It's not a good thing when a guy in a company bashes his own company's product. At least the guy had the sense to look embarassed. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects connection timeouts?
Have you checked your unirpcservices file timeout value. It may be UniRPC timing out the connection on the server. Glenn -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, April 01, 2009 10:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/ index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData on VMWARE
I know this has been asked before but I cannot access the archive. I'm looking for anyone with experience of a production UniData system running in a VMWARE environment. Thx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects and UniData Triggers (UD 7.1)
We are having a problem with UniObjects calling a UniData subroutine that updates a file with a trigger on it. The first part of the problem dealt with the global catalog. The error we received was Unable to load the subroutine on the server Source. There was a Tech Note on a solution, to setup an entry in the ud_database file that pointed to the account we needed to connected to. Once the ud_database was setup then we changed the AccountPath property to the ud_database entry instead of the full path to the account (i.e. C:\this\is\the\path\to\the\account). The reason this was needed is we had a separate Global Catalog setup, due to multi-client environment setup. When testing this change we ended up with another UniObjects exception which did not give us much to go on. The second exception is below. ThreadID: 7 Name : Enter UniSession::CreateUniSubroutine() ThreadID: 7 Name : Enter UniSubroutine::UniSubroutine(UniSession pSession,string pSubName, int pNumArgs) ThreadID: 7 Name : Enter UniSubroutine::ResetArgs() ThreadID: 7 Name : Exit UniSubroutine::ResetArgs() ThreadID: 7 Name : Exit UniSubroutine::UniSubroutine(UniSession pSession,string pSubName, int pNumArgs) ThreadID: 7 Name : Exit UniSession::CreateUniSubroutine() ThreadID: 7 Name : Enter UniSubroutine::SetArg( int aArgNum, string aArgVal ) ThreadID: 7 Name : Exit UniSubroutine::SetArg( int aArgNum, string aArgVal ) ThreadID: 7 Name : Enter UniSubroutine::SetArg( int aArgNum, string aArgVal ) ThreadID: 7 Name : Exit UniSubroutine::SetArg( int aArgNum, string aArgVal ) ThreadID: 7 Name : Enter UniSubroutine::Call() ThreadID: 7 Name : [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30102] Unknown Error [30102] Occurred Source: UniSubroutine Class Method: ThreadID: 7 Name : Enter UniObjects:: CloseSession() We are using UniData 7.1 (710) and SB+ 5.2.4. Note the subroutine does go through a process of calling SB.REMOTE.PROCESS so we can get into the SB+ environment for the subroutine, but I don't think this should matter. This process works fine in all other cases. Does anyone have any input or recommendations on this? Glenn Batson -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Need better description of UO.NET Error 22001
Can someone explain to me what Error 22001 in UO.NET is. The error text and documentation reference Bad field number. What does Bad field number mean? Does it mean something like index out of range for a dynamic array? Glenn Batson Development Manager Jenkon [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 360-256-4400 Phone 360-256-9623 Fax www.jenkon.com http://www.jenkon.com/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniXML exception from UO.NET
It just took me getting away from it a little. The problem was I had some subroutines that were called from my dictionaries that either needed to be compiled or cataloged. I did both so not sure which one fixed it. Glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Batson Sent: Friday, February 24, 2006 9:40 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniXML exception from UO.NET I have a piece of code that submits a query through UO.NET like: list SQL_DIST WITH DIST_NBR = 11 ID NAME ID.SUPP TOXML *** Note there are a lot more columns than what I show in the above query. I get the following exception. Can anyone give me pointers on what the error is trying to tell me. I see the error in the UO.NET documentation but it is just a mapping of numbers to error, so not much help. The query does work from the ECL. Exception: IBMU2.UODOTNET.UniXMLException Message: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30111] This is not an I-Type or the I-type is corrupt[IBM U2][UODOTNET - UNICLIENT][ErrorCode=91] Please verify UniVerse or UniData Version. This feature may not be supported in older UniVerse or UniData version. Glenn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UO.NET and SB+
My understanding is the sbobject is the state based implementation and was too slow. My understanding was the stateless was more performant but not sb aware. Again past experience keeps is from going back. -- Sent from my BlackBerry Wireless Device -Original Message- From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sat Jan 28 05:54:41 2006 Subject: RE: [U2] UO.NET and SB+ Glenn If you were considering a WWW route then RedBack supports SBObjects directly and gives you a connection pool while at the same time being SB+ aware. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Batson Sent: 26 January 2006 23:12 To: u2-users@listserver.u2ug.org Subject: [U2] UO.NET and SB+ I sent this to SB+ solutions but I also thought someone here might have some opinions. Sorry if this has been discussed before. I'm having problems getting to indexinfocus.com to do a search. Is anyone using UO.NET in an environment that includes SB+. We are and to get into SB+ we have a wrapper subroutine that passes data through COMMON to an SB+ aware subroutine called by SB.REMOTE.PROCESS. I would like to know what other approaches may be used. One concern for us now is the overhead of the login logic that occurs every time. We are not trying to get around the license but are concerned with the processing overhead. In other words for every API call that calls a routine that uses SB+ we call SB.REMOTE.PROCESS which has to go through a login. I would like the login to stay persistent through the life of the connection pool connection. Does anyone have any suggestions or other secret ways of handling what we are trying to do? I know the initial response is why not use RedBack. We had a bad experience with RedBack and therefore went away from it. I definitely don't want to say RedBack is bad, because it may have been our own fault in how we implemented it. We just have a sour taste in our mouths and will not go back. Actually we ended up using SB.REMOTE.PROCESS in the RedBack world also because stateless RBOs did not support SB+ execution. Any input would be appreciated. Glenn Batson www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UO.NET and SB+
I sent this to SB+ solutions but I also thought someone here might have some opinions. Sorry if this has been discussed before. I'm having problems getting to indexinfocus.com to do a search. Is anyone using UO.NET in an environment that includes SB+. We are and to get into SB+ we have a wrapper subroutine that passes data through COMMON to an SB+ aware subroutine called by SB.REMOTE.PROCESS. I would like to know what other approaches may be used. One concern for us now is the overhead of the login logic that occurs every time. We are not trying to get around the license but are concerned with the processing overhead. In other words for every API call that calls a routine that uses SB+ we call SB.REMOTE.PROCESS which has to go through a login. I would like the login to stay persistent through the life of the connection pool connection. Does anyone have any suggestions or other secret ways of handling what we are trying to do? I know the initial response is why not use RedBack. We had a bad experience with RedBack and therefore went away from it. I definitely don't want to say RedBack is bad, because it may have been our own fault in how we implemented it. We just have a sour taste in our mouths and will not go back. Actually we ended up using SB.REMOTE.PROCESS in the RedBack world also because stateless RBOs did not support SB+ execution. Any input would be appreciated. Glenn Batson www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UO.NET registry exception in method dealing with performance counters
I had a question a couple of weeks back regarding the subject line. As part of that message I stated I had lost the exception that UO.NET was throwing. Well I finally got it replicated again on a new server. Below is the exception. As was mentioned in the earlier email, assigning Local System to the Application Pool identity for IIS, fixed the exception and then I could set it back to Network Services. So I'm real certain this has to do with IIS not having enough permissions to do the registry update. Does anyone have ideas on how to accomplish this, without changing the Application Pool identity? Glenn Batson Server Error in '/' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Requested registry access is not allowed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SecurityException: Requested registry access is not allowed.] Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable) +473 System.Diagnostics.PerformanceCounterLib.CreateRegistryEntry(String machineName, String categoryName, CounterCreationDataCollection creationData, Boolean iniRegistered) +184 System.Diagnostics.PerformanceCounterLib.RegisterCategory(String machineName, String categoryName, String categoryHelp, CounterCreationDataCollection creationData) +43 System.Diagnostics.PerformanceCounterCategory.Create(String categoryName, String categoryHelp, CounterCreationDataCollection counterData, String machineName, String localizedIniFilePath) +923 System.Diagnostics.PerformanceCounterCategory.Create(String categoryName, String categoryHelp, CounterCreationDataCollection counterData) +17 IBMU2.UODOTNET.UniPerfCounter..ctor() +782 IBMU2.UODOTNET.UniObjects.set_UOPooling(Boolean value) +90 Jenkon.Web.BusinessObjects.WBO..cctor() in C:\Inetpub\wwwroot\Branches\2.3.0-IH4\WebBusinessObjects\WBO.cs:77 Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UNiOLEDB
Stuart Boydell wrote, I'm wondering what peoples experience of using UniOLEDB is.. Here is our experience. Our environment experience has been on version 6 of UniData on Windows 2003. 1) Our engineer's had a heck of a time getting the right connection string to work. It has been such a long time back that I don't remember what the problems seemed to revolve around. Once it started we moved on. 2) We used it for an ASP.NET application. I'm not a .NET engineer but since it is a COM DLL I'm certain there was COMInterop involved. Since it was COM then yes it ran in unmanaged code. We were able to implement C# code that called interfaced with the DLL and ran as a Windows service, getting its request from a MSMQ queue. We did not use ADO.NET pooling. I would have to query and engineer on why, but my guess is it does not fit. 3) The real issue is it uses the UniData SQL engine, which did not perform to our expectations. Additionally we implemented our own connection pooling by using window services and MSMQ queues, but we were told this is not how it is intended to be used. It is intended more for a client server implementation. Either as a result of our implementation or the UniOLEDB implementation, we seemed to have issues with timeouts that fully could not be explained. The overhead of using VSG to define the SQL Schema and setting up uci.config and ud_database was not appealing. 4) Note we only used it for querying data and not updates. We have a lot of business logic tied up in UniBasic and SB+ therefore we have to use UniObjects (and RedBack in the past) to call subroutines. So you end up having more database connections than you would like. 5) Our impression has always been that having UniData on Unix on the backend will perform better and be more stable. Our problem is the majority of our market will not support Unix deployments whether on principal or practice. We are running this environment in production though and it is workable just too many issues. Therefore we are moving away from it and using UniObjects.NET and UniData 7.1. We are switching all our SQL statements over to UniQuery statements that generate data to XML. So for most of the simply queries with string data have worked within the MS dataset. We are using XSLT to for the others. One reason is to get in an environment IBM supports and that is not a COM implementation. Additionally IBM says that native access is always faster (native being subroutines and uniquery). If you have questions you can contact me directly. Also though I have not had any experience with it you may want to look at MV.net. Glenn Batson 360.256.4400 www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/