ERROR:Illegal function call

[venkatpavan]

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

 

[OllyC]

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

 

[venkatpavan]

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

 

[OllyC]

can you post the full database trace and audit log to the forum?

 

[venkatpavan]

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

 

[OllyC]

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.

 

[eyetry]

DataBase trace:
<385124-3599>: Returned status: (1002) No data found