Dave, I respect your opinion of my bad form but given that there has been
little to no information on this topic, would it make sense to sit on the
knowledge that there is a problem (regardless of who is to blame) and just
let others stumble blindly into it themselves?
It's likely that that the
Overall, I would have to agree. There have been missteps along the way, but
as was mentioned before, it happens with any product. I do wish I had come
to this list first rather than going through Rocket support. Might have
avoided some embarrassing crow.
On Fri, Feb 18, 2011 at 1:13 PM,
Ah Bill, that was you? Thank you! That was the problem I ran into last
week and the new UDT.OPTION fixed very nicely.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
About a week ago I upgraded Unidata 7.1 on Windows XP/32 to Unidata 7.2 on
Windows 7/64. Everything I need in Unidata seems to work fine on this
release with one notable exception: Unidata 7.2 on Windows will no longer
properly execute the Windows ftp program. Rocket support has basically said
...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, February 17, 2011 5:48 PM
To: U2 Users List
Subject: [U2] Frustrated with Rocket / Unidata 7.2
About a week ago I upgraded Unidata 7.1 on Windows XP/32 to Unidata 7.2 on
Windows 7/64. Everything I need in Unidata seems to work fine
I wonder if the ftp on Win2003 is better than the ftp on Win7?
Sure, I realize that it's about impossible for Rocket to know every little
incompatibility with Windows versions but ftp? That's pretty crucial.
___
U2-Users mailing list
I dunno man. There's some really good folks in the U2 group but sometimes I
wonder if the decision makers over there ever consider that there are real
people trying to use these products?
On Thu, Feb 17, 2011 at 8:14 PM, Charlie Noah cwn...@comcast.net wrote:
Totally OT, and I'm just musing
Thanks for the chuckle - that was funny!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Oh, I completely agree. But the point isn't FTP vs. SCP or SFTP, the point
is the value (or anti-value) of unexpectedly breaking existing code.
For years I've been preaching about making reusable components of things
that are on the fringe of the operating environment to minimize the impact
of
I have a bit of code that issues this command (basically) for logging:
WRITESEQ MESSAGE APPEND ON F.SEQ ELSE NULL
Yesterday, this program started throwing errors like this:
In *...program...* at line 29 write error, errno = 9
The item size at this time is 11M, nowhere close to the 2G max size
I'd like to rename this topic to when umask attacks. Come to find out the
problem with this WRITESEQ was that the log record got created by a user
with a umask of 022 and was being updated by a user with a umask of 007.
This caused the log to be created with rw-r--r-- permissions and even
though
P.S. Thanks to BobW for the offlist assistance!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I have a customer setting up a Win7/64 box for UPS Worldship. Previously
they had a XP/32 box in that same place running an earlier version of the WS
solution. They've installed the Unidata ODBC driver (which is 32-bit) and
have configured it, and have tested it successfully using Excel. (By
.
Good luck!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Wednesday, January 26, 2011 9:50 AM
To: U2 Users List
Subject: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
I have
Nothing in the event log. Not sure how to enable a DSN trace within the
Fedex app. Input?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Where will the log be written?
On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny jscha...@gmail.com wrote:
turn it on in the configuration tab of the data source, bottom right
Kevin King wrote:
Nothing in the event log. Not sure how to enable a DSN trace within the
Fedex app. Input
Ah, I see it now. It's in the Tracing tab here.
On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny jscha...@gmail.com wrote:
turn it on in the configuration tab of the data source, bottom right
Kevin King wrote:
Nothing in the event log. Not sure how to enable a DSN trace within the
Fedex app
I'm like Jeff. I prefer a separate file and routine for generating
sequential numbers. This allows for prefixing, suffixing, formatting,
padding, and validation of the numbers from one bit of code. Certainly
there is always the issue of what happens when a file becomes corrupted, but
that's
Two things come immediately to mind... First, to force people off you're
shutting down Unidata altogether? Seems a bit harsh, that's all I'm
saying. Second, what about deleteuser instead of udtkill? I'm not a fan of
deleteuser (because even the documentation says it can cause corruption) but
I would think the migration would be application specific. That said, it
certainly wouldn't be a difficult thing to write.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Getting everything you want in one read is practical in limited
circumstances. Getting what you want in one REQUEST, however... that's much
more valuable.
We use JSON formatted strings to pass structured data into and out of
Unidata using subroutines to collect everything we need. This allows a
Shawn, while I applaud the concept of finding a way to plug a MV database in
where a SQL database might otherwise be ensconced, one problem with the
attempt is that while the storage itself is a different animal, more so is
the access. Most of these types of apps that rely on a SQL database do so
Yes, on the BASIC side. You use CHANGE in BASIC to convert a
multidimensional JSON object to a dynamic array? Okay, you have my
attention... do tell please.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
The problem as I see it Mecki is that we have effectively two kinds of
arrays in JSON; name/value pairs and sequential arrays. So perhaps I'm
over-complicating but it seems problematic to represent scalars, NVPs, and
sequential arrays with dynamic arrays - at least in a way that would allow
the
We also do a lot with JSON but a JSON string can go far beyond attributes,
values, and subvalues. Would be interested in Doug's take on how to extract
something out of a JSON string without parsing it from scratch on every
extraction, and how he would represent 4 or more dimensions in a MV item?
In our JSON implementation (moving information between U2 and PHP) we've
artificially limited the data coming into U2 so that it doesn't go deeper
than (effectively) multivalues. We allow the data going out of U2, however,
to be nested significantly deeper. For this product the limit isn't a
There are a number of differences between running Unidata on Unix vs.
Windows. Performance and everything else as stated not withstanding, one of
the gotchas that always seems to surprise people is that on Unidata on Unix
if you have a DIR-type file you can write records into it with a * in the
Is there any way to tell - in a cron script - if Unidata is paused?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Yeah, that's what I was looking for - thanks!
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I'm a little confused when you say:
There is no CLOSE basic statement executed; only a free(filevar)
filevar=''
Because above that I see:
CLOSE F.VAR
An even more interesting question: how'd you get the source to SB.FILEVAR.S?
___
U2-Users mailing
On earlier versions of SB+ - running on Unidata - we have created a couple
of processes that can be used to create and delete a temporary work file for
use by whatever logic falls between the CREATE.WORK.FILE and
DELETE.WORK.FILE processes. In trying to port these to SB/XA on UV we're
running
If we're talking Unidata there are memory considerations based on how
something is cataloged. Catalog something globally and throw a thousand
users at it and at most it'll be loaded into memory once. Don't catalog it,
or catalog it locally or direct and each user will get their own copy of the
Found the issue. Apparently in this version of SB+ when you WRITE something
to a file in a paragraph, SB+ opens the file to a buffer variable that it
holds open until the paragraph terminates. So when the paragraph (with the
WRITE) called the DELETE.WORK.FILE routine, the calling paragraph had
Let's be careful we're lobbing grenades at the right enemy. As I see things
the conflict here isn't choosing vendor supplied solutions vs. open source,
the problem is the vendor doing a poor job of making something that is
usable and truly useful.
There is a time and place for both vendor
Brilliant article! Thanks for sharing.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Unidata 6.1.15 on AIX. The following command:
SSELECT SHOPPING.LIST BY.EXP PROD.NUM
Yields the message too many values in sort. There is one record in this
file with 36,457 product numbers but would that break the BY.EXP? If so,
is there a config parameter somewhere that could be tweaked to
...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Monday, October 25, 2010 10:54 AM
To: U2 Users List
Subject: [U2] too many values in sort
Unidata 6.1.15 on AIX. The following command:
SSELECT SHOPPING.LIST BY.EXP PROD.NUM
Yields the message too many values in sort. There is one record
Mike, I agree with you. This is unfortunately a vendor application and
they're storing quick retrieval lists of products. The customer can build
these lists (via Excel import) as big as they want.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Second the cyber-spanking. C'mon gents, last thing we need is more
politician-esque shots across the bow.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
If the value already has the decimal point in it, MR2 or MD2 will scale the
value as well as round. If you want to leave the decimal place alone, use:
ROUNDED = OCONV(ORIGINAL.VALUE,'MR20')
Remember that MR2 or MD2 is the same as MR22/MD22, where the first number is
the number of decimals to
John, what you've described is a feature of the GUI; the ability to click
through prompts in any order. If there are mandatory fields you shouldn't
be able to save the record until those fields have a value, but if those
fields are not mandatory the validation may never run. This can, of course,
Did some testing today to see if Uniobjects could still read data when the
database is paused. Negative. In attempting to connect to Unidata via
Uniobjects an error 39207 is returned. This error is of course not
documented in the Uniobjects documentation.
Is there a comprehensive list of UO
I'm particularly fond of the word correctly in that comment. It's one
thing to fail in reading. It's another to fail in reading correctly. :-)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
What about creating a view against the table and using the view in your
join?
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
*We rely pretty heavily on legacy documentation, so I figured this might be
newsworthy to others as well...*
Only Three More Months to Get Legacy On-line Documentation
As of 30 September we will be removing old documentation from our Web site
and replacing it with the latest documentation
We have had a number of problems with AE on UV/Windows; every now and again
- and sometimes repeatedly in the same couple of seconds - some catalog
pointer just disappears and AE stops working. We've experienced problems
with other UV sites and having catalog pointers just disappear but this is
If Mr. Bishop is removed from the list and we no are longer privy to his OOO
notices, will he make a sound?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Amy, what's the lock table look like during these delays?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Yeah Amy, LIST.READU EVERY. If something has filled up the lock table, it
could take some time for the terminating session to find and eliminate any
locks that are tied to that session.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
John has an interesting point. I thought QUIT was UV but looking into the
system in front of me right now it appears to be an SB+ thing running SH.OFF
out of DMSH. So that makes me wonder if the file size of DMSECURITY or
DMCONT or one of those DM files might be having an impact?
Amy, is LO (rather than QUIT) any faster?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
did you verify that LO is the default UV LO and not overwritten by
anything? If so, that definitely says the issue is in UV.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
How much space is being occupied for Unidata temp space? Have you restarted
Unidata on that box anytime recently?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Thursday, June 24, 2010 11:36 AM
To: U2 Users List
Subject: Re: [U2] UniData 'QUIT'
How much space is being occupied for Unidata temp space? Have you
I've never tried manually clearing the temp directory, but if a file has a
last modified timestamp older than the last time you started Unidata, I
wouldn't think there'd be any problems.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Support doesn't run on a standard clock, my friend... My only regret is
that we haven't put this one to bed yet, at least not confirmed.
On Sat, May 22, 2010 at 4:38 PM, Dave Laansma dlaan...@hubbardsupply.comwrote:
What are you people doing 'working' on a Saturday?!
Sincerely,
David
That's interesting, because refiling the group records is usually all it
takes. Did you refile the ROOT record?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
To recap: you logged in as the SB user, refiled all of the groups, and
you're still getting the XX message corrupt message? XX is a system?
user? group? account?
Just trying to clear my head and understand what SB+ thinks is incorrect.
I wouldn't think this would be much of an issue, but
AH what about refiling each of the F5-Accounts with Restrictions screens
from /SEC.GROUP.SETUP? Those have checksums as well - and refer to systems.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Susan, you said As far as I know, the user did not edit the record, he went
through the screens, so the checksum should be ok. Ah, if only it were
that simple. In some earlier releases of SB+ (and possibly as late as 5.3,
though I thought it was corrected in 5.2) if someone editing something in
I understand the beauty of being able to push reports out a slave printer,
but what do you do when the goal is printing labels with specific large
proportionally spaced fonts and center or right justification of the text?
___
U2-Users mailing list
Hey Peter, that sounds like the ticket for what I need. What version should
I look for?
Glen, the goal is to be able to print a label on a laser printer from a
keypress on the Unidata application side. The complexities are that the
label needs various fonts, most of them proportionally spaced
While the PW thing looks cool, and especially the integration with AccuTerm,
the customer is on an earlier version of AccuTerm and I'm not entirely
certain I can convince them to upgrade. But... we have some really good
ideas floating around here, and I appreciate all the input.
Been working with PrintWizard all afternoon, thanks. This looks like it'll
do the job nicely for our immediate need.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I realize this is an old thread now, but is there any way to improve the
speed of the AccuTerm file transfer (preferably using an error correcting
protocol)? On SBClient a 25K file takes a couple of seconds, on AccuTerm
the same file takes about 30 seconds.
I noticed that the AccuTerm ASCII transfer is markedly faster, but ...
there's no error correction there either (right?) and if this file loses an
inopportune character or two, well, bad juju can happen.
___
U2-Users mailing list
The end game at the moment is that a Unidata session will build a Word
document which is then opened by the client and printed. So the web service
probably isn't going to work in this context.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Glen, so how is it exactly that an event on the server will trigger this
transfer, open, print, and exit?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Thanks Robert, I see that now. But... how is one to actually use that data
source, say, in a SQL Server linked server context?
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
That's all unfortunate. I'm not sure if I'm more disillusioned by the hell
that I've gone through with Microsoft in terms of Windows versions and SQL
Server and linked servers and config and ... or with the overall state of
affairs with the Rocket/U2 connectors. If we can't connect people to our
Final update, hopefully.. As of this moment, IT'S WORKING!
The silver bullet in this situation was some option in SQL Server called
Allow inprocess. Not sure what this does exactly, but this option (in
Server Objects | Linked Servers | Providers | IBM.UniOLEDB) has to be
checked for SQL Server
Not sure how to do it strictly in Unidata, but you might setup a simple
Apache server that echos the headers back in the contents and then use this
to test the Unidata headers. Incidentally, what header seems to be the
problem?
-K
___
U2-Users mailing
Whether HTTP or HTTPS, the headers should be the same, right? So why not
test with a simple HTTP connection instead of going through the creative
dentistry of setting up IIS w/ HTTPS?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
Good info, Ben! Thanks for sharing!
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Could you post the output of your protocol log? Maybe someone here might
see something?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Well, IIS can do HTTP just like Apache. (Well, not exactly, but you know
what I mean.) But I like the protocolLogging option mentioned above. You
might try that first.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
404? Doesn't look like a header thing, looks like the URL is wrong.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I have a customer who has downloaded the most recent Unidata clients from
the Rocket website and is trying to install them on Windows 2008/64-bit.
The installation appears to go according to plan, there are no errors and no
events logged, and yet after installing the ODBC driver, the Unidata ODBC
As far as I know there isn't a way to prevent someone from closing the
telnet application.
-K
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
?
--- On Thu, 4/22/10, Kevin King precisonl...@gmail.com wrote:
From: Kevin King precisonl...@gmail.com
Subject: Re: [U2] SB CLIENT TERMINATION
To: U2 Users List u2-users@listserver.u2ug.org
Date: Thursday, April 22, 2010, 3:55 PM
As far as I know there isn't a way to prevent someone from
:
You need to use the 32-bit odbc driver manager.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Friday, 23 April 2010 8:01 a.m.
To: U2 Users List
Subject: [U2] UniODBC/UniOLEDB
Firewall is disabled. Both on the same domain. Authentication is
configured for Both Windows and SQL Server Auth on both boxes.
Interestingly enough, Brian, absolutely nothing (related to OLEDB) shows up
on the Event Viewer. I agree with you that this is not likely a U2-specific
issue; the
But David, it works without the domain on that other box. (Oh, and the
server in this situation is an AIX box.) The client is simply trying to
recreate the connection that works on another box.
New information: The memory of the failing box has been expanded to 4G and
the customer has installed
I haven't tried linking the two SQL servers together, but that would be a
good test, wouldn't it?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
New information: In earlier tests I was logging in to SQL Server using
Windows authentication. All queries with the linked server using
IBM/Rocket's UniOLEDB driver failed. Over the weekend the client set up my
user ID using SQL Server authentication, and the queries now work (on the
old server;
Going back to something Colin said earlier, I've created the exact same
test.udl file on the desktop of both machines. The old machine lets me
connect to Unidata via the UniOLEDB driver just fine. The new machine does
not. I get an error:
Test connection failed because of an error in
Ping test reports identical IP addresses for the server name.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
I found the UniOLEDB.dll in C:\windows\system32. On the server that works
the version is 1.5.1.7211. On the server that does not work the version is
1.6.0.7276. I believe the two were at one time identical but the client
downloaded the latest-and-greatest from the RS website, which is why they
New information: I just learned that the Windows server where the UniOLEDB
connection is working is Windows 2003 *R2 Enterprise *SP2 whereas the
Windows server that is not working with UniOLEDB is Windows 2003
*Standard*SP2. My apologies for my earlier assertion that the two
servers were
No, not on either box (the one that works vs. the one that doesn't). The
user ID and password are the Unidata user and password with no extra domain
decoration.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
.); Source = Microsoft SQL Native Client; Code =
-2147217900,4/14/2010 9:53:32 PM,4/14/2010 9:53:34 PM,0
So to start with the obvious question, does ths IBM UniOLEDB driver just...
not work at all?
On Mon, Apr 5, 2010 at 12:51 PM, Kevin King precisonl...@gmail.com wrote:
We've worked out this issue
I'm wondering if the problem might be the provider string in setting up the
SQL Server linked server. Looking at the IBM/Rocket documentation I'm not
seeing a single word about what this provider string is supposed to look
like. The client currently has this provider string for the UniOLEDB
Thank you all for the insights; all information is appreciated.
Going back to the beginning, I have been told all along that the original
SQL Server connection works perfectly for my contact. However, when I RDP
to that server and try to run the exact same query, it fails with this
message:
Msg
Well, no. If this other person RDPs into the box, authenticates into SQL
Server, and runs the query, purportedly it works. If I RDP into the box,
authenticate into SQL Server and run the exact same query against that
linked server, it fails with the message as shown earlier.
I do have access to uci.config. Not sure how the IBM/Rocket drivers were
installed but there's been no indication that it would have been installed
only for a single user.
I'll try the testconnection.udl thing. Thanks for that.
-K
___
U2-Users
Colin, I got the connection string and while it tests the connection just
fine, when I try to use the connection in SQL Server the error is the same:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider IBM.UniOLEDB for linked server KTEST reported an
error. The provider reported an unexpected
Has anyone done this successfully using the IBM UniOLEDB driver? I have a
customer struggling with this and I just don't have the background with
UniOLEDB.
-Kevin
http://www.PrecisOnline.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Saturday, April 03, 2010 7:31 PM
To: U2 Users List
Subject: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
I have a customer who is trying to configure a couple of SQL Server
instances
Well, that doesn't seem to be the problem. Here's what I'm getting:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider IBM.UniOLEDB for linked server PSI reported an
error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from
I have a customer who has a view that appears like this in SQL:
SELECT ID,TYPE,BEGIN_DATE,END_DATE,FISCAL_PERIOD,PERIOD_OPEN FROM
T_CRP_FISCAL_PERIODS UNNEST NL_ALL
BEGIN_DATE,END_DATE,FISCAL_PERIOD,PERIOD_OPEN WHERE ID =
001FISCAL.PERIODS;
This view, as far as I have been informed, was created
201 - 300 of 932 matches
Mail list logo
