Uniface User Forum

(updates : we found solutions for the table creation error; I have removed this in the text here under)

Hello,

We need to migrate our application from Uniface 9.7  to 10.3 (were are also migrating from Solaris & Oracle 12 to Solaris & oracle 19c)

For the moment we are just at the begining of our work 🙂 : have installed Uniface 10.3 and changed asn file.

We have read in the documentation that we need to create a new repository (we need it on our Oracle 19c DB) as the old one is not compatible anymore.

When launching our shortcut to start IDE, somes tables seems to be created in ou DB but it generates a log files with various errors and stop working after few seconds :

Object NOTFOUND   [0] prc/$$register@system_library.prc

Object NOTFOUND   [0] rsp/uurepos@e
Object NOTFOUND   [0] rsp/uurepos@system_library@e.rsp

Object NOTFOUND   [0] rsp/ide@usys@e.rsp
Object NOTFOUND   [0] rsp/ide@system_library@e.rsp

Object NOTFOUND   [0] fmt/u_multipleselect@usys@e.fmt

Object NOTFOUND   [0] men/usys_bar@usys@e.men

Object NOTFOUND   [0] rsp/uc_main@e

Object NOTFOUND   [0] rsp/uc_props@e
Object NOTFOUND   [0] rsp/uc_props@system_library@e.rsp

Object NOTFOUND   [0] rsp/uumessage@usys@e.rsp
Object NOTFOUND   [0] rsp/uumessage@system_library@e.rsp

Object NOTFOUND   [0] rsp/ide_api_1@e
Object NOTFOUND   [0] rsp/ide_api_1@system_library@e.rsp

and so on.. until last part of log :
    hop=0;dbg=0;pid=13372;tid=9576;qid=0;ins=0;
Server: I/O function: Z, mode: 0, on file/table: UFORM
Server: I/O function: Z, mode: 0, on file/table: UINC
Server: I/O function: Z, mode: 0, on file/table: ULIBINC
Server: I/O function: Z, mode: 0, on file/table: ULIBPRC
Server: I/O function: Z, mode: 0, on file/table: ULIBSNP
Server: I/O function: Z, mode: 0, on file/table: UPRC
Server: I/O function: Z, mode: 0, on file/table: UPROJECT
Server: I/O function: Z, mode: 0, on file/table: UREFAPS
Server: I/O function: Z, mode: 0, on file/table: UREFCPT
Server: I/O function: Z, mode: 0, on file/table: UREFENT
Server: I/O function: Z, mode: 0, on file/table: UREFPRJ
Server: I/O function: Z, mode: 0, on file/table: USNP
Server: I/O function: Z, mode: 0, on file/table: UXFIELD
Server: I/O function: Z, mode: 0, on file/table: UXGROUP
Server: I/O function: A, mode: 0, on driver: ORA
From Server:chn=1281;len=32: ANSWER; typ=Z;av=I;op=Z;ret=0,0;
    hop=0;dbg=0;pid=13372;tid=9576;qid=0;ins=0;
To Server:chn=1281;len=6: SRVSHUT;
8061 - Network error detected (NETERR_PIPE_BROKEN [-17]: TCP: [-81] Connection has been terminated).
Checkin UWALL: 1
Checkin UDE: 1
Checkin UESC: 1
Checkin UCLTSRVDB: 1
2020-02-25 11:24:51.98 - Uniface session stopped

So the questions are :

• Where are the missing objects ?
•  How can we setup .asn with those missing object
•  Why Network error at the end ?

We hope somebody you will be able to help us 🙂

Bye

Hello Pascal,

The error ORA-00904 ("UREPVERSION": invalid identifier) seems to suggest that the UDICVER table already exists in the database. And since the column UREPVERSION is missing it probably is from an old Uniface (version < 10) installation. Please make sure that you are pointing the repository to the correct database (that actually is empty).

I hope this helps.

Kind regards,
Daniel

Hello Daniel,

Yes you are right, I found the problem (we had cloned the DB and the repository 9.7 too, after having dropped the old 9.7 repository table and deleted the remaining synonyms we used we managed to start ide with UNIFACE 10!).

There are still the missing objects (the same in my first question above) but we can open IDE.