Page 1 of 1
How to use c_system from another DB
Posted: Tue Jan 10, 2012 7:56 pm
by spygob
Hi there,
I'm quite new to Jade Investigator. I have been asked to install Investigator onto a couple of laptops for our Internal Audits division for training purposes only. What I have done is I've succesfully installed the app into the laptops.
What I would like help with however is how do I use the database files from our Jade Server's c_system directory on the laptops so that the users can still login using their current profiles and view existing cases and such.
I have tried replacing the c_system directory on the laptops with the one from the server but when I try to run the app, I get an error saying "jomsrvrinitialize failed, error 3057". I checked the jommsg1.log and the errors mostly talk about timestamps not matching the control file. And it goes on to say "update timesamp in file". How do I know which file is the timestamp file and how do I update it?
Thanks in advance for your kind assistance.
Re: How to use c_system from another DB
Posted: Wed Jan 11, 2012 2:36 pm
by torrie
This error is probably due to the journal logs not matching the files in the c_system directory. Copying files is not recommended, but if you do then you need to make sure that
- The system that you copying from is stopped
- The in use journal logs are copied as well
A much better approach would be to restore the latest backup of the server onto the laptops. Jade checks the files as it restores them. You are then checking that the lastest backup of the production is a good backup. We do this when refreshing test / training systems. Take a look at the Jade Database Administration Guide (DBAdmin.pdf) for the details.
You will probably need to ask the people who support your Investigator system about the location of the backups etc. They can probably tell you the best way to refresh a training system.
Re: How to use c_system from another DB
Posted: Wed Jan 11, 2012 7:32 pm
by spygob
Hi Torrie and thank you for your helpful response.
I followed your recomendation and read up on the Backup and Restore procedures and had a go at it.
The problem I have now is that, when I try to open the database using the Jade Database Utility, I get an error message that says " The Specified or default Jade INI file does not exist". I checked the Jade Error Messages book and it says,
"125 The specified or default Jade INI file does not exist
Cause
This error occurs if an attempt is made to start a JADE executable and the JADE initialization file
is not at the specified or expected location.
Action
Specify the fully qualified name of an existing JADE initialization file in the command line for a
JADE executable."
I know that the initialization file is in the c_system directory and that is where I point the utility to but I still get the same message.
Any help will be highly appreciated.
Re: How to use c_system from another DB
Posted: Thu Jan 12, 2012 8:02 am
by torrie
Take a look in the jommsg<n>.log. If you get this error it's likely to be in a directory called logs which is along side the bin directory containing jdbutil.exe. Normally the logs are found in the directory specified in the JadeLog section of the INI file, but the logs directory is the default.
The JDBUtil program expects to find an INI file called JADE.ini in the c_system (unless one is specified explicitly.) You may need to make a copy of your INI file as Jade.ini in the c_system directory. The JDB utility needs the INI as it contains all the system settings for that Jade system
Re: How to use c_system from another DB
Posted: Thu Jan 12, 2012 1:13 pm
by spygob
Thank you for your wonderful assistance, Torrie.
I managed to get help from investigator support and all is well now.
What I had to do was to copy the existing c_system and c_bin directories as well as the 3 desktop shortcuts from the jade training server into the laptops and change the paths in the shortcut target and start in to the appropriate locations. I didn't have to install a new instance of Investigator on the laptops.
Thanks again for your help.
God Bless.