Page 1 of 1

"*DataStage*DSR_LOADSTRING" Internal data error.

Posted: Wed Mar 15, 2006 2:54 pm
by djdinjan
Hi folks, i have a job which reads the job statistics and loads them into a sequential file. The source stage used here is a universe stage. The file into which the details are loaded has been created by me and also the job is run by me so, i guess this should not be a permissions issue as mentioned in another topic related to DataStage*DSR_LOADSTRING.

DataStage Job 136 Phantom 16662
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
File '/home/dsadm/Ascential/DataStage/Projects/FDM89_TST/DS_RESENU/DATA.30':
Computed blink of 0x800 does not match expected blink of 0x0!
Detected within group starting at address 0x3F000!

Please let me know if you have any suggestions on how to resolve this.

Thanks,
Dinesh

Re: "*DataStage*DSR_LOADSTRING" Internal data erro

Posted: Wed Mar 15, 2006 2:56 pm
by djdinjan
djdinjan wrote:Hi folks, i have a job which reads the job statistics and loads them into a sequential file. The source stage used here is a universe stage. The file into which the details are loaded has been created by me and also the job is run by me so, i guess this should not be a permissions issue as mentioned in another topic related to DataStage*DSR_LOADSTRING.

DataStage Job 136 Phantom 16662
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 147, Internal data error.
Program "*DataStage*DSR_LOADSTRING": Line 151, Internal data error.
File '/home/dsadm/Ascential/DataStage/Projects/FDM89_TST/DS_RESENU/DATA.30':
Computed blink of 0x800 does not match expected blink of 0x0!
Detected within group starting at address 0x3F000!

Please let me know if you have any suggestions on how to resolve this.

Thanks,
Dinesh
I get the above messages after the write is done into the file.

Thanks,

Posted: Wed Mar 15, 2006 3:53 pm
by ray.wurlod
Your DS_RESENU (resource) hashed file has become corrupted for some reason. This is highly unusual, as this file is completely used "read only" as far as I am aware.
Try this command and let us know what it says:

Code: Select all

UVFIXFILE DS_RESENU

Posted: Wed Mar 15, 2006 4:09 pm
by djdinjan
Hi Ray, thanks for the information. Looks like you have forgotten to mention the command you wanted me to run.

Thanks,
Dinesh

Posted: Wed Mar 15, 2006 4:13 pm
by DSguru2B
You need to be a charter member in order to see his reply as his replies are premium content and only visible to charter members.
The command he wanted you to run was

Code: Select all

UVFIXFILE DS_RESENU
Also, dont forget to tell us what it said.
Cheers.

Posted: Wed Mar 15, 2006 4:13 pm
by ogmios
djdinjan wrote:Hi Ray, thanks for the information. Looks like you have forgotten to mention the command you wanted me to run.

Thanks,
Dinesh
UVFIXFILE DS_RESENU (or fixtool in newer versions).

Posted: Wed Mar 15, 2006 4:51 pm
by djdinjan
Hi all, I had run the command and it said "No such file or Directory".

Any suggestions on how to fix this file.

Thanks,
Dinesh

Posted: Wed Mar 15, 2006 4:53 pm
by ogmios
djdinjan wrote:Hi all, I had run the command and it said "No such file or Directory".

Any suggestions on how to fix this file.

Thanks,
Dinesh
Run it in the project where the file resides

Ogmios

Posted: Wed Mar 15, 2006 5:29 pm
by djdinjan
Hi all, The following are the results of the command

ID "DSTAGE_PLI_E_0089" doesn't hash to primary group 64
ID "DSTAGE_RUN_E_0379" doesn't hash to primary group 64
ID "DSTAGE_JOB_E_2033" doesn't hash to primary group 64
ID "DSTAGE_UDT_E_3018" doesn't hash to primary group 64
ID "DSTAGE_XML_I_6202" doesn't hash to primary group 64
ID "DSTAGE_IPC_E_7019" doesn't hash to primary group 64
ID "DSTAGE_JSG_M_0049" doesn't hash to primary group 64
ID "DSTAGE_REP_I_0183" doesn't hash to primary group 64

several more lines as above and

Error: Processing primary group 123, overflow group 0
Record length discrepancy at address 0x0003d800
Encoded size = 0, calculated size = 2048.
calculated BLINK = 0x00000800 (2048).
ID "" doesn't hash to primary group 122

few more message as above and

warning: file load discrepancy detected.

Thanks and regards,
Dinesh
[/img]

Posted: Wed Mar 15, 2006 6:33 pm
by ray.wurlod
You might try to repair DS_RESENU using fixtool or uvfixfile. Results are not, however, guaranteed. You might be better to restore a good one from backup. Rename or move the corrupted copy first. There is a separate DS_RESENU hashed file in each project, so you can also copy a good one from another project, or the Template directory. Don't forget to perform a recursive copy, so that you also get the three files DATA.30, OVER.30 and .Type30. These files should total slightly over 300KB (337920 bytes on Linux).

Posted: Thu Mar 16, 2006 11:57 am
by djdinjan
Ray, this has worked. We happened to replace the file with one from a different project and the job has run fine.

Thanks a lot to you all.

Regards,
Dinesh

Posted: Thu Aug 07, 2008 5:12 pm
by chulett
Just stumbled across this problem in a project I don't normally spend much time in and found the DS_RESENU hashed file was corrupted as noted here. Copied the contents from another project and all is well now.

:D