SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DatabaseConnect Error (Profile not found)

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
DatabaseConnect Error (Profile not found)
Author Message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post DatabaseConnect Error (Profile not found) Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
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 View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
The profile was defined using the 32-bit version of the ODBC Admin util.
Tue May 07, 2013 9:49 am View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
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 View user's profile Send private message
mpadilla



Joined: 02 Jul 2008
Posts: 33

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.