Solved

Error while chech-in

Posted on 2006-11-23
3
283 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
  • 2
3 Comments
 
LVL 20

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 20

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
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.

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now