Again, this went to Mike from my reply button - apologies. -------- Forwarded Message -------- Subject: Re: [RBASE-L] - Password error Date: Fri, 16 Jun 2017 16:48:29 +0100 From: Alastair Burr <[email protected]><mailto:[email protected]> Reply-To: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]>
If it adds any clarity below are the examples from my five databases with the lines immediately preceeding and following copied & pasted directly from the output files: SET FASTLOCK OFF CREATE SCHEMA AUTHOR Books HATTON CREATE TABLE `Various_Menus` + SET FASTLOCK OFF CREATE SCHEMA AUTHOR General HATTON CREATE TABLE `Dummy` + SET FASTLOCK OFF CREATE SCHEMA AUTHOR MultiDat HATTON CREATE TABLE `ApplicationSetting` + SET FASTLOCK OFF CREATE SCHEMA AUTHOR Records HATTON SET USER HATTON none CREATE TABLE `All_Names` + SET FASTLOCK OFF CREATE SCHEMA AUTHOR Visuals HATTON CREATE TABLE `Various_Menus` + Using R:BASE X, U.S. Version, Build: 10.0.2.20307 As you can see the fourth database adds an extra line. The output files are created in a loop so nothing is different between them. I can edit out the rogue line and then rebuild the database but. so far, this extra line will reappear sooner or later. Before I stopped spending any more time on it I did not think it was caused by the backup process. If I had any suspicions at all it was that maybe it was to do with mistyping the user name at some point but I couldn't find a way to prove it. In the end it was easier just to type none when needed. Regards, Alastair. On 16/06/2017 16:13, [email protected]<mailto:[email protected]> wrote: Good morning to all: Thank you, Razzak, for your response. Your comments and questions are valid and I appreciate the professional manner in which they were expressed. I truly mean that. I'll take it from here for completing my long overdue upgrade process. Regarding the original question, I did a "from the ground up" rebuild of the database in question. One of the structure files provided an insight into the password issue. Here is the output of the structure file for the ID_MASTER table: SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' SET CURRENCY ' ' SUFF 0 B DISCONNECT SET STATICDB OFF SET ROWLOCKS ON SET FASTLOCK OFF CREATE SCHEMA AUTHOR MILL2250 PUBLIC SET USER PUBLIC none CREATE TABLE `ID_MASTER` + (`ID` INTEGER, + `FILE_NAME` TEXT (26), + `STARTED` DATETIME, + `COILNUMBER` TEXT (20), + `STCD_NO` INTEGER, + `STCD_DASH` TEXT (12), + `GRADE` TEXT (4), + `MELTCODE` TEXT (6), + `TIME_STAMP` DATETIME, + `NO_FILE` INTEGER, + `LAST_PASSNUM` INTEGER, + `PASS_FOOTAGE` INTEGER, + `COMPLETEDOK` INTEGER, + `DIRLEFT` INTEGER, + `RTE_GAUGE_MIN` DOUBLE, + `RTE_GAUGE_MAX` DOUBLE, + `ROLL_START` DATETIME, + `ROLL_STOP` DATETIME) CREATE INDEX IM_ID_IDX ON `ID_MASTER` (`ID` ASC) Note the "SET USER PUBLIC none" line. That's the command that apparently caused the problem and I have no explanation or knowledge as to when, how or why that particular setting was ever set. Whatever the case, I removed that command from each structure file before doing the re-build. I then unloaded the structure again to make sure that it was truly gone. So far so good. I anticipate that the problem has been addressed. Thanks again to everyone that contributed to this discussion. It has been a valuable exchange. May everyone have a safe and enjoyable weekend. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: "A. Razzak Memon" <[email protected]><mailto:[email protected]> To: [email protected]<mailto:[email protected]>, Date: 06/16/2017 07:03 AM Subject: Re: [RBASE-L] - Password error Sent by: [email protected]<mailto:[email protected]> ________________________________ Good Morning, Mike: Thanks for the clarification. Yes, I did notice, thus no response from me until someone suggested to submit a bug. My reaction was to get this cleared right away. Why fake news? Having said that, if I remember correctly, and looking at our records, my entire development team has spent many many hours to address all your reported items related to R:BASE X Enterprise (Version 10), including some cool enhancements. They provided you with private updates, etc. for your testing and verification. Since there were no further reports or any pending items for a long time, I am just curious as to what is preventing you from taking advantage of all those fixes and enhancements in R:BASE X Enterprise (Version 10), and why you still continue to use the un-supported (EOS/EOL) version of R:BASE 9.5 for your employer? Remember, one of the most important aspects in business growth is your company data, and no one else has more invested in your success than R:BASE Technologies! Please let us know if there is anything else we can do to help you. Very Best R:egards, Razzak At 10:56 PM 6/15/2017, [email protected]<mailto:[email protected]> wrote: >Good evening, Razzak: > >With all due respect I did specify in my original post that I was >using eXtreme 9.5. > >At 10:47 AM 6/14/2017, >[email protected]<mailto:[email protected]> wrote: >"Using eXtreme 9.5, I would appreciate some suggestions or insight >into why this happens or what I can look for." > >At any rate, this particular problem has appeared sporadically over >the last couple of years with one particular database. It's a >relatively simple one with two tables and a few views. It's less >than 50MB in size. > >I finally decided to post to the list for suggestions. > >I have R:Styled and traced my programs and carefully examined the >code. No errors or issues were discovered. > >I am going to design a different method for backing up the database >to see if I can eliminate the error. > >I will share my findings. > >Thank you for your comments and suggestions. > >Kind Regards. > >Mike Ramsour >AK Steel Coshocton Works >Quality Department >Phone: 740-829-4340 >Cell: 740-502-1659 > > >From: "A. Razzak Memon" <[email protected]><mailto:[email protected]> >To: [email protected]<mailto:[email protected]>, >Date: 06/15/2017 03:34 PM >Subject: Re: [RBASE-L] - Password error >Sent by: [email protected]<mailto:[email protected]> > >Mike, > >Did you realize that everyone on this list thinks that you are using >R:BASE X Enterprise, when in fact, you are NOT. > >Since you are still using R:BASE eXtreme 9.5 (64), is this the first >time you have encountered such -ERROR-? > >What has changed on you end, as this has nothing to do with R:BASE, >since you have been using the same version for a long time, using the >same database. > >Have you checked your backup databases? > >Hope that provides you with some blue's clues ... > >Razzak > > >At 10:47 AM 6/14/2017, >[email protected]<mailto:[email protected]> wrote: > > >Good day: > > > >I have a daily backup routine that loops through about 20 > >databases. The program connects to a database, AUTOCHKs it and then > >copies it to a backup folder. > > > >There is one database that generates the following error when the > >program attempts to connect to it: -ERROR- The current password is > >not correct for this user identifier. (2867) > > > >The owner of the database is set to public and there has never been > >a password associated with the database. > > > >Entering a bogus password or clicking through it generates this > >message: -ERROR- Incorrect password. User identifier has been > >changed to PUBLIC. (2870) > > > >After which the database gets backed up. > > > >I cannot find anything that would indicate why this is happening to > >this one particular database. I've checked it, I've rebuilt it and > >still I get the message. > > > >Using eXtreme 9.5, I would appreciate some suggestions or insight > >into why this happens or what I can look for. > > > >Thanks for any help. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. 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. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
