×
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
-
Less
More
- Posts: 18
- Thank you received: 3
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:On the test server execution fails:
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
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
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
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1209
- Thank you received: 158
5 years 2 months ago - 5 years 2 months ago #22728
by VK
Cheers
VK
Replied by VK on topic EXCEPTION enq failure
Hi
post here output of:
from test env.
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
-
Less
More
- Posts: 18
- Thank you received: 3
5 years 2 months ago #22730
by SandroK
Replied by SandroK on topic EXCEPTION enq failure
Hi VK,
Attached is the jdiag output.
Thanks and stay safe!
SandroK
Attached is the jdiag output.
Thanks and stay safe!
SandroK
Please Log in or Create an account to join the conversation.
- SandroK
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 18
- Thank you received: 3
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
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
-
Less
More
- Posts: 18
- Thank you received: 3
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
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