New Member Needs Help

[jmanj]

Thanks in advanced for those who can help me in my problem. Just a few months ago my company decided to changed ERP software to manage our business needs. One of this tools is
Mercator 5.0 in which I only have 3 days training. I have already created few simple inbound maps and works pretty well. The help in designer is the only real help I could get as far as documentation.

Now I'm being tasked to create an outbound map that will involved creating a database(oracle) query. I have so far been successful in running the maps thru my client PC using SQL*net to connect to the Oracle database. However, when I build the map for our sun/solaris server and run it thru the command line, it is giving me a "Source not available" message and the map exited. I am not sure what is happening here. I'm not a UNIX expert either. I called help desk and the fellow I talked to has no exprience with databases and queries. Could it be a problem with connectivity to the
Oracle server? As far as I know the $ORACLE_HOME variable is
not setup yet. Could this be the problem? Any help and or
suggestion is greatly appreciated.

Thanks.

Mannie

 

[janhes]

You need to check your logs to see which source is not available. Source is usually for an input card not output.

 

[jmanj]

janhes,

Thanks for your reply. I have only one input source and that is
a database query(.mdq). Everything is fine when tested from the
client PC but not in the sun server. Here's the SourceCommand adapter override:

-ID1 "'-DBTYPE ORACLE -CONNECT LDEV1 -MDQ APCHECKS.mdq
-DBNAME CHECKS -QUERY CBQRY'"

My first suspect is the database adapter in the sun server has
not been properly installed. I have no knowledege if the
ORACLE environmental variables has been defined.

Any more thoughts from you GURUS out there???

Thanks.

Mannie

 

[jlchelles]

You should try to put a trace file to see the detail of the database transaction (-TRACE mydbtrace.txt) as you are using a mdq, some default settings like userid or password could be wrong.

 

[jmanj]

jlchelles,

Thanks for the tip. I put a trace and I'm getting a return code
of 27 which means "Failed to load shared libraries". Then the
next message was "No such file or directory".

I'm getting confused now because I'm pretty sure the mercator
shared libraries are loaded in the LD_LIBRARY_PATH variable.

Any more help on this?? Thanks so much.

Mannie

 

[kashush]

Can you attach the *.dbl file. That would be very usefull.

 

[jmanj]

Kashush,

Thanks for your reply. I found out that the person who installed mercator in the server did not do a full install
therefore we have some missing utility files for oracle.

I let you know what happens when we reinstall the product.
i.e., if we can find the CD.

Mannie