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

Lewis Megginson Lmegginson at holyfamily.edu
Thu Feb 7 12:40:08 EST 2008


   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 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 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 






More information about the download-list mailing list