BusinessObjects Board

DS 4.1 Management Console not creating schedule or .BAT

dataservices administration
#1

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, MS SQL Server and CMS all running on the same box.

Thanks for any suggestions.

Michael

michael.ardizzone :us: (BOB member since 2008-03-11)

CMS connection is not valid when creating a new schedule
#2

What SP are you on? First go to Mnagement and then to CMS, then give the required credentials for the service account it is running on. Then generate password file.
Then you can go to to the batch job schedules and create a schedule, make sure that use password file and Data Services Schedules instead of BOE. This worked for us. Let me know if that works of if you need anything else.

SantoshNirmala :india: (BOB member since 2006-03-15)

#3

Santosh,

Thanks for the reply. I believe it had something to do with a bad install. I decided to start with a fresh machine and reinstall all the software and it now works fine. It was a strage error and knew it it was not normal.

Best Regards

michael.ardizzone :us: (BOB member since 2008-03-11)

#4

Hi
I get the same error when I try to add a schedule. The problem is nothing shows up under the administrator node - the left hand side panel stays blank. I have multiple repositories defined - shows up on the run and I can select individual repo, see jobs under that.
But I don’t see any Management node to define CMS connection.

Any help?

Thanks

RGBIA (BOB member since 2013-03-20)

#5

On the left should you have a menu. It is based on java script or so and it takes sometimes somewhat longer to load.

Alternatively, try another browser.

In the menu on the left at the end there is Management node, with under that the CMS Connection.

Johannes Vink :netherlands: (BOB member since 2012-03-20)

#6

What is the error?

eganjp :us: (BOB member since 2007-09-12)

#7

[quote:18307b606f=“michael.ardizzone”]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, MS SQL Server and CMS all running on the same box.

Thanks for any suggestions.

Michael
[/quote]

Hi Experts,

I’ve got the same issue in DS 4.1.

I’ve link the CMS in Data Services Management Console and generated the password file.

When I try to set a new job schedule, using psw file, the browser return this error and no jobs are made in Windows Scheduler Task:

Repository:<repo_name> Schedule:Test_console_Chrome Error:Error while adding a job to scheduler

Checking the JS event server log I found this row: i 08-13-13 15:56:47 (5516:9244) JobServer: AddSchedule:fails : Error while adding a job to scheduler (BODI-850112) [/i]

Google don’t help me serching this error code.

Viewing the browser source code when error is displayed I found a java Exception stack trace (see file attached for detail) .

In JS Schedule folder in Server machine the .bat execution command is created correctly (If I double click on that bat the job starts).
Could be a user profiling issue?
Other suggestion.

Thanks.

MM
java stack trace.txt (3.0 KB)

mcdm (BOB member since 2011-06-20)

#8

what is the complete version of DS 4.1 ? and also what is the OS Locale ?
do the following
go to CMC, select EIMAdaptiveProcessingServer and Stop the server
open Properties of the Server, enable FINER tracing for DS Admin Server
Save and Close and Start the Server

Create a new Schedule
go to <BOE_HOME>\SAP BusinessObjects Enterprise XI 4.0\logging folder and look for the latest DS.AdminService_*.log file
go to the end of the file and look for
, you will see a request and response, can you post only the request and response for ModifySchedules (do not attach the complete log)

also, did you open a case with SAP Support for this ? if yes, what is the case #

manoj_d (BOB member since 2009-01-02)

#9

Hi Manoj_d,

Thanks for your quick reply.

The DS Product version is 14.1.1.210 and the OS Locale server machine is MS Windows 2008 R2.

I did what you suggest and attached you can find a part of DS.AdminService_*.log.

Like you can see at line 31 I try to schedule a Job with instance name “cippalippa”.
Let me know if you see something interesting and you have other suggestions.

Thank a lot,
MM
DS.AdminService_20130816_1673583260_0.txt (22.0 KB)

mcdm (BOB member since 2011-06-20)

#10

I think the problem is happening on the job server side when it’s trying to create a schedule Task on OS, try to create a schedule again, once it fails, go to Job Server log folder (it’s %DS_COMMON_DIR%\lob<JobServerName>), and open the latest server_eventlog_.txt file and check for errors related to schedule

what is the logon under which the DS Windows Service is running ? if it’s SYSTEM account then change that to a suer account and restart the service and try again (this to see if there is any issue related to windows security and creating schedule tasks on windows scheduler)

also, check if you are able to create scheduler tasks directly from windows scheduler

also, try to create a schedule on BOE and see if you can use that as workaround

manoj_d (BOB member since 2009-01-02)

#11

OK, I Fix the problem! Thanks for your suggestion.

The DataServices windows user wasn’t able to add task on Win Task Scheduler.
So, I add DS Win User in OS System like Administrator.
I restart the DS Service and all schedules goes on.

Perfect!

mcdm (BOB member since 2011-06-20)

#12

[The CMS connection is not valid.]

I ran into this error when first learning how to use the Management Console. My resolution was much more simple - I just had to go the Management --> CMS Connection link in the left-hand pane and set up a CMS connection.

Perhaps I should read the manual. :smiley:

Jesse (BOB member since 2002-08-20)