DTP Error - "SQL Error: 904-"

[Former Member]

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

[Former Member · Accepted solution]

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)

[Former Member]

Our DBA resolved the issue.

Thanks,

Gnana

[Former Member]

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..