Eroare interogare facturi disponibile in SPV #1

Closed
opened 2025-05-26 22:07:11 +03:00 by sandrei · 2 comments
Owner

Pentru cif netdava apare eroare apoi incarca in scurt timp facturile SPV.
image

org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 64
                    QueryExecutorImpl.java:2733 org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
                    QueryExecutorImpl.java:2420 org.postgresql.core.v3.QueryExecutorImpl.processResults
                     QueryExecutorImpl.java:372 org.postgresql.core.v3.QueryExecutorImpl.execute
                           PgStatement.java:517 org.postgresql.jdbc.PgStatement.executeInternal
                           PgStatement.java:434 org.postgresql.jdbc.PgStatement.execute
                   PgPreparedStatement.java:194 org.postgresql.jdbc.PgPreparedStatement.executeWithFlags
                   PgPreparedStatement.java:180 org.postgresql.jdbc.PgPreparedStatement.execute
                             result_set.clj:674 next.jdbc.result-set/stmt->result-set
                             result_set.clj:669 next.jdbc.result-set/stmt->result-set
                             result_set.clj:949 next.jdbc.result-set/fn
                             result_set.clj:862 next.jdbc.result-set/fn
                               protocols.clj:34 next.jdbc.protocols/fn[fn]
                                   jdbc.clj:268 next.jdbc/execute!
                                   jdbc.clj:254 next.jdbc/execute!
                                 db_ops.clj:231 efactura-mea.db.db-ops/fetch-ids-mesaje-descarcate
                                 db_ops.clj:227 efactura-mea.db.db-ops/fetch-ids-mesaje-descarcate
                                    api.clj:123 efactura-mea.web.api/call-for-lista-facturi
                                    api.clj:115 efactura-mea.web.api/call-for-lista-facturi
                                    api.clj:275 efactura-mea.web.api/handle-list-messages
                                    api.clj:268 efactura-mea.web.api/handle-list-messages
                                   Var.java:386 clojure.lang.Var.invoke
                             middleware.clj:114 muuntaja.middleware/wrap-format-request[fn]
                             middleware.clj:132 muuntaja.middleware/wrap-format-response[fn]
                              middleware.clj:96 muuntaja.middleware/wrap-format-negotiate[fn]
                           anti_forgery.clj:102 ring.middleware.anti-forgery/wrap-anti-forgery[fn]
                                   flash.clj:39 ring.middleware.flash/wrap-flash[fn]
                                session.clj:112 ring.middleware.session/wrap-session[fn]
                          keyword_params.clj:53 ring.middleware.keyword-params/wrap-keyword-params[fn]
                           nested_params.clj:89 ring.middleware.nested-params/wrap-nested-params[fn]
                                  params.clj:75 ring.middleware.params/wrap-params[fn]
                                cookies.clj:198 ring.middleware.cookies/wrap-cookies[fn]
                            content_type.clj:39 ring.middleware.content-type/wrap-content-type[fn]
                         default_charset.clj:31 ring.middleware.default-charset/wrap-default-charset[fn]
                            not_modified.clj:66 ring.middleware.not-modified/wrap-not-modified[fn]
                               x_headers.clj:22 ring.middleware.x-headers/wrap-x-header[fn]
                               x_headers.clj:22 ring.middleware.x-headers/wrap-x-header[fn]
                                  ring.cljc:382 reitit.ring$ring_handler$fn__22711.invoke
                                 oauth2.clj:209 ring.middleware.oauth2/wrap-oauth2[fn]
                                  params.clj:75 ring.middleware.params/wrap-params[fn]
                                session.clj:112 ring.middleware.session/wrap-session[fn]
                              middleware.clj:42 efactura-mea.web.middleware/wrap-app-config[fn]
                                 webjars.clj:46 ring.middleware.webjars/wrap-webjars[fn]
                              stacktrace.clj:99 ring.middleware.stacktrace/wrap-stacktrace-web[fn]
                                   AFn.java:154 clojure.lang.AFn.applyToHelper
                                   AFn.java:144 clojure.lang.AFn.applyTo
                              AFunction.java:33 clojure.lang.AFunction$1.doInvoke
                                RestFn.java:411 clojure.lang.RestFn.invoke
                                    sync.clj:28 ring.adapter.jetty9.handlers.sync/-handle
                                    sync.clj:20 ring.adapter.jetty9.handlers.sync/-handle
                               (Unknown Source) ring.adapter.jetty9.handlers.SyncProxyHandler.handle
                        ContextHandler.java:851 org.eclipse.jetty.server.handler.ContextHandler.handle
                                Server.java:181 org.eclipse.jetty.server.Server.handle
                      HttpChannelState.java:635 org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run
                        HttpConnection.java:403 org.eclipse.jetty.server.internal.HttpConnection.onFillable
                    AbstractConnection.java:322 org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded
                           FillInterest.java:99 org.eclipse.jetty.io.FillInterest.fillable
              SelectableChannelEndPoint.java:53 org.eclipse.jetty.io.SelectableChannelEndPoint$1.run
             AdaptiveExecutionStrategy.java:478 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask
             AdaptiveExecutionStrategy.java:441 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask
             AdaptiveExecutionStrategy.java:293 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce
             AdaptiveExecutionStrategy.java:201 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run
                ReservedThreadExecutor.java:311 org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run
                      QueuedThreadPool.java:979 org.eclipse.jetty.util.thread.QueuedThreadPool.runJob
                     QueuedThreadPool.java:1209 org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob
                     QueuedThreadPool.java:1164 org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run
                               Thread.java:1447 java.lang.Thread.run
Pentru cif netdava apare eroare apoi incarca in scurt timp facturile SPV. ![image](/attachments/c1a50f1e-a001-43be-a37c-65cbf712e78a) ``` org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 64 QueryExecutorImpl.java:2733 org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse QueryExecutorImpl.java:2420 org.postgresql.core.v3.QueryExecutorImpl.processResults QueryExecutorImpl.java:372 org.postgresql.core.v3.QueryExecutorImpl.execute PgStatement.java:517 org.postgresql.jdbc.PgStatement.executeInternal PgStatement.java:434 org.postgresql.jdbc.PgStatement.execute PgPreparedStatement.java:194 org.postgresql.jdbc.PgPreparedStatement.executeWithFlags PgPreparedStatement.java:180 org.postgresql.jdbc.PgPreparedStatement.execute result_set.clj:674 next.jdbc.result-set/stmt->result-set result_set.clj:669 next.jdbc.result-set/stmt->result-set result_set.clj:949 next.jdbc.result-set/fn result_set.clj:862 next.jdbc.result-set/fn protocols.clj:34 next.jdbc.protocols/fn[fn] jdbc.clj:268 next.jdbc/execute! jdbc.clj:254 next.jdbc/execute! db_ops.clj:231 efactura-mea.db.db-ops/fetch-ids-mesaje-descarcate db_ops.clj:227 efactura-mea.db.db-ops/fetch-ids-mesaje-descarcate api.clj:123 efactura-mea.web.api/call-for-lista-facturi api.clj:115 efactura-mea.web.api/call-for-lista-facturi api.clj:275 efactura-mea.web.api/handle-list-messages api.clj:268 efactura-mea.web.api/handle-list-messages Var.java:386 clojure.lang.Var.invoke middleware.clj:114 muuntaja.middleware/wrap-format-request[fn] middleware.clj:132 muuntaja.middleware/wrap-format-response[fn] middleware.clj:96 muuntaja.middleware/wrap-format-negotiate[fn] anti_forgery.clj:102 ring.middleware.anti-forgery/wrap-anti-forgery[fn] flash.clj:39 ring.middleware.flash/wrap-flash[fn] session.clj:112 ring.middleware.session/wrap-session[fn] keyword_params.clj:53 ring.middleware.keyword-params/wrap-keyword-params[fn] nested_params.clj:89 ring.middleware.nested-params/wrap-nested-params[fn] params.clj:75 ring.middleware.params/wrap-params[fn] cookies.clj:198 ring.middleware.cookies/wrap-cookies[fn] content_type.clj:39 ring.middleware.content-type/wrap-content-type[fn] default_charset.clj:31 ring.middleware.default-charset/wrap-default-charset[fn] not_modified.clj:66 ring.middleware.not-modified/wrap-not-modified[fn] x_headers.clj:22 ring.middleware.x-headers/wrap-x-header[fn] x_headers.clj:22 ring.middleware.x-headers/wrap-x-header[fn] ring.cljc:382 reitit.ring$ring_handler$fn__22711.invoke oauth2.clj:209 ring.middleware.oauth2/wrap-oauth2[fn] params.clj:75 ring.middleware.params/wrap-params[fn] session.clj:112 ring.middleware.session/wrap-session[fn] middleware.clj:42 efactura-mea.web.middleware/wrap-app-config[fn] webjars.clj:46 ring.middleware.webjars/wrap-webjars[fn] stacktrace.clj:99 ring.middleware.stacktrace/wrap-stacktrace-web[fn] AFn.java:154 clojure.lang.AFn.applyToHelper AFn.java:144 clojure.lang.AFn.applyTo AFunction.java:33 clojure.lang.AFunction$1.doInvoke RestFn.java:411 clojure.lang.RestFn.invoke sync.clj:28 ring.adapter.jetty9.handlers.sync/-handle sync.clj:20 ring.adapter.jetty9.handlers.sync/-handle (Unknown Source) ring.adapter.jetty9.handlers.SyncProxyHandler.handle ContextHandler.java:851 org.eclipse.jetty.server.handler.ContextHandler.handle Server.java:181 org.eclipse.jetty.server.Server.handle HttpChannelState.java:635 org.eclipse.jetty.server.internal.HttpChannelState$HandlerInvoker.run HttpConnection.java:403 org.eclipse.jetty.server.internal.HttpConnection.onFillable AbstractConnection.java:322 org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded FillInterest.java:99 org.eclipse.jetty.io.FillInterest.fillable SelectableChannelEndPoint.java:53 org.eclipse.jetty.io.SelectableChannelEndPoint$1.run AdaptiveExecutionStrategy.java:478 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask AdaptiveExecutionStrategy.java:441 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask AdaptiveExecutionStrategy.java:293 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce AdaptiveExecutionStrategy.java:201 org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.run ReservedThreadExecutor.java:311 org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run QueuedThreadPool.java:979 org.eclipse.jetty.util.thread.QueuedThreadPool.runJob QueuedThreadPool.java:1209 org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob QueuedThreadPool.java:1164 org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run Thread.java:1447 java.lang.Thread.run ```
sandrei self-assigned this 2025-05-26 22:28:57 +03:00
eugen changed title from eroare interogare facturi disponibile in SPV to Eroare interogare facturi disponibile in SPV 2025-05-26 22:34:33 +03:00
Author
Owner

Rectificat ajax request, eroarea nu mai apare.

Rectificat ajax request, eroarea nu mai apare.
Owner

Rezolvat :)

Rezolvat :)
eugen closed this issue 2025-08-14 11:09:56 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
2 participants
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
Netdava/efactura-mea#1
No description provided.