eppesuiG
1st July 2008, 18:20
I am installing from scratch a new baan IVc4 system on AIX 5.3 using these CDs: master english, portingset 6.1c.07.09, update spanish, batch installer upto sp23, service pack 24.


run cd.read6.1 on the master cd. Read only tools package and portingset
corrected the bse/etc directory adding the missing rc.start_blogind
updated porting set from 6.1c.07.09 to 6.1c.07.18
run "sh install6.1"
stopped when setting up datedase
used ora8_inst6.1 to setup database files: lib/ora/ora_{users,groups,storage} lib/defaults/db_resource
changed ORACLE_SID to TWO_TASK in lib/tabledef6.1
corrected ipc_info in oder to use sockets instead of pipes for ora8_srv6.1
continued installation up to the end

run cd.read6.1 on the update-spanish cd. Read only tools package
run "sh install6.1"
update completed

patch-installed solution 19608std.dmp from batch installerd CD
patch-installed stnd (only tools)
loaded PMC indexes
created empty tfB40_c4 in order to inizialize PMC
initialized PMC
initializes PMC B-language support
pmc-installed all batch installer service pack translation for language 5

pmc-installed sp24 for tools (no translation available yet)
installed latest standard program patch (230433stnd) and required solutions

then, I created a few packages (tc, td, ...) created a package combination and imported some software from an old triton 3.1_a system.

What happen is that when recompiling all reports I get the error:

bshell Messages 2
Fatal error: ttadv335.layo index 279 out of dims [1] 260
Fatal error: Can not continue in ttadv3240m000 in DLL: ottdllobject (<28>)

Please note, that I did not moved any data between the old system to the new one via oracle: I just used "export data dictionary" and "improt data dictionary".
Please also note that when (point 6.) I inizialized oracle parameters, I wrote in bse/lib/defaults/db_resource:
nls_lang:latin american spanish_america.we8iso8859p1
nls_sort:binary
ora_default_tablespace:BAAND
ora_temporary_tablespace:TEMP

while in oracle I have those NLS parameters:
SQL> col value format a49
SQL> col parameter format a30
SQL> select * from v$nls_parameters;

PARAMETER VALUE
------------------------------ -------------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

Does anyone have any suggestion?

Thank you very much,
Giuseppe

NPRao
1st July 2008, 21:09
Giuseppe,

You can use the Search option to refer to the already discussed threads. The issue is with NLS_LANGUAGE setting -

ttadv335.layo index 301 out of dims (http://www.baanboard.com/baanboard/showthread.php?t=10605&highlight=nls)

eppesuiG
2nd July 2008, 02:30
Hi NPRao,
I think this problem is different from all others since it does not imply a migration from a previous server: no NLS_LANG has been changed in the database or during a database migration.
I couldm't find any solution for this problem.

Thanks,
Giuseppe