Hi.

I have installed BIVc4 with Oracle 9i. The database was created manually.

Sometimes (this happens ramdomly) when you're in a session and zoom to a subsession the BW hangs. NO errors appear on the event viewer. Cannot find any oracle errors too.

what can this be?


Created 44 companies and inserted a lot of data and there was no problem. This only happens in subsessions (zoom) called by a main session.


Here is my DB_RESOURCE:

ora_init:0111000
dbsinit:021
ora_timeout:{60,60,60,60,60}
ora_max_array_insert:2
ora_max_array_fetch:2
rds_full:2
lock_retry:0

And ORA_STORAGE:

*:*:T:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDB INITRANS 3
*:*:I:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDBIDX INITRANS 3


Thanks
Fred

Hello,

Can someboyd explain the meaining of the below line which is specified in ora_storage file ?



*:*:T:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDB INITRANS 3
*:*:I:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDBIDX INITRANS 3


Regards

Learner

I am not sure of those errors. I have not installed 9i, nor am I a big database person. But I do see this type of thing if the references are not correct when I try and zoom based on the references... usually eventually get an error though.

Did you do rebuild indexes and references after you built? That's the reorganized tables session, or the corresponding bdb commands, with Data and Indices checked, and Repair Reference Counter checked. You may have already done these (probably have), but I found doing them from the session with the error logs turned on, then checking those logs, helped in cases that I could not determine the problem.

Note: Oracle may be fine, but Baan stores those reference counters on it's own, so can be messed up even if the db is fine.

Learner,

*:*:T:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDB INITRANS 3
*:*:I:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDBIDX INITRANS 3

Refer to the BaaN manual -
iBaan ERP - Oracle Database Driver Technical Reference
Manual.

The following is an example of an entry in the driver parameter file:
*:*:T: group:0214::
In this example, the database driver will create tables owned by an iBaan ERP group, and will use the iterative technique during the query generation.
A driver parameter file is defined for each database driver. The storage file for the iBaan ERP Oracle database driver is called ora_driver_param and is located in the Windows NT directory %BSE%\lib\ora or the UNIX directory $BSE/lib/ora.
If the ora_driver_param file does not exist, the driver will fall back to the functionality of porting set 6.2a.X, and use the ora_storage file to retrieve the required information.
The file should consist of zero or more entries, each consisting of several fields separated by colons. The format of an entry in the storage file is as follows:
(primary key in bold)
<table/module specification> : <company number> : <object type> : <group> :
<table/index optimization> : <refresh time>

Hi Learner,

Can somebody explain the meaining of the below line which is specified in ora_storage file ?

*:*:T:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDB INITRANS 3
*:*:I:group:0214:MSGSIZE:PCTFREE 5 TABLESPACE BAANDBIDX INITRANS 3

The Oracle RDBMS provides a way of pre-allocating table space for database objects, such as tables and indexes. This can be specified by means of so called storage (or creation) parameters. In order to specify these storage parameters for tables and indexes created by the Oracle driver, they can be put in the $BSE/lib/ora/ora_storage file. In this file, for every table and index created by the Oracle driver, the creation parameters can be specified.

Also Refer to Knowledge Quest and search ora_storage, where this is nicely explained.

-Suhas