Skip to Content
author's profile photo Former Member
Former Member

Facing Some synchronising Issues

hi,

I have some record in our "SQL DATABASE" And it is also present in our cache database but when user synchronise user did not get that record on the same date when this record inserted into the CacheDataBase .

After one day, when user syncs he get that data. Kindly let me know why this delay occurs??

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jan 08, 2014 at 08:35 AM

    Is there any load parameter in the MBO created ? If yes to which key it is mapped to (PK or SK) ? What is the cache policy of MBO ? Have you checked by changing the detection interval in sync group.

    - Midhun VP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 10:44 AM

    ConnectionProperties connectionProperties = application.getConnectionProperties();

    connectionProperties.setServerName(getResources().getString(R.string.server_url));

    connectionProperties.setPortNumber(Constants.MESSAGING_PORT);

    connectionProperties.setFarmId(getResources().getString(R.string.farm_id));

    LoginCredentials credentials = new LoginCredentials(userName, password);

    connectionProperties.setLoginCredentials(credentials);

    ConnectionProfile syncProfile = APHSmCRMDB.getSynchronizationProfile();

    syncProfile.setServerName(getResources().getString(R.string.server_url));

    syncProfile.setPortNumber(Constants.REPLICATION_PORT);

    syncProfile.setNetworkProtocol("http");

    NetworkStreamParams streamParams = syncProfile.getStreamParams();

    streamParams.setUrl_Suffix(getResources().getString(R.string.url_suffix));

    syncProfile.setCacheSize(102400);

    syncProfile.setDomainName("default");

    syncProfile.setAsyncReplay(true);

    syncProfile.save()

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 01:26 PM

    after connections

    UserSubscription userSynchronizationParameters = new UserSubscription(); userSynchronizationParameters.setLoginId(userName); User.addSubscription(userSynchronizationParameters);

    APHSmCRMDB.synchronize(Constants.SYNC_GROUP_USER);

    List<User> userList = User.findAll();

    if (CollectionUtils.isEmpty(userList)) { return new Response(false, getResources().getString(R.string.user_sync_failed), null); }

    User user = userList.get(0);

    TerritoryUserSubscription territoryUserSynchronizationParameters = new TerritoryUserSubscription(); territoryUserSynchronizationParameters.setLocationCode(user.getTERRITORY_CODE()); TerritoryUser.addSubscription(territoryUserSynchronizationParameters);

    SiteHeadPainterContractorMappingSubscription siteHeadPainterContractorMappingSynchronizationParameters = new SiteHeadPainterContractorMappingSubscription(); siteHeadPainterContractorMappingSynchronizationParameters.setLocationCode(user.getUNIT_CODE()); SiteHeadPainterContractorMapping.addSubscription(siteHeadPainterContractorMappingSynchronizationParameters);

    Painting_SystemSubscription paintingSystemSynchronizationParameters = new Painting_SystemSubscription(); paintingSystemSynchronizationParameters.setLocationUnitCode(user.getUNIT_CODE().trim()); Painting_System.addSubscription(paintingSystemSynchronizationParameters);

    HolidaysSubscription holidaysSynchronizationParameters = new HolidaysSubscription(); holidaysSynchronizationParameters.setUnitCode(user.getUNIT_CODE().trim()); Holidays.addSubscription(holidaysSynchronizationParameters);

    AppointmentSubscription appointmentSynchronizationParameters = new AppointmentSubscription(); appointmentSynchronizationParameters.setUserCode(user.getUSER_CODE()); Appointment.addSubscription(appointmentSynchronizationParameters);

    Sales_OpportunitySubscription opportunitySynchronizationParameters = new Sales_OpportunitySubscription(); opportunitySynchronizationParameters.setUserCode(user.getUSER_CODE()); Sales_Opportunity.addSubscription(opportunitySynchronizationParameters);

    SiteSubscription siteSynchronizationParameters = new SiteSubscription(); siteSynchronizationParameters.setUserCode(user.getUSER_CODE()); Site.addSubscription(siteSynchronizationParameters);

    CustomerSubscription customerSynchronizationParameters = new CustomerSubscription(); customerSynchronizationParameters.setUserCode(user.getUSER_CODE()); Customer.addSubscription(customerSynchronizationParameters);

    APHSmCRMDB.synchronize();

    i done that code

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 01:27 PM

    Please help me out for this issue. I face this issues in live.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.