We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

QRY5052 - Query run failed. &28 records added to member &16. ( OS/400 )

QRY5052 - Query run failed. &28 records added to member &16. ( OS/400 )

BAL Application Log Documentation   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.
SAP E-Book


Message : QRY5052
Query run failed. &28 records added to member &16.

Message Long Text :

Cause . . . . . : At least one field used to select/omit the next record contains incorrect data, data which could not be converted, or an unexpected null value; or subselect processing for an SQL view returned other than a single record. The data added to the file could be incomplete.
Recovery . . . : To determine which fields are in error, remove field selections (if any), and run the query (or SQL SELECT statement) with output to display. Query for i5/OS fills a numeric field with plus (+) signs if the field contains incorrect decimal or floating-point data, or if the field is affected by a divide by zero error. Query for i5/OS fills a non-numeric field with plus (+) signs if the field has a conversion error running to the display or if the field contains data that is not correct. However, the conversions needed to run to the display may differ from those needed to put records in the member.
In Query for i5/OS, go to the Select Output Type and Output Form display, then type a 1 in the Output type prompt or press F5 on any display to see the report.
In interactive SQL, use PF13 to enter the Interactive SQL Session Services panel. Choose the Change Session Attributes option, then take the SELECT Output Device option to make the change.
Or, to display the output using the RUNQRY command, you can specify *DISPLAY on the OUTTYPE parameter.
After you have determined which fields are in error in which records, make any changes necessary to avoid the bad data or failing conversions and run the query again.

Message File : QQRYMSG
Library Message File : QSYS2924


General Material Data   CPI1466 during Backup  
This documentation is copyright by IBM.

Length: 3240 Date: 20201028 Time: 154030     sap01-206 ( 2 ms )