Results 1 to 7 of 7

Thread: Import from Excel do not work in Server but works locally

  1. #1
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    723

    Import from Excel do not work in Server but works locally

    I have one custom application with editable grid.
    When I import from Excel, after pressing the "continue" button, the web page shows the progress bar and hangs forever. Attached the screenshot. But it has no issue when I run locally. I confirmed that all the related objects are deployed to server. When I checked the JAS log, I see the below text.

    How can I find the root cause for this issue as I cannot re-produce it in local web client.

    Code:
    14 Jan 2020 17:23:45,474 [WARN  ] MRAUF - [RUNTIME]         *ERROR* CallObject@20258589: COSE#1000 Request timeout: timeout after 270000ms host OUR_SERVER:6014(1138) SocID:1172 PID:5920 BSFN:IsColumnInTeamFileF59TC090 user:MRAUF Env:JPD812 
    14 Jan 2020 17:23:45,474 [WARN  ] MRAUF - [RUNTIME]         *ERROR* CallObject@20258589: The business function being executed is causing a problem user:MRAUF Env:JPD812 
    14 Jan 2020 17:23:45,474 [SEVERE] MRAUF - [RUNTIME]         OWFormatValidator.callDDFormatProc receives JASServiceException: BFName= com.jdedwards.system.lib.dataformat.EditRuleException
    com.jdedwards.system.lib.dataformat.EditRuleException
    	at com.jdedwards.jas.net.NetManager.callRule(Unknown Source)
    	at com.jdedwards.jas.net.NetManager.callEditRule(Unknown Source)
    	at com.jdedwards.system.lib.dataformat.OWFormatValidator.callDDEditProc(Unknown Source)
    	at com.jdedwards.system.lib.dataformat.OWFormatValidator.applyEditRules(Unknown Source)
    	at com.jdedwards.system.lib.dataformat.OWFormatValidator.formatAndValidateInternalValue(Unknown Source)
    	at com.jdedwards.system.lib.dataformat.OWFormatValidator.formatAndValidateInternalValue(Unknown Source)
    	at com.jdedwards.runtime.engine.GridEngine.leaveColumn(Unknown Source)
    	at com.jdedwards.runtime.engine.GridEngine.rowExited(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTGridFocusManager.setCurrentCell(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTGridFocusManager.setFocus(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTGrid.onCellClick(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTGrid.onCellClick(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTImportGrid.processImportData(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTImportGrid.processOkEvent(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTImportGrid.processVirtualEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.showWindow(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTGrid.processVirtualEvent(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.grid.VTFormGrid.processVirtualEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.showWindow(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.startForm(Unknown Source)
    	at com.jdedwards.runtime.er.FormInterconnectStatement.execute(Unknown Source)
    	at com.jdedwards.runtime.er.StatementBlock.execute(Unknown Source)
    	at com.jdedwards.runtime.er.ERModule.executeEventRules(Unknown Source)
    	at com.jdedwards.runtime.engine.form.FormEngine.doEvent(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.form.VTForm.doEvent(Unknown Source)
    	at com.jdedwards.runtime.engine.ButtonEngine.onClick(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.sysPressButton(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.onClick(Unknown Source)
    	at com.jdedwards.runtime.vtcomponent.VTHyperMenuExit.processVirtualEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processVTEvent(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.processEventLoop(Unknown Source)
    	at com.jdedwards.runtime.virtual.OWVirtual.run(Unknown Source)
    	at com.jdedwards.base.util.ThreadPool$WorkerThread.run(Unknown Source)
    14 Jan 2020 17:23:45,536 [SEVERE] MRAUF - [KERNEL]          *ERROR* Associated kernel 5920 not found  host OUR_SERVER:6014(1138) SocID:1172, freeLocal 
    14 Jan 2020 17:23:45,536 [WARN  ] MRAUF - [RUNTIME]         *ERROR* CallObject@6155441f: COSE#1017 Associated kernel not found. Please see Enterprise Server log for details:  host OUR_SERVER:6014(1138) SocID:1172 PID:5920 BSFN:IsColumnInAddressBook user:MRAUF Env:JPD812
    Attached Images Attached Images
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  2. #2
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,038
    Check you enterprise server COK logs. Looks like your edit function, IsColumnInTeamFileF59TC090, is having an issue.

    Craig
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  3. #3
    How many rows are you trying to import ? How many columns per row ? Have you customised grid format to make sure only those columns are there which you absolutely need ? Have you tried with lesser # of rows . There are some jas setting on enterprise server for grid imports , limits , timeouts etc . You need to check this with your system admin too .

  4. #4
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    723
    Yes Craig. I was thinking in the same way. Please also note the last line showing error in IsColumnInAddressBook. But how come a standard function in error while it works on all other screens.

    Meanwhile, what is the term 'COK' stands for. And where I can find those log files in the server.
    Last edited by Rauf; 01-14-2020 at 11:22 PM.
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  5. #5
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    723
    jdedwardsuser

    1 row and 1 column only ( already shown in the attachment )
    Last edited by Rauf; 01-14-2020 at 11:23 PM.
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

  6. #6
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,038
    COK is "call object kernel". It's the process on the enterprise server that runs the business functions attached to a user session. The latter functions in your session could fail because something before it caused a problem. You can find the logs using server manager, but now looking at your release, you may have to dig into the server file system log directory.
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

  7. #7
    Member Rauf's Avatar
    Join Date
    Jan 2012
    Location
    Kerala, India
    Posts
    723
    I did not much investigate on the logs as my version is too old.
    Instead I have solved the issue by disabling the 'Edit' function on the data item and moved the 'Edit' function to 'Col Exited' event.
    Now it works fine.
    RAUF
    JDE Techno-Functional
    JDE E1 8.12 | TR 8.96.40 | Windows XP SP 3

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.