Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Data Migrator Job Log
 Login/Join
 
Gold member
posted
Hi,

I don't know why some of Data Migrator Job logs are being logged successfully, but some of them do not be logged. And I am sure these missing job log's jobs are run successfully. Anyone knows what is happening?

Thanks


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9
 
Posts: 51 | Registered: December 15, 2006Report This Post
Platinum Member
posted Hide Post
A couple of questions and some things to check...

(1) What release and platform are you running on? Please update your signature with this information as it could make a difference.

(2) Are the "jobs" that you don't get logs for running in deferred mode? If they are, check the SCHEDULER to make sure it has not crashed.

(3) Are these "jobs" process flows, data flows, Data Migrator stored procedures, or a combination of the three? If you use a lot of stored procecures and don't have -SET &ECHO=ALL in the top of it, you should still get a log but you won't see much.

(4) How large is your log file? This probably isn't your issue if you're getting logs for some things but this is always good to check. Depending on the release you are on, there is a 2GB limit.

(5) Have you looked in your DFM_DIR directory? When jobs are run in deferred mode, their info is first written to "temp" files in the DFM_DIR directory, then when the job is done, the info is written into the actual log file. If you don't have anything currently running but there are files in the DFM_DIR directory, that could be your missing logs. The only way I know to deal with this is to rebuild the log. If you don't want to do that, or want to know if there is another way, open a case with IBI.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Report This Post
Gold member
posted Hide Post
Hi Jessica,

All these jobs are running in deferred mode. These jobs had run without crash, but just didn't get logs. And I found that these jobs were started to run at 5am, but the log was started at 5:45am.

Anyway the jobs get logs today.

Thanks


May

WebFOCUS 7.6.8 Servlet
- MRE/BID/Self Service/ReportCaster
- MS Windows Server 2003
- MS SQL Server 2005
- DataMigrator 7.6.9
 
Posts: 51 | Registered: December 15, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders