Home > IT Answers > AS/400 > CPF3204
aceofdelts
1,565 pts.
 CPF3204
AS/400, CPF3204
I'm getting this error today on a CRTLF. Text says "cannot find object" tho the PF does exist in libl (a major file so all hell would break loose if it were gone) and LF key fields do exist. I suspect it is due to triggers on the PF. Can anyone confirm or refute this ? I'll keep digging in the meantime since I'd rather not disable the triggers merely based on a hunch.

Software/Hardware used:
as400
ASKED: December 7, 2012  5:55 PM
UPDATED: December 7, 2012  6:10 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   14,060 pts. , aceofdelts   1,565 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Is that the only message? The joblog and the compile listing might both have messages. If you run STRDBG and STRSQL, can you run CREATE VIEW to see if a similar SQL VIEW can be created? The debug output might show more detail. Are there any constraints on the PF? — Tom

TomLiotta
 110,135 pts.
 

I suspect that the compile jobs library list didn’t include the library with this file or the logical file had the wrong library or file name in the PFILE.

philpl1jb
 44,630 pts.
 

Removing the triggers on the physical file did the trick.
thanks for the quick replies.

aceofdelts
 1,565 pts.