Hi-
One of our developers has discovered that none of our customized forms are available in our development vrc structure. I did a quick check to be sure all of our custom sessions, scripts, and reports were not affected. They are fine and reside in the vrc that I expect. What would cause Forms to suddenly 'disappear' from a vrc?
How would I go about restoring them?
Thanks,
bb

Are the forms missing at the Unix level as well? This may provide more clues.

Brendan-
No, I think the ttadv300 table is corrupt. The form objects are still present on UNIX.

Did you ever happen to load ttadv300 via a delimited bdbpre and bdbpost? I have found issues in some versions of Baan with this out of company 000 for forms and had to use the bdbpre non-delimited version where it stores the dictionary type of info along with the data in the data dump file. Basically the issue was with the form layout data in company 000 having embedded characters that bdbpre/post got confused with the delimiter so things got corrupted. Try accessing the table from Oracle sqlplus and see if it "looks" right. Not sure what else to try. Maybe re-create/check the indexes to the table?

I did use a sequential dump file format to refresh our dev data with what was on production. I don't think it is delimited. :confused:

Did you refresh the test env from the production env taking the application dump using "export data dictionary" & forgot to take the form sources while exporting? you could take a dump again from the production env for the forms along with the form sources & load it in the test env.

Hi,

Is it that you were trying the sequential dump for ttadv300 and after that the Forms have dissappeared.

If this is the case you may have ticked "Delete the existing table / drop the table"

In case you have a back up of your forms you may have to reload them.

Baanboozeled,
I did use a sequential dump file format to refresh our dev data with what was on production. I don't think it is delimited.
I am not sure about your version but it seems similar to this issue I encountered last year and the fix was available in the Porting Set 7.3a02.
More info from my case -

I exported Baan table data from company 410 in development using session ttaad4226m000 – Create Sequential Dump of Table. Then I tried to import 410 tables into company-135
Using session ttaad4227m000 – Create Table from Sequential Dump. I get the following error-

Adding indexes ...
ttaad510135 R 1 12382 Adding indexes ...
ttaad511135 R 1 12437 Adding indexes ...
ttaad512135 R 1 10459 Adding indexes ...
tttxt001135 R 2 7146 Adding indexes ...
tttxt002135 R 6 6575 Adding indexes ...
tttxt004135 R 1 8 Adding indexes ...
tttxt005135 R 1 7 Adding indexes ...
tttxt010135 R 1 74075 Adding indexes ...Can not creat index 1 (error 2452)

tttxt012135 R 2 0 No rows in table
Adding indexes ...
tttxt015135 R 1 0 No rows in table
Adding indexes ...
tttxt030135 R 1 0 No rows in table
Adding indexes ...

[DEV:bsp]/app/common/home/bsp/tttaad>ll
total 0
[DEV:bsp]/app/common/home/bsp/tttaad>oerr ora 2452
02452, 00000, "invalid HASHKEYS option value"
// *Cause: The specified HASHKEYS option must be an integer value.
// *Action: Specify an appropriate value.
[DEV:bsp]/app/common/home/bsp/tttaad>

The table tttxt010 in company 410 has 13511 rows and tttxt010 in company-135 has 74075 rows.

Can you please clarify us on how to fix this error? Is there a problem in the export/import process ?

Thank you
Solution description:
VERSION(S):
All

SITUATION IDENTIFIED IN:
bdbpost6.2

SITUATION DESCRIPTION:
Error 2452 (ora 1452)

SOLUTION DESCRIPTION:
Dump with error was created with fixed length. Created new dump with field separator.