Resolving File assciated with template definition is not found in the database. (235,77) PeopleSoft BI Publisher Issue

All,

If you’re getting the error as in the error message provided below, then it means that your current report template’s version is not the same as the one that was originally inserted into the project in Application designer.

image001 (1)

File assciated with template definition is not found in the database. (235,77) 

The following steps would help resolve this issue:

  1. Run this SQL statement in your development instance where the Report template actually works without any issue :
select * from PSFILEDEFN where userfilename like 'BI_RPT.rtf%';

Here, BI_RPT.rtf% is your actual template file name – *.rtf

  1. You will get a row for English and for multiple languages, if templates for multiple languages were added
  2. Note the FILEID for both rows
  3. Now if you go to App Designer and look at the filename in Upgrade tab, it will be different from what was returned from the aforementioned SQL statement – that is because, if you had modified the templates multiple times after inserting into the project, only the first one would be retained – So, there is a mismatch between what is there in the project and what is actually saved to the database
  4. Press Ctrl + F7 and select BIP File Definitions – provide the FILEID that was returned in Step #3 and ensure it is available in the Upgrade tab – verify that the FILEID from the database is the same as the one in Application Designer

Hope this helps! 🙂

Advertisements

About Manikandan Surendren

A PeopleSoft Techno-functional Consultant. An engineering graduate in Computer Science. Technology Enthusiast. Movie freak. Gadget geek.
This entry was posted in Code, Oracle, PeopleSoft. Bookmark the permalink.

4 Responses to Resolving File assciated with template definition is not found in the database. (235,77) PeopleSoft BI Publisher Issue

  1. Anamika says:

    It helped!!! thank you…

  2. Adrian SH says:

    Thank you so much for sharing this information. It saved my day! This was making me crazy 😛

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s