Solved

Error while chech-in

Posted on 2006-11-23
3
287 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

626 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