打开调整会计期出错！（有图）

robin_cao

今天，打开调整会计期时候出现错误！
如图所示：

robin_cao

错误日志：
+---------------------------------------------------------------------------+
Oracle General Ledger: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

GLOOAP module: Open Period
+---------------------------------------------------------------------------+

Current system time is 31-DEC-2006 16:14:32

+---------------------------------------------------------------------------+


>> main() 31-DEC-2006 16:14:32
Set_of_books_id = 1
Chart_of_accounts_id = 50181
Application_id = 101
execution_mode = P
User_name = CXH
Request_id = 6517851
Login_id = 7502318

>> glopcs() 31-DEC-2006 16:14:32

<< glopcs() 31-DEC-2006 16:14:32

>> glucmt() 31-DEC-2006 16:14:32

<< glucmt() 31-DEC-2006 16:14:32

>> gloroc() 31-DEC-2006 16:14:32
SHRD0180: gloroc() - Performing action >> starting_gloroc...
SHRD0026: Current system time is: 31-DEC-2006 16:14:32

SHRD0181: gloroc() - Open Year = 0
SHRD0083: Dropping table gl_posting_interim(synonym)

>> afupbind() 31-DEC-2006 16:14:32

<< afupbind() 31-DEC-2006 16:14:32

>> afupexec() 31-DEC-2006 16:14:32

<< afupexec() 31-DEC-2006 16:14:32

>> afuerror() 31-DEC-2006 16:14:32

<< afuerror() 31-DEC-2006 16:14:32

>> afurelease() 31-DEC-2006 16:14:32

<< afurelease() 31-DEC-2006 16:14:32

>> afuopen() 31-DEC-2006 16:14:32

<< afuopen() 31-DEC-2006 16:14:32

>> afubind() 31-DEC-2006 16:14:32

<< afubind() 31-DEC-2006 16:14:32

>> afupbind() 31-DEC-2006 16:14:32

<< afupbind() 31-DEC-2006 16:14:32

>> afupexec() 31-DEC-2006 16:14:32

<< afupexec() 31-DEC-2006 16:14:32

>> afupbind() 31-DEC-2006 16:14:32

<< afupbind() 31-DEC-2006 16:14:32

>> afupexec() 31-DEC-2006 16:14:32

<< afupexec() 31-DEC-2006 16:14:32

>> afuerror() 31-DEC-2006 16:14:32

<< afuerror() 31-DEC-2006 16:14:32

>> afurelease() 31-DEC-2006 16:14:32

<< afurelease() 31-DEC-2006 16:14:32

>> afuopen() 31-DEC-2006 16:14:32

<< afuopen() 31-DEC-2006 16:14:32

>> afubind() 31-DEC-2006 16:14:32

<< afubind() 31-DEC-2006 16:14:32

>> afupbind() 31-DEC-2006 16:14:32

<< afupbind() 31-DEC-2006 16:14:32

>> afupexec() 31-DEC-2006 16:14:32

<< afupexec() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

>> afuerror() 31-DEC-2006 16:14:38

<< afuerror() 31-DEC-2006 16:14:38

>> afurelease() 31-DEC-2006 16:14:38

<< afurelease() 31-DEC-2006 16:14:38

>> afuopen() 31-DEC-2006 16:14:38

<< afuopen() 31-DEC-2006 16:14:38

>> afubind() 31-DEC-2006 16:14:38

<< afubind() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

>> afuerror() 31-DEC-2006 16:14:38

<< afuerror() 31-DEC-2006 16:14:38

>> afurelease() 31-DEC-2006 16:14:38

<< afurelease() 31-DEC-2006 16:14:38

>> afuopen() 31-DEC-2006 16:14:38

<< afuopen() 31-DEC-2006 16:14:38

>> afubind() 31-DEC-2006 16:14:38

<< afubind() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

>> afuerror() 31-DEC-2006 16:14:38

<< afuerror() 31-DEC-2006 16:14:38

>> afurelease() 31-DEC-2006 16:14:38

<< afurelease() 31-DEC-2006 16:14:38

>> afuopen() 31-DEC-2006 16:14:38

<< afuopen() 31-DEC-2006 16:14:38

>> afubind() 31-DEC-2006 16:14:38

<< afubind() 31-DEC-2006 16:14:38

>> afupbind() 31-DEC-2006 16:14:38

<< afupbind() 31-DEC-2006 16:14:38

>> afupexec() 31-DEC-2006 16:14:38

<< afupexec() 31-DEC-2006 16:14:38

<< glompi() 31-DEC-2006 16:14:38

>> glucmt() 31-DEC-2006 16:14:38

<< glucmt() 31-DEC-2006 16:14:38
SHRD0180: gloroc() - Performing action >> GL_POST_INTERIM has been successfully created...
SHRD0026: Current system time is: 31-DEC-2006 16:14:38


>> gloinp() 31-DEC-2006 16:14:38
SHRD0079: 21226 record(s) inserted into gl_posting_interim

