problem loading copybook

Help
2009-09-15
2014-05-14
  • Scott Anderson
    Scott Anderson
    2009-09-15

    I can load a few of our microfocus copybooks, but there are a couple i get
    Class=class java.lang.NullPointerException Error=null

    net.sf.JRecord.External.XmlCopybookLoader : -1
    net.sf.JRecord.External.CobolCopybookLoader : -1
    net.sf.RecordEditor.layoutEd.LoadCopyBook : -1
    javax.swing.AbstractButton : -1
    javax.swing.AbstractButton$Handler : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.plaf.basic.BasicButtonListener : -1
    java.awt.Component : -1
    javax.swing.JComponent : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.Container : -1
    java.awt.Window : -1
    java.awt.Component : -1
    java.awt.EventQueue : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1

    problem loading Copybook: C:\MicroFocus\Base\copybooks\ipsout.cpy Message:
    null

     
  • Bruce Martin
    Bruce Martin
    2009-09-15

    This could be caused by Tabs in columns 1 to 8. Try changing Tabs to spaces.
    If this does not work please send me the Copybook and I will have a look at it

     
  • Scott Anderson
    Scott Anderson
    2009-09-16

    enter code here

     
  • Scott Anderson
    Scott Anderson
    2009-09-16

    how do I attach a file, or is there a different address to send it to?

     
  • Bruce Martin
    Bruce Martin
    2009-09-20

    Problem caused by cb2xml (cobol copybook anaylsis) doing a case sensitive
    search for redefined elements. If anyone else needs a fixed version, let me
    know, otherwise I will include it in the next version of the RecordEditor

     
  • mlz
    mlz
    2012-10-11

    I am trying to use Record Edit. RecordEdit_Installer_for_HSQL_0.85.exe was
    installed on my machine. I am using Windows 7. When I go into Full Editor and
    try load load a COBOL copybook, I get the following info:

    ******************** Warning
    ***************************
    Tried to Connect to the HSQL Data Base Server and failed. Will run in Database
    embedded mode.
    This package works best in Data Base Server Mode (option on menu, exit this
    program before you start the Server).

    If you wish to use the package in imbeded Mode, You may wish to reveiw the
    Database
    Options (Menu option Edit >>> Edit Startup options)
    1) Properties >>>> Defaults then click on the Default DB tab. You can now
    select the Normal DB Connection
    2) JDBC Parameters >>> JDBC Properties ~ Auto Close Connection. Setting it to
    Y will alow
    multiple versions of the RecordEditor to be run at once, but you may have
    update problems

    See "Improving the running of RecordEditor HSQL" section in HowTo
    documnetation for more details

    EditRec Load Layouts - Table not found: TBL_R_RECORDS in statement

    SQL:
    Select TblKey, Details
    From Tbl_TI_IntTbls
    Where TblId = ?
    Order By TblKey

    Table not found: TBL_TI_INTTBLS in statement

    Class=class java.sql.SQLException Error=Table not found: TBL_TI_INTTBLS in
    statement

    org.hsqldb.jdbc.jdbcUtil : -1
    org.hsqldb.jdbc.jdbcPreparedStatement : -1
    org.hsqldb.jdbc.jdbcConnection : -1
    net.sf.RecordEditor.utils.jdbc.AbsDB : 99
    net.sf.RecordEditor.re.db.Table.TableDB : 85
    net.sf.RecordEditor.utils.jdbc.AbsDB : 548
    net.sf.RecordEditor.utils.jdbc.DBList : 51
    net.sf.RecordEditor.utils.swing.AbsRowList : 85
    net.sf.RecordEditor.utils.swing.AbsRowList : 165
    net.sf.RecordEditor.utils.swing.BmKeyedComboModel : 91
    javax.swing.JComboBox : -1
    javax.swing.JComboBox : -1
    net.sf.RecordEditor.utils.swing.BmKeyedComboBox : 72
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 279
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 164
    net.sf.RecordEditor.layoutEd.LayoutMenu$4 : 88
    javax.swing.AbstractButton : -1
    javax.swing.AbstractButton$Handler : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.AbstractButton : -1
    javax.swing.plaf.basic.BasicMenuItemUI : -1
    javax.swing.plaf.basic.BasicMenuItemUI$Handler : -1
    java.awt.Component : -1
    javax.swing.JComponent : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.Container : -1
    java.awt.Window : -1
    java.awt.Component : -1
    java.awt.EventQueue : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1

    SQL:
    Select TblKey, Details
    From Tbl_TI_IntTbls
    Where TblId = ?
    Order By TblKey

    Class=class java.lang.NullPointerException Error=null

    net.sf.RecordEditor.re.db.Table.TableDB : 88
    net.sf.RecordEditor.utils.jdbc.AbsDB : 548
    net.sf.RecordEditor.utils.jdbc.DBList : 51
    net.sf.RecordEditor.utils.swing.AbsRowList : 85
    net.sf.RecordEditor.utils.swing.AbsRowList : 165
    net.sf.RecordEditor.utils.swing.BmKeyedComboModel : 91
    javax.swing.JComboBox : -1
    javax.swing.JComboBox : -1
    net.sf.RecordEditor.utils.swing.BmKeyedComboBox : 72
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 279
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 164
    net.sf.RecordEditor.layoutEd.LayoutMenu$4 : 88
    javax.swing.AbstractButton : -1
    javax.swing.AbstractButton$Handler : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.AbstractButton : -1
    javax.swing.plaf.basic.BasicMenuItemUI : -1
    javax.swing.plaf.basic.BasicMenuItemUI$Handler : -1
    java.awt.Component : -1
    javax.swing.JComponent : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.Container : -1
    java.awt.Window : -1
    java.awt.Component : -1
    java.awt.EventQueue : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1

    SQL:
    Select TblKey, Details
    From Tbl_TI_IntTbls
    Where TblId = ?
    Order By TblKey

    Class=class java.lang.NullPointerException Error=null

    net.sf.RecordEditor.re.db.Table.TableDB : 116
    net.sf.RecordEditor.re.db.Table.TableDB : 26
    net.sf.RecordEditor.utils.jdbc.AbsDB : 549
    net.sf.RecordEditor.utils.jdbc.DBList : 51
    net.sf.RecordEditor.utils.swing.AbsRowList : 85
    net.sf.RecordEditor.utils.swing.AbsRowList : 165
    net.sf.RecordEditor.utils.swing.BmKeyedComboModel : 91
    javax.swing.JComboBox : -1
    javax.swing.JComboBox : -1
    net.sf.RecordEditor.utils.swing.BmKeyedComboBox : 72
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 279
    net.sf.RecordEditor.layoutEd.LoadCopyBook : 164
    net.sf.RecordEditor.layoutEd.LayoutMenu$4 : 88
    javax.swing.AbstractButton : -1
    javax.swing.AbstractButton$Handler : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.DefaultButtonModel : -1
    javax.swing.AbstractButton : -1
    javax.swing.plaf.basic.BasicMenuItemUI : -1
    javax.swing.plaf.basic.BasicMenuItemUI$Handler : -1
    java.awt.Component : -1
    javax.swing.JComponent : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.Container : -1
    java.awt.Component : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.LightweightDispatcher : -1
    java.awt.Container : -1
    java.awt.Window : -1
    java.awt.Component : -1
    java.awt.EventQueue : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1
    java.awt.EventDispatchThread : -1

    Does anyone have any suggestions for getting this to work?

     
  • Bruce Martin
    Bruce Martin
    2012-10-11

    Note: there is a later version (0.88 available);

    The messages indicates the program has not found the DB.

    Try restarting the computer (this should start the DB Server) and see how
    you go then.


    If restarting does not work, it gets a little trickier.

    1) Stop the DB server (there is menu item for this)
    2) Do an uninstall (or delete everything in directory
    C:\User\RecordEdit_HSQL\Database)
    3) Do a clean install
    4) Start the DB Server (option on menu) or restart the computer
    5) Check the editor is working

     
  • Markus Staeck
    Markus Staeck
    2013-09-26

    Bruce,

    Thanks for this useful program.
    I was able to create XML files describing the structure of records and imported these XML copybooks into the editor. I just cannot figure out why the content of the element <COBOLNAME> is not being imported. Is this currently not supported? Or is there something wrong with my xml file? Nothing of earth shattering importance, but I would like to understand what I am doing wrong.

    Regards,
    Markus

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <RECORD RECORDNAME="5 - Registro Trailer de Lote Pagamento de Tributos" COPYBOOK="" DELIMITER="&lt;Tab&gt;" DESCRIPTION="CNAB240 V8.7 Batch Trailer Tax and Utilities Payments " FILESTRUCTURE="Default" STYLE="0" RECORDTYPE="RecordLayout" LIST="Y" QUOTE="" RecSep="default" LINE_NO_FIELD_NAMES="1">
    <FIELDS>
    <FIELD NAME="01.5 - Código do Banco na Compensação" POSITION="1" LENGTH="3" TYPE="Num (Right Justified zero padded)" DEFAULT="" COBOLNAME="G001"/>
    <FIELD NAME="02.5 - Lote de Serviço" POSITION="4" LENGTH="4" TYPE="Num (Right Justified zero padded)" DEFAULT="" COBOLNAME="G002"/>
    <FIELD NAME="03.5 - Tipo de Registro" POSITION="8" LENGTH="1" TYPE="Num (Right Justified zero padded)" DEFAULT="5" COBOLNAME="G003"/>
    <FIELD NAME="04.5 - Uso Exclusivo FEBRABAN/CNAB" POSITION="9" LENGTH="9" TYPE="Char" DEFAULT="" COBOLNAME="G004"/>
    <FIELD NAME="05.5 - Quantidade de Registros do Lote" POSITION="18" LENGTH="6" TYPE="Num (Right Justified zero padded)" DEFAULT="" COBOLNAME="G057"/>
    <FIELD NAME="06.5 - Somatória dos Valores do Pgtos" POSITION="24" LENGTH="18" TYPE="Num (Right Justified zero padded)" DEFAULT="" COBOLNAME="B002"/>
    <FIELD NAME="07.5 - Complemento de registro" POSITION="42" LENGTH="189" TYPE="Char" DEFAULT="" COBOLNAME="B003"/>
    <FIELD NAME="08.5 - Códigos das Ocorrências para Retorno" POSITION="231" LENGTH="10" TYPE="Char" DEFAULT="" COBOLNAME="G059"/>
    </FIELDS>
    </RECORD>
    
     
  • Bruce Martin
    Bruce Martin
    2013-09-26

    Currently COBOLNAME tag is currently not imported for RecordEditor-Xml. It is a information field in the RecordEditor that is filled in when a Cobol-Copybook is imported and is not used in anyway.

    I will update the RecordEditor to import it COBOLNAME from the XML, but I am currently workin on Csv request to support Embedded-NewLines (https://sourceforge.net/p/recsveditor/discussion/general/thread/041521f2/). Not sure of a completion date, probably a couple of weeks

     
  • Markus Staeck
    Markus Staeck
    2013-09-30

    Bruce,

    Thanks for the info. I can live without the COBOL name for the time being. In my case it would have saved time when looking up the definition of a field, but it is not crucial for what I would like to use record editor. No rush. I am already happy that I can import record structures via XML.

     
  • Bruce Martin
    Bruce Martin
    2013-10-02

    I have uploaded an upgrade version that will import the CobolName tag on Xml Field

    It contains upgrade jars for a RecordEditor 0.95 installation (if you are not running version 0.95, you will need to install this first).

    As always, it is advisable to backup your current RecordEditor-installation before doing the upgrade.