Customers may have file or library names that contain the “.” character in the name.  When attempting to download a library name that contains the “.” character the following SQL error is encountered:

[Micro Focus] [RUMBA Data Access]  Syntax error or access violation. SQLSTATE   = 42961[ : The relational database is not the same as the current server.  SQLCODE=  -114.  :  Relational Database XXXX                 SSSSSSSS is not the same as server.  

 In the above example error XXXX would be the characters preceding the “.” character in the library name and the SSSSSSSS would be the system name.

If attempting to download both a file name and library name that contain the “.” character the following SQL error is encountered:

[Micro Focus] [RUMBA Data Access]  Syntax error or access violation. SQLSTATE   = 42601[ : Invalid character in SQL statement.  SQLCODE=  -104.  : Token  .  was not valid.  VALID TOKENS: FOR WHICH FETCH ORDER UNION EXCEPT OPTIMIZE

To resolve this problem the file name and/or library name should be enclosed in quotes.  For example, if you are downloading a file named CUST.MAST from a library named TEST.XFR using the RUMBA File transfer GUI, you would need to add quotations as follows:

“TEST.XFR”/”CUST.MAST”

The file and library names are specified on the right hand side of the RUMBA File Transfer GUI.  The SQL statement will now be parsed correctly and the file transfer will successfully complete.