<< gloinp() 31-DEC-2006 16:14:43

<< gloroc() 31-DEC-2006 16:14:43

>> glucmt() 31-DEC-2006 16:14:43

<< glucmt() 31-DEC-2006 16:14:45

>> glucmt() 31-DEC-2006 16:14:45

<< glucmt() 31-DEC-2006 16:14:45

>> glopib() 31-DEC-2006 16:14:45

<x glopib: errexit() 31-DEC-2006 16:14:46
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -1632 sqlerrml: 66
sqlerrmc:
ORA-01632: max # extents (200) reached in index GL.GL_BALANCES_N3

sqlerrp: sqlerrd: 0 0 0 12 0 538976288
sqlwarn: sqltext:
*****************************************************

oracaid: oracabc: 0
oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 0 orastxtl: 0
orastxtc:

orasfnmc: oraslnr: 0 orasfnml: 0
orahoc: 50 ormoc: 6 oracoc: 5
oranor: 0 oranpr: 12 oranex: 12

SHRD0015: glopib failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
*****************************************************
SHRD0044: Process logging off database and exiting ...

<x gluccf() 31-DEC-2006 16:14:46
+---------------------------------------------------------------------------+
Start of log messages from Plsql program
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from PlSql program
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+


Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.



+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 31-DEC-2006 16:14:46

+---------------------------------------------------------------------------+
argc = 6
glopcs() - ab_enabled is = 0
glopcs() - ab_period_set_name is = RM_会计日历
glopcs() - sqlcode after PCS1 cursor open = 0
glopcs() - prior to being set to null, control ptr = 0
glopcs() - afterwards control ptr = 0
glopcs() - second argument (sob_id) = 1
glopcs() - third argument (parent ptr) = ffbeb4d0
glopcs() - fetch iteration number = 1
glopcs() - sqlcode after array fetch = 1403
glopcs() - sqlerrd[2] after array fetch = 1
glopcs() - number fetched = 1
glopcs() - mallocing control space...
glopcs() - control ptr post alloc is = 225070
glopcs() - sob_id = 1 : cfy_flag = 0
: cqt_flag = 0 : t_year = 2006
glopcs() - t_num = 13 : t_type = 1
glopcs() - t_name = 13-2006 : func_curr = CNY
glopcs() - lo_name = 12-2006 : lo_year = 2006
glopcs() - t_adjust_period_flag = Y
glopcs() - lo_adjust_period_flag = N
glopcs() - t_days_in_period = 1
glopcs() - lo_days_in_period = 31
glopcs() - lo_adjust_period_flag = N
glopcs() - t_period_start_date = 2006/12/31
glopcs() - t_period_end_date = 2006/12/31
glopcs() - t_quarter_start_date = 2006/10/01
glopcs() - t_year_start_date = 2006/01/01
glopcs() - lo_num = 12
glopcs() - num_per_f_year = 13
glopcs() - fut_ent_pers = 1
glopcs() - ab_retained_earnings_ccid = 1115
glopcs() - total fetched records = 1
glopcs() - prior to realloc, control ptr = 225070
glopcs() - prior to realloc, sizeof cntl = 320
glopcs() - post realloc, control ptr = 225070
glopcs() - sob_id = -1 : cfy_flag = -1
: cqt_flag = -1 : t_year = -1
glopcs() - t_num = -1 : t_type =
glopcs() - t_name = : func_curr =
glopcs() - lo_name = : lo_year = -1
glopcs() - lo_adjust_period_flag =
glopcs() - t_adjust_period_flag =
glopcs() - t_days_in_period = -1
glopcs() - lo_days_in_period = -1
glopcs() - t_period_start_date =
glopcs() - t_period_end_date =
glopcs() - t_quarter_start_date =
glopcs() - t_year_start_date =
glopcs() - lo_num = -1
glopcs() - num_per_f_year = -1
glopcs() - fut_ent_pers = -1
glopcs() - total fetched records = 1
glopcs() - ab_required = 0
Control structure array in place.
glompi() - sqlcode post drop table = 0
glompi() - mpi_stmt.arr is
create table gl_posting_interim
(code_combination_id number(15),
period_name varchar2(15) not null,
set_of_books_id number(15) not null,
currency_code varchar2(15) not null,
period_year number(15),
period_num number(15),
period_type varchar2(15),
account_type varchar2(1),
bal_seg_value varchar2(25),
actual_flag varchar2(1),
encumbrance_type_id number(15),
budget_version_id number(15),
template_id number(15),
translated_flag varchar2(1),
incremental_flag varchar2(1),
period_net_dr number not null,
period_net_cr number not null,
quarter_to_date_dr number not null,
quarter_to_date_cr number not null,
project_to_date_dr number not null,
project_to_date_cr number not null,
begin_balance_dr number not null,
begin_balance_cr number not null,
period_net_dr_beq number,
period_net_cr_beq number,
begin_balance_dr_beq number,
begin_balance_cr_beq number,
segment1 varchar2(25),
segment2 varchar2(25),
segment3 varchar2(25),
segment4 varchar2(25),
segment5 varchar2(25),
segment6 varchar2(25),
segment7 varchar2(25),
segment8 varchar2(25),
segment9 varchar2(25),
segment10 varchar2(25),
segment11 varchar2(25),
segment12 varchar2(25),
segment13 varchar2(25),
segment14 varchar2(25),
segment15 varchar2(25),
segment16 varchar2(25),
segment17 varchar2(25),
segment18 varchar2(25),
segment19 varchar2(25),
segment20 varchar2(25),
segment21 varchar2(25),
segment22 varchar2(25),
segment23 varchar2(25),
segment24 varchar2(25),
segment25 varchar2(25),
segment26 varchar2(25),
segment27 varchar2(25),
segment28 varchar2(25),
segment29 varchar2(25),
segment30 varchar2(25))
tablespace GLD
STORAGE(INITIAL 500K NEXT 250K
MINEXTENTS 1 MAXEXTENTS 121
PCTINCREASE 0)

