1. Description:
The below error message is shown in the event log when comparing Inventory and Purchasing Transactions between HQ and Branch. This has been replication on the below setup:
HQ Server: LINKQA1
HQ Database: LINKSOFTHQ
HQPOSWeb: 10.0.0.11\POS-HQ
Branch Server: LinkQA4
Branch Database: LINKSOFTBRANCH2
BranchPOSWeb: 10.0.0.14\POS-Branch
Error Message: Remote table-valued function calls are not allowed.. This job will process again in 10 minutes.
2. Environment Details
Machine Name | LINKQA4 |
User name: | admin |
Operating System: | |
Browser name/Version: | |
| Other | |
3. Steps to recreate
a. Log into QA4 Branch POSWeb
b. Create a batch with Table Type as Transaction and Compare Group Name as Inventory. At this stage you will notice comparison is stopped with status as In progress(1/6) - LBS_XFER_DET.
c. Create a batch with Table Type as Transaction and Compare Group Name as Purchasing. At this stage you will notice comparison is stopped with status as In progress(3/5) - LBS_PO_DET (DB -LINKSOFTBRANCH1, Server - QA1).
d. Verify Event Log and error message will be shown as
Remote table-valued function calls are not allowed.
4. Current Behaviour:
5. Expected Behaviour:
-----------------------------------------------------------------------
--- TO BE COMPLETED AFTER THE CASE HAS BEEN RESOLVED ---
Has the problem been solved?:
Steps taken to resolve the issue:
Has the final solution review been done with the customer? (Yes/No) Notes from discussion with customer: