query1
5th October 2004, 17:01
we have the following settings:
porting set = 7.1.d.06
database = oracle9i
O/S = Sun SPARC SOLARIS2.6
we have exported and imported the data for the company "000" from our exisiting server
with the following setup
porting set = 6.2a.03.01
database = oracle8
O/S = Sun SPARC SOLARIS2.5.1
with this setup, the tabledef6.2 points to the correct driver. the baan session
is able to run.But when we ty to insert any value on any table it
gives the error cannot insert 'Corrupted data dictionary db_insert error"
we tried doing the bdbpre and then the bdbpost also after dropping the HASH columns
and indexes, to make the tables and the data in sync with the Level 2
but there is an error
Error ORA-1400 occurred during execute
ORA-01400: cannot insert NULL into ("BAAN
"."TTTAAD400000"."T$DSC1")
actually the data export for the particular column has some ascii value 0 and it is not null but we are able to view that through the GTM.It appears as null and even in the seperator wise sequential dump it stores like :
sample:
u|pvk|||
l|smp|||
l|pvk|||
l|mrl|||
a|DAM|||
p|DAM|||
How do we do the bdbpost in this case and what is the solution? Kindly help us .
We have tried doing the bdbpre using the level 1 driver and then the bdbpost using the level 2 but nothing seems to work.
porting set = 7.1.d.06
database = oracle9i
O/S = Sun SPARC SOLARIS2.6
we have exported and imported the data for the company "000" from our exisiting server
with the following setup
porting set = 6.2a.03.01
database = oracle8
O/S = Sun SPARC SOLARIS2.5.1
with this setup, the tabledef6.2 points to the correct driver. the baan session
is able to run.But when we ty to insert any value on any table it
gives the error cannot insert 'Corrupted data dictionary db_insert error"
we tried doing the bdbpre and then the bdbpost also after dropping the HASH columns
and indexes, to make the tables and the data in sync with the Level 2
but there is an error
Error ORA-1400 occurred during execute
ORA-01400: cannot insert NULL into ("BAAN
"."TTTAAD400000"."T$DSC1")
actually the data export for the particular column has some ascii value 0 and it is not null but we are able to view that through the GTM.It appears as null and even in the seperator wise sequential dump it stores like :
sample:
u|pvk|||
l|smp|||
l|pvk|||
l|mrl|||
a|DAM|||
p|DAM|||
How do we do the bdbpost in this case and what is the solution? Kindly help us .
We have tried doing the bdbpre using the level 1 driver and then the bdbpost using the level 2 but nothing seems to work.