Team coding installation

SQL Navigator
1

Hi,

I’m having trouble installing team coding support.

The install script seems to run without trouble however the team-coding status shows team coding not installed.

I have run the install script multiple times, I have also tried uninstalling beforehand.

enlosed is the install log from the most recent install.

Creating user SQLNAV
ORA-01920: user name ‘SQLNAV’ conflicts with another user or role name
Granting admin role to SQLNAV
Successful
Connecting as SQLNav User
Successful
Creating Table SQLNAV.SQLN_SAVED_SQLS
ORA-00955: name is already used by an existing object
Creating Table SQLNAV.SQLNAV4_PROJECT_LIST
ORA-00955: name is already used by an existing object
Creating Sequence PROJECTLISTSEQ
ORA-00955: name is already used by an existing object
GRANT SELECT ON PROJECTLISTSEQ TO SQLNAV_ADMIN

Successful
GRANT SELECT ON PROJECTLISTSEQ TO SQLNAV_MGR

Successful
GRANT SELECT ON PROJECTLISTSEQ TO SQLNAV_LDR

Successful
GRANT SELECT ON PROJECTLISTSEQ TO PUBLIC

Successful
Making Grants on Table SQLNAV.SQLNAV4_PROJECT_LIST
Successful
GRANT DELETE, SELECT, UPDATE, INSERT ON SQLNAV.SQLNAV4_PROJECT_LIST TO SQLNAV_MGR

Successful
GRANT SELECT ON SQLNAV.SQLNAV4_PROJECT_LIST TO PUBLIC

Successful
GRANT SELECT, INSERT, UPDATE ON SQLNAV.SQLNAV4_PROJECT_LIST TO SQLNAV_LDR

Successful
Creating Table SQLNAV.SQLNAV4_PROJECT
ORA-00955: name is already used by an existing object
Making Grants on Table SQLNAV.SQLNAV4_PROJECT to SQLNAV_ADMIN
Successful
Making DELETE Grant on Table SQLNAV.SQLNAV4_PROJECT to SQLNAV_MGR
Successful
Making SELECT Grant on Table SQLNAV.SQLNAV4_PROJECT to PUBLIC
Successful
Making INSERT, UPDATE Grant on Table SQLNAV.SQLNAV4_PROJECT to SQLNAV_LDR
Successful
Creating Table SQLNAV.SQLNAV4_USER_MAPPING
ORA-00955: name is already used by an existing object
Making Grants on Table SQLNAV.SQLNAV4_USER_MAPPING to SQLNAV_ADMIN
Successful
Making Grants on Table SQLNAV.SQLNAV4_USER_MAPPING to SQLNAV_MGR
Successful
Making Grants on Table SQLNAV.SQLNAV4_USER_MAPPING to SQLNAV_LDR
Successful
Making Grants on Table SQLNAV.SQLNAV4_USER_MAPPING to PUBLIC
Successful
Creating Table SQLNAV.SQLNAV4_VCS_CONFIG
ORA-00955: name is already used by an existing object
Making Grants on Table SQLNAV.SQLNAV4_VCS_CONFIG to SQLNAV_ADMIN
Successful
Making SELECT Grant on Table SQLNAV.SQLNAV4_VCS_CONFIG to SQLNAV_MGR
Successful
Making SELECT Grant on Table SQLNAV.SQLNAV4_VCS_CONFIG to SQLNAV_LDR
Successful
Making SELECT Grant on Table SQLNAV.SQLNAV4_VCS_CONFIG to PUBLIC
Successful
Creating Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG
ORA-00955: name is already used by an existing object
Altering Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG
Successful
Making Grants on Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG to SQLNAV_ADMIN
Successful
Making Grants on Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG to SQLNAV_MGR
Successful
Making Grants on Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG to SQLNAV_MGR
Successful
Making UPDATE Grant on Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG to SQLNAV_LDR
Successful
Making UPDATE Grant on Table SQLNAV.SQLNAV_PROGRAM_STATUS_LOG to PUBLIC
Successful
Creating Table SQLNAV.SQLN_VCS_FILEEXT
ORA-00955: name is already used by an existing object
Making SELECT, UPDATE Grants on Table SQLNAV.SQLN_VCS_FILEEXT to SQLNAV_ADMIN
Successful
Making SELECT Grant on Table SQLNAV.SQLN_VCS_FILEEXT to SQLNAV_MGR
Successful
Making SELECT Grant on Table SQLNAV.SQLN_VCS_FILEEXT to SQLNAV_LDR
Successful
Making SELECT Grant on Table SQLNAV.SQLN_VCS_FILEEXT to PUBLIC
Successful
Inserting (Type) into Table SQLNAV.SQLN_VCS_FILEEXT
ORA-00001: unique constraint (SQLNAV.SYS_C0016111) violated
Creating Table SQLNAV.SQLNAV4_TIMESTAMP
ORA-00955: name is already used by an existing object
Making Grants on Table SQLNAV.SQLNAV4_TIMESTAMP to SQLNAV_ADMIN
Successful
Making Grants on Table SQLNAV.SQLNAV4_TIMESTAMP to SQLNAV_MGR
Successful
Making Grants on Table SQLNAV.SQLNAV4_TIMESTAMP to SQLNAV_LDR
Successful
Making Grants on Table SQLNAV.SQLNAV4_TIMESTAMP to PUBLIC
Successful
Creating TIMESTAMPTRIGGER
Successful
Creating PROJECTLISTTRIGGER
Successful
Creating PROJECTTIMESTAMPTRIGGER
Successful
Creating USERMAPTIMESTAMP TRIGGER
Successful
Creating Table SQLNAV.SQLNAV4_PSL_VCS_INFO
ORA-00955: name is already used by an existing object
Making Grants on Table SQLNAV.SQLNAV4_PSL_VCS_INFO to SQLNAV_ADMIN
Successful
Making Grants on Table SQLNAV.SQLNAV4_PSL_VCS_INFO to SQLNAV_MGR
Successful
Making Grants on Table SQLNAV.SQLNAV4_PSL_VCS_INFO to SQLNAV_LDR
Successful
Making Grants on Table SQLNAV.SQLNAV4_PSL_VCS_INFO to PUBLIC
Successful
Creating Sequence SCRIPTIDSEQ
ORA-00955: name is already used by an existing object
GRANT SELECT ON SCRIPTIDSEQ TO SQLNAV_ADMIN

Successful
GRANT SELECT ON SCRIPTIDSEQ TO SQLNAV_MGR

Successful
GRANT SELECT ON SCRIPTIDSEQ TO SQLNAV_LDR

Successful
GRANT SELECT ON SCRIPTIDSEQ TO PUBLIC

Successful
Creating TRIGGER BEFOREDELETEPROJECTLIST
Successful
Creating TRIGGER BEFOREDELETEPSLVCS
Successful

2

Hi Tony,

Thanks for your post, we are checking this for you.

Could you provide more infomation about your issue? do you have installed Toad Team Coding in the same environment? and what TeamCoding client do you want to install ?

Thanks,

Michael

3

Hi Michael,

The issue seems to be fixed by a patch made for me by Bruce.

See www.toadworld.com/…/42201.aspx for details.

To answer your questions.

I installed the toad team coding to see if the worked, but subsequently deleted them.

I would prefer the sql navigator version.

Not sure this helps as the patch fixed the issue as I said.