1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Tally ERP 9 Gives Error and disconnect, When we Request Data using XML.

Discussion in 'Tally Integration' started by Bhushan Cellica, Nov 11, 2019.

    
  1. Bhushan Cellica

    Bhushan Cellica Member


    Hello All,

    Tally ERP 9 gives "Memory Allocation" Error dialog box and disconnect, When we request data using following XML,

    Code:
    <ENVELOPE>
   <HEADER>
     <VERSION>1</VERSION>
     <TALLYREQUEST>Export</TALLYREQUEST>
     <TYPE>Data</TYPE>
     <ID>Company Details</ID>
   </HEADER>
   <BODY>
     <DESC>
       <STATICVARIABLES>
         <SVCURRENTCOMPANY>DEMO COMPANY</SVCURRENTCOMPANY>
         <EXPLODEFLAG>Yes</EXPLODEFLAG>
         <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
       </STATICVARIABLES>
       <TDL>
         <TDLMESSAGE>
           <REPORT NAME="Company Details">
             <FORMS>Company Details</FORMS>
             <TITLE>"Company Details"</TITLE>
           </REPORT>
           <FORM NAME="Company Details">
             <TOPPARTS>Simple CD Part</TOPPARTS>
             <HEIGHT>100% Page</HEIGHT>
             <WIDTH>100% Page</WIDTH>
           </FORM>
           <PART NAME="Simple CD Part">
             <TOPLINES>Simple CD Details</TOPLINES>
             <SCROLLED>Vertical</SCROLLED>
             <COMMONBORDERS>Yes</COMMONBORDERS>
           </PART>
           <LINE NAME="Simple CD Details">
             <LEFTFIELDS>CmpName</LEFTFIELDS>
             <RIGHTFIELDS>Addr,Addr1,Addr2,Addr3,Addr4,Addr5,CIN,PAN,CmpNo,EndingAt,GSTNO</RIGHTFIELDS>
           </LINE>
           <FIELD NAME="CmpName"><USE>CmpName Field</USE> <SET>$Name:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr"><USE>Addr Field</USE> <SET>$Address:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr1"><USE>Addr1 Field</USE> <SET>$_Address1:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr2"><USE>Addr2 Field</USE> <SET>$_Address2:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr3"><USE>Addr3 Field</USE> <SET>$_Address3:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr4"><USE>Addr4 Field</USE> <SET>$_Address4:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr5"><USE>Addr5 Field</USE> <SET>$_Address5:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="CIN"><USE>CIN Field</USE> <SET>$CorporateIdentityNo:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="PAN"><USE>PAN Field</USE> <SET>$IncomeTaxNumber:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="CmpNo"><USE>CmpNo Field</USE> <SET>$CompanyNumber:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="EndingAt"><USE>EndingAt Field</USE> <SET>$EndingAt:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="GSTNO"><USE>GSTNO Field</USE> <SET>$GSTRegNumber:TaxUnit:@@CMPExcisePrimaryGodown</SET></FIELD>
         </TDLMESSAGE>
       </TDL>
     </DESC>
   </BODY>
</ENVELOPE>
    But this error occurs only on two machines till now, for others it is working properly.

    Please guide me to solve this error.

    Is anything missing or require some changes in it ?

    Thanks,
    Bhushan Akole.
     
    Bhushan Cellica, Nov 11, 2019
    #1


  2. teja varma

    teja varma Active Member


    this working fine on my machine:
    Code:
    <ENVELOPE>
   <HEADER>
     <VERSION>1</VERSION>
     <TALLYREQUEST>Export</TALLYREQUEST>
     <TYPE>Data</TYPE>
     <ID>Company Details</ID>
   </HEADER>
   <BODY>
     <DESC>
       <STATICVARIABLES>
         <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
       </STATICVARIABLES>
       <TDL>
         <TDLMESSAGE>
           <REPORT NAME="Company Details">
             <FORMS>Company Details</FORMS>
             <TITLE>"Company Details"</TITLE>
           </REPORT>
           <FORM NAME="Company Details">
             <TOPPARTS>Simple CD Part</TOPPARTS>
           </FORM>
           <PART NAME="Simple CD Part">
             <TOPLINES>Simple CD Details</TOPLINES>
             <SCROLLED>Vertical</SCROLLED>
           </PART>
           <LINE NAME="Simple CD Details">
             <LEFTFIELDS>CmpName</LEFTFIELDS>
             <RIGHTFIELDS>Addr,Addr1,Addr2,Addr3,Addr4,Addr5,CIN,PAN,CmpNo,EndingAt,GSTNO</RIGHTFIELDS>
           </LINE>
           <FIELD NAME="CmpName">
                <SET>$Name:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr"><SET>$Address:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr1">
           <SET>$_Address1:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr2"> <SET>$_Address2:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr3"><SET>$_Address3:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr4"> <SET>$_Address4:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="Addr5"><SET>$_Address5:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="CIN"><SET>$CorporateIdentityNo:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="PAN"> <SET>$IncomeTaxNumber:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="CmpNo"><SET>$CompanyNumber:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="EndingAt"> <SET>$EndingAt:Company:##SVCurrentCompany</SET></FIELD>
           <FIELD NAME="GSTNO"><SET>$GSTRegNumber:TaxUnit:@@CMPExcisePrimaryGodown</SET></FIELD>
         </TDLMESSAGE>
       </TDL>
     </DESC>
   </BODY>
</ENVELOPE>

    No need to use styles and formatted statements like (use,height,width,etc) it has no effect in reponse
     
    teja varma, Nov 14, 2019
    #2
    Bhushan Cellica likes this.


  3. Bhushan Cellica

    Bhushan Cellica Member


    Thanks for Reply, it works as expected.
     
    Bhushan Cellica, Nov 18, 2019
    #3


Share This Page