Issue with Conntrans

[Former Member]

When Pricing Condition records are added or changed, I could see the records in the Outbound Queue in CRM. But after I run the Conntrans, I don't see some of the records in the Mobile database. Could somebody please help me with this issue?.

[Former Member]

Hi Vadim,

I did not make any changes to the BDOC.

Thanks,

Jansi.

[Former Member]

Hi Vadim,

Only some of the changes fail during the delta download.

I had checked the Delta and the Initial BDOC's. The SENDBITS in both delta and Initial are different.

Thanks,

Jansi.

[Former Member]

Jansi,

In case if you made changes to any BDOC's related to this download, then try to regenerated them in smoggen or gnrwb.

I'll try to find more info on this issue and let you know.

Regards,

Vadim.

[Former Member]

Hi Frank,

I did not check it before. I checked it now after I had received your reply and I do not see any unprocessed messages in the inbound queue.

Thanks,

Jansi.

[Former Member]

Jansi,

In your earlier reply you've mentioned that when you do an extract of the Condition table, all the records for Pricing is successfully downloaded to ides database.

In case of delta download, changes are not reflected in ides ( all changes OR just some of them ) ?

I have seen this once. Please, check SENDBITS in the BDOC.

Go to SMW01, and compare the SENDBITS in both BDOC's ( extract and delta ).

See if it's different. I think for extract it will be like FFFFFFFFFF...

It could be SENDBITS issue.

Regards,

Vadim.

[Former Member]

Hello Jansi,

have you checked the queue Manager in the client console if there are some unprocessed inbound queue messages on the client ?

regards

Frank

[Former Member]

Hi Ankan,

Conntrans do not show any errors. It appears like as if everything is processed successfully. But when I check the ides, I do not find some of my changes.

Yesterday's changes were processed fine so, I did not see anything unusual in the trace. Since Conntrans do not fail to download the changes everyday, I guess I have to turn on the trace all the time I run the Conntrans until I run into the issue again.

Thanks,

Jansi.

[former_member192750]

Hi Jansi,

Does Conntrans show you any errors? If yes, in which stage: Receive or Import?

Also, did you gather anything interesting from the SQL trace?

Thanks and regards,

Ankan

[Former Member]

I turned on the trace today using the SQL Profiler but all the changes are downloaded successfully to the ides. We have 5 Mobile Sites.

What I had seen last week is, the records that failed to download to ides on Mobile Site 1 are downloaded successfully to ides on Mobile Site 2. Something is really weird about the Conntrans. It is very difficult to debug because it is not consistent and does not fail to download for every change.

We had similar issues with the IPC Dataloader and that is why we are using the Conntrans technique to download the data to the Standalone servers and this is not working either.

Could somebody please advice me what my next steps should be.

Thanks,

Jansi.

[Former Member]

Hi Jansi,

First. You don't see "<b>some</b>" records ? What exactly ? Do you have all pricing conditions data on your laptop ?

If Pricing Condition is changed in CRM, and it does not exist on your laptop, there is nothing to update on the laptop.

You can investigate that. Please, see what is inserted into the ides database while Conntrans is executed.

To simplify your debug process, make sure you don't have any data to conntrans on your Mobile Client ( when you conntrans - 0 out of 0 records ).

Then, add or change Pricing Condition in CRM. There should be some records in your Outbound queue.

Start your SQL Profiler ( if you have one. In case if you run MSDE , you won't have that tool on the laptop ).

Go to Start->Programs->Microsoft SQL Server->SQL Profiler.

Create a new trace. Choose ides database.

Then perform Conntrans. After Conntrans is done, look in the profiler window, what UPDATE or INSERT statements are executed. This way you can find out what happens with this synchronization.

Let me know if this helpfull.

Regards,

Vadim.

[Former Member]

Hi Vadim,

What I meant to say is, when changes are made to the Pricing data, I see those changes getting logged in the Outbound queue but when I run the conntrans, some of the changes

are not updated or inserted into ides.But when I do an extract of the Condition table again, all the records from that Pricing table is successfully downloaded to ides database.

I will try to debug this issue by turning on the SQL Profiler.

Thanks,

Jansi.