Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have recently (from about 2-3 weeks) started facing a new problem.
We are loading about 1.9 million records from one of our database views into a Load with out any conditions. But recently I have noticed that it is fetching less than half of the records only. Even in the log files it will say 90000 records loaded. There is no error and the load always completes successfully.
Our version of QV is 11.20.12048.0 SR3
Has anyone else faced similar issues? Can it be related to Publisher memory or CPU?
Any help will be appreciated.
Thanks,
Can you upload the script of the document and the document log file?
Is views have any filters or ?
You're probably using a SELECT statement to read records from your database view.
If you launch the same SELECT in your Database Management tool (Oracle SQL Developer, SQL Server Management Studio or whatever command line tool you have at your disposal), do you get more rows?
Peter
Yes in the view there are more rows
Yes view is based on the underlying tables with conditions. But in QV we are selecting all of the records in the view