Static data - newline character


I am evaluating deployment suite for Oracle. After 10 minutes of playing with source control I am happy about the speed but I encountered an Error and now the project is broken for me (error reported).

Error: Failed to compare Static data: HeadToWorking: OCI-22062 invalid input string [WHERE RQT_ID=385075]

Looking at the generated .csv file I can see the what's causing the problem (most probably)

 "9","30","Project initiatives","Project initiatives",null,"APPL_INTREQUESTS.INTREQUESTS_WEB_API.REQUEST_LIST_URL(385075)","15","lightbulb","SELECT COUNT(*) FROM APPL_INTREQUESTS.WOR_WOS_REQ_WAITING_VIEW

This shall be one line, but the data in one of the columns contains a newline character (before WHERE RQT_ID ...).

Am I missing some configuration parameter, have I approached the static data wrong or your product cannot simply support data with newline characters because of CSV file format limitations?

Best Answer

  • Alex BAlex B Posts: 1,084 Diamond 4
    Hi @petrv,

    The issue is going to be that the newline is a Carriage return / Line Feed (CR/LF) rather than just an LF.  In these cases, Source Control for Oracle can't distinguish the end-of-line character of a single record from the end of the line in a multi line field.

    What source control system are you using?  If you are using Git, this may be related to a setting for how the end-of-line character is treated by the Git repository. We have seen in some cases that the file in the repository is set with LF characters in the multiline field, but it is returned with CRLF due to a setting in Git.  If this seems like the case I can provide more information on the setting.

    Otherwise, you will need to ensure that the newline character for multi-line strings is only a LF where the end of line for a single record is still CRLF.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.