VI upgrade to 9.2.12.4 from 9.2.7.2

More
2 weeks 5 days ago #22839 by ddudley20
Looks like i need to run a few table updates.
Oracle repository, but new 9.2.12.4 opens with error
adsobjtree; Field USER_FIELD_01 not found
while connecting to the repositoryadsObjTree.
   
Looked for an ALTER script in new install path but did not find one.
please advise, thanks

 

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

More
2 weeks 5 days ago #22840 by ddudley20
Cancel this one, found the .SQL on your site , ran column adds and VI starts up.
The following user(s) said Thank You: admin

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

More
2 weeks 4 days ago #22841 by admin
For those who are having the same problem here is the link to the repository upgrade scripts

www.etl-tools.com/repository-database-updates/

Mike
ETL Architect

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

More
1 week 7 hours ago - 1 week 6 hours ago #22842 by dudleybokf20
Back to unresolved.

also discovered today that External Application Action call of a SQLPLUS command fails with new version.

Started up 9.2.7.2 and ran job without error.
sqlplus scott/tiger@server @P:\auto\tpteller\TPHolds.sql
and it ran without issue.

Started up 9.2.12.4 and ran job get error.
sqlplus scott/tiger@server @P :\auto\tpteller\TPHolds.sql
only a message "failed"
Start In; is set to .sql folder and job runs manually without error.
Job step fails to find .sql when run on schedule.
 
Last edit: 1 week 6 hours ago by dudleybokf20. Reason: new information

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

More
1 week 5 hours ago #22843 by dudleybokf20
Changed step from making a sqlplus scott/tiger@server call to running a .bat file with sqplus command inside.
Still fails with only "failed".
Run job manually not using scheduler and it completes.
Have local Admin service account running both Exec Agent and Mgmt Console.

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

More
6 days 18 hours ago #22844 by admin
Good Morning.

Is P: a mapped drive/network share?

Mapped drives do not exist inside windows services

Mike
ETL Architect

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