In the Linux version of PITSS.CON, if you are unable to compile reports due to the following error:
“Report compilation error 256”
You can fix the problem by applying the following steps:
- Open up $ORACLE_HOME/bin/rwconverter.sh in a text editor. Make sure that there are fully-written paths and that there are no “$$oracle.instance$$” occurrences. If there are any variables like that, replace $$oracle.instance$$ with the fully-written path to the ORACLE_INSTANCE directory and replace $$oracle.home$$ with the fully-written path to the ORACLE_HOME directory.
- Open up $ORACLE_INSTANCE/config/reports/bin/reports.sh in a text editor and go to $REPORTS_PATH. In the REPORTS_PATH, add the following to the end of the REPORTS_PATH (using PITSS1 as an example): :/opt/oracle/pitsscon/tool:/opt/oracle/pitsscon/users/pitss1/rdf:/opt/oracle/pitsscon/users/pitss1/olb:/opt/oracle/pitsscon/users/pitss1/tool (NOTE: You may need to add additional paths for other PITSS users such as PITSS2 at the end of REPORTS_PATH). Copy the entire REPORTS_PATH, save the file, and close the file.
- Open up the PITSS-related env files such as pitss1.env and paste the entire REPORTS_PATH inside the file. NOTE: If you are working in pitss1.env and there is pitss2.env REPORTS_PATH information, you can remove the PITSS2-related path information. Save and close the file.
- Restart the WLS_REPORTS server. This MUST be done after applying step 2.
NOTE: Make sure you are able to compile reports in your shell environment. Otherwise, the above steps may not work.
NOTE: New installations of PITSS.CON are not recommended in Linux. PITSS.CON should be installed in a Windows environment.
