Service Operations Insight

Expand all | Collapse all

Sync issue between CCC and CCR

  • 1.  Sync issue between CCC and CCR

    Posted Oct 15, 2014 07:25 AM

    I am getting "Failed to notify CCR server after data migration" error in Tomcat logs and the DM groups are not synchronized with CCR due to which we have blank reports on CCR.

     

    1. We tried checking http://CCR_Server/PortalwebService and it is working fine.

    2. http://CCR_Server/PortalwebService\AdminCommandWS.asmx\updategroups  is also working fine as group got created and reflected on CCR portal under groups.

     

    still the issue is same. appreciate for any pointers !!!

     

    FYI: DM/CCC, CCR and Oracle Database, all are deployed on seaperate servers on same VLAN and there is no firewall in between.



  • 2.  Re: Sync issue between CCC and CCR

    Posted Oct 15, 2014 07:58 AM

    Hi Ravi,

     

    1.Check if the DMgroups job was run successfully
    2.Check if the Routine_Total_Migration job in Data Manager -> Scheduled Migrations are running successfully
    3.Check if the rollups post Routine_Total_Migration are completing.
    4.If all of the aforesaid are clear, then check  NPC_DM_GROUP_MAPPING_CONFIG table to see if there is any data.  Please let us know in case NPC_DM_GROUP_MAPPING_CONFIG table is not effected with any data, even after the steps 1, 2 and 3 are complete.

    Additional notes from the CCC help, if you need to check the basics again.

    If an error occurs and synchronization fails, the following message is displayed in the Tomcat log, followed by other messages and stack trace: "Failed to notify CCR server after data migration."

    After establishing synchronization between one instance of the CCC (Data Manager) database and one instance of CCR, you must perform the following steps  to change that configuration (for example,  connect a different CCR to the same  database or connect a different  database to the same CCR):

     

    1. In the CCR administration user interface, delete the CA-Hyperformix group tree which is located under All Groups.
    2. In the database, truncate the database table NPC_DM_GROUP_MAPPING_CONFIG.
    3. Update the value of the CCR url, as follows:
               a. In the Data Manager application, click Configuration Settings on the main menu.
               b. In Manage Configuration Settings, select Global Parameters from the configuration type menu.
               c. Enter the CCR base URL as the value of the CCR_URL property.
    4. Save your changes, then stop and restart the CA_CCC Apache Tomcat service.

     

     

    Regards,

    KS



  • 3.  Re: Sync issue between CCC and CCR

    Posted Oct 16, 2014 12:59 AM

    Hi KS,

     

    Thanks for your quick response !!!

     

    1. Step 1 to 3 are completed everyday without any error still we do not have data in NPC_DM_GROUP_MAPPING_CONFIG table.
    2. This is a new instance on CapMan and we have not pointed this CCR to any other database earlier.
    3. We do not have any data in above mentioned table because the PortalWebService is unable to process groups data and as mentioned, we tried creating groups manually with PortalWebService by supplying the required data, it created the groups sucessfully and those groups are visible in CCR -> Groups but still DM groups are not synched.

     

    any other clue ?



  • 4.  Re: Sync issue between CCC and CCR

    Posted Oct 16, 2014 06:51 AM

    Hi,

     

    Even we are facing the same issue in our environment. Our set up is also new one, and facing the same issue.

     

    A CA case is already open for the same, but still not luck yet.

     

    cheers!

    T



  • 5.  Re: Sync issue between CCC and CCR

    Posted Oct 16, 2014 09:23 AM

    This problem is not seen in our Development server where the CCR and CCC/DM are installed on the same system. but in our Test and prod where CCR and CC/DM are in different Server, the synch doesn't happens



  • 6.  Re: Sync issue between CCC and CCR

    Posted Oct 16, 2014 09:34 AM

    Hi Toshi,

     

    Dirk is working with you on that issue that you opened with support, he is researching on it and should update shortly.

    I am also working on a similar case, I will post it here when I have an update.

     

    Regards,

    KS



  • 7.  Re: Sync issue between CCC and CCR
    Best Answer

    Posted Oct 16, 2014 10:20 PM

    Hi KS,

     

    The issue in out environment is resolved, the resolution was provided by Dirk over the CA support case.

     

    the solution was to adda new entry of NPC.AdminCommandWS.AllowRemoteAccess in the hidden setting page of CCR

     

    cheers!!

    T



  • 8.  Re: Sync issue between CCC and CCR

    Posted Oct 17, 2014 07:16 AM

    Hi T,

     

    Thank you for the update, the same resolution that was provided to you was implemented for Ravigu and the issue is resolved.

     

    Regards,

    KS



  • 9.  Re: Sync issue between CCC and CCR

    Posted Jul 06, 2017 03:21 AM

    Hi all,

     

    I faced the same problem on production environment at a customer with same symptoms and same error message.

    Steps 1, 2, 3 from KS where fine, but table NPC_DM_GROUP_MAPPING_CONFIG was empty.

    Oracle DBA found out there was a problem with Oracle XDB Package, the reinstalled it.

    That solved the problem.

    No root cause given by Oracle DBA.

    Hope this may help in case someone has the same problem!

     

    Best regards,

     

    Francois



  • 10.  Re: Sync issue between CCC and CCR

    Posted Jul 06, 2017 04:07 AM

    Hi Francois

     

    That's very interesting - I have seen similar issues on the Oracle side that we resolved by running an older version of the JDBC driver.  I wonder if the XDB package is actually the root cause, and what your DBA found is possibly a better solution…?

    [Update: found on Oracles Doc site: JDBC Standards Support 

    Note:

    In Oracle Database 10g and earlier versions of Oracle Database 11g, Oracle JDBC drivers supported the Oracle SQL XML type (XMLType) through an Oracle proprietary extension, which did not conform to the JDBC standard.

    The 11.2.0.2 Oracle JDBC drivers conformed to the JDBC standard with the introduction of a new connection property, oracle.jdbc.getObjectReturnsXMLType. If you set this property to false, then the getObject method returns an instance of java.sql.SQLXML type and if you depend on the existing Oracle proprietary support for SQL XMLType using oracle.xdb.XMLType, then you can change the value of this property back to true.

    However, setting of the getObjectReturnsXMLType property is not required for the current version of Oracle JDBC drivers.

    This adds to the notion that the two things could well be related...]

     

    If possible, please could you share the Oracle version and DM/CCC jdbc driver version details.

     

    Thanks



  • 11.  Re: Sync issue between CCC and CCR

    Posted Jul 06, 2017 04:47 AM

    Hi Adrian,

     

    Well, looks like I mixed 2 discussion threads but I can't find anymore the other one...

    The complete error message from ca_ccc-stdout.log was:

    Failed to notify CCR server after data migration.
    error encountered -31085: ORA-31085: schema "XDh1jUheYAR5PgNAgAILJCxg==" already registered

     

    Unfortunately, Oracle DBA wouldn't give us detail about it. I guess the Oracle Message ORA-31085 pushed them to reinstall the package and that worked...

     

    Oracle version is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

    Oracle JDBC Drivers release 11.2.0.3.0

    CCC 2.9

    DM  5.6.0.8 

     

    Best regards,

    Francois



  • 12.  Re: Sync issue between CCC and CCR

    Posted Aug 09, 2017 04:11 AM

    Like Adrian mentioned, the error "ORA-31085: schema "XDh1jUheYAR5PgNAgAILJCxg==" already registered"  is a resultant of invalid XDB package and the error should no longer occur once the package is installed,