Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error #11 Record not found or Duplicate key on write

Status
Not open for further replies.

rccjc

MIS
Dec 26, 2006
2
US
We been having problem using "Period End Processing" module under G/L, anyone know how to fix this problem ?

detail error information attached on below, pleas help !!


**********************************************************
Error Information 12/26/06 12:57:36


Error #11: Record not found or Duplicate key on write
Program GL_ACCOUNT_BUS.pvc
Line 585


General Information:
File X:\MAS90\MAS_IGF\GLIGF\GL_SubAccount.M4T
Last Key Value 03
Last Key Text 03

Last Channel Opened 32685
Last Channel Accessed 32689

Object Number 100033
Object Method SetDefaults
Object Text GL_Account_bus

Available Memory 29390127


Object Identifer Name
---------------------------------------------
[100001] SY_Session
[100002] SY_File
[100003] *obj/winapi
[100004] SY_UI
[100005] SY_LocaleInfo
[100006] SY_Security
[100007] SY_Security
[100008] SY_Registration
[100009] SY_Security
[100010] GL_PERIODENDPROCESSING_UI
[100011] SY_Collection
[100012] SY_PERIODENDREPORT_BUS
[100013] SY_Collection
[100014] *dict/idxinfo
[100015] *Dict/Colinfo
[100016] SY_KeyDefinition
[100017] SY_KeyDefinition
[100018] SY_KeyDefinition
[100019] SY_Collection
[100020] SY_ChildColl
[100021] SY_ChildColl
[100022] SY_ChildColl
[100023] SY_BusinessColl
[100024] SY_Task_SVC
[100025] SY_Collection
[100026] SY_KeyDefinition
[100027] SY_KeyDefinition
[100028] SY_KeyDefinition
[100029] SY_KeyDefinition
[100030] GL_FiscalYear_Svc
[100031] SY_Collection
[100032] SY_KeyDefinition
[100033] GL_Account_bus
[100034] SY_Collection
[100035] SY_KeyDefinition
[100036] SY_Collection
[100037] SY_ChildColl
[100038] SY_ChildColl
[100039] SY_ChildColl
[100040] SY_ChildColl
[100041] SY_ChildColl
[100042] SY_ChildColl
[100043] SY_ChildColl
[100044] SY_ChildColl
[100045] GL_FiscalYear_bus
[100046] SY_Collection
[100047] SY_KeyDefinition
[100048] GL_FiscalYearDetail_BUS
[100049] SY_Collection
[100050] SY_KeyDefinition
[100051] SY_KeyDefinition
[100052] GL_MainAccount_bus
[100053] SY_Collection
[100054] SY_KeyDefinition
[100055] SY_KeyDefinition
[100056] SY_Collection
[100057] SY_ChildColl
[100058] SY_ChildColl
[100059] SY_ChildColl
[100060] SY_ChildColl
[100061] SY_ChildColl
[100062] SY_ChildColl
[100063] SY_ChildColl
[100064] GL_SOURCEJOURNAL_BUS
[100065] SY_Collection
[100066] SY_KeyDefinition
[100067] SY_Collection
[100068] SY_ChildColl
[100069] SY_ChildColl
[100070] SY_ChildColl
[100071] SY_ChildColl
[100072] GL_SubAccount_bus
[100073] SY_Collection
[100074] SY_KeyDefinition
[100075] SY_KeyDefinition
[100076] SY_Collection
[100077] SY_ChildColl
[100078] SY_PeriodEndListing_rpt
[100079] SY_ReportEngine
[100080] SY_Collection
[100081] SY_KeyDefinition
[100082] SY_KeyDefinition
[100083] SY_KeyDefinition
[100084] SY_KeyDefinition
[100085] SY_KeyDefinition
[100086] Sy_PopupXref_Svc
[100087] SY_Collection
[100088] SY_KeyDefinition
[100089] SY_Module_svc
[100090] SY_Collection
[100091] SY_KeyDefinition
[100092] GL_SourceJournalHistory_Svc
[100093] SY_Collection
[100094] SY_KeyDefinition
[100095] SY_KeyDefinition
[100096] SY_KeyDefinition
[100097] SY_KeyDefinition
[100098] GL_FiscalYear_Svc
[100099] SY_Collection
[100100] SY_KeyDefinition
[100101] GL_Account_svc
[100102] SY_Collection
[100103] SY_KeyDefinition
[100104] GL_MainAccount_svc
[100105] SY_Collection
[100106] SY_KeyDefinition
[100107] SY_KeyDefinition
[100108] SY_ErrorInfo_UI
[100109] SY_Collection
[100110] SY_ErrorInfo_BUS
[100111] SY_Collection
[100112] SY_KeyDefinition
[100113] SY_KeyDefinition
[100114] SY_KeyDefinition
[100115] SY_BusinessColl


