If you use Azure Service Bus queues or topics to import data, you can monitor and troubleshoot the data import information on several specific pages.


Application Consultant Application Consultant Start Start Receive data from Service Bus queue or topic subscription Receive data from Service Bus queue or topic subscription You can use the 'Service Bus queue' connector to import data from a Service Bus queue.To import data, first receive the data from a Service Bus queue or topic subscription. The received data is added to the 'Received data from queue' table in Connectivity studio.On receiving data from the Service Bus:Based on the Service Bus search definitions and settings on the received data, import messages are automatically assigned to the received data records.You can use 'peek lock'. If you use 'peek lock', the received Service Bus messages are temporarily locked in the Service Bus queue or topic subscription. Procedure 1. Go to Connectivity studio > Inquiries > Service Bus queue > Received data. 2. On the Action Pane, click Operation. 3. Click Receive data 4. In the Source connector field, enter or select a value. 5. Select Yes in the Peek lock field. 6. In the Number of messages field, enter a number. 7. In the Reschedule message (hrs) field, enter a number. 8. Sub-task: Set recurrence. 9. Expand the Run in the background section. 10. Select Yes in the Batch processing field and fill in the other fields as desired. 11. Click Recurrence. 12. Fill in the recurrence settings as desired and click OK. 13. Click OK. Notes You can also use the 'Receive and process data' process. This process: Receives the data from the Service Bus queue or topic subscription. Runs the messages that are automatically assigned to the received Service Bus data records. You can indicate which data you want to receive: Queue or topic subscription data. If 'Yes', you can also use the peek lock function. Dead letter data. You cannot use the peek lock function for dead letter data. If 'peek lock' is used,  Service Bus message  is locked If 'peek lock' is used,  Service Bus message  is locked Monitor data received from Service Bus queue or topic subscription Monitor data received from Service Bus queue or topic subscription You can monitor the data that you receive from an Azure Service Bus queue or topic subscription. Use the Received status to decide if any troubleshooting action is required. The possible statuses are: Status Description New The data is received from the Service Bus queue or topic subscription. Based on the Service Bus search definitions, a message is assigned. In process The data is now imported into D365 FO by the assigned message. Finished The data import into D365 FO is finished successfully. Error The data import into D365 FO is finished with errors. Invalid The data is received from the Service Bus queue or topic subscription. But, based on the Service Bus search definitions, no message is assigned. Procedure 1. Go to Connectivity studio > Inquiries > Service Bus queue > Received data. 2. To show all received data records, clear the Show errors check box. What's the received  data record status? What's the received  data record status? Adjust Service Bus search definitions Adjust Service Bus search definitions You can use Service Bus search definitions to automatically assign Connectivity studio messages to received data records from a Service Bus. Procedure 1. Go to Service Bus search definitions. Note: You can open this page from the Connectivity studio menu or from the Connector page. 2. Click New. 3. In the Dead letter field, select the applicable option. 4. In the Service Bus namespace field, enter the name of the applicable Service Bus namespace. 5. In the Entity name field, enter the name of the applicable Service Bus queue or Service Bus topic. 6. In the Subscription field, if the entity is a topic, enter the name of the applicable Service Bus topic subscription. 7. In the Priority field, enter the desired priority number. 8. In the Content info field, enter the value based on which to filter the search definition. 9. In the Subject filter field, select an option. 10. In the Subject info field, enter the value based on which to filter the search definition. 11. Define the message to be assigned to the received data records that match the search definition. In the Message field, enter or select a value. Note: The defined message must have the 'Service Bus queue' connector as source connector. 12. In the Company field, enter or select a value. 13. Close the page. Reassign message to data received from Service Bus queue or topic subscription Reassign message to data received from Service Bus queue or topic subscription If no message is assigned to data that you received from a Service Bus queue or topic subscription (Received status = Invalid), you must adjust or add Service Bus search definitions. If you have done so, you can retry to assign messages to the received data records without a message assigned.On reassign, for all received data records without a message, a matching search definition is searched for. If a matching search definition is found:The message and company, as defined for the search definition, are assigned to the received data record.The received data record status is set to 'New'.You can reassign messages:AutomaticallyManually Procedure 1. Go to Connectivity studio > Inquiries > Service Bus queue > Received data. 2. Sub-task: Reassign messages automatically. 3. On the Action Pane, click Design. 4. Click Reassign. 5. Sub-task: Assign message manually. 6. Click Edit. 7. In the list, find and select the desired record. 8. In the Message field, enter or select a value. Import received Service Bus data Import received Service Bus data You can import data from a Service Bus queue or topic subscription. First, you must receive the data from the Service Bus queue or topic subscription. On receiving data from the Service Bus, based on the Service Bus search definitions and settings on the received data, import messages are automatically assigned to the received data records. When the data is received, you can import the received data from the 'Received data from queue' table into D365 FO. To import the received data, run the messages as assigned to the received data records. You can run the messages in several ways, as desired. You can run a message by running a: Project Task Message If an import message run finishes: Successfully, the related received data record gets the status 'Finished'. If 'peek lock' is used, the Service Bus message is removed from the queue or topic subscription. With errors, the related received data record gets the status 'Error'. If 'peek lock' is used, the Service Bus message is moved from the queue or topic subscription to the related dead letter queue. Note: The assigned import messages must have the 'Service Bus queue' connector as source connector. Notes You can also use the 'Receive and process data' process. This process: Receives the data from the Service Bus queue or topic subscription. Runs the messages that are automatically assigned to the received Service Bus data records. You can indicate which data you want to receive: Queue or topic subscription data. If 'Yes', you can also use the peek lock function. Dead letter data. You cannot use the peek lock function for dead letter data. What's the status  when the import  message has run? What's the status  when the import  message has run? If 'peek lock' is used,  Service Bus message  is removed If 'peek lock' is used,  Service Bus message  is removed If 'peek lock' is used,  Service Bus message is  moved to dead letter queue If 'peek lock' is used,  Service Bus message is  moved to dead letter queue Troubleshoot message issues

