Business Objects XI R2 changing connections

[Former Member]

Hi

I am using Business Objects XI R2 , we are going to move from SQL Server 2000 to SQL Server 2005. I followed all the steps already mentioned and discussed in the forum namely

1) Create a copy of CMS repository database schema (SQL 2000) in SQL 2008 - DBA will do this.

2) boeadmin should have access to these new db -- has access

3) Create ODBC connection, test its connectivity -- works

4) Open CCM (one by one), stop CMS. -- stopped all

5) Right click on CMS in CCM and go configuration tab, Choose the option "select a datasource" and select SQL server(ODBC). Point to the new ODBC (Already created in control panel). -- Done

6) Start CMS -- working fine

Everything is alright but the schedules are not being picked up. Which means users who have scheduled reports will not have those schedules anymore. This is not what I want, when I change the connection from old db to new db (both dbs are clones -- verified this) why is the new connection not picking up the schedules ??

Kindly share your ideas

Thanks

Bharad

[former_member202789 · Accepted solution]

Hi Bharad,

Following are the mistakes highlighted in yellow in your steps and green is the correct  steps that you should follow:

1)     Create a copy of CMS repository database schema (SQL 2000) in SQL 2008 - DBA will do this.

Correct -  1: First of all, if you need to move to SQL 2005 then why are you creating schema in SQL 2008.

2: You need to create a new Blank DB in SQL 2008 for CMS and audit you may copy the audit DB schema

2)     boeadmin should have access to these new db -- has access

Correct: boeadmin should have access to old and new db

3)     Create ODBC connection, test its connectivity – works

Correct: Create ODBC Datasource connection and test it for both old and new dbs in SQL Server 2000 and 2005

4) Open CCM (one by one), stop CMS. -- stopped all

5) Right click on CMS in CCM and go configuration tab, Choose the option "select a datasource" and select SQL server (ODBC). Point to the new ODBC (Already created in control panel). – Done

Correct – 1: Right Click on CMS in CCM and go to configuration tab and select “Select a Datasource” and select your new db datasource.

2: Right Click again on CMS in CCM and go to configuration tab and select “Copy Data from another data source” and select your old SQL 2000 CMS DB

Note: it will say that all the data will be wiped out in the new DB >> Click on ok and it will Copy Complete

6) Start CMS -- working fine

Regards,

Animesh Kumar

[Former Member · Accepted solution]

Hi Animesh,

Thanks for the detailed instructions. Its 2005, by mistake I said 2008. XIR2 is not supported by 2008Sql server so I do not want to go there. I have 2 follow up questions -->

1) Your instructions worked well, actually I had mentioned same steps the only difference this time I worked only on one CMS at a time, last time I worked paralelly on 2 CMS , my bad..but now its working perfectly fine. Except that I am not able to login to Infoview. I am able to login and work on CMC though. When I login to Infoview I get a weird error, not able to login to Infoview using any ID but CMC is totally fine

An error has occurred: java.lang.ClassCastException

do share your thoughts.. thanks buddy

2) in between someone mentioned that I may need to update FRS, do you think that is needed ?

[former_member202789 · Accepted solution]

Hi Bharad,

Reply on 1st Question: I have never seen ClaasCastException error at login but yes i've faced nullpointer exceptions many times while configuring Vintela AD SSO.

I have following questions in order to have a better understanding of the issue:

if you log in with default Enterprise Administrator account, do you still get the error in InfoView?

Did you try and regeploy Desktop.war?

Is the issue reproducible with multiple Enteprise accounts?

Reply on 2st Question: In your case it would not be required, because you are running CMSDBCOPY from the same old BO Server and not from a fresh/new BO Box.

To be on the safer side, you may stop old Input/Output File Repository servers >> Create new pair of file Repository servers >> Configure them by providing the correct local/network filestore location. If it is at network location, you will need to run these services with Network Credential (Service Account).

Regards,

Animesh Kumar

[Former Member · Accepted solution]

Thanks Everyone, it worked. That class java error came, I stopped all services, restarted the machine and started CMS first and then one by one all other services and its working fine...

Now the quest is not over, I have a CE10 (yes the old crystal 10 version) which I have to do the same thing. When I do anythng to this It says

CMS_INFOOBJECTS3 is already there in the database ?? what does that mean, I mean I am trying to import from another data source and it told me it wil overwrite but dont understand why this error ? This CE10 is sooo old am not able to find any help at all

[former_member202789 · Accepted solution]

Hi Bharad,

I am not sure about the error message. But are you trying to move CE 10 to MSSQL Server 2005? It might not be supported with CE 10.

You may try below given steps:

1: Use Re-create option in CCM to re-initialize the new CMS repository(for which you are getting this error)

2: Use  "Copy Data from another data source" from backup/old CMS database.

Regards,

Animesh Kumar

[Former Member · Accepted solution]

Hi Animesh,

I tried both the available options "copy data from another data source", "recreate current data source" but it says it cannot do this because there is already an object named CMS_Infoobjects3 in the database.

Can I delete this table from the db and retry this option ?

