Skip to Content
author's profile photo Former Member
Former Member

DTP Error - "SQL Error: 904-"

Dear Experts,

I am experiencing "SQL Error: 904-" error when loading data to an open hub destionation from infocube using DTP's. The load is terminated with the following message "[IBM][CLI Driver][DB2] DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF"

and "SQL Error: 904-.

We are on SPS 13.

Please advice.

Thanks,

Gnana

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 09:24 PM

    Gnana,

    Unavailable resource -904 is a DB2 sql error code. This means one of the resource is either held by someother resource or either the source or destination is not created yet.

    Here is what you can do.

    1. Check and make sure both source and destination are active.

    2. Check the DTP is active?

    3. Check your destination table/object is not locked by other resource.

    Start you r extraction and if you get the error again. Look at the dump and see what is teh resource that is not available. That is the key for your issue. You may need to bring in your DBA and/or BASIS folks to resolve this issue.

    Goodluck,

    Alex(Arthur Samson)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2008 at 12:09 AM

    In continuation ,is your cube having noncumulative KF and open hub using those ,in such case pls check this Note 548553 - Open hub 3.0A Support Package 12/3.0B Support Package 5,might get some insight.

    Sanity check with other infocube the open hub to check for error pattern

    Hope it Helps

    Chetan

    @CP..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 04:00 PM

    Our DBA resolved the issue.

    Thanks,

    Gnana

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.