RE: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread David Wolverton
This is starting to sound like a case that needs to be logged with IBM - We know IBM people watch the list, and the fact no one has chimed in after all this time tells me there's probably more to your issue - it's not going to be a UserList fix, sorry to say! Hopefully the customer has a 'paid in

RE: [U2] UniObjects 81009 error

2008-06-05 Thread Symeon Breen
81009 is rpc failed. This can happen for a number of reasons, it could be network related, it could be the data server timing out your connection. A few points to look at / questions Is this ud or uv ? Does it take a fair amount of time to happen ? - what are your timeout settings for

[U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Louie Bergsagel
IF statements don't work in my paragraphs any more. They worked yesterday. No upgrades or changes that I know of. LOGIN.TEST Your 'VOC' has been modified to use long file names. Illegal IF statement. Illegal IF statement. CT VOC LOGIN.TEST LOGIN.TEST 0001 PA 0002 PTERM CASE NOINVERT 0003

RE: [U2] UniObjects 81009 error

2008-06-05 Thread u2ug
Thanks Symeon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: June 5, 2008 11:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniObjects 81009 error 81009 is rpc failed. This can happen for a number of reasons, it could be

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Ken Hall
Louie - I noticed that you have included a LONGNAMES ON statement in this login test. LONGNAMES ON should only be run once in each account, not repeatedly. I don't know if that is your problem, but it might be. Ken At 09:59 AM 6/5/2008, you wrote: IF statements don't work in my paragraphs any

Re: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread Kevin King
Yeah, I've hoping Wally might chime in, but... This is really a deal breaker right now, and it's giving us a black eye that we can't seem to fix whatever this is. On Thu, Jun 5, 2008 at 5:26 AM, David Wolverton [EMAIL PROTECTED] wrote: This is starting to sound like a case that needs to be

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Louie Bergsagel
I commented out that LOGNAMES line, logged out, and in, and ran LOGIN.TEST again, and it still gives me an Illegal IF statement. error message. I'm also finding dictionary I-TYPES not working today that worked yesterday: LIST REPORTS START.DATE UD.TODAY WITH START.DATE = UD.TODAY Bad data = for

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Louie Bergsagel
I found the problem. Somebody had deleted the = VOC record. ED = Unable to open =, not a file in VOC. I restored it from EQ. -- Louie CT VOC =EQ = 0001 K 0002 4 EQ 0001 K 0002 4 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

RE: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Ron Hutchings
On Line 6 don't you need to go to a label to execute a command instead of trying to directly execute it? Date: Thu, 5 Jun 2008 09:59:00 -0700 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Universe: IF statements in parargraphs don't work anymore IF statements

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Dianne Ackerman
We had something similar happen once - check if the VOC entery for TERM has been changed. -Dianne At 09:59 AM 6/5/2008, you wrote: IF statements don't work in my paragraphs any more. They worked yesterday. No upgrades or changes that I know of. LOGIN.TEST Your 'VOC' has been modified to

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Nancy Fisher
Thanks! Good to know. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 Visit our Website www.peninsulatruck.com [EMAIL PROTECTED] - Original Message - From: Louie Bergsagel [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, June 05, 2008 12:56

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Louie Bergsagel
No, that works fine. You only need a label if you want to skip some lines. Turns out somebody had deleted the VOC equal sign record =. Which brings up a good security question, how do you prevent someone from deleting things? Put shell around ED and DELETE? It would be a bummer to have to make

Re: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread Wally Terhune
Kevin King wrote: Yeah, I've hoping Wally might chime in, but... This is really a deal breaker right now, and it's giving us a black eye that we can't seem to fix whatever this is. __ I'm really not the best U2 support resource to deal with ODBC issues. You really

RE: [U2] Universe: IF statements in parargraphs don't work anymore

2008-06-05 Thread Bessel, Karen
Has anything happened that may have wreaked havoc with your Pick flavor? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com

Re: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread Geoffrey Mitchell
I don't think this is relevant, but I'll throw it out there as a longshot We had a problem with JDBC where we would get memory leaks if we didn't close our Statements. Closing the connection wasn't enough (in most databases, closing the connection implicitly closes the statements). The

Re: [U2] re:form multiple spreadsheets excel file in universe

2008-06-05 Thread Louie Bergsagel
The program? What program? We sure could use one. -- Louie Bergsagel North Coast Electric On Tue, Jun 3, 2008 at 1:33 PM, Irina Lissok [EMAIL PROTECTED] wrote: Hi everyone, We have the program which runs and creates separate excel files for relational data. --- u2-users mailing

Re: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread Results
I had a problem like this once when thee software on each end implemented threads differently. One was expecting Apartment threading and the other was expecting something else... I think it was coclass inits. I don't know if that applies here, but it sounds real similar. - Chuck Kevin King

RE: [U2] Unidata 7.1 ODBC Threading Problems?

2008-06-05 Thread David Jordan
This is just a wild thought as I do not know the details of what you are doing. Maybe look at a transaction process around the routine, where you set the transaction level to the lowest. When operating in ODBC you need to deal with RDBMS logic more that U2 for file processing. To get a clean

RE: [U2] re:form multiple spreadsheets excel file in universe

2008-06-05 Thread Colin Alfke
See also: www.nebula-rnd.com/products/xlite.htm hth Colin Alfke Calgary Canada From: louiebergsagel The program? What program? We sure could use one. -- Louie Bergsagel North Coast Electric On Tue, Jun 3, 2008 at 1:33 PM, Irina Lissok wrote: Hi everyone, We have the program which runs