DataStage Error generated while viewing the log

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
shobhit_vk_gupta
Participant
Posts: 14
Joined: Wed May 05, 2010 1:24 am

DataStage Error generated while viewing the log

Post by shobhit_vk_gupta »

Hi all,

I am facing one issue while loading the data in the oracle table with the help of server jobs. Number of records are 113 Millions. The job is simple. Its design is like extraction from DB2 then transformer and finally loading stage to load data in oracle database. I have used ODBC stage for the extraction and loading. Data is loaded in the table but the job is aborted.While viewing the log i am getting one pop up with the error like :

Error selecting from log file RT_LOG1776
Command was : SSELECT RT_LOG1776 WITH @ID LIKE '1NON' COUNT..
Error was: Internal data error . File
'C:\ASCENTIAL\DATASTAGE\PROJECTS\EPMDEV/RT_LOG1776/DATA
Computed blink of 0xA60 does not match expected blink of 0x0!y Detected
within group starting at address 0x80000000!y

Kindly help
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Blink stands for backward link.

Did you have loads of messages or did you run out of space ? A search for blink may help you.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Your log is corrupted due to too many messages being logged and the size exceeding 2GB. An exact search for "Computed blink of" should turn up many conversations on the topic as well as your options.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply