Validation and resolution for BIP generating invoice pdf of zero size

You might come across some issue in BRM-BIP where you will find that BIP is generating blank pdf of zero bytes.

Root Cause : 
  • It can happen due to BIP mount point getting full but still docgen in running and pushing invoice xml from brm to BIP temp . It leads to incorrect behavior of BIP causing formation of zero byte temp file at location :  /opt/shared/bip11g/xdo/tmp in BIP .
  • EDU (electronic document uploader) is another weblogic domain which retrieves invoice pdf from BIP and publish them to WCC ( web content centre) . It picks pdf based on http request recieved from BIP . No validation for file size is there. 
  • Then it stores the document in WCC. Data is stored in below six tables of WCC : 
  • If you check for file size in filestorage table , you will find it as 0 , which confirms that pdf has not data in it.
Resolution : 
  • Firstly increase the mount point size to reduce further occurrence of this issue.
  • Then extract all such invoice pdf using joins of above query.
  • Use WCC archiver tool to purge all those impacted invoice pdf . Also you can write a procedure with delete statement to purge data from for all six tables for incorrect pdfs.
  • WCC archiver tool is comparatively slow , better to go for manual SQL Procedure .
  • Then , you need to regenerate all such invoices.
  • XMLP_INVOICE_JOB is the default table of BIP which is being used to generate duplicate pdf as per OOTB behaviour of BRM-BIP. 
  • OOTB batch republish utility (startEDURepublishUtil.sh) of EDU at path : edu/17158021/files/services/industry/Communications/JavaServices/ebp uses above table to get invoice data and republish the pdf. 
  • The EBP solution provides a republish utility ‘startEDURepublishUtil.sh’ to republish batches processed by BI publisher that failed to upload invoices to WCC or are not there in WCC. The republishing utility requires as input data the different job IDs and Bill Numbers to republish the failed jobs. 

  • For republish multiple invoice in one go ,you need to prepare input file for all the invoices .
  • Input file should contain : BILL_NUMBER ,OUTPUT_ID
  • Below example of query to BIP scheduler tables to retrieve OUTPUT_ID and time of the creation of the entry for Bill Number ‘B1-12345678' ;
select xo.output_name as bill_no,xj.parent_job_id, xj.job_id, xo.output_id,xo.created
from xmlp_sched_job xj, xmlp_sched_output xo
where xj.job_id=xo.job_id and xo.output_name='B1-12345678'  
  • You can also use parent job id from above query for republishing all the invoice of that batch , as displayed in option 3 of above screenshot.

Comments

Post a Comment

Popular posts from this blog

cm core dump analysis

Go to the location of core file , ideally it should be there in $PIN_HOME/sys/cm Then , execute below command :   gdb cm <core file name > It will execute debugger for the core file . Now , put below command : Thread apply all bt T he output of above command will dump the stack frames for all the threads in a process You can select thread a according to your issue. use below command to select a thread. Thread 1 This will switch to thread 1 after switchover the stack for the current thread can be dummped with bt command . bt Once the back trace is dumped we can inspect each frame, in this case frame 0 looks interesting to us, by using below command : frame 0 frame <number>" command is use to dump the particular frame of stack trace. The command "list +" will show the source for the stack dump . list+
Read more

NO_RESPONSE file handling during rating in ECE and OCOMC

Implementing NO RESPONSE file handling for the ECE Cartridge Pack and Offline mediation controller (OCOMC) PROBLEM STATEMENT :  The ECE DC receives the CDR input stream, which includes the ECE response records from Oracle Communications Billing and Revenue Management Elastic Charging Engine and checks for CDR errors. The records for which no response is received from ECE, they are sent to NO_RESPONSE Directory of that particular ECE DC node. If the number of files increases in this no_response directory, then it is a critical situation and this needs to be handled properly. Such type of Revenue Leakage of the CDRs need to be appropriately routed to avoid causing losses to the Bahrain operator. BACKGROUND STUDY : Step 1 : Network Accounting Record (NAR) Collection Cartridge (CC). The NAR CC reads the no response CDR input stream from the No response directory. The output is made available for the No Response DC ASCII .   Step 2 : NO RESPONSE OCECE ASCII Distrib...
Read more

Script to create snapshot in Oracle ECE

In Oracle ECE patch set 3 , we need to take pricing snapshot before restart so that it can be recovered with same pricing data again. If snapshot is not taken then you will end up loosing all your pricing data in ECE cache. Then you have to go for PDC republish which may take more than 48 hrs (depending upon your price plan structure). To avoid this situation I would recommend you to schedule snapshot creation in crontab so that always you have backup . You can put a simple login to delete snapshot older than 30 days as per your business policy. Please find below steps to create pricing snapshot in oracle ECE using script . Create groovy with below lines of code . import java.lang.management.* import javax.management.ObjectName import javax.management.remote.JMXConnectorFactory as JmxFactory import javax.management.remote.JMXServiceURL as JmxUrl import groovy.swing.SwingBuilder import javax.swing.WindowConstants as WC import java.time.LocalDate import java.t...
Read more