Skip to content

REP-0189: Cannot write to Reports Server cache

We had seen one issue in EBS R12 in which simple report porgamrs like “Active users”  were throwing erorrs like below:

 Enter Password:
 REP-0118: Unable to create a temporary file.

REP-0189: Cannot write to Reports Server cache
 REP-0069: Internal error
 REP-57054: In-process job terminated:Terminated with error:
 REP-189: Cannot write to Reports Server cache
 this is the error in Log file
 APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
 American_America.UTF8


Remember that Reports Server cache points to $REPORTS_TMP path so issue could have occurred if

  • the $REPORTS_TMP path path was not writeable
  • the $REPORTS_TMP path was inaccessible
  • the $REPORTS_TMP path was Full.

 

 

On verification we found that Filesystem was full:

$ df -h /fs01
 Filesystem size used avail capacity Mounted on
 /dev/vx/dsk/dg0071-01/fs01vol
 84G 84G 0K 100% /fs01

 

Clearing up the filesystem helped in correcting the error.

 

[Post Views: 94]

Read Offline: PDF Download

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *