Jump to content
We've recently updated our Privacy Statement, available here. ×

Exception has been thrown by the target of an invocation. (HRESULT: 80131604)


Alex Gomes 2

Recommended Posts

Ol!

Sempre que tento atualizar meus dados de forma manual aparece o erro abaixo.

Clico em "ok" e quando vou novamente para atualizar o erro aparece novamente e por mais 5 vezes. J procurei em fruns e no consegui encontrar alguma soluo.

Conseguem me ajudar

 

Error message: Could not reload data.

TargetInvocationException at Spotfire.Dxp.Framework:

Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:

at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)

at Spotfire.Dxp.Forms.FormsDataCanvasWebViewImpl.HandleRefreshProducer(JsonBundle args)

 

ImportException at Spotfire.Dxp.Data:

An error occurred when executing a query in the external data source.

External error:

ORA-03113: end-of-file on communication channel

Process ID: 380551

Session ID: 138 Serial number: 2171

Data connection:

Experience_Tempo_Real

Server:

x

Connect using:

x

Authentication method:

Oracle authentication

Submitted query:

SELECT "SpotfireCustomQuery1"."CPF_CNPJ" AS "CPF_CNPJ", "SpotfireCustomQuery1"."FUNCIONALIDADE" AS "FUNCIONALIDADE", "SpotfireCustomQuery1"."AO" AS "AO", "SpotfireCustomQuery1"."DESCRIO_AO" AS "DESCRIO_AO", "SpotfireCustomQuery1"."STATUS" AS "STATUS", "SpotfireCustomQuery1"."PLATAFORMA" AS "PLATAFORMA", "SpotfireCustomQuery1"."SEGMENTO" AS "SEGMENTO", "SpotfireCustomQuery1"."AUTOSSERVIO" AS "AUTOSSERVIO", "SpotfireCustomQuery1"."DIA_ANTERIOR" AS "DIA_ANTERIOR", "SpotfireCustomQuery1"."DATA_HISTORICA" AS "DATA_HISTORICA", "SpotfireCustomQuery1"."DATA_ATUAL" AS "DATA_ATUAL", "SpotfireCustomQuery1"."FUNCIONALIDADE_PT" AS "FUNCIONALIDADE_PT", "SpotfireCustomQuery1"."AO_PT" AS "AO_PT", "SpotfireCustomQuery1"."STATUS_PT" AS "STATUS_PT", "SpotfireCustomQuery1"."AUTOSSERVIO_PT" AS "AUTOSSERVIO_PT" FROM

 

 

SELECT D.NUMCNPJCPF AS CPF_CNPJ,

D.IDFUNCIONALITY AS FUNCIONALIDADE,

D.IDACTION AS AO,

D.STOBS AS DESCRIO_AO,

D.STINTEGRITY AS STATUS,

D.STSOURCESYSTEM AS PLATAFORMA,

D.STSEGMENT AS SEGMENTO,

D.AUTOSERVICO AS AUTOSSERVIO,

D.DTTIME-1 AS DIA_ANTERIOR,

D.DTTIME AS DATA_HISTORICA,

SYSDATE AS DATA_ATUAL,

UPPER(DECODE(D.IDFUNCIONALITY,'INVOICE','fatura',

'REGISTER','Cadastro',

'BILLING_ACCOUNT','Conta de Faturamento',

'LOGIN','Login',

'ANTI_DDOS','Anti DDOS',

'NEGOTIATION_HISTORY','Histrico de Negociao',

'NEGOTIATION','Negociao',

'RECHARGE','Recarga',

'AUTOMATIC_DEBIT','Dbito Automtico',

'DATA_TRAFFIC','Trfego de Dados',

'DEMAND_MONITORING','Solicitaes de Protocolo',

'FOLLOW_RECHARGE','Acompanhamento de Recarga',

'PRODUCTS_PLANT','Planta de Produtos',

'DETAILING','Detalhamento',

'DETAILING_PRE','Detalhamento Pr-Pago',

'DETAILING_RECHARGES','Detalhamento da Recarga',

'DOCUMENTS','Documentos/Contratos',

'OPERATIONS_HISTORY','Histrico de Aes no Site',

'RECHARGE_DOCUMENTS','Documentos da Recarga',

'REQUEST_AUDIO','Solitao de udio',

'ACCOUNT_DELIVERY_TYPE','Tipo de Entrega de Conta',

'DATA_QUOTA','Cota de Dados',

'400MB_QUOTA_BONUS','Bnus Cota de Dados 400MB',

'CHANGE_DUE_DATE','Alterao Data Vencimento',

'CHANGE_EMAIL','Alterao de e-mail',

'CHANGE_PREPAID_ADDRESS','Alterao Endereo Pr-Pago',

'CONSULTANT_WHATSAPP','WhatsApp do Consultor',

'DETAILING_POS','Detalhamento de Ps',

'EXPRESS_RECHARGE','Recarga Expressa',

'EXPRESS_RECHARGE_LOGGED','Recarga Expressa Logado',

'PRODUCT_CANCELLATION','Cancelamento de Produto',

'PROVISIONAL_SUSPENSION','Suspenso Provisria',

'SMS','SMS',

'UNLOCK_CONFIDENCE','Desbloqueio em Confiana',

'MANUAL','Manual',

'NEGOCIACAO','Negociao',

'STORE','Loja',

'SVA','SVA',

'USAGE_DETAILING','Detalhamento do Uso',

'AUTOMATIC_LOGIN','Login Automtico',

'INCIDENT','Incidentes',

'CHANGE_PASSWORD','Alterao de Senha',

'EXPRESS_RECHARGE_UNLOGGED','Recarga Expressa No Logado',

'ALIAS_BILLING_ACCOUNT','Apelido Conta de Faturamento',

'',''

)) AS FUNCIONALIDADE_PT,

