I guess, if soft link not created then it will completed with error ann there will not be any log file.
So some other problem is there.
Can you show the code which you used in that program?
Please post a screenshot of the concurrent executable setup.
Also post the output of "ls -la shell_script_name".
echo "Starting mutl_otm_file_loader.prog"
# Use above line when using this as conc program for user password
echo "PROG FILE"
#echo "USER" $USER
# Remove Old Data and create blank file
echo -n > mutl_otm_to_ebs_files.dat
# Generate New Data File with list of XML files
for i in `ls *.xml`
echo "FILE" $i
echo $i >> mutl_otm_to_ebs_files.dat
# Load List of File Names to Table
sqlload userid=$USER control=$MUTL_TOP/bin/mutl_otm_to_ebs.ctl data=$MUTL_TOP/data/import/OTM/mutl_otm_to_ebs_files.dat log=mutl_otm_to_ebs_files.log bad=mutl_otm_to_ebs_files.bad
echo "Log File" $FILE.log
sqlload userid=$USER control=$MUTL_TOP/bin/mutl_otm_to_ebs.ctl data=$MUTL_TOP/data/import/OTM/mutl_otm_to_ebs_files.dat
is it sqlload or sqlldr?
I guess it is sqlldr
We are actually migrating from 11i to R12 and the same code is working fine in 11i.
Even if it is sqlldr in R12 i should see the previous ECHO command results in the log file isn't it?
AS you can see i am not getting anything in the log file.
I suspect something is wrong with the soft link hence the actual shell script is not at all executed.
May I know how you created Soft link?
Also provide output for below.
ls -altr your_prog_file*
We need without .prog only.
Create soft link by using below command and check
ln -s -f $FND_TOP/bin/fndcpesr mutl_otm_file_loader
But i don understand what you mean by without .prog only.
there must be a two files for Host concurrent program right?
same file name one without .prog(creates symbolic/soft link)
and other with .prog (actual shell script file which needs to be executed)
You used ln -s -f $FND_TOP/bin/fndcpesr mutl_otm_file_loader only right?
I mean -f is also there right?
before that make sure mutl_otm_file_loader.prog has all permissions.
Then open putty and go to custom top (where you mutl_otm_file_loader.prog file there) and then run ln -s -f $FND_TOP/bin/fndcpesr mutl_otm_file_loader command.
Hope this will resolve this issue.
It didnt work either.
By any chance fndcpesr file could be corrupted, if yes how to check that?
Do one thing...
Just rename mutl_otm_file_loader to mutl_otm_file_loader_09-05-2016
Then ran the schell script conc program. it should give error with out log file.
Then create soft link. Then rerun the program. This time conc program should complete normal.
Check and let me know.