glompi() - sqlcode post create table = 0
glompi() - mpi_stmt.arr is
create index gl_posting_interim_n1
on gl_posting_interim
(code_combination_id,
period_name,
set_of_books_id,
currency_code)
tablespace GLX
STORAGE(INITIAL 80K NEXT 40K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)

glompi() - sqlcode post create u1 index = 0
glompi() - mpi_stmt.arr is
create index gl_posting_interim_n2
on gl_posting_interim (template_id)
tablespace GLX
STORAGE(INITIAL 20K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0)

glompi() - sqlcode post n2 index create = 0
glompi() - gl_posting_interim and index recreated.
glompi() - gl_posting_interim locked in exclusive mode.
gloinp() - examining 0 th sob_id (1) for ipi; cfy = 0
gloinp() - appending clause = 'sob.set_of_books_id = 1 '
gloinp() - insert stmt length = 1972
gloinp() - insert stmt is:
insert into gl_posting_interim (code_combination_id, period_name, set_of_books_id, currency_code, period_year, period_num, period_type, actual_flag, translated_flag, period_net_dr, period_net_cr, period_net_dr_beq, period_net_cr_beq, quarter_to_date_dr, quarter_to_date_cr, project_to_date_dr, project_to_date_cr, begin_balance_dr, begin_balance_cr, begin_balance_dr_beq, begin_balance_cr_beq, template_id) select b.code_combination_id, decode(b.set_of_books_id , 1, '13-2006', 'ERROR'), b.set_of_books_id, b.currency_code, decode(b.set_of_books_id, 1, 2006 ,-1), decode(b.set_of_books_id, 1, 13 ,-1), decode(b.set_of_books_id, 1, '1' ,'ERROR'), b.actual_flag,decode(b.set_of_books_id,1,decode(b.currency_code,'CNY',NULL,'STAT',NULL,'R'),0), 0 , 0,0,0, decode(b.set_of_books_id , 1, nvl(b.quarter_to_date_dr,0) + nvl(b.period_net_dr,0) , -1), decode(b.set_of_books_id, 1, nvl(b.quarter_to_date_cr,0) + nvl(b.period_net_cr,0) ,-1), nvl(b.project_to_date_dr,0) + nvl(b.period_net_dr,0), nvl(b.project_to_date_cr,0) + nvl(b.period_net_cr,0), nvl(b.begin_balance_dr,0) + nvl(b.period_net_dr,0), nvl(b.begin_balance_cr,0) + nvl(b.period_net_cr,0), decode(b.set_of_books_id,1,decode(b.currency_code,'CNY',0,'STAT',0,nvl(b.begin_balance_dr_beq,0)+nvl(b.period_net_dr_beq,0)),0),decode(b.set_of_books_id,1,decode(b.currency_code,'CNY',0,'STAT',0,nvl(b.begin_balance_cr_beq,0)+nvl(b.period_net_cr_beq,0)),0), b.template_id from gl_balances b, gl_sets_of_books sob where b.actual_flag = 'A' and ( b.currency_code in (sob.currency_code,'STAT') or translated_flag='R' ) and b.set_of_books_id = sob.set_of_books_id and b.period_name = sob.latest_opened_period_name and (sob.set_of_books_id = 1 )
gloinp() - sqlcode after insert = 0

robin_cao

我实在看不出错误所在！

哪位遇到过这样的问题！

谢谢！

纵横四海

有没有更多的日志或者贴图，好像信息有限阿。

peijuntao

ORA-01632: max # extents (200) reached in index GL.GL_BALANCES_N3
索引的盘区用完了，加大即可。

robin_cao

原帖由 peijuntao 于 2007-4-18 17:39 发表
ORA-01632: max # extents (200) reached in index GL.GL_BALANCES_N3
索引的盘区用完了，加大即可。

peijuntao正解，当时就是这样解决的！
还是要谢谢老兄你的回复！:02526b