Author |
Message |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
DatabaseConnect Error (Profile not found) |
|
I am creating a new server for 24x7 and installed the trial version (5.1402).
I have some jobs in JAL that need to run.
I setup the profile for a DB.
When I run the job, an error comes up saying:
"An error occurred while executing 24x7 script: Line 21: Database profile myprofile not found."
The profile is using SQLServer and exists. I tested it and was able to connect.
Any ideas on how to fix this?
|
|
Fri May 03, 2013 9:41 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
JAL doesn't use JDBC profiles that you setup in the scheduler UI. JAL is using ODBc or native drivers and maintains it's own set of profiles in the registry. Or alternatively you can specify connection settings directly in the JAL script, not using profiles.
Please take a look at Upgrade from 24x7 Windows Edition, see section "3. Migrating database connection profiles..."
|
|
Sun May 05, 2013 4:01 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
I had no access to the old server, thus I can't migrate the old connection profiles.
Is there other option that does not include modifiying the scripts?
|
|
Mon May 06, 2013 10:51 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Well, there seem to be only 3 options,
(1) copy old server profiles
(2) change scrips not to use profiles
(3) recreate profiles in the registry by hand, but if you are unfamiliar with how they are stored, that would be very difficult to do from scratch.
|
|
Mon May 06, 2013 12:59 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Is it available a download link for a version 3.X for the windows version?
Since the scripts we have were written in that version, maybe making the initial install and config in the 3.X version can then later be used for the migration of all these jobs for the 5.x.
|
|
Mon May 06, 2013 2:05 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
When I tried using the
DatabaseConnectEx
it prompts me everytime to select the data source. How can I prevent that?
I created the data source in the server where 24x7 is running.
The instruction I am putting is:
DatabaseConnectEx( "ODBC:sql server","DBServer","database","username","password","True")
|
|
Mon May 06, 2013 2:45 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
You can get the old version from download.com
The reason for the promo is that it cannot find the specified profile. Have you defined it as profile for 32-bit applications using 32-bit version of ODBC Administrator utility?
|
|
Mon May 06, 2013 5:49 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
The profile was defined using the 32-bit version of the ODBC Admin util.
|
|
Tue May 07, 2013 9:49 am |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Tried getting the older version from download.com, but it seems the links to it don't work. Is there a link on your site where I can get a copy of it?
|
|
Tue May 07, 2013 11:28 am |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
It appears we got archived versions on our web servers. Please contact support-AT-softtreetech.com to obtain a download link.
|
|
Tue May 07, 2013 10:35 pm |
|
![](templates/GreenTech/images/spacer.gif) |
mpadilla
Joined: 02 Jul 2008 Posts: 33
|
|
|
|
Ok. I got the older version of 24x7.
Here is how it worked.
1.) Installed the version 3.4.27, configured the DB Profile.
2.) Installed the version 5.1. When launched it prompted the detection of an older installation, and I accepted the option to convert the jobs and profiles to the new installation.
The DatabaseConnect now detects the DB profile.
This is just in case somebody needs to go through this exercise again.
Thanks,
|
|
Thu May 09, 2013 10:44 am |
|
![](templates/GreenTech/images/spacer.gif) |
|