E1: 42: Sales Invoice Print (R42565) Returns Blank PDF and Error OS400QL010 FetchSQLRow:Fetch failed in the JDE.LOG (Doc ID 2950752.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

After upgrading from 8.12 to 9.2, if a user tries to Reprint an Invoice (R42565) on the iSeries AS/400 Enterprise Server in their DV environment (TESTDTA), the program returns a Blank PDF stating “No Data Selected”. If the same test is done on the iSeries AS/400 in their Pristine (PS920DTA) environment, the Invoice is printed on the Report PDF.

• This occurs only if there are no records in the Sales Detail History (F42119) file.
• The client does not purge to the Sales Detail History (F42119) file at the time of Sales Update (R42800).

ERRORS IN JDEDEBUG LOG
The UNION ALL (F4211 and F42119) SELECT statement in the Logs for the DV Environment (TESTDTA) show the following database specific errors indicating failure to fetch the records as shown below:

If this SQL Statement is executed from the SQL prompt in the iSeries AS/400, it does return records and does not return Errors in the Debug Logs.

Steps to Duplicate:

1. Sign into the DV920 environment.
2. In Customer Service Inquiry (P4210) find a sales order that has already been processed through Sales Update (R42800).
   1. Verify in Databrowser the order still exists in the Sales Detail (F4211) file.
   2. Verify in Databrowser the order DOES NOT exist in the Sales Detail History (F42119) file.
3. Run a Reprint Version of Sales Invoice Print (R42565) with Debug Logs activated and Data Selection on the closed order.
   1. Default Tab Option #5 (Prevent Next Status Update) = 1 (Prevent next status update).
   2. Default Tab Option #6 (Prevent A/R Number Assignment) = 1 (Prevent).
4. The job appears to complete normally.
   1. The Report PDF is blank and says “No data selected”.
5. Retrieve the JDEDEBUG log.
   1. Search for “OS400QL010”
   2. Verify the message OS400QL010 - FetchSQLRow:Fetch failed.
   3. Verify the message “JDB9900172 - Failed to execute db fetch Exiting Fetch with Failure”.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.