Error Selecting From Log File Rt_log
Contents |
is
Datastage Delete Rt_log
received "Unable to open DICT 'RT_LOGnnn'." Technote (troubleshooting) Problem(Abstract) This error datastage rt_log files indicates that the metadata for RT_LOG files, stored in D_RT_LOG, cannot be opened. In each project directory resides a number of UniVerse dictionary files, containing column definitions. If the dictionary file cannot be read, logs will fail to display with an error: Error selecting from log file RT_LOGnnn Command was: SSELECT RT_LOGnnn WITH @ID LIKE '1N0N' COUNT.SUP Error was: Unable to open DICT "RT_LOGnnn". Resolving the problem Make sure the file D_RT_LOG exists in the project directory, and is readable by the DataStage user. If the file is missing, copy the file from the Template project into this project directory. Set permissions on the file to 775 if needed. Document information More support for: InfoSphere DataStage Software version: 7.5, 8.0, 8.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Reference #: 1442199 Modified date: 2014-08-05 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
0x830 does not match expected blink View next topic View previous topic Add To Favorites This topic has been marked "Resolved." This topic is not resolved, but there is a WORKAROUND. Post new topic Reply to topic DSXchange Forum Index » IBM® Infosphere DataStage Server Edition Author Message arnie_nits Participant Joined: 13 Aug 2007 Posts: 101 Points: 792 Posted: Mon Nov 16, 2009 11:36 pm Reply with quote Back to top DataStage Release: 7x Job Type: Server OS: Unix Hi, I was running a job and http://www-01.ibm.com/support/docview.wss?uid=swg21442199 it aborted halfway. I tried to run the job again but it didnot run atall. This job was running sucessfully before. I just added 1 extra column this time. When I tried to run the job status in director I got error: Error selecting from log file RT_LOG10197 Command was: SSELECT RT_LOG10197 WITH @ID LIKE '1NON'COUNT Error http://www.dsxchange.com/viewtopic.php?p=383129&sid=78b2a66b01a0d1a5a3dfea1ad81f0995 was Internaldata error. File '/apps/ascential/Ascential/Datastage/Projects/LA Computed blink of 0x830 doesnot match expected blink of 0x0! Detected at address 0x29800! I have no clue about this. Please help. Regards, Arnie. [* Note: PLease avoid topic titles like "DataStage Error" as that encompases about 90% of the articles in the forum. Title changed to be more descriptive - Andy *] View user's profile Send private message DS_SUPPORT Group memberships:Premium Members Joined: 04 Aug 2006 Posts: 232 Location: Bangalore Points: 1920 Posted: Tue Nov 17, 2009 12:42 am Reply with quote Back to top I hope the log file is corrupted, you can clear the log file , by executing the command, from the administrator command prompt. Code: CLEAR.FILE RT_LOG10197 This will clear the Auto Purge settings of that job, so please set it again. View user's profile Send private message Rate this response: 0 1 2 3 4 5 Not yet rated arnie_nits Participant Joined: 13 Aug 2007 Posts: 101 Points: 792 Posted: T
have moved to www.dataGenX.net, Keep Learning with us. Thursday, June 13, 2013 DataStage-Director: Unable to open DICT 'RT_LOG###' When attempting to open a job log in Director, user gets the following error message: Error selecting from log file RT_LOG### Error was: Unable to open DICT 'RT_LOG###'. This is because the D_RT_LOG http://datastage4you.blogspot.com/2013/06/datastage-director-unable-to-open-dict.html file is missing from the projects directory. To solve this issue simply copy D_RT_LOG from another project to the project directory that is missing this file. That's it. By Atul Singh at 00:19 Labels: Administration , Answers , DataStage , director , Errors , logs , RTLogging , Troubleshoot Atul Singh a Tech blogger who crazy about food :) Newer Post Older Post Home Pages Home Interview Questions E-Training DataStage Scenario Tips & Tricks Total log file Pageviews Try Me Loading... Must Reads Interview Questions : DataWareHouse - Part-1 DataSet in DataStage Read Sequential File with SCHEMA file Hash Files in DataStage Interview Questions : Linux/Unix : Part-2 Issuing commands to a Queue Manager (runmqsc) Conductor Node in Datastage Read Fixed Width Flat File with Sequential File Stage Interview Questions : DataStage - Part 1 XMeta DB : Datastage Repository Google+ n Me Blog Archive ► 2015 ( 50 ) ► October ( error selecting from 1 ) ► August ( 2 ) ► July ( 4 ) ► June ( 11 ) ► May ( 11 ) ► April ( 5 ) ► March ( 1 ) ► February ( 6 ) ► January ( 9 ) ► 2014 ( 116 ) ► December ( 4 ) ► November ( 6 ) ► October ( 11 ) ► September ( 9 ) ► August ( 5 ) ► July ( 11 ) ► June ( 10 ) ► May ( 13 ) ► April ( 10 ) ► March ( 9 ) ► February ( 16 ) ► January ( 12 ) ▼ 2013 ( 167 ) ► December ( 10 ) ► November ( 15 ) ► October ( 11 ) ► September ( 14 ) ► August ( 17 ) ► July ( 17 ) ▼ June ( 17 ) Oracle Interview Questions - Part-2 list of tables in an Oracle database Magic Command to BackUp Putty Sessions Get DB2 Version First time IIS User Setup - DataStage 8.7 Selecting DataStage job log results in error: Erro... Oracle Interview Questions - Part-1 Delete All PuTTY Sessions Together Execute an SQL script file in SQLPlus - Oracle DataStage-Director: Unable to open DICT 'RT_LOG###... MQ queue naming standards Putty Sessions Time Out due to Inactivity DataStage Job aborts with err