Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

dashboard error and html

Received Response
11
Views
6
Comments
3b27f78f-ec4b-4545-a5c8-52ead265ae47
3b27f78f-ec4b-4545-a5c8-52ead265ae47 Rank 1 - Community Starter

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.

or

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

Thank you.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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

  • 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]
    [Deleted User] Rank 2 - Community Beginner
    
    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.

  • 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?

  • 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]
    [Deleted User] Rank 2 - Community Beginner

    That's what she I said