Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

ORA-00904: : invalid identifier in bi publisher

Received Response
201
Views
1
Comments
Samir Samiraee
Samir Samiraee Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

ORA-00904: : invalid identifier in bi publisher

Content

I got invalid identifier in oracle bi publisher and i cannot to find which identifier is invalid!!!

pls. help me to learn how to find reasons like this...

tnx...

i have only this info about my error:

[052217_011432304][][EXCEPTION] java.sql.SQLException: ORA-00904: : invalid identifier

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)

        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)

        at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)

        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)

        at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)

        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3026)

        at oracle.apps.xdo.dataengine.XMLPGEN.writeDefaultGroup(Unknown Source)

        at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source)

        at oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)

        at oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)

        at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)

        at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown Source)

        at oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)

        at oracle.apps.xdo.servlet.data.bind.SQLBoundValue11.callDataEngine(SQLBoundValue11.java:702)

        at oracle.apps.xdo.servlet.data.bind.SQLBoundValue11.processData(SQLBoundValue11.java:499)

        at oracle.apps.xdo.servlet.data.bind.SQLBoundValue11.getXML(SQLBoundValue11.java:825)

        at oracle.apps.xdo.servlet.ReportContextImplV11.getReportXMLData(ReportContextImplV11.java:408)

        at oracle.apps.xdo.servlet.CoreProcessor.process(CoreProcessor.java:212)

        at oracle.apps.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:81)

        at oracle.apps.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:678)

        at oracle.apps.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:255)

        at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:270)

        at oracle.apps.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:250)

        at oracle.apps.xdo.servlet.XDOServlet.doGet(XDOServlet.java:178)

        at oracle.apps.xdo.servlet.XDOServlet.doPost(XDOServlet.java:201)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:86)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)

        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)

        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)

        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500)

        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:744)

Answers

  • Samir Samiraee
    Samir Samiraee Rank 2 - Community Beginner

    hi,

    I found my answer...  I forgot to grant bi-user to execute (in my problem) my function.... that was only that...

    don't forget grant to your bi-user to access to your objects...