Re: [U2] Frustrated with Rocket / Unidata 7.2
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 problem really doesn't have anything to do with Rocket. But when their response admitted changing things followed with it's working as designed and no additional information to help mitigate what was a broken program, that's hardly a solution. Thank God for the folks on this list who redirect, clarify, correct, and offer suggestions that actually can help. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
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, Address mrparkl...@yahoo.com wrote: Unidata is more stable than many versions of Microsoft Windows. Unidata does not frustrate or aggravate me. It is very reliable. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
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
[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 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 that in this version they changed the telnet server so that it can only run fully stdin/stdout compliant programs in the shell. Because the Windows ftp program isn't exactly stdin/stdout compliant, it is no longer a functional PCPERFORM program. Even if the ftp program is scripted to connect, transfer, and exit with no additional inputs or outputs, the ftp program will still fail. Of course, in this case if there's a put in the commands it'll fail after writing a zero byte file, potentially overwriting something. I could be frustrated with Microsoft because, after all, it's their program that's failing, I'm more frustrated with Rocket. While it's frustrating to have a past ability removed it's more frustrating to have received absolutely zero warning from Rocket that this could happen. I've searched the docs for 7.2... can't find a word about this change. (Hey, and I could be missing something; that's certainly a possibility.) It's fortunate that this install isn't a big production system, but what if it was? There are several production systems running Unidata on Windows, so if any of y'all are using ftp or any OS commands that may not meet Rocket's muster, please be aware of this change in 7.2. BTW, for me the fix was to use WinSCP (in command line mode) instead of Microsoft's FTP program. So far it seems to work just fine though the scripting is a bit different from Microsoft's ftp client. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Doug... If that's working on 7.2.7/Win I'd love to know how. Things here aren't the same as they were on 7.1. Non-Windows versions appear to be fine. Windows versions... not so much. Wally, my case # is 153722. It was posted through my support contacts @ S7. Feel free to contact me off list if you need more info. On Thu, Feb 17, 2011 at 6:42 PM, Wally Terhune wterh...@rocketsoftware.comwrote: Hi, Kevin. I don't find any support cases opened by you recently. Can you provide a support case number so I can review your interaction with our team and the technical bits, as well. thanks Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@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 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 that in this version they changed the telnet server so that it can only run fully stdin/stdout compliant programs in the shell. Because the Windows ftp program isn't exactly stdin/stdout compliant, it is no longer a functional PCPERFORM program. Even if the ftp program is scripted to connect, transfer, and exit with no additional inputs or outputs, the ftp program will still fail. Of course, in this case if there's a put in the commands it'll fail after writing a zero byte file, potentially overwriting something. I could be frustrated with Microsoft because, after all, it's their program that's failing, I'm more frustrated with Rocket. While it's frustrating to have a past ability removed it's more frustrating to have received absolutely zero warning from Rocket that this could happen. I've searched the docs for 7.2... can't find a word about this change. (Hey, and I could be missing something; that's certainly a possibility.) It's fortunate that this install isn't a big production system, but what if it was? There are several production systems running Unidata on Windows, so if any of y'all are using ftp or any OS commands that may not meet Rocket's muster, please be aware of this change in 7.2. BTW, for me the fix was to use WinSCP (in command line mode) instead of Microsoft's FTP program. So far it seems to work just fine though the scripting is a bit different from Microsoft's ftp client. ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
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 here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Thanks for the chuckle - that was funny! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
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 issues like this, but here many years into this career it's been my experience that few who have heard my barking have actually heeded the advice. Now, this issue could seriously bite some good folks. That's really the focus of this frustration... knowing that my limited experiences quite possibly may only be the tip of this iceberg. I think what really set me off was the statement from Rocket support that it's working properly, when clearly properly to Rocket is equivalent to broken in what used to be perfectly functional code. Forgive me, but is this really the best confidence builder? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 6.1 AIX: write error, errno = 9 on WRITESEQ
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 for this AIX platform. My question is, what is errno = 9? BTW, this problem persisted for about 2 hours and then just went away without any technical intervention. What would cause this? I'd really like to make sure it doesn't happen again! -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 AIX: write error, errno = 9 on WRITESEQ
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 the two users were in the same group, there were no group write privs on the file. Just documenting the madness for posterity. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 AIX: write error, errno = 9 on WRITESEQ
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
[U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
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 tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
I'll pass that along, thanks! On Wed, Jan 26, 2011 at 11:15 AM, Robert Houben robert.hou...@fwic.netwrote: It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem. Note that a normal user cannot write to the Program Files directory (plus other places) under Windows 7/2008 server environment. Lots of older apps required you to do this, and will break when ported, unless you run with elevated privileges. You may wish to check if UPS has an updated version of their app for Windows 7/x64. I have a number of things I do on my Win7/x64 system that require me to run as Administrator with UAC turned off. It simply won't work otherwise. 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 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 tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
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
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
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? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
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. Input? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Data in Dict
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 what backups are for. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Killing a UO connection
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 that's the command that I understand is supposed to be used in place of UniAdmin to force a user down. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migration
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
Re: [U2] Migration
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 web request to make a single request and get a response that could include any number of different data elements spanning one read, multiple reads, even multiple files. It's pretty slick. But that's beside the original question. The original question of taking information out of a SQL database and mapping it to a MV database is meaningless without a context, and that context - in my opinion of course - is an application that is creating and/or consuming that information, irrespective of the configuration of data refrigerator in use. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migration
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 because the data access code is a bunch of SQL queries. And while most MV platforms provide some type of SQL compatibility, that compatibility negates much of the benefits of the MV environment (i.e. nested data sets, etc.), single reads, etc. A while ago I did a proof of concept for a design that used PHP objects to provide pluggable access to Unidata, Universe, MySQL, and PostgreSQL. While I'm sure more talented others have taken the concept much farther than I, the more important problem in all this is that it's inventing a new data access method that isn't MV and it isn't SQL. Moreover, when coding something like this to be compatible with the least-common-denominator, often the end result is the very definition of least. Personally, I think the read/write/delete model of MV is head and shoulders better than the select/insert/update/remove model in SQL. So my efforts were invested on providing a simple read/write/delete model on top of a generic SQL db. But what I found was that there is no generic SQL. MySQL and PostgreSQL in particular are two completely different animals when it comes to insert/update. And all this ripples down to the issue of advisory locking and the other niceties that we tend to take for granted with MV. On the flip side, I am of the opinion that indexing and query optimization are generally much better on SQL. I do wish more SQL implementations supported virtual/derived/correlative fields. This is another of those wonderful things in MV that we tend to take for granted. I am all about finding ways to integrate MV into the larger technology landscape. But right now I believe the two worlds are so far apart that a general purpose application of one technology into the other camp is still problematic. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] JSON Parsing
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
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 input to be decoded and re-encoded into an identical JSON string. I understand the concept of not going deeper than 4 dimensions but we've found that we can harness the power of the server to generate a lot of information very quickly (think of it like multiple simultaneous report requests) and then send it all back in one data stream for rendering via the web server. This is smokin' fast compared to trying to read each record over the connection and do the reporting logic from the PHP side. Our menu structure itself is a nested PHP object that can go to any number of levels. We can build such a thing easily in BASIC and send it to the web server no problem but if the web server wanted to move that depth of information into Unidata, well, it's a bit more involved. And as to why JSON vs. XML, especially when Unidata already supports XML, I gotta go back to one of my fundamental TCP/IP lessons: If you want data to move faster on the wire, move less of it! JSON can move the same information as XML (structurally speaking) but with a lot less bandwidth. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
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? Building JSON is simple in MV Basic. Parsing it can be a bit more difficult. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sparse array population in Pick
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 problem but I would love to find a sensible way to parse a JSON string of any depth or complexity into a U2 structure that can be easily consumed by a program. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Upgrading and Migrating from Unix to Windows
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 name. On Windows, that write will fail. This is a particularly interesting problem with EDI, which seems to use the * in a number of contexts. Of course, the * can appear in the data just fine. It just cannot appear in the key. I find Unix (and variant) systems significantly easier to administrate as well, with the exception of printers which can be a bit of a hassle. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 6.1: dbpause/dbresume indicator
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
Re: [U2] Unidata 6.1: dbpause/dbresume indicator
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
Re: [U2] UV 10.3.3/SB+ 6.0.3
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 list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV 10.3.3/SB+ 6.0.3
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 into a situation where Universe won't delete the data portion of the work file. Basically these process are wrappers for the CREATE.FILE and DELETE.FILE TCL verbs. Each process builds a variable with the appropriate command and then calls a subroutine to silently EXECUTE the command and return the results. If I run the two back to back from TCL the file is created and deleted without incident. If, however, something is written into the work file between these two commands - as might be done from a program or paragraph - the DELETE.WORK.FILE process (calling the DELETE.FILE TCL verb) will remove the dictionary of the file, but not the data nor the VOC pointer. The error returned from the DELETE.FILE command (executed by this process) is Unable to delete file WRK. where the 's are the current port #. Before the file is deleted, both the dictionary and data portions are closed using the CLOSE statement in an SB+ paragraph. Even more interesting is that after the process is complete and has returned to its caller, the DELETE.WORK.FILE process works without incident. It's almost like SB+ is holding an open file buffer after the file has been closed or somehow the DELETE.FILE is running at a different execution level than the CREATE.FILE that originally made the file. So to factor SB+ out of the mix I created a real simple test program: 001: EXECUTE 'CREATE.FILE WRK.3604 1 1' 002: OPEN 'WRK.3604' TO F.WRK THEN 003: WRITE '' ON F.WRK,'X' 004: CLOSE F.WRK 005: END 006: EXECUTE 'DELETE.FILE WRK.3604' CAPTURING OUTPUT 007: CRT OUTPUT This program reliably creates and deletes the file each time, yet it is almost identical to what we're trying to do from the SB+ paragraph. So here's my question: Is UV sensitive about execution levels when deleting a work file? What might make Universe think the file is open when we've attempted to close it using the CLOSE statement in an SB+ paragraph (other than the obvious possibility that CLOSE might be broken)? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cataloging Programs
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 program in memory when its running. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV 10.3.3/SB+ 6.0.3
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 the file open and UV wouldn't delete it. The fix in this case is that we will now run all our work file stuff through a wrapper that opens the work file, calls the SB+ process that needs the work file, and when that process returns we'll close the work file and then delete it. That looks like it's going to work very well. Sorry for the waste of bandwidth; posting the solution now to hopefully help someone else someday. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building XML using the UV XDOM API functions
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 supplied and open source solutions. As Jerry has stated some customers prefer to have one vendor for everything. For other customers, having one vendor for everything is a level of captive dependence they would rather avoid. One size certainly does not fit all. But all that aside, vendors need to put more attention into their products to make them useful and usable rather than simply another tick on a marketing checklist. Having XML support or whatever doesn't mean jack squat if it's so convoluted and unstable and poorly documented so as to be about worthless without heroics. This is where vendors could learn a great deal from the open source movement; open source technologies, though having no clear vendor or support often do a much better job of making things that are useful, usable, AND understandable. Once vendors return to a commitment to excellence over a commitment to marketing things may change. Until then, as solution providers the best we can do is keep all of our options open and when there are no options, to create new ones. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building XML using the UV XDOM API functions
Brilliant article! Thanks for sharing. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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 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 make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davis dda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@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 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 make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [ http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [ http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XLr8Editor and Tools Updates
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
Re: [U2] how to round to 2 decimals?
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 show and the second digit is the number of decimals to scale. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client - Disable TAB
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, create some madness when you have a validation process or PA on a field that is setting up stuff for something to follow later. The short answer, though not a good one, is don't do that. In GUI each prompt has to be considered completely standalone knowing that anyone can click to it from anywhere. It's a completely different programming paradigm than what we have historically done with green screens. Oh, and it happens in character mode as well when the mouse is used to click through to fields. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Another undocumented Uniobjects error
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 error codes... anywhere? An error is an error is an error, I understand that, but I would sure like to understand all the ways this thing can fall down. -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another undocumented Uniobjects error
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
Re: [U2] SQL field name issue.
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
[U2] From today's Rocket newflash...
*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 versions. If you wish to keep old versions of our documentation, please download them before that deadline. After September 30th, older documentation will only be available via U2BusinessConnect download. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe: AE just ... disappears?
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 the first time it's happened with AE and never this often. The ADDAE program (thanks Susan [Joslyn]!) fixes the issue but... What is up with UV and catalog pointers disappearing? -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Very much OT - AUTO: Haydon Bishop is out of the office (again)
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
Re: [U2] UniData 'QUIT'
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
Re: [U2] UniData 'QUIT'
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData 'QUIT'
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? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData 'QUIT'
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
Re: [U2] UniData 'QUIT'
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
Re: [U2] UniData 'QUIT'
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
Re: [U2] UniData 'QUIT'
Yeah, that's exactly what I'm asking. If you restart Unidata, that *should *be cleared or at least reduced, but if not, I would wonder why it's so dang full...? On Thu, Jun 24, 2010 at 12:44 PM, Amy Cook amy_c...@k2sports.com wrote: It started happening on the 14th. We rebooted minimum once a day the 14th-16th, and I have restarted UniData without a reboot twice since then as part of troubleshooting in the evenings when people aren't on system. Wow! I'm not sure this is what you're asking, but my unidata temp space is set to e:\ud\temp...and it's huge...51g239k files. -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 restarted Unidata on that box anytime recently? ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData 'QUIT'
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
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 Laansma IT Manager Hubbard Supply Co. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
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
Re: [U2] receiving error message XX record corrupt on logto
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 if the XX is a system you might bring up the SBSYSMENU menu in /MD and refile that also. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
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 a security record and wasn't specifically the SB user or in the ROOT group, SB+ could corrupt the checksum. If you can login as SB and refile the suspected records, that might help. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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 and center or right justified. That's the gig. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Complex printing (was Re: AccuTerm File Transfer)
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
Re: [U2] AccuTerm File Transfer
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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
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
Re: [U2] UniODBC/UniOLEDB and Win2008?
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
Re: [U2] UniODBC/UniOLEDB and Win2008?
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 data, then what hope of survival is there, really? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 to play nicely with the UniOLEDB driver on this one system. No idea why this system needs to be configured differently from any others... any ideas? My deepest gratitude for all of the insight, information, and opinion helping me through this issue. If any of you ever get nearby, margaritas on me! -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
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 list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
Good info, Ben! Thanks for sharing! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
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
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Viewing HTTP headers when using UniData submitRequest()
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
[U2] UniODBC/UniOLEDB and Win2008?
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 driver is not listed in the list of ODBC data sources for the server. Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB CLIENT TERMINATION
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
Re: [U2] SB CLIENT TERMINATION
Not that I know of. That's one of the weak spots with telnet, once it's dead it's dead. However, I do recall something on my forum about some program called... screen, was it? http://www.precisonline.com/forum/index.php/topic,245.0.html This utility purportedly abstracts the telnet session on the server so that if you drop your connection, you can restore it. Haven't tried it myself, but it seems like a cool idea. On Thu, Apr 22, 2010 at 1:56 PM, Address mrparkl...@yahoo.com wrote: Is there any way to keep the telnet session active after the sb client window has been closed ? --- 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 closing the telnet application. -K ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniODBC/UniOLEDB and Win2008?
How would a person do such a thing? Doesn't Windows have just this one ODBC connection store and when you use a connection you use whatever Windows is going to use? Forgive me for what must seem like stupid Windows questions. On Thu, Apr 22, 2010 at 2:10 PM, phil walker p...@gnosys.co.nz wrote: 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 and Win2008? 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 driver is not listed in the list of ODBC data sources for the server. Is Unidata's ODBC driver incompatable with Win2008 or 64-bit, or both? -K ___ 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 -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 customer is building up another Win box to see if they can overcome this by starting over. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 a version of the UniOLEDB driver that I have working here. In fact, I have this very same UniOLEDB driver plugged in as a linked server in my SQL Server 2008 and it works without drama. The test.udl file as recommended by Colin is now able to make a connection, but that's where it stops. With the linked server configured inside of the client's SQL Server 2005, a query issued against that linked server returns this: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider IBM.UniOLEDB for linked server ADS reported an error. Access denied. Msg 7350, Level 16, State 2, Line 1 Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server ADS. I've verified the user ID and password and I'm confident they're correct. And I've tried logging into SQL Server both using Windows authentication and also SQL Server authentication, with no difference. And as I said, I have it working here with SQL Server 2008 and the same UniOLEDB driver. So could there be some weird Windows security issue, maybe something preventing the OLEDB infrastructure from instantiating the UniOLEDB driver? I've checked permissions on the UniOLEDB.dll and that looks all good, i.e. it matches the other server. So given all that, what am I missing? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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; the new server is still a mess). The authentication method is the only thing that changed. This then begs the question: What Windows permissions are being respected by the UniOLEDB driver that it would work in one authentication scheme but not the other? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 initializing provider. Died in UCI::SQLConnect with SQLSTATE IM976, Native error:0 [IBM][SQL Client]UCI connections to non UniVerse databases is not allowed. What the...? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 are different now. Would it be worth the effort to have them uninstall this updated version and reinstall the original version on the new server, especially knowing that it didn't work originally which is why they updated it in the first place? Or can we just move this one dll from one server to the other, renaming the 1.6 version to something temporary? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 identical; I should have checked this earlier. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
And just when I thought it was safe to go back in the water... This issue is NOT resolved. My customer has found that there is ZERO way to get the IBM UniOLEDB driver working in SQL Server. They had it working temporarily using the Microsoft ODBC - OLEDB driver, but that's not working 100%. With the IBM UniOLEDB driver configured as a linked server, no connection to the backend Unidata is possible. The connection itself fails. Using the Microsoft ODBC - OLEDB driver, the connection works sometimes, but not reliably. Under certain circumstances (using the Microsoft driver) this message will appear: Error: Description = Cannot initialize the data source object of OLE DB provider MSDASQL for linked server PSI. (Microsoft SQL Native Client (80040e14): The OLE DB provider MSDASQL for linked server PSI reported an error. The provider reported an unexpected catastrophic failure.); 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. It appears that - at least in this case - the OLE DB connection being used by SQL Server was in fact using the ODBC data source as defined on that Win box. The ODBC data source, however, was setup to connect to a specific database (account) and SQL Server was attempting to override it with a path to a different account. That override apparently doesn't work so well. So we created a new ODBC connection that points to the right account and SQL Server is now able to use that linked server to pull information from the appropriate location. On Mon, Apr 5, 2010 at 8:58 AM, Kevin King precisonl...@gmail.com wrote: 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 OLE DB provider IBM.UniOLEDB for linked server PSI. unexpected catastrophic failure? -K -- -Kevin http://www.PrecisOnline.com -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 driver: ODBC;DataSource=ADS;DSN=ADS;SRV=ADS;DBQ=/ud/XXX;DATABASE= ...and as far as I have heard it works on one SQL Server instance, but fails miserably on an exact duplicate system. Two systems, identical in every way with the exception of distinct SQL Server database instances, same U2 ODBC and OLEDB drivers, and yet one works and the other... blows chunks with catastrophic failure and stuff like that. Ideas? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 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 OLE DB provider IBM.UniOLEDB for linked server PSI. Note that this purportedly the server that WORKS, not the broken one. Given a security context with a specific user ID and password for the linked server, what in Windows would make this work for one user but not for another? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 catastrophic failure. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider IBM.UniOLEDB for linked server KTEST. Gotta love those catastrophic failures... Had a date like that once. :-) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Setting Up Unidata 7.1 as Linked Server in SQL Server 2005
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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
The uci.config is identical on both servers. Let me look for that security tab; that may be the golden ticket right there. On Mon, Apr 5, 2010 at 6:31 AM, Lettau, Jeff jlet...@polkaudio.com wrote: Is the UCI.config file setup on the 2nd server? Does the SQL server recognize the driver as a valid provider under linked servers? Under the linked server in properties there should be a security tab that you need to fill in with the login and password to connect to remote systems. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@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 to access Unidata 7.1 on AIX via OLEDB by setting up Unidata as a linked server in SQL Server. The exact same OLEDB (and ODBC) driver is installed on both systems and is configured identically between the two. One system can access the Unidata information in a table (that has been configured via VSG) but the other cannot. The root question is why can one server access Unidata and the other cannot, especially when the two are configured identically?. One thing I've noticed is that the linked server configuration doesn't include any authentication information for OLEDB, but clearly there has to be some authentication somewhere, right? And with the presence of ODBC in the SQL Server provider string for the linked server, does that mean that OLEDB uses the ODBC connector to access Unidata? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
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 OLE DB provider IBM.UniOLEDB for linked server PSI. unexpected catastrophic failure? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] VSG Creates Incompatible ODBC View
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 via the VSG. And this is valid SQL when run from the sql command line in Unidata. However, when this view is used over ODBC, it returns 001FISCAL.PERIODS is not a valid field name. For this particular situation, changing the double quotes to single quotes seems to do the trick, but that leads me to two questions for this esteemed group: a) Is VSG creating incompatible SQL, or does this appear to have been created by a human? b) Will we encounter other difficulties by this change from double quotes to single quotes in the WHERE clause? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
