ODBC stage error

amarnadh0203 · Post by **amarnadh0203** » Mon Aug 04, 2008 3:27 pm

I have a job design like below:

ODBC Stage ----> Sequential file Stage

ODBC stage with "BULK INSERT" and "SELECT 'ok' as RSLT"

Sequential file Stage with input link for 'RSLT'.

the job completes with FINISH status but logs a Fatal error listed below:

Fatal Error: ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv..

Can some one help to get rid off the Fatal error in the log.

chulett · Post by **chulett** » Mon Aug 04, 2008 3:33 pm

Post the entire message. Double-click on it to see it.

amarnadh0203 · Post by **amarnadh0203** » Mon Aug 04, 2008 4:33 pm

Thas only message i am getting ..nothing else....

chulett · Post by **chulett** » Mon Aug 04, 2008 5:37 pm

Ok, so it's the "only" message but is that the complete message? I can't believe it literally ends with "[ODBC SQL Serv..". Can you please try double-clicking on it to get an Event Detail dialog box, then clicking "Copy" and then paste the result into a post here?

amarnadh0203 · Post by **amarnadh0203** » Tue Aug 05, 2008 6:03 am

ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

thats all i can see in the event log window...

gshankar007 · Post by **gshankar007** » Tue Aug 05, 2008 6:15 am

What you need to do is

1. Check the ODBC Stage Mappings (verify the authenication)
2. Include the sequential file stage (not sure what r u trying to do here)
3. Check what have u mapped in the input and output stages of sequential file

run these steps and let me know the outcome

chulett · Post by **chulett** » Tue Aug 05, 2008 6:48 am

amarnadh0203 wrote:ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

thats all i can see in the event log window...

One last time for grins...

Didn't ask what you can see, I asked you to click on 'Copy' and then paste everything from the clipboard (Ctrl-V) to a message here.

amarnadh0203 · Post by **amarnadh0203** » Tue Aug 05, 2008 9:32 am

Project:IS_Risk_Control (tedshdu2:31539)
Job name:CopyOfP001_SP_Job
Event #:17
Timestamp:8/5/2008 7:58:03 AM
Event type:Fatal
User:n431c7
Message:
ODBC_Enterprise_3,0: [DataDirect][ODBC SQL Serv

Sorry for being over confident... here it is what i have got from event log.

chulett · Post by **chulett** » Tue Aug 05, 2008 9:45 am

Weird. That's way too fatal, it didn't even have time to write the entire message out it seems. Best to open a case with your official Support provider for this, if you haven't done so already.

amarnadh0203 · Post by **amarnadh0203** » Tue Aug 05, 2008 9:58 am

Thank you very Much...