UPPER(DECODE(D.IDACTION,'2VIA','2 Via',

'ADDRESS','Endereo',

'ADDRESS_CHANGE','Alterao de Endereo',

'AUTHENTICATION','Autenticao',

'BAR_GRAPH','Grfico de Barras',

'BARCODE','Cdigo de Barras',

'BILLET','Boleto',

'CALCULATE','Clculo',

'CHECK_CARD','Verificao do Carto',

'CONTACT','Contato',

'CONTACT_DELETE','Excluso do Contato',

'CONTACT_EDIT','Edio do Contato',

'CONTACT_NEW','Novo Contato',

'CREDIT_CARD','Carto de Crdito',

'DELETE','Excluso',

'DETAIL','Detalhamento',

'DETAILS','Detalhamento',

'DETAILS_EXCEL','Detalhamento por Excel',

'DOWNLOAD','Download',

'EMAIL','Email',

'EVENTS_SUMMARY','Resumo de Eventos',

'FEBRABAN','Febraban',

'GRAPH','Grfico',

'GRAPH_ALERTS','Alerta Grfico',

'MANUAL_AUTHENTICATION','Autenticao Manual',

'OLD_VERSION','Verso Antiga',

'ONLINE','Online',

'OPTIONS','Opes',

'PERSONAL','Pessoal',

'POST_OFFICE','Correios',

'RELATIONSHIP','Relacionamento',

'SENDBYEMAIL','Envio por Email',

'SENDBYEMAIL_EXCEL','Envio de Excel por Email',

'SENDBYEMAIL_PDF','Envio de PDF por Email',

'SUBMIT','Submeter',

'USER_CONFIRMATION','Confirmao de Usurio',

'USER_NEW','Novo Usurio',

'VALID_PROTOCOL','Protocolo Vlido',

'INVALID_PROTOCOL','Protocolo Invlido',

'VERIFY_NUMBER','Verificao do Nmero',

'VIEW','Visualizao',

'WEB','Web',

'VIEW_BARCODE','Visualizao Cdigo de Barras',

'SUBMIT_EMAIL','Enviar Email',

'SUBMIT_SMS','Enviar SMS',

'COPY_BARCODE','Copiar Cdigo de Barras',

'SUBMIT_INVALID_FORM','Formulrio Invlido',

'SUBMIT_VALID_FORM','Formulrio Vlido',

'CHECK_DOCUMENT','Verificar Dados',

'VALID_TOKEN_SMS','Validar Token SMS')) AS AO_PT,

UPPER(DECODE(D.STINTEGRITY,'SUCCESS','SUCESSO',

'SUCESSO','SUCESSO',

'ERROR','ERRO',

'WARNING','ATENO')) AS STATUS_PT,

UPPER(DECODE(D.AUTOSERVICO,'S','SIM',

'N','NO')) AS AUTOSSERVIO_PT

FROM

TABELA D

WHERE 1 = 1

AND D.DTTIME BETWEEN SYSDATE - 6 AND SYSDATE

AND D.AUTOSERVICO = 'S'

ORDER BY D.DTTIME DESC) "SpotfireCustomQuery1" (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(ManagedDataConnection dataConnection, Guid virtualJoinViewId, DataTableSchema schema, Guid promptCo

Link to comment
Share on other sites

Such error is seen when connection drops/broken between client and server.

 

https://www.tekstream.com/resource-center/ora-03113-end-of-file-on-communication-channel/

http://www.dba-oracle.com/m_ora_03113_end_of_file_on_communications_channel.htm

https://docs.oracle.com/cd/B19306_01/win.102/b14306/appendixb.htm

 

You can check with your network team or Oracle DB team regarding this behavior and also test the

same query in sql developer

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...