× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

EXCEPTION enq failure

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #22726 by SandroK
EXCEPTION enq failure was created by SandroK
Dear forum members,
On the test server for some reason, EXCEPTION inquiry (that lists all unauthorized records in the system) does not work. On the live server all looks ok:
LIVE BANK - R14
List of Unauthorised Files

 ------------------------------------------------------------------------------
    FBNK.ACCOUNT                                 1   1    0    0    0    0    0
    FBNK.FUNDS.TRANSFER                         30  27    0    0    3    0    0
    FBNK.LD.LOANS.AND.DEPOSITS                  19  17    0    0    2    0    0
On the test server execution fails:
TESTING BNK - R14        ENQUIRY, INPUT                           REF EXCEPTION
                                                [EQ NE LK UL GT LT GE LE RG NR]
 (2)SELECTION       (3)OPERAND (4)LIST
 ------------------------------------------------------------------------------
 <d>  FILE.NAME

 (6) Pre-set Selection.....
 (9.1) Sort Field..........
 (10.1) Fixed Selection.... USERNO EQ !TNO
 (11.1) Fixed Sort Fields.. SORT.FLD
 12 Print all pages (Y/N)..


 -- LAST SIGN.ON, DATE: 30 APR 2020     TIME: 10:05        ATTEMPTS: 0 --------
 30 APR 2020 10:09:35  USER (29 APR) K.GRELL           [46509,2      VALIDATED jBASE: /R14/database/live/bnk/bnk.run/t24lib/eb_overrideprocessing/lib.EB_OverrideProcessing.1.so: /R14/database/live/bnk/bnk.run/t24lib/eb_overrideprocessing/lib.EB_OverrideProcessing.1.so: cannot open shared object file: Too many open files
 ** Error [ SUBROUTINE_CALL_FAIL ] **
Unable to perform CALL to subroutine DISPLAY.MESSAGE , Line  6861 , Source JOURNAL.UPDATE.JBASE.b
Press C to continue or Q to quit
Trap from an error message, error message name = SUBROUTINE_CALL_FAIL
Line 6861 , Source JOURNAL.UPDATE.JBASE.b
jBASE debugger->Q
** FATAL ERROR IN (OPF) **
MISSING FILE - F.RECORD.LOCK , MNEMONIC =  , IN.PARAMETER = F.RECORD.LOCK , COMPANY = GE0010001 , CALL.ROUTINE = OPF.b,EB.RECORD.LOCK.b,EB.RECORD.LOCK.b

Line 20474 , Source S.REAL.TIME.RESET.b
jBASE debugger->Q
Are you sure ?Y
jBASE debugger , QUIT
jsh live ~ -->

Some details on the system R14, TAFC, Jbase, CentOS 6.
All of the rest operations runs ok, normal transactions, COB, reports, etc.

Thanks in advance!
Sandro

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
5 years 2 months ago - 5 years 2 months ago #22728 by VK
Replied by VK on topic EXCEPTION enq failure
Hi
post here output of:
jdiag -v

from test env.

Cheers
VK
Last edit: 5 years 2 months ago by VK.

Please Log in or Create an account to join the conversation.

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #22730 by SandroK
Replied by SandroK on topic EXCEPTION enq failure
Hi VK,

Attached is the jdiag output.

File Attachment:

File Name: jdiagoutput.txt
File Size:8 KB


Thanks and stay safe!
SandroK
Attachments:

Please Log in or Create an account to join the conversation.

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #22738 by SandroK
Replied by SandroK on topic EXCEPTION enq failure
Dears VK,

I think we've found the issue. In jdiag output max files option for test is 1024 only, while on live its 500000 (guess this is also not a good option). Will let the group know the outcome.

Thanks
Sandro

Please Log in or Create an account to join the conversation.

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #22739 by SandroK
Replied by SandroK on topic EXCEPTION enq failure
Dears, that was the issue with max open files parameter (ulimit -a).
Increasing the limit (ulimit -n xxx) is not obvious, so you may refer to this link syamkumar-linux.blogspot.com/2014/03/uli...-limitsconf-not.html

Cheers
Sandro
The following user(s) said Thank You: VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.031 seconds