1. Home
  2. Support
Article - CS342716

In Vuforia Studio when publishing a new or an existing Project, an exception is thrown in a dialogbox

Modified: 21-Feb-2025   


Applies To

  • Vuforia Studio 8.0.0 N/A to 9.23.0
  • Vuforia Experience Service 8.0.0 N/A to 9.23.0

Description

  • In Vuforia Studio when publishing a new or an existing Project, an exception is thrown in a dialogbox
  • When publishing a new Project, exception is :
{"message":"cannot execute INSERT in a read-only transaction","errorCode":"","error":{}} 
  • When publishing an upgrade of Project exception is :
{"message":"cannot execute UPDATE in a read-only transaction","errorCode":"","error":{}} 
  • In Vuforia Studio log file, verbose is :
    • When publishing a new Project :
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] Zipping  <%USERPROFILE%>\Documents\VuforiaStudio\Projects\<Project name>\dist
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] filter out entry: extensions/js/libthingview_wasm.wasm
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] zip size 2034907 bytes (approximately 2 MB)
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] Starting Upload
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] zip size 2034907 bytes (approximately 2 MB)
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618317540400:<Project name>] zip size 2034907 bytes (approximately 2 MB)
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618317540400:<Project name>] Response code  500
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618317540400:<Project name>] Response body  {
  "message": "cannot execute INSERT in a read-only transaction",
  "errorCode": "",
  "error": {}
}
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618317540400:<Project name>] Response error  null
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618317540400:<Project name>] Failed to upload to the Experience Service. null
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:projectHelper] publishTask error for project <Project name> {
  statusCode: 500,
  message: '{\n' +
    '  "message": "cannot execute INSERT in a read-only transaction",\n' +
    '  "errorCode": "",\n' +
    '  "error": {}\n' +
    '}'
}
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:api] Error occured while publishing project <Project name> {
  statusCode: 500,
  message: '{\n' +
    '  "message": "cannot execute INSERT in a read-only transaction",\n' +
    '  "errorCode": "",\n' +
    '  "error": {}\n' +
    '}'
}
  • When publishing a Project already published :
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618295726489:<Project name>] Zipping  <%USERPROFILE%>\Documents\VuforiaStudio\Projects\<Project name>\dist
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618295726489:<Project name>] filter out entry: extensions/js/libthingview_wasm.wasm
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618295726489:<Project name>] zip size 3975927 bytes (approximately 4 MB)
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618295726489:<Project name>] Starting Upload
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618295726489:<Project name>] Response code  500
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618295726489:<Project name>] Response body  {"message":"cannot execute UPDATE in a read-only transaction","errorCode":"","error":{}}
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618295726489:<Project name>] Response error  null
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:ves-publish:1618295726489:<Project name>] zip size 3975927 bytes (approximately 4 MB)
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:ves-publish:1618295726489:<Project name>] Failed to upload to the Experience Service. null
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:projectHelper] publishTask error for project <Project name> {
  statusCode: 500,
  message: '{"message":"cannot execute UPDATE in a read-only transaction","errorCode":"","error":{}}'
}
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:api] Error occured while publishing project <Project name> {
  statusCode: 500,
  message: '{"message":"cannot execute UPDATE in a read-only transaction","errorCode":"","error":{}}'
}
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:projectHelper] Building ves-ar-extension app: <Project name>
[YYYY-MM-DDTHH:MM:SS.MSZ] info: [twx-studio:projectSettings] Notify preview windows:  private-room-<Project name>
[0mPOST /api/project/resource/save [32m200[0m 1970.358 ms - -[0m
[0mGET /api/switch [32m200[0m 1.387 ms - -[0m
[0mPOST /api/publish/ [32m200[0m 244.243 ms - 15[0m
[YYYY-MM-DDTHH:MM:SS.MSZ] error: [twx-studio:index] Server error 9067b5e5-ac6c-4d3a-b33c-5e31f5a665fc [Error: ENOENT: no such file or directory, stat '<%USERPROFILE%>\Documents\VuforiaStudio\Projects\<Project name>\dist\lib\cdn\angular-sanitize.min.js.map'] {
  errno: -4058,
  code: 'ENOENT',
  syscall: 'stat',
  path: '<%USERPROFILE%>\\VuforiaStudio\\Projects\\<Project name>\\dist\\lib\\cdn\\angular-sanitize.min.js.map',
  expose: false,
  statusCode: 404,
  status: 404
}
  • In a running Vuforia Experience Service verbose is :
    • When publishing an Experience at first time :
<client ip address>:<port number> - <username> [YYYY-MM-DDTHH:MM:SS.MSZ] "GET /ExperienceService/capabilities/mtg HTTP/1.1" 200 16 "-" "-" 0 ms <Server hostname> - [YYYY-MM-DDTHH:MM:SS.MSZ] - ms - ms - ms - ms
*** Terminating upload POST (500). error: cannot execute INSERT in a read-only transaction
    at Connection.parseE (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:614:13)
    at Connection.parseMessage (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:413:19)
    at TLSSocket.<anonymous> (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:129:22)
    at TLSSocket.emit (events.js:315:20)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:271:9)
    at TLSSocket.Readable.push (_stream_readable.js:212:10)
    at TLSWrap.onStreamRead (internal/stream_base_commons.js:186:23)
  • When publishing an existing Experience :
<client ip address>:<port number> - <username> [YYYY-MM-DDTHH:MM:SS.MSZ] "GET /ExperienceService/capabilities/mtg HTTP/1.1" 200 16 "-" "-" 0 ms <Server hostname> - [YYYY-MM-DDTHH:MM:SS.MSZ] - ms - ms - ms - ms
*** Terminating upload POST (500). error: cannot execute UPDATE in a read-only transaction
    at Connection.parseE (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:614:13)
    at Connection.parseMessage (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:413:19)
    at TLSSocket.<anonymous> (/appl/tes_8.5.11/node_modules/pg/lib/connection.js:129:22)
    at TLSSocket.emit (events.js:315:20)
    at addChunk (_stream_readable.js:295:12)
    at readableAddChunk (_stream_readable.js:271:9)
    at TLSSocket.Readable.push (_stream_readable.js:212:10)
    at TLSWrap.onStreamRead (internal/stream_base_commons.js:186:23)
  • When starting Vuforia Experience Service exception is :
YYYY-MM-DDTHH:MM:SS.MSZ vxs Process exiting with code: 1
Process exiting with code: 1
/appl/tes_8.5.11/node_modules/q/q.js:155
                throw e;
                ^

Error: error: cannot execute DROP TABLE in a read-only transaction
    at /appl/tes_8.5.11/routes/handlers/postgresHandler.js:430:23
    at _rejected (/appl/tes_8.5.11/node_modules/q/q.js:864:24)
    at /appl/tes_8.5.11/node_modules/q/q.js:890:30
    at Promise.when (/appl/tes_8.5.11/node_modules/q/q.js:1142:31)
    at Promise.promise.promiseDispatch (/appl/tes_8.5.11/node_modules/q/q.js:808:41)
    at /appl/tes_8.5.11/node_modules/q/q.js:624:44
    at runSingle (/appl/tes_8.5.11/node_modules/q/q.js:137:13)
    at flush (/appl/tes_8.5.11/node_modules/q/q.js:125:13)
    at processTicksAndRejections (internal/process/task_queues.js:79:11)
error: Forever detected script exited with code: 1
error: Script restart attempt #19101
This is a printer-friendly version of Article 342716 and may be out of date. For the latest version click CS342716