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

[Alex Gomes 2]

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

[Khushboo Rabadia]

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