I. 09/07 18:08:49. Database server started at Wed Sep 07 2005 18:08
I. 09/07 18:08:49. Trying to start SharedMemory link …
I. 09/07 18:08:49. SharedMemory link started successfully
I. 09/07 18:08:49. Trying to start TCPIP link …
I. 09/07 18:08:49. Starting on port 2638
I. 09/07 18:08:49. TCPIP link started successfully
I. 09/07 18:08:49. Now accepting requests
E. 09/08 14:55:32. Cannot open transaction log file – Can’t use log file “user_data.log” since it is shorter than expected
E. 09/08 14:55:32. Cannot open transaction log file – Can’t use log file “example.log” since it is shorter than expected
E. 09/08 14:55:32. Cannot open transaction log file – Can’t use log file “log_data.log” since it is shorter than expected
E. 09/08 14:55:32. Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
E. 09/08 14:55:32. Cannot open transaction log file – Can’t use log file “SoaringSky.log” since it is shorter than expected
What is going on here? Everything works, but after a restart of my PowerBook (1 GHz, 2 GB RAM, OS 10.3.9) I get this message.
I deleted the log files (what do you mean by renaming it?) and get now the following errors (in the sybase_log.txt file):
E. 09/08 16:18:00. Cannot open transaction log file – Can’t use log file “example.log” since it is shorter than expected
E. 09/08 16:18:00. Cannot open transaction log file – Can’t use log file “log_data.log” since it is shorter than expected
E. 09/08 16:18:00. Cannot open transaction log file – Can’t use log file “crm.log” since it is shorter than expected
E. 09/08 16:18:00. Cannot open transaction log file – Can’t use log file “SoaringSky.log” since it is shorter than expected
E. 09/08 16:25:04. Cannot open transaction log file – No such file or directory
E. 09/08 16:25:04. Cannot open transaction log file – No such file or directory
E. 09/08 16:25:04. Cannot open transaction log file – No such file or directory
E. 09/08 16:25:04. Cannot open transaction log file – No such file or directory
E. 09/08 16:25:04. Cannot open transaction log file – No such file or directory
Servoy create only for two databases (servoy_repository.log and an example db) new log file, not for the others, like crm for example.
Best regards, Robert
grahamg:
Robert
Have you tried deleting (or renaming) all the .log files. If a .log file doesn’t exist the db will creat a new one for you.
I am getting the exact same thing. I have 3 different copies installed and they are all giving me the same error message. First it would not let me include my new database into Servoy preferences, now it won’t even let me start up the repository. After I get that error message that Robert gets, I cannot even access anything! Repository under File is grayed out.
Here I am with the idea for a great new app that will change the world as we know it, and I can’t even get past square one!
Inside your sybase_db folder there is a log file that will tell you the error. Looks like you have databases specified in your sybase.config file that don’t actually exist at the path you’ve specified.
… and deleting log files doesn’t help, nor is anything amis with the sybase.config file (as far as I can tell).
It was working just fine at the Servoy training, then I went to DevCon. Uh oh… can Servoy tell that I was “using another”?
Anyway, it worked fine for maybe a month, then poof! it sucks , all of a sudden. I could probably do like I did last time, and reinstall both apps, drop my files in… but what a hassle! Plus, I get the feeling that there is something I may be missing that might keep things stable. One should not have to reinstall the app, I would think.
FWIW, I am using a 667 PB w/ 768 RAM and OS 10.3.9.
I. 08/26 09:42:19. Database server started at Fri Aug 26 2005 09:42
I. 08/26 09:42:19. Trying to start SharedMemory link …
I. 08/26 09:42:19. SharedMemory link started successfully
I. 08/26 09:42:19. Trying to start TCPIP link …
I. 08/26 09:42:19. Starting on port 2638
I. 08/26 09:42:19. TCPIP link started successfully
I. 08/26 09:42:19. Now accepting requests
I. 09/12 10:40:01. Database server started at Mon Sep 12 2005 10:40
I. 09/12 10:40:01. Trying to start SharedMemory link …
I. 09/12 10:40:01. SharedMemory link started successfully
I. 09/12 10:40:01. Trying to start TCPIP link …
I. 09/12 10:40:01. Starting on port 2638
I. 09/12 10:40:01. TCPIP link started successfully
I. 09/12 10:40:01. Now accepting requests
E. 09/13 11:23:07. Cannot open transaction log file – Can’t use log file “servoy_repository.log” since it is shorter than expected
E. 09/13 11:27:06. Cannot open transaction log file – Can’t use log file “servoy_repository.log” since it is shorter than expected
E. 09/13 14:42:29. Cannot open transaction log file – Can’t use log file “servoy_repository.log” since it is shorter than expected
The servoy_repository.log is anything but short. Is there a part of it that somehow can connote “shortness” regarless of its length?
So… I reinstalled Servoy, and added the databases for my solution, updated the sybase config file, but did not update the repository server. The crm (example) database opens, no problem.
Next, I replaced the repository server. The problem then returned. So it seems that the repository server had been corrupted. Any thoughts on whether this is an accurate assessment, and/or why it may have been corrupted?
Jim
Can’t connect to the repository server specified in the application preferences
Hmm, this looks like you move(d) around your repository WITHOUT the log file.
You can throw away the log file if you are on the machine where you created the database (at least that’s my experience). You can’t move a database from one machine to the other without log file (when created) since your database relies on the log file. And, you certainly can’t replace a database and keep the log file from the other database in your directory.
It looks like you did the last: ‘Can’t use log file “servoy_repository.log” since it is shorter than expected’
Hmm, this looks like you move(d) around your repository WITHOUT the log file.
You can throw away the log file if you are on the machine where you created the database (at least that’s my experience). You can’t move a database from one machine to the other without log file (when created) since your database relies on the log file. And, you certainly can’t replace a database and keep the log file from the other database in your directory.
It looks like you did the last: ‘Can’t use log file “servoy_repository.log” since it is shorter than expected’
These instructions are no longer valid. I went to replace files and there is no res folder. Inside the folders some of the files are not there like asa.cvf and dblgen9.res, so I did not replace them. I replaced all I could and now I cannot restart the repository and there are no log entries for my work today.
All I want to do is start a new database and begin my project. I have been at this for a week off and on and I am still no closer to beginning my project than I was Monday! Why is it so hard to even get started in Servoy?? Am I a little frustrated? Yeah, just a tad.
Jim Schliestett:
Next, I replaced the repository server. The problem then returned. So it seems that the repository server had been corrupted. Any thoughts on whether this is an accurate assessment, and/or why it may have been corrupted?
Can’t connect to the repository server specified in the application preferences
“I feel your pain.” I, too, have put in a few hours wrangling with “getting started in Servoy,” feeilng like I was in a mud wrestling match with a beast the likes of which I’d never encountered before. (I’m coming from FMP: “File/New Database”, DONE. Of course what comes after that in FMP gets harder and harder as you try to do more and more, whereas I am finding Servoy is easier to get my work accomplished.)
Anyway, here’s a suggestion, if you are using Mac OS X. I was cussin’ out Servoy, and talking to the monitor: “It ought to just work.” Finally I tried this course of action and have never seen those messages since (the below might be total overkill … you might want to start by just fixing permissions, but do it off the start-up CD):
(1) Backed up the stuff that was working in Servoy
(2) Trashed everything on my hard drive that was servoy-related
(3) Started up off of my disk utilities CD, verified the HD (which was OK) and fixed permissions (which were not OK, and I believe that permissions get fixed better when the volume in question is not the startup volume … but that could just be my own superstition… but, when is the last time you ran this kind of maintenance? Not accusing, just asking you to consider…)
(4) Reinstalled Sybase Central first (careful what version! use 9.0.1, nothing higher, as per the forum FAQ)
(5) Reinstalled Servoy
When you install Sybase Central it creates another “user”
Thank you for those explicit instructions! Some of us ARE very slow in comprehension. I finally found the 9.0.1 version of Sybase Central and that was the key. I do not understand why Servoy does not either bundle Central with the program or provide the URL directly to it like this?
Thank you, Harriet! I am starting fresh, with a nice new G5 iMac, and am incouraged to hear your story. Perhaps I will not experience another inexplicable Servoy autodestruct.
I am still very interested in why problems such as this occur, and how to avoid them. I am thinking that a change of working habits and equipment may be necessary. FileMaker makes it easy to work in marginal conditions (e.g. old gear), but when problems do happen, that particular ease of use may bite.