Solved

Error while chech-in

Posted on 2006-11-23
3
286 Views
Last Modified: 2013-12-16
I sent files to the configuration management team to check-in certain files.

They sent me this reply. Can you tell me what is wrong?

The files have been checked in. However conk_prod.sql could not be checked in and encountered following error.                

 

"ERROR [/home/nims/source/SCCS/Release223/congo/production/s.conk_prod.sql]: No newline at end of file 'conk_prod.sql' (de18)
dev.sh: Failed during delta""
0
Comment
Question by:aman_greval
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
tfewster earned 500 total points
ID: 18004542
Have you tried putting an extra carriage return at the end of the sql file?
0
 

Author Comment

by:aman_greval
ID: 18005354
Thanks  for your help, Yes it did work.

We do not get such errors everytime we check-in our files. Why did we encounter this error this time.

Please tell me what precautions we should take (during check-in) so that this error is not repeated in future.
0
 
LVL 21

Expert Comment

by:tfewster
ID: 18009344
You needs to look at how conk_prod.sql is created; If it's created by vi for example, vi will always append a newline character at the end of the last line, even if you didn't type <Return>. But if it's generated by a program, e.g.
   printf "sql statement" > conk_prod.sql
there may not be a newline.

A simple way of fixing text files might be:
for FILE in *.sql
do
  echo "" >> $FILE
done

(Even though we're appending "nothing" to the file, it creates the newline at the end. But _please_ make copies of your files first, in case this breaks them.)

0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question