[Download-List] DOWNLOAD version 7.21 ********No moreentries in CI table in LCT-466

[Brich, Richard W.]

Hello Download users
Last week was getting ********No more entries in CI table in LCT-466

fixes Mr. Meggison suggested were made:

now getting this message from the query: 
154 records retrieved to list 1.

Using input file XH.ENROLLMENT

Output to file XH.SDMT.FTP.DIR XMNPSAS.TAB

 

*********In /datatel/coll18/production/apphome/CTLG/DOWNLOAD.LOAD at
line 126 out of BUF_TYPE space.     
thanks for any assistance
Dick Brich

-----Original Message-----
From: Brich, Richard W. 
Sent: Thursday, February 07, 2008 10:58 AM
To: 'Cedarville DOWNLOAD Users'
Subject: RE: [Download-List] DOWNLOAD version 7.21 ********No
moreentries in CI table in LCT-466

THANKS Mr. Megginson

-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Lewis
Megginson
Sent: Thursday, February 07, 2008 10:40 AM
To: Cedarville DOWNLOAD Users
Subject: Re: [Download-List] DOWNLOAD version 7.21 ********No
moreentries in CI table in LCT-466



   Richard,

         Sounds like you need your baseline modified. See the following
document.

  5436 - No more entries in CI Table in LCT-x error
 
Date: 1/29/2007 6:19:09 PM

Error message encountered:
No more entries in CI Table in LCT-x error
where x is a number (usually one or two digits).

This is a UniData error and can be caused by the settings in udtconfig.
Below are the relevant udtconfig settings for the CI (and MI) table
error messages: SHM_GPAGESZ SHM_LCINENTS SHM_LPAGESZ

In one particular situation this error was encountered while running the
snapshot process (TSNP) from the Reporting Utilities module.

Extracting the UniSQL select statement that was being executed when the
error occurred, it was tested at the UniSQL prompt:

:SQL 
sql> SELECT 
sql>
STTR_ACAD_LEVEL,STTR_STUDENT,STTR_TERM,STTR_CURRENT_STATUS,SHU_STTR_
SCHED_BILL_FLAG,SHU_STTR_TERM_STU_TYPE,SHU_STTR_LAST,STTR_NAME,SHU_STTR_
ARA_BAL_
01,SHU_STTR_COURSE_ACTIVE_CRED,SHU_STTR_PAR_MISC3,SHU_STTR_PAR_MISC4,SHU
_STTR_SC
S_COURSE_SECTION 
sql> ,SHU_STTR_SCS_SEC_TERM,SHU_STTR_SEC_SCHED_TYPE,STTR_USER25 FROM 
sql> SHU_ODS_STU
TERM_CC_SNAP; 

No more entries in CI table in LCT-13 


After looking over the udtconfig settings, it was recommended that they
change the value of the following settings in Section 2.1...
NOTE: The udtconfig file lives in the include directory under UDTHOME -
for example: /usr/ud71/include/udtconfig

Current:
SHM_GPAGESZ=1024
SHM_LMINENTS=48
SHM_LCINENTS=100
SHM_LPAGESZ=8

New Values:
SHM_GPAGESZ=2048
SHM_LMINENTS=255
SHM_LCINENTS=255
SHM_LPAGESZ=32

Once these changes are in place, restart UniData and these parameters
will take effect. After making these changes to the udtconfig - the
snapshot process completed successfully for this view.
 
********No more entries in CI table in LCT-466 

Lewis Megginson 
Administrative Systems Coordinator
Holy Family University
9801 Frankford Ave.
Philadelphia, PA 19114-2009
Phone 267-341-3636

Colleague Version: 18
Unidata: 7.1.8 
O/S: HPUX 11i v1 64bit     
WebAdvisor 3.0.4  
LDAP EDIR 8.7.3 



_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080213/bb281439/attachment.html>