Twenty•2mo ago

Can't change currency on opportunity

Trying to change the currency on an opportunity from USD to GBP but it refuses to change. I've checked my docker compose logs and keep seeing this entry. Could this have something to do with it? Thanks

worker-1  | Exception Captured
worker-1  |   undefined
worker-1  |   [
worker-1  |     Error: Error executing raw query for workspace 7466e32c-2e87-4e8a-81f7-0f4066425a2e: column "objectMetadataId" of relation "auditLog" does not exist
worker-1  |         at WorkspaceDataSourceService.executeRawQuery (/app/packages/twenty-server/dist/src/engine/workspace-datasource/workspace-datasource.service.js:105:19)
worker-1  |         at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
worker-1  |         at async AuditLogRepository.insert (/app/packages/twenty-server/dist/src/modules/timeline/repositiories/audit-log.repository.js:25:9)
worker-1  |         at async CreateAuditLogFromInternalEvent.handle (/app/packages/twenty-server/dist/src/modules/timeline/jobs/create-audit-log-from-internal-event.js:47:9)
worker-1  |         at async MessageQueueExplorer.invokeProcessMethods (/app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:111:17)
worker-1  |         at async MessageQueueExplorer.handleProcessor (/app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:105:13)
worker-1  |         at async /app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:79:17
worker-1  |         at async /app/packages/twenty-server/dist/src/engine/integrations/message-queue/drivers/pg-boss.driver.js:34:13
worker-1  |         at async resolveWithinSeconds (/app/node_modules/pg-boss/src/manager.js:35:14)
worker-1  |         at async /app/node_modules/p-map/index.js:57:22
worker-1  |   ]

worker-1  | Exception Captured
worker-1  |   undefined
worker-1  |   [
worker-1  |     Error: Error executing raw query for workspace 7466e32c-2e87-4e8a-81f7-0f4066425a2e: column "objectMetadataId" of relation "auditLog" does not exist
worker-1  |         at WorkspaceDataSourceService.executeRawQuery (/app/packages/twenty-server/dist/src/engine/workspace-datasource/workspace-datasource.service.js:105:19)
worker-1  |         at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
worker-1  |         at async AuditLogRepository.insert (/app/packages/twenty-server/dist/src/modules/timeline/repositiories/audit-log.repository.js:25:9)
worker-1  |         at async CreateAuditLogFromInternalEvent.handle (/app/packages/twenty-server/dist/src/modules/timeline/jobs/create-audit-log-from-internal-event.js:47:9)
worker-1  |         at async MessageQueueExplorer.invokeProcessMethods (/app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:111:17)
worker-1  |         at async MessageQueueExplorer.handleProcessor (/app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:105:13)
worker-1  |         at async /app/packages/twenty-server/dist/src/engine/integrations/message-queue/message-queue.explorer.js:79:17
worker-1  |         at async /app/packages/twenty-server/dist/src/engine/integrations/message-queue/drivers/pg-boss.driver.js:34:13
worker-1  |         at async resolveWithinSeconds (/app/node_modules/pg-boss/src/manager.js:35:14)
worker-1  |         at async /app/node_modules/p-map/index.js:57:22
worker-1  |   ]

4 Replies

WillR•2mo ago

Think the log message was a red herring. Deleted it all and started again and those messages have gone. When I amend opportunities, I see this message in the JS console: Warning: fragment with name OpportunityFragment already exists. graphql-tag enforces all fragment names across your application to be unique; read more about this in the docs: http://dev.apollodata.com/core/fragments.html#unique-names index-JGIdMgsI.js:329:95677 Got a working instance where I can change the currency and have that console message there too so think that's unrelated too. Strange!

charles•2mo ago

Hi @WillR, the auditLog bug was a known bug that has been fixed recently indeed We do have some remaining warnings with apollo cache but I don't think they should impact you Is your issue solved?

WillR•2mo ago

Haven't checked since (had a baby, haven't slept either 😄) I'll check later and update. Thanks!

charles•2mo ago

Haha, taking care of your baby is far more important! Take care 🙂 i'll mark this as resolved, feel free to re-open it once you have time to take a look

Gaming

Programming

Can't change currency on opportunity