Application Search

[ConvertFromOldNGs]

by ??? >> Sun, 26 Mar 2006 2:43:20 GMT

I have an old backed up database (2-3 years old) with the appropriate bin and system folders (etc etc). I created a shortcut to run the jade app but i get a returned error message that the schema doesn't exist.
"1213 error: Invalid Schema : JadeSchema."

Shortcut target : C:\xxxx\bin\jade.exe path=C:\xxxx\system app=Jade server=singleUser

I changed the schema to another (by looking through the system file "_userscm.dat") but my problem is that I don't know what app I can use. app=Jade is ideal as I want to see the code for this backed up system.

To target a schema= you need an app= and I don't know what that would be.

Can anybody direct me to where I may find the apps for my backed up system?

[ConvertFromOldNGs]

by allistar >> Mon, 27 Mar 2006 7:28:55 GMT

I have an old backed up database (2-3 years old) with the appropriate bin and system folders (etc etc). I created a shortcut to run the jade app but i get a returned error message that the schema doesn't exist.
"1213 error: Invalid Schema : JadeSchema."

Shortcut target : C:\xxxx\bin\jade.exe path=C:\xxxx\system app=Jade server=singleUser

I changed the schema to another (by looking through the system file "_userscm.dat") but my problem is that I don't know what app I can use. app=Jade is ideal as I want to see the code for this backed up system.

Your system is most likely deployed, and hence JadeSchema has been removed. One solution is to undeploy the database. To do this you'll need to know exactly what Jade version it is and them find the undeployment files. This is typically 10 "_*.dat" files, and copying them into your system directory followed by a "reset timestamps" normally does the trick. Make sure you backup the system first.

To target a schema= you need an app= and I don't know what that would be.

Can anybody direct me to where I may find the apps for my backed up system?

You could write a method in JADE that output all schema and app names (a simple iteration through Schema.instances would do the trick) to a file. Import this into the database and then run it using jadloadb (using executeSchema=??? executeApp=??? executeMethod=???)

Regards,
Allistar.

[ConvertFromOldNGs]

by Patwos >> Tue, 28 Mar 2006 2:00:22 GMT

Further to Allistar's reply, you don't actually want to replace all the _*.dat files as the ones that start _user*.dat contain your user schema data.

The ones you want to replace are the 6 _sys*.dat files (or 5 _sys*.dat files if your system is a very old Jade release) and the two _jad*.dat files with ones from an equivalent Jade level "development" database. Refer to FAQ 15035 for further details about this process.

Your difficulty of course may be working out exactly what version of those files you need. If you can identify the base release of Jade this system is then upgrading it may be a possibility.

eg: If you know it is version 5.2.08.???, then you could upgrade a copy of the backup to the latest 5.2.08 consolidated release, and then use the development version of the _sys*.dat and _jad*.dat files from that same consolidated release to convert the system to a development system and allow you to run the Jade app.

Hope that helps,
Pat.

[ConvertFromOldNGs]

by cnwjhp1 >> Tue, 28 Mar 2006 2:11:00 GMT

You should be able to determine the Jade version from the bin folder. In Windows Explorer, use menu View>Choose Details, and select Product Version to be displayed.

[ConvertFromOldNGs]

by ??? >> Tue, 28 Mar 2006 6:16:54 GMT

Thank you all,

I will attempt the above a see where it gets me.

[ConvertFromOldNGs]

by ??? >> Tue, 28 Mar 2006 6:47:47 GMT

Thank you all,

I will attempt the above a see where it gets me.

[ConvertFromOldNGs]

by Jared >> Tue, 28 Mar 2006 21:39:06 GMT

Hi ???, I have a possible solution. If you are lucky you might be able to find out information from the log files. Preferable jommsg[n].log in the log folder.

If you can find this file search for the line "Local process sign-on...". On the same line it will tell you the schema and application that was instantiated. Something like:

scm=mySchema, app=myApp

also just after that it might log the version as well.

Hope this helps.

[ConvertFromOldNGs]

by ??? >> Thu, 30 Mar 2006 8:29:48 GMT

Thank you all,

I replaced the appropriate files with undeployed versions and it worked! Unfortunately, all method source code was missing (due to being deployed) i.e. *** Source not available ***

I remember setting this parameter when I deployed the app. Alzheimer’s must run in the family.

If anybody knows of a way of getting back the missing method code I would love to hear it, but i believe this is impossible, especially since I dont have the original code/app.

Cheers Everyone



Cheers all

[ConvertFromOldNGs]

by Torrie >> Thu, 30 Mar 2006 22:43:28 GMT

I've asked this question and Jade is able to decode it for you. I suggest you contact the support desk.

Torrie

[ConvertFromOldNGs]

by Jade Support >> Thu, 30 Mar 2006 23:50:00 GMT

There is currently no method or utility for getting back missing source code in a JADE environment.

Schema/method loads are the only way of 'restoring' method source.

Jade Support.