I have crystaladmin.CMS_Infoobjects3 and global\BOEAdmin.cms_Infoobjects5 , 2 tables in the db, is this the reason ?

I think CE10 is supported by SQL Server 2005 I checked this sometime back.

Thanks for your inputs

Bharad

I verified that the user ID has access to delete tables so I dont know why it is saying Database access error

[former_member202789 · Accepted solution]

Hi Bharad,

Couple of things:

1: Before running any of these options in CCM just validate whether there is any orphan CMS service running in the background.

After stopping all the services, check whether there is any CMS.exe running on that box. If it is running then kill it.

CMD.exe >> Taskkill –f PID

2: After stopping all the services and checking the orphan CMS as mentioned in Point 1, Go SQL Server 2005 box and run profiler and check whether there is any open connection to this database with any service or application. There should not be any open connection with any service or application.

You may drop these tables in the Database after taking a backup, but I would suggest create a new DB and give the SQL/windows account DBOwner role to it and then point the CE10 CMS to this new DB >> then run Copy DB option from CCM from your historical CMS DB.

Regards,

Animesh Kumar

[Former Member · Accepted solution]

Nope Animesh, dint help

Maybe I will delete the contents of these tables, will that help ?

or drop infoobjects3 ?  jus making sure its not going to make a huge mistake

[former_member202789 · Accepted solution]

You may drop all tables and it will not a be a mistake, if you take a back up of it before deleting.

Did you mean that you tried with a blank db and it did not work?

Can you list down the  exact steps you performed. when you mention the steps,

refer the Current DB as Current CMS DB, new that I suggested as NEW CMD DB and the one that you want to restore to as Master CMS DB.

~Animesh Kumar

[Former Member · Accepted solution]

Hi Animesh, I deleted infoobjects3 table, and recreated this table from Prod to Dev. Its working now. But not able to CMC or eportfolio (infoview). Some kind of corruption i guess.

When i login to eportfolio (infoview) or cmc the link displays the error,

Communication Error :

Communication failed with all configured Web Component Servers because they are disabled or not currently running. If this problem continues, please contact the system administrator.

it doesn't even ask user ID or password, the link immediately gives this error. I recreated the WCS, all services are up and running fine, including CMS. I stopped and restarted the services and also the servers. No luck !!

This SAP doc listed below shares various things to try and I have checked all these things still the error is not going away

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c06eabbd-843f-2b10-c7b0-c486e59c3...

It is true that this error was not occurring earlier before I manipulated infoobjects3 or other tables, any other thoughts ??

Thanks Animesh

Bharad

[former_member202789 · Accepted solution]

Hi,

If you have verified each and every troubleshooting step in the guide and if you feel it could be because of a possible corruption then you may recreate (CCM) the CMS DB and it will recreate the default tables in the CMS DB.

After doing recreate in CCM for CMS DB there will be no corruption left. You may check the CMC page now. If it still gives you the same error then it is a configuration issue and not the corruption. You would need to check the same. Check the mappings between the web server, the Web Connector, and the WCS

Check Chapter 5 of

Crystal Enterprise™ 10

Installation Guide

Regards,

Animesh Kumar

[former_member202789 · Accepted solution]

Share the Event Viewer error message as well.

[Former Member · Accepted solution]

Hi Animesh, thanks for your response. You have shared a document which is for latest crystal version, I am using a very very old crystal version. Nevertheless I am going to try it soon but I need to understand how to check "mappings between the web server, the Web Connector, and the WCS" I dont know much about working on tomcat servers, so how do i login here to check > any help

[Former Member · Accepted solution]

surprisingly there are no error or warning messages in event viewer at all 🙂 but CMC or eportfolio wouldn't work

[former_member202789 · Accepted solution]

here is the Crystal Enterprise 10 Installation Guide.

[Former Member]

Ok one more question -- Where are the contents and schedules actually stored.?? I have two dbs one is BOEXIR2DEV and BOEXIR2DEV_AUDIT ? and I requested DBAs to copy these 2 dbs only from PROD to DEV ?

BOEXIR2DEV has 5 tables, CMS_Alias, CMS_IDNumbers, CMS_Infoobjects, CMSRelations, CMS_VersionInfo

BOEXIR2DEV_AUDIT has the usual Audit detail, audit type, Event Type, Audit Event, Application Type and Server process tables

If the DBA has already copied it then isnt it enough if I just change the connection in ODBC ?

[former_member182521]

Bharad,

These are CMS DB tables to hold repository metadata information

BOEXIR2DEV has 5 tables, CMS_Alias5, CMS_IDNumbers5, CMS_Infoobjects5, CMSRelations5, CMS_VersionInfo5

These are CMS DB audir tables to do the activity monitoring

BOEXIR2DEV_AUDIT has the usual Audit detail, audit type, Event Type, Audit Event, Application Type and Server process tables

Have you compared CMS DB copies of both your repositories. I would suggest you to do table row level comparison for the table named CMS_InfoObjects5 in CMS database. This will give you the deviations if any.

Regards,

Mani

[Former Member]

yes sir I compared these 2 look to be the same

[CdnConnection]

Bharad,

      The best and most efficient way to copy the CMS is a follows:

