[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DB Integrator Public Conference |
| Notice: | Database Integration - today! Kit/Doc info see note 36 |
| Moderator: | BROKE::ABUGOV |
|
| Created: | Mon Sep 21 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1171 |
| Total number of notes: | 5187 |
Gidday,
This is similar to note 1046.* though we have tried everything
mentioned and more, so it is probably smarter to post this as a
separate note.....
Any assistance greatly apreciated. If you need me to raise this as
an IPMT case then I can.
Cheers,
Dave Reinhold
CSC, Sydney, Australia
-----------------------------------------------------------------
VMS 5.5-2H4/6.2
RDB 6.1 ECO2
DBI 3.1-02A
ACMS 4.1-0
NO CDD
The problem is basically,
sn_who_log:WHO_GPR_INCOME_ANAL_RPT_COM.LOG
%WHO-F-ERRPRC, Error in procedure WHO_GPR_INCOME_ANAL_RPT_PROG
-WHO-F-ERRPRC, Error in procedure who_gpr_income_anal_ord_itm_ss
-WHO-F-ERRTXT, Database Error detected in Singleton Select.
-RDB-F-SYS_REQUEST, error from system services request
-DBI-E-SORTEXECFAIL, Sort execution failed
-SORT-F-LRL_MISS, longest record length must be specified
---------------------------------------------------
The DBI trace file is on ORAREP::DBI_TRACE.OUT;1 (not very origional)
and is about 6084 blocks,
Accounting record for job:-
---------------------------
BATCH Process Termination
-------------------------
Username: WHOSRV01 UIC: [WHOEXC]
Account: WHOACC Finish time: 12-AUG-1996 17:21:48.52
Process ID: 20413C53 Start time: 12-AUG-1996 13:44:16.38
Owner ID: Elapsed time: 0 03:37:32.14
Terminal name: Processor time: 0 00:13:32.00
Remote node addr: Priority: 3
Remote node name: Privilege <31-00>: 0018C001
Remote ID: Privilege <63-32>: 00000000
Remote full name:
Queue entry: 366 Final status code: 00000004
Queue name: WHO_BATCH
Job name: SCHEDULER_WHO_MTL_WHO_GPR_EOP_INCOME_AN
Final status text: <no text>
Page faults: 123730 Direct IO: 135772
Page fault reads: 2906 Buffered IO: 1322
Peak working set: 35000 Volumes mounted: 0
Peak page file: 106588 Images executed: 48
Other resource information (collected with 10 seconds of error
occuring):-
--------------------------------------------------------------------------
DIOLM 1500 remaining
BIOLM 1500 remaining
BYTLM 19991360 remaining
PAGFILLM 278532 remaining
ASTLM 1549 remaining
TQELM 1049 remaining
Free pages left: 1535553
Authorisation record for WHOSRV01:-
-----------------------------------
Username: WHOSRV01 Owner: Whole Sale
Account: WHOACC UIC: [4100,1] ([WHOEXC])
CLI: DCL Tables:
Default: SN_WHO_DISK:[WHO.TMP]
LGICMD: SN_WHO_EXE:LOGIN.COM
Flags:
Primary days: Mon Tue Wed Thu Fri Sat Sun
Secondary days:
No access restrictions
Expiration: (none) Pwdminimum: 5 Login Fails: 0
Pwdlifetime: 30 00:00 Pwdchange: 17-MAR-1995 12:36
Last Login: 17-MAR-1995 13:07 (interactive), 13-AUG-1996 07:00 (non-interactive)
Maxjobs: 0 Fillm: 1500 Bytlm: 20000000
Maxacctjobs: 0 Shrfillm: 0 Pbytlm: 0
Maxdetach: 0 BIOlm: 1500 JTquota: 1024
Prclm: 60 DIOlm: 1500 WSdef: 2048
Prio: 4 ASTlm: 1550 WSquo: 25000
Queprio: 0 TQElm: 1050 WSextent: 30000
CPU: (none) Enqlm: 32767 Pgflquo: 300000
Authorized Privileges:
CMKRNL EXQUOTA NETMBX SETPRV TMPMBX
Default Privileges:
CMKRNL EXQUOTA NETMBX SETPRV TMPMBX
Identifier Value Attributes
CNWUSR %X8001010F
WHOSUP %X80010143
WHOUSR %X80010141
GRPWHOEXC %X80010180
ACMSOPER %X80010230
GRPFRS %X800100ED
FRSUSR %X80010121
System PQL parameters:-
-----------------------
Parameters in use: Active
Parameter Name Current Default Min. Max. Unit Dynamic
-------------- ------- ------- ------- ------- ----
PQL_DASTLM 200 24 4 32767 Ast D
PQL_MASTLM 200 4 4 32767 Ast D
PQL_DBIOLM 200 18 4 32767 I/O D
PQL_MBIOLM 100 4 4 32767 I/O D
PQL_DBYTLM 8192 8192 1024 -1 Bytes D
PQL_MBYTLM 40000 1024 1024 -1 Bytes D
PQL_DCPULM 0 0 0 -1 10Ms D
PQL_MCPULM 0 0 0 -1 10Ms
PQL_DDIOLM 200 18 4 32767 I/O D
PQL_MDIOLM 100 4 4 32767 I/O D
PQL_DFILLM 16 16 2 32767 Files D
PQL_MFILLM 100 2 2 32767 Files D
PQL_DPGFLQUOTA 32768 8192 512 -1 Pages D
PQL_MPGFLQUOTA 32768 512 512 -1 Pages D
PQL_DPRCLM 8 8 0 32767 Processes D
PQL_MPRCLM 10 0 0 32767 Processes D
PQL_DTQELM 8 8 0 32767 Timers D
PQL_MTQELM 0 0 0 32767 Timers D
PQL_DWSDEFAULT 837 100 60 -1 Pages
PQL_MWSDEFAULT 837 60 60 -1 Pages
PQL_DWSQUOTA 1674 200 60 -1 Pages D
PQL_MWSQUOTA 1674 60 60 -1 Pages D
PQL_DWSEXTENT 8192 400 60 -1 Pages D
PQL_MWSEXTENT 8192 60 60 -1 Pages D
PQL_DENQLM 400 30 4 32767 Locks D
PQL_MENQLM 400 4 4 32767 Locks D
PQL_DJTQUOTA 1024 1024 0 -1 Bytes D
PQL_MJTQUOTA 0 0 0 -1 Bytes D
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1091.1 | update on files | ORAREP::GIDDAY::REINHOLD | Skippy | Wed Aug 21 1996 03:13 | 12 |
| I also copied the additional files to ORAREP::
WHO_GPR_EOP_INCOME_ANAL_RPT_COM.LOG;9
which is 88 blocks,
I'll try copying the
WHO_GPR_IAR_DBI_DUMP.TXT;2
though it is 26847 blocks big, and may take a while.
|
| 1091.2 | sort error - we've never seen that one! | BROKE::ABUGOV | | Wed Aug 21 1996 16:18 | 16 |
|
Hi Dave,
Has anything changed for this customer that caused this problem to show
up? All of our sort calls set up the longest record length field as far
as I can tell. It is this field that sort is complaining about.
We have a new trace flag with this release called "SORT" that
allows us to trace calls to sort - in this case we would print out the
value for the longest record length.
Is it possible that the customer would install the latest ft?
Thanks,
Dan
|
| 1091.3 | yep! we can try that. | ORAREP::GIDDAY::REINHOLD | Skippy | Wed Aug 21 1996 22:26 | 22 |
| Thanks Dan,
This site is still in development and planning to go live in 4-6
weeks. This is the same site as the DBI Bug check and the "DBI-I-INV
DESC TYPE" problems.
To get hold of the Field test kit would be great! (because of the
other problems they are doing their development on VAX (compiling
against RDB V4.1 and linking against 6.1), but are planning on running
on ALPHA - so it would be nice to test against both), that way (if it
resolves all of the problems) we could get them to hold off going live
until the next release is in SSB.
Is it possible that you could pass on the pointer to a kit? either
for myself or my Oracle counterparts?
We would then be able to do the new trace on "SORT"
Cheers,
Dave
|
| 1091.4 | They'll need a field test agreement... | BROKE::ABUGOV | | Thu Aug 22 1996 08:15 | 10 |
|
Hi Dave,
Please send mail to [email protected] to get a field test agreement
for your customer. You should include customer name, address, phone
number, email address and contact name.
Thanks,
Dan
|