Update F0301 in UBE is failing

[Shoe]

Good afternoon everyone,
This is my first posting so I hope my Netiquette is correct. I have done a search in the forums but have not found an answer to my issue. I have a custom UBE that performs several table updates. All of the updates perform correctly except the update to the F0301. Following is a protion of the jdedebug log that appears to show an error in attempting the update. As you can see, the update to the F03B16 works but not the update to the F0301. I would appreciate any help in defining what this error is.
Mar 26 10:25:35 ** 438656 UPDATE PDDTA.F03B16S SET RSAN8=459575.000000,RSPART='C',RSCO='00000',RSENBL=3142128.000000,RSAHB=0.000000,RSDHBJ=0,RSAG=5618500.000000,RSNINV=61.000000,RSSAG=5618500.000000,RSCREE=0.000000,RSDFIJ=106074,RSDLIJ=107085,RSDT1J=107032,RSASTY=5618500.000000,RSPAAP=2476372.000000,RSNINP=53.000000,RSAIPL=3589525.000000,RSNIPL=42.000000,RSDLP=107078,RSALP=370847.000000,RSCMGR='CERTAIN ',RSCLMG='LOPEZ ',RSUSER='SCHUMACHER',RSPID='R55AR008D',RSUPMJ=107085,RSUPMT=102534.000000 WHERE ( RSAN8 = 459575.000000 AND RSCO = '00000' AND RSPART = 'C' )
Mar 26 10:25:35 ** 438656 Entering JDB_FreeKeyBuffer
--UBE--[4]-- --ER: Line(169): Done Processing File I/O.
--UBE--[4]-- --ER: Line(170): <Skipping ELSE>
--UBE--[4]-- --ER: Line(172): <Processing ENDIF/ENDWHILE> End If
--UBE--[4]-- --ER: Line(172): <Done Processing ENDIF/ENDWHILE>
--UBE--[4]-- --ER: Line(174): <Processing File I/O> F0301
--UBE--[4]-- --ER:: Update....
--UBE--[6]-- Call jdeActiveRptFlag to get report Updateable flag in thread ID 0
--UBE--[6]-- Call jdeActiveRptFlag to get report Updateable flag in thread ID 0
Mar 26 10:25:35 ** 438656 Entering JDB_OpenTable( Table = F0301)
Mar 26 10:25:35 ** 438656 Entering JDB_ClearSelection
Mar 26 10:25:35 ** 438656 Entering JDB_ClearSequencing
--UBE--[4]-- --ER: Line(174): Done Processing File I/O.

We are running JDE Enterprise One 8.0 / service pak 23 / Oracle 8.1.7.4 database / Microsoft Windows 2000 5.0 service pak 3

Thank you for any and all help!!!
Tom

 

[Chan Rana]

Hi Tom,
Welcome to the jdelist.

Information you posted is very less to come to any conclusion. Go thru the jde.log also if that can give you some clue of the problem.
If its failing on Update statement then try to comment that statement and insert one new update statement and see if it works.
Thanks,

 

[Shoe]

Chan,

Thank you for your response! All I have to say is DOH!!! It worked when I commented out the statement and added a new one. I know I have done this before but I guess I went brain dead thinking about this one!!!

Looks like a good technique for a statement that is entered correctly but still does not function is to create a new statement.

Thanks again!!!
Tom