Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Tuesday, 11 October 2016

Call SAPurgeAllCache() in OBIEE



 While doing OBIEE development I often use to have doubt that the database is updated properly are not. 

I use Call SAPurgeAllCache() command to purge all the cache  

Call SAPurgeAllCache()
Call SAPurgeAllCache()





Call SAPurgeAllCache()
Call SAPurgeAllCache()

ora-39002 invalid operation, ORA-06512: at "SYS.UTL_FILE", line 536



 Issue :
 
If you face the issue  ORA-39002: invalid operation ,ORA-39070: Unable to open the log file, ORA-29283: invalid file operation, ORA-06512: at "SYS.UTL_FILE", line 536, ORA-29283: invalid file operation. 


Solution:

Create directory as mention in screenshot
ora-39002 invalid operation, ORA-06512: at "SYS.UTL_FILE", line 536 

Check if the directory has created properly 
 
ora-39002 invalid operation, ORA-06512: at "SYS.UTL_FILE", line 536 

Make sure you have created physical folder also. 



Note: Use directories name in caps key