Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR:Illegal function call

Status
Not open for further replies.

venkatpavan

Programmer
Feb 18, 2006
42
SG
Hi,

I'm getting following error when trying to insert into database table
<Message>Illegal function call</Message>

Please let me know if anyone have idea about this error.

Thanks,
Venu.V
 
Where do you see the error - is it in the audit log?
Was does the Mercator database trace file say?

Also database are you calling, what platform are you on and what version of Mercator?

cheers,
Olly
 
Thanks for the response...Here are the Details

I'm getting this error in Map Audit log,In Database log file it is showing inserts are happening successfully and they areinserting successfully but file is failing due to this error.

USing DB2 platform is Unix AIX and 8.0.2 mercator version.

Thanks,
Venu.V
 
can you post the full database trace and audit log to the forum?
 
Hi, Below is the Audit log

<ExecutionSummary MapStatus="Error" mapreturn="76" ElapsedSec="46.557" BurstRestartCount="0">
<Message>Adapter failed to put data on output</Message>
<CommandLine>/mercator2/6.5/fl/maps/cobc/COBC.mmc</CommandLine>

<SourceReport card="1" adapter="File" bytes="17234844" adapterreturn="0">
<Message>Data read successfully</Message>
<Settings>/mercator2/6.5/fl/split/in_big/PCOB.BA.N0362.PARTB.CLAIMS.3676160</Settings>
<TimeStamp>14:45:09 July 25, 2007</TimeStamp>
</SourceReport>

<TargetReport card="1" adapter="Sink" bytes="1163" adapterreturn="0">
<Message>Success</Message>
<TimeStamp>14:45:18 July 25, 2007</TimeStamp>
</TargetReport>

<TargetReport card="2" adapter="Sink" bytes="614" adapterreturn="0">
<Message>Success</Message>
<TimeStamp>14:45:18 July 25, 2007</TimeStamp>
</TargetReport>

<TargetReport card="3" adapter="DB" bytes="233" adapterreturn="-20">
<Message>Illegal function call</Message>
<Settings>-UPDATE OFF -MDQ /mercator/mdq/HIPAA_AIX_prod.mdq -DBNAME PTRK01A -TABLE RETAIN.IN_TRACKING_TB -T</Settings>
</TargetReport>

<TargetReport card="4" adapter="DB" bytes="80" adapterreturn="-20">
<Message>Illegal function call</Message>
<Settings>-UPDATE ONLY -MDQ /mercator/mdq/HIPAA_AIX_prod.mdq -DBNAME PTRK01A -TABLE RETAIN.IN_TRACKING_TB -T</Settings>
</TargetReport>

<TargetReport card="5" adapter="DB" bytes="162" adapterreturn="-20">
<Message>Illegal function call</Message>
<Settings>-UPDATE OFF -MDQ /mercator/mdq/HIPAA_AIX_prod.mdq -DBNAME PRPT01A -TABLE INTERNAL.CLAIM_TRAFFIC_TB -T</Settings>
</TargetReport>

<TargetReport card="6" adapter="Sink" bytes="2" adapterreturn="0">
<Message>Success</Message>
<TimeStamp>14:45:18 July 25, 2007</TimeStamp>
</TargetReport>

<TargetReport card="7" adapter="Sink" bytes="3" adapterreturn="0">
<Message>Success</Message>
<TimeStamp>14:45:18 July 25, 2007</TimeStamp>
</TargetReport>

DataBase trace:
<385124-3599>: Returned status: (1002) No data found
<385124-3599>: Cleaning up and closing the transaction...
<385124-3599>: Transaction commit succeeded.
<385124-3599>: Returned status: (0) Success

 
What happens if you run a simple map with just one database output card?
can you try removing the UPDATE OFF too?
can you try combining cards 3 and 4 (they both write to the same table)?

I was expecting more information in the trace, so possibly there's a problem with the DB2 adapter or client.
 
DataBase trace:
<385124-3599>: Returned status: (1002) No data found


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top