nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

dashboard error and html

3b27f78f-ec4b-4545-a5c8-52ead265ae47

OBIEE 11g
I created dashboard page. When users invite the page, users see error code.

However, if they press apply button, they can get correct value from dashboard page.

I want to modify this situation.

For example,

When dashboard page was loaded, apply button is pressed automatically by html or java script.

If you have a solution, please help me on this.

Thank you.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

What's the error code? What's the error message? Screenshot? Have you looked at the OBIPS logs? You want to script around with HTML or JS instead of searching WHAT the problem actually is?!

How To Ask Questions The Smart Way

3b27f78f-ec4b-4545-a5c8-52ead265ae47

error code is below.

If users click prompt apply button, error is disappeared.

View Display Error

Odbc driver returned an error (SQLExecDirectW).

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 46047] Datetime value TIMESTAMP ''2016-04-01 00:00:00'' from TIMESTAMP ''2016-04-01 00:00:00'' does not match the specified format. (HY000)

[Deleted User]


3b27f78f-ec4b-4545-a5c8-52ead265ae47 wrote:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 46047] Datetime value TIMESTAMP ''2016-04-01 00:00:00'' from TIMESTAMP ''2016-04-01 00:00:00'' does not match the specified format. (HY000)

You're defaulting stuff the wrong way check our prompts and dashboard construction with regards to data types used and hwo they're instantiated.

3b27f78f-ec4b-4545-a5c8-52ead265ae47

When I click prompt apply button, error code is disappeared and all data is correct.

So I think...

when dashboard page is loaded, system clicks prompt apply button automatically by using html code or java script code.

are you able to create html code for auto click prompt apply button?

Gianni Ceresa

Why do you want to make something complicated when the simple solution exists?

It's how Christian said: you are setting a default value in your prompt or your analysis and you are doing it in the wrong way.

Check what are you setting and where and fix it, using the right format. If you say that by applying the prompts after selecting a value the error disappear you can probably just set a default value to your prompt and the problem is solved. If it's what you do it seems you are doing it in the wrong way, so fix that and your error is gone.

[Deleted User]

That's what she I said

Upcoming Event

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Implementation Patterns, Security, and Best Practices
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…

Top Leaders