Page 1 of 1

DataStage Error generated while viewing the log

Posted: Sun Oct 24, 2010 11:51 pm
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

Posted: Mon Oct 25, 2010 5:15 am
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.

Posted: Mon Oct 25, 2010 7:09 am
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.