Author Topic: Control WS exception on GVP  (Read 2377 times)

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 7639
  • Karma: 56330
Control WS exception on GVP
« on: August 05, 2014, 07:00:04 PM »
Hi guys,
I had an incident today at a customer development and have no clue on how to control it.

Issue is:
1. I call a WS via the Composer Object
2. I set the input parameters for the WS
3. Expect a return based on WSDL

What normally could happen is that WS could go out and I call the badfetch exception on it.

What happened today is that the WS internally has some DB connections and so on, so the WS was up, but the return didn't match what was coded on the block.

The return was:

[code]
{'errorMsg':'{"Fault":{"faultcode":"soap:Server","faultstring":"CallableStatementCallback; uncategorized SQLException for SQL [{? = call pck_camada_servicos_ura.fnc_dados_endereco_ativo(?, ?, ?, ?, ?)}]; SQL state [72000]; error code [1045]; ORA-01045: user DNE_LINK lacks CREATE SESSION privilege; logon denied\nORA-02063: preceding line from DNE\nORA-06512: at \"AST.PCK_CAMADA_SERVICOS_URA\", line 533\nORA-06512: at \"AST.PCK_CAMADA_SERVICOS_URA\", line 561\n; nested exception is java.sql.SQLException: ORA-01045: user DNE_LINK lacks CREATE SESSION privilege; logon denied\nORA-02063: preceding line from DNE\nORA-06512: at \"AST.PCK_CAMADA_SERVICOS_URA\", line 533\nORA-06512: at \"AST.PCK_CAMADA_SERVICOS_URA\", line 561"}}'}
[/code]

An Oracle error. So the Output didn't match obviously and gave a general error...
How could I control this to catch it and do something like send the call to the agents directly?

Thanks!