DTP Error - "SQL Error: 904-"

[#1]

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]

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