VI upgrade to 9.2.12.4 from 9.2.7.2

More
2 months 3 weeks 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 months 3 weeks 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 months 3 weeks 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
2 months 2 weeks ago - 2 months 2 weeks 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: 2 months 2 weeks ago by dudleybokf20. Reason: new information

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

More
2 months 2 weeks 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
2 months 2 weeks 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.

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.