Re: [U2] SOAP in UniBasic

2011-02-16 Thread Symeon Breen
Something to do with case I believe From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lunt, Bruce Sent: 16 February 2011 00:13 To: u2-users@listserver.u2ug.org Subject: [U2] SOAP in UniBasic I wrote a program to make a SOAP call for

[U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Stephen Jackson
I am new to the U2 java api. I am trying to make a subroutine call but get the following Exception. It is not in the documentation and I have not had a lot of luck tracking it down. I am able to make a simple query so not sure if there is some configuration or something I am not aware of which

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Steve Romanow
Make sure that the account you are trying to connect to is in the UD.ACCOUNT file that resides in the sys account. Here is what mine looks like. LIST UD.ACCOUNT F1 F2 F3 09:31:11 Feb 16 2011 1 VOC... F1 F2. F3. sys/usr/udtho rootud

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Symeon Breen
You get this if the backend dies for whatever reason, permissions, corrupt files etc... From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: 16 February 2011 14:28 To: u2-users@listserver.u2ug.org Subject: [U2]

[U2] Purging and Indexing

2011-02-16 Thread Glorfield, Gordon
Good Morning, Looking for opinions and experiences here. We are trying to do some system cleanups. We found that our PO file has over 10 million records dating back some 7 years. We've decided that 2 years of PO history is plenty to keep on file. Currently there are no indices on this

Re: [U2] Purging and Indexing

2011-02-16 Thread George Gallen
What about creating a new file first do a SELECT (not SSELECT) and only write to the new file the ones you want using a program (still might take a bit). CNAME the OLD FILE when done CNAME the NEW file to the original name Then build any indexs you want on the NEW file -Original

Re: [U2] Purging and Indexing

2011-02-16 Thread Steve Romanow
On 2/16/2011 10:07 AM, Glorfield, Gordon wrote: Good Morning, Looking for opinions and experiences here. We are trying to do some system cleanups. We found that our PO file has over 10 million records dating back some 7 years. We've decided that 2 years of PO history is plenty to keep on

Re: [U2] Purging and Indexing

2011-02-16 Thread Dan Fitzgerald
Is it a distributed file? If so, I'd write a basic program to loop through each of the parts sequentially (i.e., a basic select), read each record, evaluate archive or not, readnext. Then, I'd run a few iterations to run in parallel. You're right about the index overhead. If you had indices,

Re: [U2] Purging and Indexing

2011-02-16 Thread Dave Davis
Sounds like the purge should come first to me - your purge sounds like it will get rid of most of the records, so the date-based index isn't that helpful for selecting the old ones, and it will slow down the time it takes to delete each record. -Original Message- From:

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread David A. Green
Can you run the same subroutine from a Basic Program? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: Wednesday, February 16, 2011 7:28 AM To:

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Stephen Jackson
Thanks, let me investigates this and see what I find. On WednesdayF/16/11 9:41 AM, Steve Romanow slestak...@gmail.com wrote: Make sure that the account you are trying to connect to is in the UD.ACCOUNT file that resides in the sys account. Here is what mine looks like. LIST UD.ACCOUNT F1 F2 F3

Re: [U2] Purging and Indexing

2011-02-16 Thread Sammartino, Richard
In Unidata, the index would be build for the 10 million records. The purge would run a little longer as the index has be updated with every record removal. The size of the index file does not shrink with the purge of the records. From my experience, I would purge the file and then build the

Re: [U2] Purging and Indexing

2011-02-16 Thread David A. Green
I would SELECT, SAVELIST, GETLIST, COPY to PO.HIST, GETLIST, PURGE PO. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Wednesday, February 16,

[U2] MAKEXML

2011-02-16 Thread Steve Romanow
Keith Johnson, do you frequent the list? I have made some Unidata patches to MAKEXML and wondered if you want these adjustments. Thanks, Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Purging and Indexing

2011-02-16 Thread Israel, John R.
Building the index will take some time. Purging data from the index as you purge the actual data will also take extra time. The more indexing there is, the longer it takes to completely file or delete a record. Purge the data first, then build your index with nothing but clean data. John

Re: [U2] UniObjects Java

2011-02-16 Thread Norman Bauer
Thanks Jeff. You may get an email from me in the near future. Norm On Tue, Feb 15, 2011 at 7:58 PM, Jeff Powell j...@powellclan.com wrote: I do a lot with UOJ and I'd be happy to help. Contact me offline if you're interested. On 02/15/2011 02:43 PM, Norman Bauer wrote: ha ha I can see

Re: [U2] Purging and Indexing

2011-02-16 Thread FFT2001
I agree with the opinions expressed, but wish, as one writer has already, to stress the *reason*. Thrashing the disk is a very bad idea. If you want to do any operation whatsoever, on more than say thirty percent of any file, the best course is to do that operation in disk order i.e. frame

Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred

2011-02-16 Thread Hona, David
Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest

Re: [U2] Strange occurance with Universe on windows unclassified

2011-02-16 Thread Holt, Jake
Just wanted to submit that we found out what the issue was (thanks to some folks on another users group). Apparently only the DC with the PDC Emulator FSMO role will work to validate and login users using the home directory/home account setting. We migrated the FSMO role and it worked fine.