MRI DB2 Report Status Failed end of file character
search cancel

MRI DB2 Report Status Failed end of file character

book

Article ID: 256910

calendar_today

Updated On:

Products

MRI Db2 for z/OS Report

Issue/Introduction

Uploaded a MRI DB2 Report to the Datacenter and got status Failed with the following error message. 
  
>>>
Db2tools service failed with error: JSON 1 is 
invalid - Unexpected token  in JSON at position
113994 
<<<

The position 113994 was at the end of the file.

Environment

Release : 1.0

MRI Db2 for z/OS Report 

Resolution

The extra line/character  was introduced by the File Transfer program when the MRI DB2 Report JSON data set was transferred from the z/OS system to the PC.

To avoid this kind of problems the File Transfer program settings have to be double checked and be sure it is configured there is not any extra/character introduced as the end of file. 
  
For example in the IBM Personal Communications emulator program you can remove this extra character with 'set RemoveEOFChar=Y' parameter in ws-profile.  
  
The manual workaround was to delete manually this extra line/character and the MRI DB2 Report got the status Complete