Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration

TOPIC: Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18625

Just upgraded from 8.4.0.12 to 9.2.4.0. VISUAL IMPORTER !!!!
Using Oracle Repository.
Get ORA-00942:table or view does not exist repositoryadsNODES
Looking at another Prod 9.2.0.4 Ora repository EVENT_MONITORS,NODES,NODES_STATUS tables missing.
Copied them to other Oracle repository, edited server name and IP entries, but now new error about a missing column.
Trying to remember, Is there a post-upgrade script i need to run?
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18626

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7638
  • Karma: 33
  • Thank you received: 425
Hello
The easiest option to migrate is via backup/restore.
Can you tell us which version you have?
Is it Ent or Pro?
And I will provide you with the guide
Mike

Please Log in or Create an account to join the conversation.

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18627

Version is Ent.

Please Log in or Create an account to join the conversation.

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18628

  • admin
  • admin's Avatar
  • Away
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7638
  • Karma: 33
  • Thank you received: 425
1. Download and install latest version 8 visual importer
www.etl-tools.com/dmdocuments/VImpES_32V8.zip
2. connect to OLD repository and make a backup
(The backup must have one file inside)
3. Uninstall version 8.
4. Install version 9.
5. Create a brand new repository
6. Connect to it
7. Perform restore
8. Run the following script to enable MongoDB and cloud connections.
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=22000
WHERE OBJECT_TYPE= '903'
INSERT INTO OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select
OBJECT_ID*-4 as OBJECT_ID,
PARENT_ID,
'Cloud Storage' as NAME,
905 as OBJECT_TYPE
From
OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=322

UPDATE OBJECT_TYPES
set OBJECT_TYPE_GROUP=24000
WHERE OBJECT_TYPE= '905'
Mike

Please Log in or Create an account to join the conversation.

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18629

Running VI Ent 8.4.0.12 "64bit".

will follow your instructions and just edited your "32" bit link to "64" and just downloaded.
wondering what version of 8.x is the download link?
thx

Please Log in or Create an account to join the conversation.

Upgrade from 8.4.0.12 to 9.2.4.0 Oracle Repository repositoryadsNODES error 1 year 1 month ago #18630

All went well, supplemental INSERT script error.
resultset of subquery off to the right in comments

INSERT INTO viadmin3.OBJECTS_TREE
(OBJECT_ID,
PARENT_ID,
NAME,
OBJECT_TYPE
)
Select -- OBJECT_ID PARENT_ID NAME OBJECT_TYPE
OBJECT_ID*-4 as OBJECT_ID, -- -20 3 MongoDB 903
PARENT_ID, -- -4076 1017 MongoDB 903
'MongoDB' as NAME,
903 as OBJECT_TYPE
From
viadmin3.OBJECTS_TREE
where OBJECTS_TREE.OBJECT_TYPE=320;
commit;

ORA-02291: integrity constraint (VIADMIN3.FK_OBJECTS_TREE_OBJECT_TYPES) violated - parent key not found

Please Log in or Create an account to join the conversation.

We have 426 guests and 2 members online