Campus Solutions - PSFT (MOSC)

MOSC Banner

Table Validation runs for days, never completes

edited Dec 19, 2017 5:38PM in Campus Solutions - PSFT (MOSC) 7 commentsAnswered ✓

We recently upgraded to PT8.55 and are on Campus Solutions 9.0.  We have not been able to get table validation, sftblval.sqr, to run to completion with the Item Due flag checked since the upgrade.  We have let it run for days and it never finishes.  There are no errors in the log file.  We have looked at SQL tuning and nothing seems amiss.  We have turned on tracing and shown that the job is progressing slowly and steadily. 

Also, we run this sftblval weekly with this option checked.  I'm curious how often everyone else runs the job.  PeopleBooks says this step compare the item due dates between item and item line and updates item line to match item when there is a discrepancy.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center