Visio and Oracle 10G reverse engineer

[kzimme]

I am using Visio Enterprise Architects SP-2 10.0.5110 and I am trying
to reverse engineer an Oracle 10G database using a 10G client. When
the reverse engineering gets to the Extracting Oracle Object, type and
body 'XDB$Complex_derivation_t'. I get a message box that says
"Encountered a fatal error during reverse engineer of information
from the database!' and nothing is extracted. It used to work on the
9i database. How can I make it work on 10G?

 

[Al Edlund]

it would be intersting to investigate how the 9i version Oracle odbc driver
handled the Oracle object type that is now failing? Are you using the same
ODBC drivers?

al

 

[kzimme]

I ran several different tests:
1) Set Visio Driver to Oracle Server, The Oracle 9i client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures. I was
able to view field and table comments and triggers.

2) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

3) Set Visio Driver to Oracle Server, the Oracle 9i client and Visio
Enterprise Architects SP2 (10.0.5110) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

4) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Enterprise Architects SP2 (10.0.5110) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

5) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 10G database -
The application stops at Extracting Oracle Object type and body
'XDB$Complex_derivation_T' and gives the message box 'Encountered
a fatal error during reverse engineer of information from the
database!'

6) Set Visio Driver to Microsoft Access, the Oracle 10G client and
Visio Enterprise Architects SP2 (10.0.5110) and an Oracle 10G database
- The application will only extract tables (primary keys, indexes,
foreign keys, & check clauses) and views and gives the error 'Data
Source Client Error: State:S1010,Native:0 origin:[Mircorosft][ODBC
Driver Manager] Function Sequence error'

7) Set Visio Driver to ODBC Generic Driver, the Oracle 10G client and
Visio Enterprise Architects SP2 (10.0.5110) and an Oracle 10G database
- The application will only extract tables (primary keys, indexes, &
foreign keys)

So it seems that there is a conversation problem with Oracle 10G
database and Visio does anyone have a fix?

I have found Visio to a be a wonderful tool to forward and reverse
engineer with 9i but now it looks like I need to find another tool ASAP.

 

[kzimme]

I ran several different tests:
1) Set Visio Driver to Oracle Server, The Oracle 9i client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures. I was
able to view field and table comments and triggers.

2) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

3) Set Visio Driver to Oracle Server, the Oracle 9i client and Visio
Enterprise Architects SP2 (10.0.5110) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

4) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Enterprise Architects SP2 (10.0.5110) and an Oracle 9i database - I
was able to reverse engineer Tables (primary keys, indexes, foreign
keys, triggers, check clauses), views, and stored procedures.

5) Set Visio Driver to Oracle Server, the Oracle 10G client and Visio
Professions 2003 SP 2 ( 11.5509.6568) and an Oracle 10G database -
The application stops at Extracting Oracle Object type and body
'XDB$Complex_derivation_T' and gives the message box 'Encountered
a fatal error during reverse engineer of information from the
database!'

6) Set Visio Driver to Microsoft Access, the Oracle 10G client and
Visio Enterprise Architects SP2 (10.0.5110) and an Oracle 10G database
- The application will only extract tables (primary keys, indexes,
foreign keys, & check clauses) and views and gives the error 'Data
Source Client Error: State:S1010,Native:0 origin:[Mircorosft][ODBC
Driver Manager] Function Sequence error'

7) Set Visio Driver to ODBC Generic Driver, the Oracle 10G client and
Visio Enterprise Architects SP2 (10.0.5110) and an Oracle 10G database
- The application will only extract tables (primary keys, indexes, &
foreign keys)

So it seems that there is a conversation problem with Oracle 10G
database and Visio does anyone have a fix?

I have found Visio to a be a wonderful tool to forward and reverse
engineer with 9i but now it looks like I need to find another tool
ASAP.