hi,

anyone know how to reset a hang pmc installation?

i'm loading sp3 and the pmc installation stop at tp

the status now is installing.. and i can't reset.

thanks


regards
alexlow

Did you run the update with the necessary permissions? I remember we had the same problem which was caused by trying to install solutions using an user account without the required permissions.

yes, run on the default installation user baan,
the status is installing.. so want to reset the status using gmt so need to know which table to modify.

thx

I'm not really sure if it will be enough by modifying the table. I hope you're doing this not on your productive system/server otherwise check the table tpmc203 (of course company 0). There you'll find the installation status. Maybe it will be also necessary to check the table tppmc260 where the solution history is saved...

baan5c tables is bit different from ln, that's problem

It's better first to investigate why a restart of the installation does not work. In $BSE/log there are some files that can help you, e.g. log.error, log.oiex1288, and maybe also log.bshell.
PMC automatically detects that there is a solution in 'installing' status and will force you to finish that installation before you can install another solution.

hi jaap,

u r right, i check the log for log.ora and got this error information, can anyone help me out on this? many thanks


------ Log Fatal SQL Statement -----
User : baan (pid 1272)
Date : 2008-06-11[04:14:57]
SQL :
INSERT INTO baandb.tttpmc260000 (t$uver,t$urel,t$ucus,t$csol,t$date,t$time,t$sern,t$user,t$comp,t$cpac,t$ccod,t$rsta,t$Refcntd,t$Refcntu) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14)
------ End of Log Message -----

Under other log it show the installation until this object

PMC Installation on date: 061108041033

Install Data Dictionary D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041034
Install Data Dictionary forms D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041212
Install Data Dictionary reports D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041233
Install Data Dictionary scripts D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041328
Install Data Dictionary libraries D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041341
Install Runtime Data Dictionary D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041348
Install objects D:/Baan/tmp/tmp083362432d/tpB50_c_wrk 061108041348


In the event viewer it shows

Event Type: Error
Event Source: Baan
Event Category: <Unknown>
Event ID: 1000
Date: 6/11/2008
Time: 9:00:25 AM
User: BAANTEST\baan
Computer: BAANTEST
Description:
Env BaanERP (D:\Baan)
Prog dbserver_dll file \db\servers\ORACLE_2\ora_native.c # 1654
Keyword Oracle Error
Username baan type S language 2
Process 0x4f8
ProcessSet baan@baantest:1272
Lasterror 183 (Cannot create a file when that file already exists.)
Errno 0
bdberrno 110 (End of file reached)
Message
dbs_errno = 0 Error 2562 occurred:
Error ORA-1562 occurred during execute.
ORA-01562: failed to extend rollback segment number 32
ORA-01650: unable to extend rollback segment RB31 by 13 in tablespace ROLLBACK_DATA

Error BDB-2562 returned.
See fatal SQL statement in 'D:/Baan/log/log.ora.sql'.
Flushed at \db\servers\ORACLE_2\ora_cursor.c : #534.

Event Type: Error
Event Source: Baan
Event Category: Bshell
Event ID: 1000
Date: 6/11/2008
Time: 9:00:25 AM
User: BAANTEST\baan
Computer: BAANTEST
Description:
Env BaanERP (D:\Baan)
Prog bshell file \logic\mir\mir\bdb_fun.c # 1144
Keyword DB error
Username baan type S language 2
Process 0x4f8
ProcessSet baan@BAANTEST:1748
Lasterror 997 (Overlapped I/O operation is in progress.)
Errno 0
bdberrno 2562 (database error 1562)
Message Error 2562 (database error 1562) on ttpmc260000 in db_insert(51)

Event Type: Error
Event Source: Baan
Event Category: Bshell
Event ID: 1000
Date: 6/11/2008
Time: 9:00:26 AM
User: BAANTEST\baan
Computer: BAANTEST
Description:
Env BaanERP (D:\Baan)
Prog bshell file \logic\mir\mir\mul_fun.c # 460
Keyword Process state:
Username baan type S language 2
Process 0x4f8
ProcessSet baan@BAANTEST:1748
Lasterror 0
Errno 0
bdberrno 2562 (database error 1562)
Message FATAL ERROR: Error 2562 (database error 1562) on ttpmc260000 in db_insert(51)
Can not continue in ttpmc2205s000 in DLL: ottpmcdllhist (ttpmcdllhist.write.sol.hist)