/
Internal System Error in Work Order/Maintenance Contract Billing window after viewing greater than 5 invoices


Internal System Error in Work Order/Maintenance Contract Billing window after viewing greater than 5 invoices

Issue/Symptom/Question

Receiving an Internal System Error in the Work/Order Maintenance Contract Billing window when trying to view more than 5 invoices at a time

Error that shows in the PTI Error Log:

User Id: XXXX
Database: PROD.PENTA
Date/Time: 11/28/2018 09:15:23
Object: n_rpttrigger
Function: of_generateAndViewReports
SQL Error #: 29276
Error Text: ORA-29276: transfer timeout
ORA-06512: at "SYS.UTL_HTTP", line 1258
ORA-06512: at "PENTA.PK_SOAP", line 367
ORA-06512: at "PENTA.PK_SOAP", line 259
ORA-06512: at "PENTA.PK_SOAP", line 167
ORA-06512: at "PENTA.PK_SOAP", line 89
ORA-06512: at "PENTA.PK_RP
n_rpttrigger ( of_generateAndViewReports, generate )
n_rpttrigger ( of_generateReports, execute trigger )
n_rpttrigger ( of_executeTrigger, Call pk_pfw_manualReports.GenerateReports )
SQL Code: -1
SQL DB Code: 29276
SQL Error Text: ORA-29276: transfer timeout
ORA-06512: at "SYS.UTL_HTTP", line 1258
ORA-06512: at "PENTA.PK_SOAP", line 367
ORA-06512: at "PENTA.PK_SOAP", line 259
ORA-06512: at "PENTA.PK_SOAP", line 167
ORA-06512: at "PENTA.PK_SOAP", line 89
ORA-06512: at "PENTA.PK_RP

Applies To

Service Management > Invoicing > Work Order/Maintenance Contract Billing window

Viewing Work Order Invoice

Resolution/Fix/Answer


If you experience this problem please submit a Service Desk ticket and reference this article.  Please provide the following information in your Service Desk ticket:


  • User Id
  • How many invoices trying to view at a time
  • Time attempting to generate invoices