Error 500 de Twinfield en la herramienta de consulta Invantive 25.0.127 (itgenoda035)

[forums]

No se logra reproducir el problema en Invantive Cloud (25.0.200) con:

select *
from   GeneralLedgerDetailsV3@tfd
where  fin_trs_head_modified >= trunc(sysdateutc) - 7000
and    fin_trs_head_modified <= trunc(sysdateutc)
and    ( company_code = 'NLA001821' 
         or company_code = 'NLA001821' 
         or company_code = 'NLA001821' 
       )
and    line >=0 
and    fin_trs_head_number>=0

El mensaje de error itgenoda035 indica que el servidor de la API de Twinfield ha devuelto un error HTTP 500 (Internal Server Error). Al parecer, se trata de un error específico del entorno que no se puede atribuir a un cambio en el software de Invantive.

El problema posiblemente sea similar a:

Error Itgenoda035 Twinfield.GeneralLedgerIntercompanyV2

Bij GeneralLedgerIntercompany-tabel krijg ik onderstaande foutmelding. Andere tabellen werkt probleemloos. Iemand een oplossing? DataSource.Error: OData: Aanvraag mislukt: De externe server heeft een fout geretourneerd: (500) Interne serverfout. (itgenoda035: De Twinfield-server heeft een interne fout geretourneerd, meestal is dat een applicatiefout binnen Twinfield. Neem contact op met de ondersteuning van Twinfield met de verzamelde oproepgegevens van het native platform of stel een …

Se trata de un mensaje de error genérico que devuelve Twinfield y que no aclara la causa:

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soap:Body>
      <soap:Fault>
         <soap:Code>
            <soap:Value>soap:Receiver</soap:Value>
         </soap:Code>
         <soap:Reason>
            <soap:Text xml:lang="en">Server was unable to process request. ---&gt; Invalid name character in 'http://www.twinfield.com/_Unexpected'.</soap:Text>
         </soap:Reason>
         <soap:Detail />
      </soap:Fault>
   </soap:Body>
</soap:Envelope>

La solicitud es:

<columns xmlns="" code="030_3">
      <column>
        <field>fin.trs.head.office</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.officename</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.year</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.period</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.yearperiod</field>
        <visible>false</visible>
        <operator>between</operator>
<from>2024/10</from>
<to>2024/10</to>

      </column>
      <column>
        <field>fin.trs.head.code</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.number</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.status</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.date</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.curcode</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.relation</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.relationname</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.inpdate</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.modified</field>
        <visible>true</visible>
<operator>between</operator>
<from>20240911000000</from>
<to>99991231235959</to>
      </column>
      <column>
        <field>fin.trs.head.username</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim2type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim3type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.valuesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.basevaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.repvaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.debitcredit</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.vatcode</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.vatbasevaluesigned</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.quantity</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.chequenumber</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.description</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.invnumber</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group1name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group2</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group2name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group3</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group3name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group4</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group4name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group5</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.dim1group5name</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.freetext1</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.freetext2</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.line.freetext3</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.origin</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.mng.type</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.regime</field>
        <visible>true</visible>
      </column>
      <column>
        <field>fin.trs.head.reportingstructure</field>
        <visible>false</visible>
      </column>
    </columns>

Se recomienda seguir el consejo indicado en el mensaje de error.

Más información sobre cómo recopilar el registro de llamadas nativas (native call log) se puede leer en:

Recopilar datos de llamadas de la plataforma nativa

Invantive SQL real-time transports massive amounts of data contained between over 70 (cloud) platforms and user applications such as Excel, Word, Power BI, technical products such as Query Tool and server products such as Data Replicator, Data Access Point or Bridge Online. This article helps you understand how to collect the data being transported between the Invantive SQL engine and the (cloud) platforms. This knowledge is essential when it is unclear what component(s) are causing a data inte…