[BUG] Handlebars not working as expected

[straiker]

Bug description:
Handlebars for Vestlused -> Kontakti jätmine and Tagasiside -> Tagasiside Bürokrati vestlustele return error

Expected behavior:

• analytics views should display data correctly

Screenshots:

Additional information:
https://ruuter.stage.buerokratt.ee/v2/private/analytics/chats/contact-information-fulfilled

{
"response": [
[],
[],
"Bad Request",
{
"error": "There was an error executing /workspace/app/module/analytics/hbs/merge-arrays.handlebars"
}
]
}

https://ruuter.stage.buerokratt.ee/v2/private/analytics/feedbacks/buerokratt-chats-nps
{
"error": "There was an error executing /workspace/app/views/analytics/get-csa-nps-object.handlebars"
}

[varmoh]

Ruuter log

2025-09-30 09:53:18.693Z  INFO [,] --- [io-8080-exec-13] ee.buerokratt.ruuter.helper.HttpHelper   : [                 ] - - - - - REQUEST BODY: {period=hour, start=2025-09-30, end=2025-09-30, urls=[], showTest=false}
2025-09-30 09:53:18.698Z ERROR [,] --- [io-8080-exec-13] ee.buerokratt.ruuter.helper.HttpHelper   : [                 ] - - - - - Failed HTTP request: 

org.springframework.web.reactive.function.client.WebClientResponseException$BadRequest: 400 Bad Request from POST http://component-byk-resql:8082/analytics/chat-cif-all-csas-away
	at org.springframework.web.reactive.function.client.WebClientResponseException.create(WebClientResponseException.java:307)
	Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: 
Error has been observed at the following site(s):
	*__checkpoint ⇢ 400 BAD_REQUEST from POST http://component-byk-resql:8082/analytics/chat-cif-all-csas-away

ReSql log
at java.base/java.lang.Thread.run(Thread.java:1583) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 1173 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)

DataMapper log
Request: {method: POST, url: /analytics/hbs/merge-arrays, params: {}, query: {}, body: {"arr1":[],"arr2":[],"arr3":"Bad Request"} err: SyntaxError: Unexpected token 'N', ..."atCount": NaN } "... is not valid JSON at JSON.parse (<anonymous>) at file:///workspace/app/server.js:139:23 at ExpressHandlebars.<anonymous> (/workspace/app/node_modules/express-handlebars/dist/express-handlebars.js:301:25) at step (/workspace/app/node_modules/express-handlebars/dist/express-handlebars.js:49:23) at Object.next (/workspace/app/node_modules/express-handlebars/dist/express-handlebars.js:30:53) at fulfilled (/workspace/app/node_modules/express-handlebars/dist/express-handlebars.js:21:58) Response: {statusCode: 200, responseData: {"error":"There was an error executing /workspace/app/module/analytics/hbs/merge-arrays.handlebars"}} Request: {method: GET, url: /, params: {}, query: {}, body: {} Request: {method: GET, url: /, params: {}, query: {}, body: {} Response: {statusCode: 200, responseData: <h1>Handlebars APP: HOME</h1>} Response: {statusCode: 200, responseData: <h1>Handlebars APP: HOME</h1>} Request: {method: POST, url: /hbs/analytics/get-csa-nps-object, params: {}, query: {}, body: {"pointNps":[],"periodNps":0} err: Error: Failed to lookup view "/workspace/app/views/analytics/get-csa-nps-object.handlebars" in views directories "./views" or "./module/*/hbs/" at Function.render (/workspace/app/node_modules/express/lib/application.js:597:17) at ServerResponse.render (/workspace/app/node_modules/express/lib/response.js:1049:7) at handleRender (file:///workspace/app/server.js:129:7) at file:///workspace/app/server.js:153:5 at file:///workspace/app/server.js:100:11 at Layer.handle [as handle_request] (/workspace/app/node_modules/express/lib/router/layer.js:95:5) at next (/workspace/app/node_modules/express/lib/router/route.js:149:13) at file:///workspace/app/node_modules/express-rate-limit/dist/index.mjs:779:7 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async file:///workspace/app/node_modules/express-rate-limit/dist/index.mjs:663:5 { view: View { defaultEngine: undefined, ext: '.handlebars', name: '/workspace/app/views/analytics/get-csa-nps-object.handlebars', root: [ './views', './module/*/hbs/' ], engine: [Function: bound ], path: undefined } }

[1AhmedYasser]

https://ruuter.stage.buerokratt.ee/v2/private/analytics/chats/contact-information-fulfilled is fixed here #545

[1AhmedYasser]

https://ruuter.stage.buerokratt.ee/v2/private/analytics/feedbacks/buerokratt-chats-nps this one is happening only on the environment meaning Failed to lookup view "/workspace/app/views/analytics/get-csa-nps-object.handlebars means that the handlebars file does not exist on the environment @varmoh

[1AhmedYasser]

After discussion with @varmoh we fixed the handlebars hbs url to reflect in environment as well as local

[straiker]

errors fixed