INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Just to let you know...what a great site you have. I posted a pretty generic question yesterday and have had 8 responses already, anyway thanks again and keep up the good work..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > EAI Distributed/Component Programming > Mercator Software: Mercator solutions Forum

Return Code: 12 - Source not available

Read More Threads Like This One

mpt123 (Programmer)

12 Dec 07 15:07

I am a new bee here, I don't have training on Ascential DataStage TX, and trying to dig in the system to see how to result this problem.

I have the error in the CompoundSystem*.txt file
"Return Code:    12 - Source not available".

Do you know what "Source" which is refered here? Where is the possible place to look ...

*** ERROR:

System:        Process
Component:    Process
Map:        C:\Edi\Maps\Prod_CDI\Process.mmc
Start Time:    Tue Dec 11 11:51:12 2007
Instance:    2
Run Time:    32.4781 seconds
Return Code:    12 - Source not available

Input 1:    Database: -T
Input 2:    File: C:\Edi\Maps\Prod_CDI\..\INPUT\Del997.txt
Output 1:    File: C:\Edi\Maps\Prod_CDI\c2_out.dat

Audit File:    C:\Edi\Maps\Prod_CDI\Process.log

dstxaix (Programmer)

12 Dec 07 15:14

the following seems to be a problem. But I may be wrong. Others can probably answer better. What's with the 2 dots together? Dont know if that is a valid path.

CODE

Input 2: File: C:\Edi\Maps\Prod_CDI\..\INPUT\Del997.txt

mpt123 (Programmer)

12 Dec 07 15:21

I have the exactly the same Input 2 like above in the different server, and it works fine.

I got the new server, and had things copied to the new server, but got errors when running in the new box.

dstxaix (Programmer)

14 Dec 07 12:52

Yes. The directory name seems to work. I tried. Did you see if you have database connection happening properly? user id, password tablename etc...

eyetry (Programmer)

18 Dec 07 17:03

Look at your map log file. If it says it can't find input2 then confirm the path % fname. Otherwise check your DB trace file. It should give you a better idea as to why you're getting the message.

kashush (Programmer)

14 Jan 08 17:46

Where are your databaser parameters? Are you using an MDQ file or specifying all the parms on the command line? This looks wrong: Input 1: Database: -T

Show us the audit log instead of the launcher log.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Mercator Software: Mercator solutions