CMS connection is not valid when creating a new schedule

[keithfisherzz9]

Hi there,

I have migrated a repository from an older 4.2 install to a new one (latest SP). I took a backup of the old repo database (SQL Server) and restored it to a new location with a new name.

I have used the repo manager to upgrade the repo.
I have connected a job server to the repo
I have registered the repo in the new IPS CMC and it tests fine
I have configured the CMS in the DWS CMC/Management area and it tests fine
I have removed references to the old system from the al_machine_info table in the repo database.

However when I try to schedule a job I get the error ‘CMS connection is not valid’. This job is one of the ones that was in the repo from before the migration.

What am I missing that needs to be updated? Does the job still pine for the old CMS?

thanks in advance
Keith

[Marek Chladny]

Hi,

I don’t know what to do with the orginial job server. But how about if you disabled it and created a brand new job server? Would that work?

[keithfisherzz9]

Hi Marek, the jobserver is brand new already, it’s only the repository database (and the projects/jobs within) that was migrated from the old system.

I can execute jobs manually but not schedule them - the error message comes up when I press the apply button in the scheduler screen…

[Shazin]

Please can you share the error you are getting.

Regards.
Shaz

[keithfisherzz9]

Hi Shaz, the error comes in the top left of the scheduling screen: ‘The CMS connection is not valid’

[keithfisherzz9]

I’ll try some of the suggestions mentioned on this thread and post updates here

DS 4.1 Management Console not creating schedule or .BAT

Specialists, Would anyone know why the management console loads correctly, executes a job correctly, but can not schedule a job or export the command files on windows? I’m getting a red error msg from the scheduler screen saying [The CMS connection is not valid.] in both cases and I am just selecting the Data Service Scheduler. I don’t think there is any special settings in the CMS for scheduling a DS job, or is there? My environment in windows server 2008 in a virtual machine with DS 4.1, M…

[Shazin]

Can you please check in case Test Connection for CMS is working fine

DSMC --> Management --> CMS Connection

Regards.
Shaz

[keithfisherzz9]

Hi Shaz, yes we have tested that and it is ok
thanks
Keith

[keithfisherzz9]

OK I found the issue - there was a special character in the administrator password: !
once I removed the special character and reset the CMS connection, all ran fine.

[Marek Chladny]

Wow, interesting. Thanks for sharing your finding.