Monitor message history

You can review and analyze the history of message runs that have run with errors. You can investigate these errors and take the appropriate actions to solve the errors. If the errors are solved, you can re-run the message run.

To monitor the message history, use the Connectivity studio integration operations workspace.

 

@videoref:CS7

Reset status of data received from Service Bus queue or topic subscription Reset status of data received from Service Bus queue or topic subscription To import data received from a Service Bus queue or topic subscription, you run import messages to read data from the 'Received data' table and import this data into D365 FO. If an import message run finishes with errors, the related received data record gets the status 'Error'. When you have finished troubleshooting the error, you can reset the received data record status. You can reset the status: At once for all received data records with the same message assigned. You can, for example do so if you have troubleshooted a message for which you have received several data records. Manually for a specific received data record. You can, for example, reset the status to: 'New' if you want to run the import message again for the received data records. 'Finished' if no import of the received data record is required. Procedure 1. Go to Connectivity studio > Inquiries > Service Bus queue > Received data. 2. Sub-task: Reset status for several records at once. 3. On the Action Pane, click Design. 4. Click Reset status. 5. In the Message field, enter or select a value. 6. In the Value from field, select an option. 7. In the Value to field, select an option. 8. Click OK. 9. Sub-task: Manually reset record status. 10. Click Edit. 11. In the list, find and select the desired record. 12. In the Recieved status field, select an option. 13. Close the page. Rerun import  message? Rerun import  message? End End Status = Invalid Status = New Status =  In process Status = Finished Status = Error Yes (Status = New) No

Activities

Name Responsible Description

Receive data from Service Bus queue or topic subscription

Application Consultant

You can use the 'Service Bus queue' connector to import data from a Service Bus queue.
To import data, first receive the data from a Service Bus queue or topic subscription. The received data is added to the 'Received data from queue' table in Connectivity studio.
On receiving data from the Service Bus:
  • Based on the Service Bus search definitions and settings on the received data, import messages are automatically assigned to the received data records.
  • You can use 'peek lock'. If you use 'peek lock', the received Service Bus messages are temporarily locked in the Service Bus queue or topic subscription.

Monitor data received from Service Bus queue or topic subscription

Application Consultant

You can monitor the data that you receive from an Azure Service Bus queue or topic subscription.
Use the Received status to decide if any troubleshooting action is required.
The possible statuses are:

Status

Description

New

The data is received from the Service Bus queue or topic subscription. Based on the Service Bus search definitions, a message is assigned.

In process

The data is now imported into D365 FO by the assigned message.

Finished

The data import into D365 FO is finished successfully.

Error

The data import into D365 FO is finished with errors.

Invalid

The data is received from the Service Bus queue or topic subscription. But, based on the Service Bus search definitions, no message is assigned.

Adjust Service Bus search definitions

Application Consultant

You can use Service Bus search definitions to automatically assign Connectivity studio messages to received data records from a Service Bus.

Reassign message to data received from Service Bus queue or topic subscription

Application Consultant

If no message is assigned to data that you received from a Service Bus queue or topic subscription (Received status = Invalid), you must adjust or add Service Bus search definitions. If you have done so, you can retry to assign messages to the received data records without a message assigned.
On reassign, for all received data records without a message, a matching search definition is searched for. If a matching search definition is found:
  • The message and company, as defined for the search definition, are assigned to the received data record.
  • The received data record status is set to 'New'.
You can reassign messages:
  • Automatically
  • Manually

Import received Service Bus data

Application Consultant

You can import data from a Service Bus queue or topic subscription.

First, you must receive the data from the Service Bus queue or topic subscription. On receiving data from the Service Bus, based on the Service Bus search definitions and settings on the received data, import messages are automatically assigned to the received data records.
When the data is received, you can import the received data from the 'Received data from queue' table into D365 FO. To import the received data, run the messages as assigned to the received data records. You can run the messages in several ways, as desired. You can run a message by running a:
  • Project
  • Task
  • Message
If an import message run finishes:
  • Successfully, the related received data record gets the status 'Finished'. If 'peek lock' is used, the Service Bus message is removed from the queue or topic subscription.
  • With errors, the related received data record gets the status 'Error'. If 'peek lock' is used, the Service Bus message is moved from the queue or topic subscription to the related dead letter queue.
Note: The assigned import messages must have the 'Service Bus queue' connector as source connector.

Troubleshoot message issues

Application Consultant

You can review and analyze the history of message runs that have run with errors. You can investigate these errors and take the appropriate actions to solve the errors. If the errors are solved, you can re-run the message run.

To monitor the message history, use the Connectivity studio integration operations workspace.

 

Reset status of data received from Service Bus queue or topic subscription

Application Consultant

To import data received from a Service Bus queue or topic subscription, you run import messages to read data from the 'Received data' table and import this data into D365 FO. If an import message run finishes with errors, the related received data record gets the status 'Error'. When you have finished troubleshooting the error, you can reset the received data record status.
You can reset the status:
  • At once for all received data records with the same message assigned. You can, for example do so if you have troubleshooted a message for which you have received several data records.
  • Manually for a specific received data record.
You can, for example, reset the status to:
  • 'New' if you want to run the import message again for the received data records.
  • 'Finished' if no import of the received data record is required.

See also

Provide feedback