Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00910 - specified length too long for its datatype when scheduling...

519017May 28 2008 — edited May 30 2008
All,

I receive the following error when attempting to schedule workbooks in my new EUL. This EUL is one of two on our Production server (EUL_US and EUL_MV).

"ORA-00910 - specified length too long for its datatype"

I should note that some workbooks do schedule with no errors but most do incur this error. Same reports in our EUL_US End User Layer schedule fine. The EUL_MV scheduled reports Complete but with this error (and no data returns). I should also mention that running them manually through Plus, Viewer and Desktop do not yield this error - it's only when scheduling.

Does anyone have an idea of how I could track this down to see the object and column it is referring to? Something in the EUL possibly? Maybe in a view or materialized view being called in our EUL?

Let me know.
Thanks,
Michael

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 27 2008
Added on May 28 2008
#business-intelligence-applications, #business-intelligence-foundation, #discoverer
8 comments
1,206 views