Azure Cosmos DB
An Azure NoSQL database service for app development.
1,543 questions
Javascript stored procedure works in production but fails to execute in emulator
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 3%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Warren Buckley (wbuckley)
1
Reputation point
We have a stored procedure which works without issue when running live on Cosmos DB in Azure.
But running the same stored procedure on the emulator fails with the following error:
The delegate parameter is incorrect. Make sure that the delegate is function declaration inlined with the call.","Encountered exception while executing Javascript. Exception = Error: filter: error
processing delegate function.\r\nStack trace: Error: filter: error processing delegate function.\n
The Javascript function that's throwing the above error is:
function fetchProjectLinks(container, organizationId) {
return new Promise((resolve, reject) => {
const predicate = (doc) =>
doc.type === 'project'
&& doc.organizationId === organizationId;
const result = container.chain().filter(predicate).map(doc => doc._self) // <-- This is the line it points to.
.value((error, docs) => {
if (error) { reject(error); }
else { resolve(docs); }
});
if (!result.isAccepted) {
reject(new Error('Failed to fetch project document links.'));
}
});
}
Currently I'm attempting to use the emulator for integration testing.
The emulator is the latest Linux docker container (which I'm running on Windows).
Doesn't matter if I inline the predicate or not, I always get the same error on the emulator.
My question is, why does this function throw the above error when running in the emulator but runs perfectly when run in Azure.
Is the Javascript being interpreted differently?
Is there a difference between the Javascript API's?
Here is the full Stored Procedure:
/*global getContext, ErrorCodes*/
// eslint-disable-next-line no-unused-vars
function createDomainControllers(controllers) {
if (controllers == null) {
throw new Error(ErrorCodes.BadRequest,
'The parameter "controllers" cannot be null or undefined');
}
if (typeof controllers === 'string') {
controllers = JSON.parse(controllers);
}
if (!Array.isArray(controllers)) {
controllers = [controllers];
}
const context = getContext();
async function main() {
const container = context.getCollection();
let promises = controllers.map(c => createController(container, c));
controllers = await Promise.all(promises);
const [first] = controllers;
const links = await fetchProjectLinks(container, first.organizationId);
promises = links.map(link => patchProject(container, link, controllers));
await Promise.all(promises);
return controllers;
}
main().then(dcs => context.getResponse().setBody(dcs))
.catch(error => context.abort(error));
}
function createController(container, controller) {
return new Promise((resolve, reject) => {
const link = container.getSelfLink();
const options = { disableAutomaticIdGeneration: false };
const created = container.createDocument(link, controller, options, (error, dc) => {
if (error) { reject(error); }
else { resolve(dc); }
});
if (!created) {
reject(new Error('Failed to create domain controller document.'));
}
});
}
function patchProject(container, link, controllers) {
return new Promise((resolve, reject) => {
const patch = [];
for (const dc of controllers) {
const item = { dc: dc };
patch.push({ 'op': 'add', 'path': '/workItems/-', 'value': item });
}
const result = container.patchDocument(link, patch, (error, doc) => {
if (error) { reject(error); }
else { resolve(doc); }
});
if (!result) {
reject(new Error('Failed to replace project document.'));
}
});
}
function fetchProjectLinks(container, organizationId) {
return new Promise((resolve, reject) => {
const predicate = (doc) =>
doc.type === 'project'
&& doc.organizationId === organizationId;
const result = container.chain().filter(predicate).map(doc => doc._self)
.value((error, docs) => {
if (error) { reject(error); }
else { resolve(docs); }
});
if (!result.isAccepted) {
reject(new Error('Failed to fetch project document links.'));
}
});
}
Here is the Domain Controller document:
{
"id": "d4f6300d-506f-8c8c-276d-ec348cc511f9",
"organizationId": "7239f2ad-3fc7-40b2-b966-2e5c9b0bc59d",
"dnsName": "berniece.info",
"domainsDnsName": "chad.berniece.info",
"site": "solutions",
"isReadOnly": false,
"ntdsGuid": null,
"fsmoRoles": [
"schemaMaster",
"ridMaster"
],
"type": "controller"
}
Here is the Project document:
{
"id": "f8ca8363-7e78-4279-8ef6-ea4d1eed6a38",
"organizationId": "6caca5ea-5e02-4456-a683-419b89d5131c",
"version": null,
"projectName": "Test project 2",
"recoveryMode": "forestRecovery",
"forest": "Forest2",
"workItems": [
{
"dc": {
"id": "3e130b16-4bc3-44dd-b929-ec393eed28e5",
"organizationId": "6caca5ea-5e02-4456-a683-419b89d5131c",
"dnsName": "dc1.rmad.local",
"domainsDnsName": "rmad.local",
"site": "Rmad site",
"isReadOnly": false,
"ntdsGuid": null,
"fsmoRoles": [
"pdcEmulator",
"infrastructureMaster"
],
"type": "controller"
},
"credentials": null,
"computerInformation": null,
"restoreSysvolFromBackup": false,
"isRestoreAdSecondStage": false,
"wipeDisks": false,
"performMalwareScan": false,
"operationsToPause": null,
"isEnabled": false,
"recoveryAction": "none",
"backup": null,
"autoUpdateBackup": false,
"dnsChangeSet": null,
"dnsChange": null,
"keepGcDataUnchanged": false,
"configureAsGcAfterReinstall": false,
"promoteRodc": false,
"tempStorage": null,
"isProcessed": false,
"useAuthoritativeSysvolRestore": false,
"inheritDomainSettings": false,
"domotionParameters": null,
"agentInformation": null,
"ditPath": null,
"logPath": null,
"sysvolPath": null,
"useAdPathsFromBackup": false,
"targetIpAddress": null,
"useFeAgentPort": null,
"feAgentPort": null,
"isoIpAddress": null,
"isoSubnetMask": null,
"isoDefaultGateway": null,
"useOriginalTargetNetworkSettings": false,
"isoPath": null,
"saveIsoOnBackupShare": false,
"driversPath": null,
"addCustomDrivers": false,
"addCustomDriversFromBackup": false,
"keepInProject": false
},
{
"dc": {
"id": "f37a197a-c7f0-4f00-8fd9-40e31386ab64",
"organizationId": "6caca5ea-5e02-4456-a683-419b89d5131c",
"dnsName": "dc2.rmad.local",
"domainsDnsName": "rmad.local",
"site": "Rmad site",
"isReadOnly": false,
"ntdsGuid": null,
"fsmoRoles": [
"ridMaster",
"domainNamingMaster"
],
"type": "controller"
},
"credentials": null,
"computerInformation": null,
"restoreSysvolFromBackup": false,
"isRestoreAdSecondStage": false,
"wipeDisks": false,
"performMalwareScan": false,
"operationsToPause": null,
"isEnabled": false,
"recoveryAction": "none",
"backup": null,
"autoUpdateBackup": false,
"dnsChangeSet": null,
"dnsChange": null,
"keepGcDataUnchanged": false,
"configureAsGcAfterReinstall": false,
"promoteRodc": false,
"tempStorage": null,
"isProcessed": false,
"useAuthoritativeSysvolRestore": false,
"inheritDomainSettings": false,
"domotionParameters": null,
"agentInformation": null,
"ditPath": null,
"logPath": null,
"sysvolPath": null,
"useAdPathsFromBackup": false,
"targetIpAddress": null,
"useFeAgentPort": null,
"feAgentPort": null,
"isoIpAddress": null,
"isoSubnetMask": null,
"isoDefaultGateway": null,
"useOriginalTargetNetworkSettings": false,
"isoPath": null,
"saveIsoOnBackupShare": false,
"driversPath": null,
"addCustomDrivers": false,
"addCustomDriversFromBackup": false,
"keepInProject": false
},
{
"dc": {
"id": "2d608e27-7af4-4076-a031-21206fa7e3c5",
"organizationId": "6caca5ea-5e02-4456-a683-419b89d5131c",
"dnsName": "dc3.rmad.local",
"domainsDnsName": "rmad.local",
"site": "Rmad site",
"isReadOnly": false,
"ntdsGuid": null,
"fsmoRoles": [],
"type": "controller"
},
"credentials": null,
"computerInformation": null,
"restoreSysvolFromBackup": false,
"isRestoreAdSecondStage": false,
"wipeDisks": false,
"performMalwareScan": false,
"operationsToPause": null,
"isEnabled": false,
"recoveryAction": "none",
"backup": null,
"autoUpdateBackup": false,
"dnsChangeSet": null,
"dnsChange": null,
"keepGcDataUnchanged": false,
"configureAsGcAfterReinstall": false,
"promoteRodc": false,
"tempStorage": null,
"isProcessed": false,
"useAuthoritativeSysvolRestore": false,
"inheritDomainSettings": false,
"domotionParameters": null,
"agentInformation": null,
"ditPath": null,
"logPath": null,
"sysvolPath": null,
"useAdPathsFromBackup": false,
"targetIpAddress": null,
"useFeAgentPort": null,
"feAgentPort": null,
"isoIpAddress": null,
"isoSubnetMask": null,
"isoDefaultGateway": null,
"useOriginalTargetNetworkSettings": false,
"isoPath": null,
"saveIsoOnBackupShare": false,
"driversPath": null,
"addCustomDrivers": false,
"addCustomDriversFromBackup": false,
"keepInProject": false
}
],
"infrastructureOrigin": null,
"infrastructureUpdatedOn": "0001-01-01T00:00:00",
"password": null,
"passwordHash": null,
"disableAuthoritativeSysvolRestore": [],
"excludedDomains": [
"quest.local",
"microsoft.com"
],
"infrastructureTemplates": [],
"pauses": [],
"alerts": [],
"gcResetStategy": "reset",
"backupFilterCriteria": {
"searchBackupsFromNow": false,
"backupAge": 0,
"backupsFromDcPreferabled": false,
"beforeDate": "2022-10-08T16:05:47.5792292Z",
"afterDate": "2022-09-29T16:05:47.5791721Z"
},
"bmrBackupFilterCriteria": null,
"maximumBackupsAgeDifference": 0,
"dcComputerDataUpdatedOn": "0001-01-01T00:00:00",
"testScenarioFileName": null,
"domainsSettings": [],
"defaultDomainsSettings": [],
"resetAdminPasswordSettings": null,
"isSimulationProject": false,
"dnsCacheData": "",
"type": "project"
}
Here is the C# Cosmos SDK Usage:
public async Task
{count} votes
-
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee2022-10-20T15:31:40.933+00:00 Hi, @Warren Buckley (wbuckley) Welcome to the Microsoft Q&A Platform, and thanks for posting your query.
As I understand the ask here is you have a stored procedure that works without issue when running on Azure Cosmos DB however the same fails when running on the emulator.
Currently, I am checking with the internal product team and get back to you with more details.Regards
Geetha -
Warren Buckley (wbuckley) 1 Reputation point
2022-10-20T18:18:44.55+00:00 Yes, that's correct. I can post the entire stored procedure if that helps but the error I'm getting in the emulator points to the function I posted above.
-
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-10-20T18:28:22.763+00:00 @Warren Buckley (wbuckley) Thanks for your response, I will let you know if a stored procedure is needed.
Regards
Geetha -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-10-26T13:04:01.293+00:00 @Warren Buckley (wbuckley) Can you please share the below information
• Complete JavaScript used in the SP
• A sample document ( on which the SP operates)
• SP calling code from the client AppRegards
Geetha -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-10-28T17:53:18.63+00:00 @Warren Buckley (wbuckley) We haven't heard back from you. Just wanted to check if you had the chance to check my message
Regards
Geetha -
Warren Buckley (wbuckley) 1 Reputation point
2022-11-01T12:47:35.183+00:00 Hi, sorry I missed your request.
I've updated the question with the requested information. -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-11-01T12:57:32.69+00:00 @Warren Buckley (wbuckley) Sure np thanks for sharing additional information.
Regards
Geetha -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-11-02T14:14:50.21+00:00 @Warren Buckley (wbuckley) while investigating the problem we noticed a bug in the emulator and escalated it to the product group and they are looking into it.
thanks for bringing this up. I will keep you posted on the status.Regards
Geetha -
Warren Buckley (wbuckley) 1 Reputation point
2022-11-02T19:09:03.833+00:00 Is the bug related to the issue I'm having? Or was something else uncovered?
-
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2022-11-02T19:21:10.697+00:00 @Warren Buckley (wbuckley) yes for the same issue you are seeing.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 38%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Johnson, Dustin M 0 Reputation points2023-06-29T16:26:17.43+00:00 I've noticed this thread has gone silent, but I am running into the same issue myself now. Do you know if this issue has been addressed by the emulator team?
Sign in to comment