[U2] UV: Can't save records in a VOC file
Attempts to create a record in the VOC file of one of our accounts fails. If I try to save a record called MFH, I get the following message: Write of MFH will not occur. Contact System Administrator. Failed to file MFH in file VOC. STATUS = -2 I know I've seen this before... but it's been years... I'm going through old cheat sheets and as a last resort, the IBM documentation but haven't found this message. Any help would be appreciated. Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] testing- please delete me
Sorry for the inbox litter. I'm attempting to verify if I can post to the list. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Thanks, Colin and to everyone who offered suggestions. Most of these I have been through including the IBM docs I have access to but Colin's suggestion about another service issue may be a clue to the problem. I am giving myself a crash course in unidata since I am only familiar with the more common relational database apps and I have a critical system that runs on unidata but support options for this are limited so I am not particularly familiar with the platform at this point. If the licensing does not have the Device License option would that disallow running the udt command line on the local machine? I have setup a script to run and extract the data to text files but without the ability to start the udt session locally I am not able to run the program. I was also looking at perhaps finding a way to run it as a phantom process but am not sure on the syntax on that and whether or not I can bypass the udt command in that fashion. Thanks for all the help. Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 11:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem Seconded. If you're still having trouble - make sure UD is licensed. I think it shows up in the smm.log if it's not. UniAdmin or confprod will show if it is or not. If it is licensed; have you installed new software recently? 5.1.27 is rather old so I'm assuming you've had it running for a while. We've had problems with another service (windows management something or other) that would grab one of the memory handles. However, it would allow UD to start on a reboot - but wouldn't let you stop and start it (without rebooting). I used tools from www.sysinternals.com to find the offending service. hth Colin Alfke Calgary Canada From:Bill Haskett Steve: You might want to check out: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0409ter hune / It's pretty good. :-) Bill -Original Message- From: Christensen, Steve Thanks for the suggestions. Unfortunately getting the following when forcing the shutdown: Attach shared memory fail. stopud failed. The Unidata service cannot be stopped. Reboot does not fix the problem either. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Equivalent of the UnIData DIR command
Doug, You didn't state whether this is a hashed file or a file produced from some other OS level application which would make some difference, but there are a number of ways to do this in UniVerse. If the file you are interested in is a UniVerse hashed file you can try and open it with the OPENPATH statement (or any of the other possibilities like referencing it through a Q-pointer with the OPEN statement). If the file doesn't exist, the ELSE clause of the OPENPATH or OPEN statement will be taken. If the file is not a UniVerse hashed file you can always try and open it with the OPENSEQ statement by using the directory path to the file. Once again, if the file doesn't exist, the ELSE clause will be taken. Either way, once the file is open you can use the Basic STATUS statement on the file variable to return a wealth of information about the file, all the fields you are interested in plus many more fields. Example: OPENSEQ '/etc/passwd' TO PASSWD.FILE ELSE CRT 'Cannot open the unix file of all valid users' STOP END STATUS FILE.PROPERTIES FROM PASSWD.FILE THEN CRT 'The size of /etc/passwd is ':FILE.PROPERTIES6,1,1 CRT 'The permissions of /etc/passwd are ':FILE.PROPERTIES5,1,1 END ELSE CRT 'Could not retrieve status on /etc/passed' END From TCL: HELP BASIC STATUS HELP BASIC OPENSEQ HELP BASIC OPENPATH From the Basic manual (CD) you can check each of these commands for a more detailed explanation including how to use $INCLUDE UNIVERSE.INCLUDE FILEINFO.H which will let you retrieve about 90 different properties of of the file by name rather than attribute,value,subvalue [EMAIL PROTECTED] wrote: Universe has a STATUS statement (not the function) and a FILEINFO() function. I think the STATUS statement will return most of what you are looking for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Tuesday, November 07, 2006 4:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Equivalent of the UnIData DIR command Similar to my last post, Is there is a command that works the same as the UniData DIR command under UniVerse. I have not been able to find any items in the UniVerse documentation that comes close. I am using the DIR command to determine if a file exists at the OA level. The UnIData DIR command returns the file size in bytes, last modified date, last modified time, and file permissions of a file. Again, I need this to work under Windows and Unix Thanks in Advance Doug Farmer This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Can't save records in a VOC file
Either your voc file has permissions set to keep you from adding to it or you've run out of disc space. - Original Message - From: Hennessey, Mark F. [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, November 09, 2006 7:25 AM Subject: [U2] UV: Can't save records in a VOC file Attempts to create a record in the VOC file of one of our accounts fails. If I try to save a record called MFH, I get the following message: Write of MFH will not occur. Contact System Administrator. Failed to file MFH in file VOC. STATUS = -2 I know I've seen this before... but it's been years... I'm going through old cheat sheets and as a last resort, the IBM documentation but haven't found this message. Any help would be appreciated. Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Device License just means you can have more than one session per DEVICE - that is, IP 192.168.0.100 can open 4 sessions to UniData, but is only 1 device, so it uses 1 seat. Non-Device licensing would consume 4 seats. So unchecked means every time you start a connection, you eat a seat. You can launch UniData directly from command line to execute a process, and that process could launch a phantom, and the exit. I don't know that you can DIRECTLY run a phantom... Others will know better. DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christensen, Steve Sent: Thursday, November 09, 2006 8:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem If the licensing does not have the Device License option would that disallow running the udt command line on the local machine? I have setup a script to run and extract the data to text files but without the ability to start the udt session locally I am not able to run the program. I was also looking at perhaps finding a way to run it as a phantom process but am not sure on the syntax on that and whether or not I can bypass the udt command in that fashion. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
No problem. The device licensing is for being able to connect to the server multiple times from the same machine but only use 1 license. It won't prevent you from connecting from the console. Does it actually say it's licensed? Did you perhaps load UD locally about a month ago? If smm is not running then no-one would be able to connect. If it's a critical system I would expect you to be a lot more frantic. The service I've had problems with is Windows Management Instrumentation Service; however, it let UniData start on the reboot. A phantom simply lets the udt process run in the background. You will still need smm running. It's pretty easy to use: from the command line you simply enter PHANTOM command Note that the process will go through the login voc item and the process will abort if it stops to ask for input. Hth Colin Alfke Calgary Canada -Original Message- From: Christensen, Steve Thanks, Colin and to everyone who offered suggestions. Most of these I have been through including the IBM docs I have access to but Colin's suggestion about another service issue may be a clue to the problem. I am giving myself a crash course in unidata since I am only familiar with the more common relational database apps and I have a critical system that runs on unidata but support options for this are limited so I am not particularly familiar with the platform at this point. If the licensing does not have the Device License option would that disallow running the udt command line on the local machine? I have setup a script to run and extract the data to text files but without the ability to start the udt session locally I am not able to run the program. I was also looking at perhaps finding a way to run it as a phantom process but am not sure on the syntax on that and whether or not I can bypass the udt command in that fashion. Thanks for all the help. Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Equivalent of the UnIData DIR command
Thanks Allen, this is what I needed. I have a subroutine I wrote that is used in an I descriptor in the dictionary of a BP file. The subroutine takes in the program name and BP file name, and returns last modified date and time, last compiled date and time, size of the program in bytes. Using the UnIData DIR command gave me this information. For UniVerse, this code you gave me should do the trick. I did not know about the STATUS command. I have worked in Reality, Pick, Mentor, Ultimate, Prime, UniData for 28 years, but never in UniVerse. Thanks again! Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Bell Sent: Thursday, November 09, 2006 8:30 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Equivalent of the UnIData DIR command Doug, You didn't state whether this is a hashed file or a file produced from some other OS level application which would make some difference, but there are a number of ways to do this in UniVerse. If the file you are interested in is a UniVerse hashed file you can try and open it with the OPENPATH statement (or any of the other possibilities like referencing it through a Q-pointer with the OPEN statement). If the file doesn't exist, the ELSE clause of the OPENPATH or OPEN statement will be taken. If the file is not a UniVerse hashed file you can always try and open it with the OPENSEQ statement by using the directory path to the file. Once again, if the file doesn't exist, the ELSE clause will be taken. Either way, once the file is open you can use the Basic STATUS statement on the file variable to return a wealth of information about the file, all the fields you are interested in plus many more fields. Example: OPENSEQ '/etc/passwd' TO PASSWD.FILE ELSE CRT 'Cannot open the unix file of all valid users' STOP END STATUS FILE.PROPERTIES FROM PASSWD.FILE THEN CRT 'The size of /etc/passwd is ':FILE.PROPERTIES6,1,1 CRT 'The permissions of /etc/passwd are ':FILE.PROPERTIES5,1,1 END ELSE CRT 'Could not retrieve status on /etc/passed' END From TCL: HELP BASIC STATUS HELP BASIC OPENSEQ HELP BASIC OPENPATH From the Basic manual (CD) you can check each of these commands for a more detailed explanation including how to use $INCLUDE UNIVERSE.INCLUDE FILEINFO.H which will let you retrieve about 90 different properties of of the file by name rather than attribute,value,subvalue [EMAIL PROTECTED] wrote: Universe has a STATUS statement (not the function) and a FILEINFO() function. I think the STATUS statement will return most of what you are looking for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Tuesday, November 07, 2006 4:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Equivalent of the UnIData DIR command Similar to my last post, Is there is a command that works the same as the UniData DIR command under UniVerse. I have not been able to find any items in the UniVerse documentation that comes close. I am using the DIR command to determine if a file exists at the OA level. The UnIData DIR command returns the file size in bytes, last modified date, last modified time, and file permissions of a file. Again, I need this to work under Windows and Unix Thanks in Advance Doug Farmer This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Can't save records in a VOC file
snip Either your voc file has permissions set to keep you from adding to it or you've run out of disc space. /snip Those were my first two thoughts... I'm at 83% capacity on that file system, and I now own the file. I've been able to resize it (!?!), list it, but attempts to add records fail with the STATUS = -2 message. Attempts to DELETE records fail with STATUS = 0 message: : FD You are about to DELETE the ENTIRE record from the file. OK (Y) ? Y Delete of MFH will not occur. Contact System Administrator. Failed to delete MFH from file VOC. STATUS = 0 Both uvfixfile and fixtool fail to find any errors. Interestingly, a COUNT of the VOC shows 4,971 records. uvfixfile also shows 4,971 records. However fixtool shows 4,982 record processed fixtool seems to all ways show more records than either a COUNT or uvfixfile show. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Unidata v6 into SQL 2005
I have resolved the 200 character problem by splitting the field into MV. Next dilemma is how to get really time updates from Unidata into SQL. I was thinking about adding a trigger to the Unidata file which execute a SQL command to update the SQL database? Very grateful for any advice on how anyone else has achieved really time updates from Unidata to another database. Thanks Graham Forbes -Original Message- From: Forbes,G,Graham,JGFT C Sent: Wednesday, November 08, 2006 12:53 PM To: 'u2-users@listserver.u2ug.org' Subject: Unidata v6 into SQL 2005 Hello all Has anyone experienced problems importing data from Unidata into SQL 2005 using the IBM ODBC driver 3.01? I have a problem with text being truncated at 200 characters and the import hanging on certain records. Has anyone tried using Redback OLE DB? Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
I've burned up any urge to become frantic years ago :^) Licensing is fine on the machine. I've verified it as I accidentally invalidated it and had to obtain a new authorization code the other day. The smm is running, just getting a failure on the udt command line so I suspect some system issues that need to be addressed. The system has been running for several years with no maintenance. I believe it has been accumulating maintenance issues and data transfers via odbc have become rather slow and cause some cross-department locking issues which is what I am working on addressing. Did you shut down the instrumentation service and the driver extension service that goes along with it? I suspect I will need to review and shut down all unnecessary services to find the culprit on this problem. Thanks Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 09, 2006 9:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem No problem. The device licensing is for being able to connect to the server multiple times from the same machine but only use 1 license. It won't prevent you from connecting from the console. Does it actually say it's licensed? Did you perhaps load UD locally about a month ago? If smm is not running then no-one would be able to connect. If it's a critical system I would expect you to be a lot more frantic. The service I've had problems with is Windows Management Instrumentation Service; however, it let UniData start on the reboot. A phantom simply lets the udt process run in the background. You will still need smm running. It's pretty easy to use: from the command line you simply enter PHANTOM command Note that the process will go through the login voc item and the process will abort if it stops to ask for input. Hth Colin Alfke Calgary Canada -Original Message- From: Christensen, Steve Thanks, Colin and to everyone who offered suggestions. Most of these I have been through including the IBM docs I have access to but Colin's suggestion about another service issue may be a clue to the problem. I am giving myself a crash course in unidata since I am only familiar with the more common relational database apps and I have a critical system that runs on unidata but support options for this are limited so I am not particularly familiar with the platform at this point. If the licensing does not have the Device License option would that disallow running the udt command line on the local machine? I have setup a script to run and extract the data to text files but without the ability to start the udt session locally I am not able to run the program. I was also looking at perhaps finding a way to run it as a phantom process but am not sure on the syntax on that and whether or not I can bypass the udt command in that fashion. Thanks for all the help. Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [adv] XLr8 Editor New Release
U2logic has released version 1.1.1.8 of our free XLr8 Editor for the Universe and Unidata. Besides the normal bug fixes we have added an amazing feature for the U2 programming world. This feature is called notification of change. When a telnet user updates a program through AE/ED and you are editing it with XLr8 Editor you will be notified to reload your version, because of their change. This works with two XLr8 Editor Users, wIntegrate editor users, or any other third party software even Notepad. And finally, we have added the ability to rename records. We would like to thank all of you using our products and the valuable input you given us over the last year. Thank you, U2logic Team BTW: If you do not have you own copy, please go to www.u2logic.com under the download menu option for instructions. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Our problem with WMIS was that UniData would start on a reboot of the server, but if you stopped UD it wouldn't restart unless you rebooted. Until I found the conflict with the WMIS service. Then I stopped the WMIS service, stopped and restarted UD - which worked fine, and then restarted the WMIS service. I used the process explorer from www.sysinternals.com to find an smm handle being held by the WMIS service. If it's only udt on the console that is giving you the problem - are you sure you're in a valid account when you start udt, or maybe the pathing is messed up? Sorry, I'm not much more help here - I always use telnet (SBClient) to connect. Can you use telnet? Hth Colin Alfke Calgary Canada -Original Message- From: Christensen, Steve I've burned up any urge to become frantic years ago :^) Licensing is fine on the machine. I've verified it as I accidentally invalidated it and had to obtain a new authorization code the other day. The smm is running, just getting a failure on the udt command line so I suspect some system issues that need to be addressed. The system has been running for several years with no maintenance. I believe it has been accumulating maintenance issues and data transfers via odbc have become rather slow and cause some cross-department locking issues which is what I am working on addressing. Did you shut down the instrumentation service and the driver extension service that goes along with it? I suspect I will need to review and shut down all unnecessary services to find the culprit on this problem. Thanks Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Can't save records in a VOC file
You're not using the PE version by any chance are you? - Original Message - From: Hennessey, Mark F. [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, November 09, 2006 9:56 AM Subject: RE: [U2] UV: Can't save records in a VOC file snip Either your voc file has permissions set to keep you from adding to it or you've run out of disc space. /snip Those were my first two thoughts... I'm at 83% capacity on that file system, and I now own the file. I've been able to resize it (!?!), list it, but attempts to add records fail with the STATUS = -2 message. Attempts to DELETE records fail with STATUS = 0 message: : FD You are about to DELETE the ENTIRE record from the file. OK (Y) ? Y Delete of MFH will not occur. Contact System Administrator. Failed to delete MFH from file VOC. STATUS = 0 Both uvfixfile and fixtool fail to find any errors. Interestingly, a COUNT of the VOC shows 4,971 records. uvfixfile also shows 4,971 records. However fixtool shows 4,982 record processed fixtool seems to all ways show more records than either a COUNT or uvfixfile show. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Ron is correct, Do a cd $UDTBIN then do the tar -xvf and then updatesys. Cheers, Angelo Collazo System Administrator Long shot but this happened to me once. The tar file must be untar'd from the udt directory, not your upgrade directory. Its meant to over right some things. Ron Sharcott (3635) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christensen, Steve Sent: Wednesday, November 08, 2006 3:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem Thanks for the suggestions. Unfortunately getting the following when forcing the shutdown: Attach shared memory fail. stopud failed. The Unidata service cannot be stopped. Reboot does not fix the problem either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Wednesday, November 08, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] udt problem Did you try stopud -f? That will force UD to stop even if it thinks users still have Unidata sessions running. If that doesn't work, sounds like you need to reboot the server. Note that these suggestions are only recommended as a last resort, as you run the risk of corrupting your data. Good luck, Tom [EMAIL PROTECTED] 11/08/06 4:13 PM Can anyone tell me what to do about this problem: Trying to start udt from command line generates the following error: Start SMM first! This is on Unidata 5.1.27 running locally. Tried startud but it is running and stopud refuses to stop it. Thanks, Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata v6 into SQL 2005
Graham, We do it every day. We use UniData BCI and it works great. Documentation is on the IBM website. Hope this helps. Cheers, Angelo -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 09, 2006 11:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Unidata v6 into SQL 2005 I have resolved the 200 character problem by splitting the field into MV. Next dilemma is how to get really time updates from Unidata into SQL. I was thinking about adding a trigger to the Unidata file which execute a SQL command to update the SQL database? Very grateful for any advice on how anyone else has achieved really time updates from Unidata to another database. Thanks Graham Forbes -Original Message- From: Forbes,G,Graham,JGFT C Sent: Wednesday, November 08, 2006 12:53 PM To: 'u2-users@listserver.u2ug.org' Subject: Unidata v6 into SQL 2005 Hello all Has anyone experienced problems importing data from Unidata into SQL 2005 using the IBM ODBC driver 3.01? I have a problem with text being truncated at 200 characters and the import hanging on certain records. Has anyone tried using Redback OLE DB? Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: Can't save records in a VOC file
Hennessey, Mark F. wrote: snip Either your voc file has permissions set to keep you from adding to it or you've run out of disc space. /snip Those were my first two thoughts... I'm at 83% capacity on that file system, and I now own the file. I don't suppose you've created indexes on the VOC and you don't have the priveleges on those files?? -- Allen Egerton --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Unidata v6 into SQL 2005
Graham, Next dilemma is how to get really time updates from Unidata into SQL. I was thinking about adding a trigger to the Unidata file which execute a SQL command to update the SQL database? Very grateful for any advice on how anyone else has achieved really time updates from Unidata to another database. I'm not sure if anyone has achieved real time as opposed to near time. The problem with putting the update into a trigger is you are tying the SQL update to your regular transaction and potentially slowing it down as well as all the error handling and recovery issues (what to do when one system is down and your updates need to queue.). AFAIK A more common approach is to use the triggers to update a UDT file of updates to go to SQL and then have a phantom or cron poll this and process them. By working around timing etc., you should be able to get your lag pretty low. The cron process can use just about whatever transmission procedure you like. From experience, make sure you have procedures to handle one or other servers being down, lost updates, clearing queues, regenerating messages, logging and status checking. It would be interesting to see where common consensus is at now as the above was the common practice a few years back when we set it up. Reviewing it is on my to-do list. HTH, Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: SYSTEM() to identify PE - wish granted!
all you have to do is ask :-) At UniData 7.1.5 (from the readme): Issue 6936 - Problem Description UniBasic -- At this release, the SYSTEM(9010) function has been added to return the database type. This function returns UD if the database is UniData, or UV if the database is UniVerse. If the database is the UniData Personal Edition, SYSTEM(9010) returns UD.PE. 6936 At UniVerse 10.1.21, the SYSTEM(9010) function was added to return the database type. This function returns UD if the database is UniData, or UV if the database is UniVerse. This function now also returns UV.PE if the installed database is the UniVerse Personal Edition. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] Kevin King [EMAIL PROTECTED] ne.comTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject SYSTEM() to identify PE 11/08/2006 04:14 PM Please respond to [EMAIL PROTECTED] er.u2ug.org From: Craig Bennett Perhaps IBM could add a SYSTEM() code which returned true if the database was a PE edition. Okay, now THIS is brilliant thinking. Thanks for sharing. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29513.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Can't save records in a VOC file
snip You're not using the PE version by any chance are you? /snip No. I was able to work around the issue by creating a Q-pointer in another account to the VOC file in question. I was then able to create a new file, copy the 'bad VOC' into the 'new VOC', then drop to unix, save off a copy of the bad VOC, then overlay the bad VOC with the new copy. At least we can now make additions/deletions to the account in question. Another strange thing: When a write or delete failed UV did NOT put a message in errlog. Thanks for your suggestions. I'll update the list if/when we find out just what happened to give this VOC file such a serious wedgie. Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Excellent! Thanks for the details. This should help narrow my focus on the problem. I suspect your right about the service issue. It definitely make sense. Thanks for the tip on the sysinternal tools. Those have some fantastic view into the processes and I can see a lot of use for other purposes on that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 09, 2006 12:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem Our problem with WMIS was that UniData would start on a reboot of the server, but if you stopped UD it wouldn't restart unless you rebooted. Until I found the conflict with the WMIS service. Then I stopped the WMIS service, stopped and restarted UD - which worked fine, and then restarted the WMIS service. I used the process explorer from www.sysinternals.com to find an smm handle being held by the WMIS service. If it's only udt on the console that is giving you the problem - are you sure you're in a valid account when you start udt, or maybe the pathing is messed up? Sorry, I'm not much more help here - I always use telnet (SBClient) to connect. Can you use telnet? Hth Colin Alfke Calgary Canada -Original Message- From: Christensen, Steve I've burned up any urge to become frantic years ago :^) Licensing is fine on the machine. I've verified it as I accidentally invalidated it and had to obtain a new authorization code the other day. The smm is running, just getting a failure on the udt command line so I suspect some system issues that need to be addressed. The system has been running for several years with no maintenance. I believe it has been accumulating maintenance issues and data transfers via odbc have become rather slow and cause some cross-department locking issues which is what I am working on addressing. Did you shut down the instrumentation service and the driver extension service that goes along with it? I suspect I will need to review and shut down all unnecessary services to find the culprit on this problem. Thanks Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] udt problem
Not sure that this would apply since it's on a windows machine and the problem doesn't have anything to do with upgrading. I've run the command in several locations just to be sure that I tried every valid directory at both the account level and the system level but same results. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Thursday, November 09, 2006 1:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem Ron is correct, Do a cd $UDTBIN then do the tar -xvf and then updatesys. Cheers, Angelo Collazo System Administrator Long shot but this happened to me once. The tar file must be untar'd from the udt directory, not your upgrade directory. Its meant to over right some things. Ron Sharcott (3635) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christensen, Steve Sent: Wednesday, November 08, 2006 3:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] udt problem Thanks for the suggestions. Unfortunately getting the following when forcing the shutdown: Attach shared memory fail. stopud failed. The Unidata service cannot be stopped. Reboot does not fix the problem either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Wednesday, November 08, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] udt problem Did you try stopud -f? That will force UD to stop even if it thinks users still have Unidata sessions running. If that doesn't work, sounds like you need to reboot the server. Note that these suggestions are only recommended as a last resort, as you run the risk of corrupting your data. Good luck, Tom [EMAIL PROTECTED] 11/08/06 4:13 PM Can anyone tell me what to do about this problem: Trying to start udt from command line generates the following error: Start SMM first! This is on Unidata 5.1.27 running locally. Tried startud but it is running and stopud refuses to stop it. Thanks, Steve --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Slow uniobjects connections
Good evening, We are experiencing very slow uniobjects (one second to connect) connections from a DLL which is called from an ASP server aplication. (W2K, UV 10.1). Does anyone have any experience to share regarding this? Thanks in advance, Marc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: SYSTEM() to identify PE - wish granted!
Wally Terhune wrote: all you have to do is ask :-) At UniData 7.1.5 (from the readme): Thanks Wally! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Unexpected interaction between Transaction State and PHANTOM {Unclassified}
OK, this seems more than a bit weird to me (must be Friday afternoon!) ... Our QA guys are testing a new VB.NET application which connects to UV via UVObjects and calls a subroutine that calls a subroutine that writes one record and PHANTOMs off a batch-type job. The VB app was written with a UVObjects Begin Transaction and Commit Transaction wrapped around it. When they looked in the PH entry, it was full of 'Verb various verbs illegal when a transaction is active' error messages. * So it looks like Transaction State persists across a PHANTOM invocation!?!? I'm shocked, horrified, amazed, etc. * Is this a feature or a bug? If a feature, is it documented anywhere? Anyone come across this before? Any suggestions on how to avoid it, other than not putting the web side into Transaction State? The whole point of writing a work-to-do record and PHANTOMing off the worker process was to de-couple the Web and UV parts of the system. Thanks Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Unusually error with telnet on Windows 2003
telnet -- When accessing normal telnet on a newly installed Windows 2003 server from the server itself. We get the Universe login message and enter user name and password and then the session is disconnected. In the Windows event log we receive the following message. Universe error: Unable to bind socket to SSL telnet port 23. It may be used by other applications or is disabled. WSA error: 10048 (I noticed a bug in the 10.1a uniadmin that the telnet and ssl telnet ports are forced to be the same and I cannot see away around that, although we have not had this problem on other 2003 machines) Environment We have loaded UniVerse Workgroups 10.1.11 onto a windows 2003 server (IBM hardware P4) with up to date patches and then have copy a database from an old Windows NT4.0 machine and we have run into the following problems that we have not seen before. There are no other applications on the server except for general administration and backup tools, it is solely for the universe application. Regards David Jordan Managing Consultant [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Access Violation on Windows 2003
I have hit an unusual problem that I have not seen before, has someone else had the same issue Access Violation -- We copied the data across from a Windows NT4.0 to a new Windows 2003 server. The servers are both under the same domain. The files can be successfully read. As they are SQL created tables, we went to run VERIFY.SQL SCHEMA FIX and the process dropped out with a fatal. We tried VERIFY.SQL TABLE . FIX and this also had a fatal on most files but was successful on some. In uniadmin we tried the File tool and it kept coming up with File read errors. We tried a uvfixfile at DOS level however this did not report errors and the fix did not resolve the above problem. We tried resetting the permissions but no result. In the Windows event log we received the following message. UniVerse error: Unhandled exception raised at address 0x0034499b. Access violation. Attempted to read from address 0x0008. Binary data is processor CONTEXT structure. Must be Friday. Regards David Jordan Managing Consultant [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Access Violation on Windows 2003
David Jordan wrote: We copied the data across from a Windows NT4.0 to a new Windows 2003 server. The servers are both under the same domain. The files can be successfully read. As they are SQL created tables, we went to run VERIFY.SQL SCHEMA FIX and the process dropped out with a fatal. We tried VERIFY.SQL TABLE . FIX and this also had a fatal on most files but was successful on some. In uniadmin we tried the File tool and it kept coming up with File read errors. We tried a uvfixfile at DOS level however this did not report errors and the fix did not resolve the above problem. We tried resetting the permissions but no result. In the Windows event log we received the following message. UniVerse error: Unhandled exception raised at address 0x0034499b. Access violation. Attempted to read from address 0x0008. Binary data is processor CONTEXT structure. Must be Friday. You copied the data across, but installed a fresh version of UniVerse designed for Windows 2003, or you copied data and UniVerse across from NT4 to 2003? If the latter, then I think your chances of having the same C runtime libraries etc on the new box are very slim. If the former, then maybe you've got some triggers somewhere defined in the SICAs that can't be found on the new box, or need recompiling perhaps. YMMV, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Access Violation on Windows 2003
Hi Ken It was a fresh install of UniVerse and we have no triggers on the tables. I am stumped why as the administrator we cannot force over any access issues or SQL issues. We have transferred the same data between NT4 and Win 2000, Win 2000 and XP and to 2003, but this maybe the first jump form NT4 to 2003. Regards David Jordan Managing Consultant [EMAIL PROTECTED] We copied the data across from a Windows NT4.0 to a new Windows 2003 server. The servers are both under the same domain. The files can be successfully read. As they are SQL created tables, we went to run VERIFY.SQL SCHEMA FIX and the process dropped out with a fatal. We tried VERIFY.SQL TABLE . FIX and this also had a fatal on most files but was successful on some. In uniadmin we tried the File tool and it kept coming up with File read errors. We tried a uvfixfile at DOS level however this did not report errors and the fix did not resolve the above problem. We tried resetting the permissions but no result. In the Windows event log we received the following message. UniVerse error: Unhandled exception raised at address 0x0034499b. Access violation. Attempted to read from address 0x0008. Binary data is processor CONTEXT structure. Must be Friday. You copied the data across, but installed a fresh version of UniVerse designed for Windows 2003, or you copied data and UniVerse across from NT4 to 2003? If the latter, then I think your chances of having the same C runtime libraries etc on the new box are very slim. If the former, then maybe you've got some triggers somewhere defined in the SICAs that can't be found on the new box, or need recompiling perhaps. YMMV, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/