- Create the NEW blank database

- Create System ODBC to new ODBC

- Stop all BOBJ Related services from the CCM

  1. With the CMS stopped. Double-click on CMC service within the CCM

  2. Go to the Configuration TAB

  3. Click Specify, you will get pop-up

4. Select the COPY option.  Select current SOURCE CMS and then copy to NEW CMS

( See detailed screen-shot below)

Coping the Audit should be no issues if it done by the DBA.  Make sure you have sufficient permission to the NEW databases, you will need ownership access to the CMS & Audit Db.

Good Luck,

Ajay

[Former Member]

First of all, thanks for taking efforts to share screenshots. I did do this, it wiped out all the folders and all the reports from DEV repository completely ? So now the folder list is empty, forget about schedules even the contents is gone 🙂 any ideas ?

[CdnConnection]

Bharad,

     The above is the only method that will guarantee 100% retention of OLD CMS. 

Is your FRS located in special location?

Are you using a SAN / NAS for your FRS?

Once the copy is done you also need to copy the FileStore Repository (FRS)

All the CMS information is located in TWO locations:

- The CMS Database, which is ONLY a point to the physical files

- The FileStore has all the physical files

- The AUDIT db only contains Audit information, not that important.

It sounds like you DID NOT copy or restore the FRS.

Regards,

Ajay

[denis_konovalov]

there were a lot of different things proposed here. What exact steps did you do and did you do a full backup of your CMS DB prior to doing them ?

[Former Member]

Yes DBAs did a full copy of these 2 databases BOEXIR2DEV and BOEXIR2DEV_AUDIT (copied both from PROD and copied into DEV with the above mentioned names)... and then I created connections to these... I did not mess around with the FRS as @Ajay_kGupta suggested , am going to do that now... I thought objects, folder structure, schedules are all stored in these 2 dbs.

[former_member182521]

Hi Bharad,

Have you compared CMS DB copies of both your repositories. I would suggest you to do table row level comparison for the table named CMS_InfoObjects5 in CMS database.

also Execute the below query in Query builder related to report schedules to narrow down what went wrong.

SELECT top 10000 SI_ID, SI_NAME,SI_KIND,SI_SCHEDULEINFO.SI_SCHEDULE_TYPE,

SI_SCHEDULEINFO.SI_SUBMITTER,SI_SCHEDULEINFO.SI_STARTTIME,SI_STARTTIME,

SI_ENDTIME,SI_NEXTRUNTIME,SI_SCHEDULE_STATUS,SI_STATUSINFO

FROM CI_INFOOBJECTS WHERE SI_SCHEDULE_STATUS = 9

In the resultset

values for SI_SCHEDULE_TYPE gives the Schedule frequency.

SI_SCHEDULE_TYPE=0 – Once: the report is run once only

SI_SCHEDULE_TYPE=1 – Hourly: the report is run hourly.

SI_SCHEDULE_TYPE=2 – Daily: the report is run daily.

SI_SCHEDULE_TYPE=3 – Weekly: the report is run weekly.

SI_SCHEDULE_TYPE=4 – Monthly: the report is run monthly.

SI_SCHEDULE_TYPE=5 – NthDay: the report is run on the nth day of the month.

SI_SCHEDULE_TYPE=6 – 1stMonday: the report will run on the first monday of every month.

SI_SCHEDULE_TYPE=7 – LastDay: the report will run on the last day of the month.

SI_SCHEDULE_TYPE=8 – Calendar: the report will run based on calendar templates.

SI_SCHEDULE_TYPE=9 – Run schedule based on calendar plugin object templates.

values for SI_SCHEDULE_STATUS gives the current status of the schedule

SI_SCHEDULE_STATUS=0 – Running

SI_SCHEDULE_STATUS=1 – Success

SI_SCHEDULE_STATUS=3 – Failure

SI_SCHEDULE_STATUS=8 – Paused

SI_SCHEDULE_STATUS=9 – Pending

Let me know if this helps.

Regards

Mani

[Former Member]

thanks for your suggestions, I tried this , it is returning zero rows.  which means no entries at all so none of the schedules got copied. I did this query in PROD (from which I copied the database to DEV) and there are plenty of entries in this source.

[denis_konovalov]

what does it mean : Everything is alright but the schedules are not being picked up ?

do you see the schedules and they do not run or you do not see schedules ?

How exactly was the CMD DB copied ?

CMSDBCopy process in CCM is the best one.

Connection itself has nothing to do with schedules, scheduling information is located in the CMS DB.

You need to be on the last available XIR2 patch to ensure most bugs related to scheduling is fixed.

[Former Member]

CMD DB copy was done by DBAs. I told them to copy BOEXIR2DEV and BOEXIR2DEV_Audit databases on to the new server and they did.

I created connections to these in the server and pointed to these new connections without altering the Cluster name.

since that dint work I tried this -- I did a "copy data from another source" using CCM  options from "Configuration" tab on CMS and lost all data

I think I wil start afresh I will ask DBAs to take another snapshot from a previous time and over write this, do let me know the steps and I will religiously follow it once more -- thanks a lot Denis

[Former Member]

  Former Member