Tom
Thank You for the detailed instructions and handholding through the process!
Cringer / Rob
Thank you for your comments/help
Attached is the documentation of the process I followed - it may help someone else
Thank You Rob.
Tom,
I have finished the dump and reload. Will let you know if there are any issues tomorrow once the office staff works on it
Thank You very much for your help!
Hi Tom,
See attached dbanalysis from olddb and the newdb. All record count matches except table _User. Do I need to export user table separate and import it ? (there is difference in blocks, size, %utilized - can I safely ignore that?
Also, can i now delete the tssr08.? in e:\solution and...
Hi Tom,
reindexing done. Log file attached
Is there a way to get a listing of all tables and the number of records in each table?. I want to make sure I reloaded all table records by comparing the olddb to the newdb after reload
Is there a way to get a listing of all tables and the number of records in each table?. I want to make sure I reloaded all table records by comparing the olddb to the newdb after reload
Good Morning Tom
I was able to create an empty database and make a backup
I am running the binary dump now - see attached batchfile
While that is running, I have a question on the .lg (log file?) - see attached - the log file starts in 2011 and has grown to 430MB (while the database...
Hi Tom,
I can only dump data definitions - Select all tables with F5 * and dump data definitions to bkuptssr.df (File size 876,424) (original database size
596,115,456 tssr08.db)
I don't see option to dump data and definition together?
Hi Tom,
mpro and pro are not in the installation folders. ProDb is there. See the list of files in the install folders \DLC and \SOLUTION. Where can I get the mpro and pro files?
Thanks
Hi Tom,
I was out sick for three days.
Thanks for the detailed instructions - I will try the dump and reload this weekend.
>>> "We have been experiencing lockups when we search for customers..." is awfully vague. What, exactly, is happening? Are there error messages? <<<<
We have an option in...
Hi Cringer,
I removed the control numbers
Progress version is 8.3E
-Where do I find the service pack info
-Windows 2003
-I haven't tried anything - don't know how to do the dump and reload
-Errors are attached in my first message on this thread
Thanks
Hi Tom,
This error has been there for many years. Since the software provider is not in business anymore, we couldn't do anything about it and it was not affecting any operations. However, recently it is starting to lockup during customer look up / search. And hence I am thinking may be a...
Greetings from Chicago,
We use an application called Service Solutions that runs on Progress 8.3E. We have been experiencing lockups when we search for customers- is there a way to dump and reload the database to get rid of the error and to optimize the database?
Please see attached list of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.