Open Files:
Channel File Name
---------------------------------------------
32684 *memory*
32685 X:\MAS90\MAS_SYSTEM\SY_ActivityLog.M4T
32686 *memory*
32687 X:\MAS90\MAS_IGF\GLIGF\GL_MainAccount.M4T
32688 X:\MAS90\MAS_IGF\GLIGF\GL_AccountSegment.M4T
32689 X:\MAS90\MAS_IGF\GLIGF\GL_SubAccount.M4T
32690 X:\MAS90\MAS_IGF\GLIGF\GL_MainAccount.M4T
32691 *memory*
32692 X:\MAS90\MAS_IGF\GLIGF\GL_Account.M4T
32693 X:\MAS90\providex.dcl
32694 *memory*
32695 *memory*
32696 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYearDetail.M4T
32697 *memory*
32698 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYear.M4T
32699 *memory*
32700 X:\MAS90\MAS_IGF\GLIGF\GL_SourceJournalHistory.M4T
32701 X:\MAS90\providex.dcl
32702 *memory*
32703 *memory*
32704 *memory*
32705 X:\MAS90\MAS_SYSTEM\SY_Module.M4T
32706 *memory*
32707 X:\MAS90\MAS_SYSTEM\SY_PopupXref.M4T
32708 *memory*
32709 X:\MAS90\MAS_SYSTEM\SY_GridDefinition.M4T
32710 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYearDetail.M4T
32711 X:\MAS90\providex.dcl
32712 *memory*
32713 *memory*
32714 *memory*
32715 *memory*
32716 *memory*
32717 *memory*
32718 X:\MAS90\MAS_IGF\GLIGF\GL_SubAccount.M4T
32719 X:\MAS90\MAS_IGF\GLIGF\GL_SourceJournalHistory.M4T
32720 *memory*
32721 *memory*
32722 X:\MAS90\MAS_IGF\GLIGF\GL_SOURCEJOURNAL.M4T
32723 X:\MAS90\MAS_IGF\GLIGF\GL_Account.M4T
32724 *memory*
32725 *memory*
32726 X:\MAS90\MAS_IGF\GLIGF\GL_MainAccount.M4T
32727 *memory*
32728 *memory*
32729 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYearDetail.M4T
32730 *memory*
32731 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYearDetail.M4T
32732 *memory*
32733 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYear.M4T
32734 *memory*
32735 *memory*
32736 X:\MAS90\MAS_IGF\GLIGF\GL_Account.M4T
32737 *memory*
32738 X:\MAS90\MAS_IGF\GLIGF\GL_FiscalYear.M4T
32739 X:\MAS90\MAS_IGF\GLIGF\GL_SUBACCOUNT.M4T
32740 X:\MAS90\MAS_IGF\GLIGF\GL_MAINACCOUNT.M4T
32741 X:\MAS90\MAS_IGF\GLIGF\GL_ACCOUNT.M4T
32742 X:\MAS90\MAS_IGF\GLIGF\GL_SUMMARYDETAILDRILLDOWN.M4T
32743 X:\MAS90\MAS_IGF\GLIGF\GL_PERIODBUDGETDETAIL.M4T
32744 X:\MAS90\MAS_IGF\GLIGF\GL_PERIODPOSTINGHISTORY.M4T
32745 X:\MAS90\MAS_IGF\GLIGF\GL_SOURCEJOURNALHISTORY.M4T
32746 X:\MAS90\MAS_IGF\GLIGF\GL_TRANSACTIONJOURNALHISTORY.M4T
32747 X:\MAS90\MAS_IGF\GLIGF\GL_RECURRINGJOURNALHISTORY.M4T
32748 X:\MAS90\MAS_IGF\GLIGF\GL_GENERALJOURNALHISTORY.M4T
32749 X:\MAS90\MAS_IGF\GLIGF\GL_DAILYPOSTING.M4T
32750 X:\MAS90\MAS_IGF\GLIGF\GL_DETAILPOSTING.M4T
32751 *memory*
32752 X:\MAS90\MAS_SYSTEM\SY_Task.M4T
32753 *memory*
32754 *memory*
32755 X:\MAS90\LOCK\IGF\GL_Account.LCK
32756 *memory*
32757 *memory*
32758 X:\MAS90\MAS_SYSTEM\SY_PERIODENDREPORT.M4T
32759 X:\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T
32760 X:\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T
32761 X:\MAS90\MAS_SYSTEM\SY_Task.M4T
32762 X:\MAS90\MAS_SYSTEM\SY_User.M4T
32763 X:\MAS90\MAS_SYSTEM\SY_Task.M4T
32764 X:\MAS90\MAS_SYSTEM\SY_User.M4T
32765 X:\MAS90\SOA\SY0CTL.SOA
32766 X:\MAS90\\providex.dde
32767 X:\MAS90\\providex.ddf


Stack line program
----------------------------------------------------------------------------------------------------
00020 00001 X:\MAS90\soa\sy_errorinfo_ui.pvc
00019 00291 X:\MAS90\soa\sy_errorinfo_ui.pvc
00018 00040 X:\MAS90\Home\lib\_winproc.xeq
00017 07120 X:\MAS90\Home\lib\_winproc
00016 00240 X:\MAS90\Home\lib\_nomads.pvc
00015 00385 X:\MAS90\soa\SY_ERROR
00014 00585 X:\MAS90\GL\GL_ACCOUNT_BUS.pvc
00013 00478 X:\MAS90\soa\SY_MAINT.pvc
00012 00656 X:\MAS90\GL\GL_PERIODENDPROCESSING_UI.pvc
00011 00877 X:\MAS90\GL\GL_PERIODENDPROCESSING_UI.pvc
00010 00844 X:\MAS90\GL\GL_PERIODENDPROCESSING_UI.pvc
00009 00274 X:\MAS90\GL\GL_PERIODENDPROCESSING_UI.pvc
00008 00040 X:\MAS90\Home\lib\_winproc.xeq
00007 07120 X:\MAS90\Home\lib\_winproc
00006 00240 X:\MAS90\Home\lib\_nomads.pvc
00005 00330 X:\MAS90\GL\GL_PERIODENDPROCESSING_UI.pvc
00004 00040 X:\MAS90\Home\lib\_winproc.xeq
00003 07120 X:\MAS90\Home\lib\_winproc
00002 00240 X:\MAS90\Home\lib\_nomads.pvc
00001 00149 X:\MAS90\soa\SY_StartUp.M4P
 
Fixed with GL4001-T(Sage MAS 90 and 200 4.00) You or your reseller will need to go to the Sage support web page and download the fix and install. If you have not done this before besure to read the documentation on how to install.

 
Thank you very much for your quick response with great tip, Problem resolved !!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top