INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Exception when insert into DB (GPF file created)

Exception when insert into DB (GPF file created)

(OP)
I'm using Mercator 6.7 to transform EDI file and put data in a Oracle 10G database.
I've got a map, it has two output cards to insert header and detail data, in DB tables HEAD and LINES. Map is working correctly. Now, I've added sevaral fields to LINES table, and without any modification on typetree map works on test environment, but when I deploy map into production environment, sometimes (not always) I get this error:

<TargetReport card="2" adapter="DB" bytes="151" adapterreturn="-2">
<Message>Exception occurred</Message>
</TargetReport>

When it occurs, a GPF is created with this content:
----------------------------------------------------
-- GPF report - Thu Jan 24 09:02:20 2013

Exception code: 0xc0000005
Exception address: 0x77e5bb3c
Number parameters: 2

Connection: 0001e4f2
Type: DB
Operation: Put
Command:
---------------------------------------------------

I've DB trace files enabled, but error doesn't write anythig in these files.


Can anybody help me? How can I know what's happening?

Thanks

RE: Exception when insert into DB (GPF file created)

you need to look at the DB trace file. It will give you a better, more relevant, return code.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close