I have 2 baan envs, on one I can compile my reports. On the other I cannot compile the exact same reports. I checked the files tss6.1 / tss_c6.1 / tss_locale6.1 and the dir locale all under the $BSE/lib. The file sizes and permissions are the same.
I also checked the permissions on the tttss001/tttss002 tables - I can read the tables fine.

The report errors are:

can't convert TSS character 0x9b29a57e

there are dozens of the errors.

ANY CLUES ??

Nick,

Check you NLS settings -


$ env | grep NLS
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ORA_NLS33=/app/common/oracle/product/8.1.7.2/ocommon/nls/admin/data

$ cd $BSE/lib/defaults
>cat db_resource
dbsinit:01
ora_max_array_fetch:5
ora_max_array_insert:5
nls_lang:american_america.we8iso8859p1
nls_sort:binary
oracle_home:/app/common/oracle/product/8.1.7.2
ora_temporary_tablespace:TEMP

My sesstings are not via ENV vars or in the tabledef6.1/db_resource files.

Not sure how these are setup, but I find them in the query below:

SQL> select * from sys.v_$nls_parameters;

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
AMERICAN

NLS_TERRITORY
AMERICA

NLS_CURRENCY
$


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA

NLS_NUMERIC_CHARACTERS
.,

NLS_DATE_FORMAT
DD-MON-YY


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_LANGUAGE
AMERICAN

NLS_CHARACTERSET
US7ASCII

NLS_SORT
BINARY


PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_CALENDAR
GREGORIAN


10 rows selected.