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

Dataflow stopped running and no longer possible to run (OAS 7.0)

Closed
57
Views
6
Comments
User_YIBD4
User_YIBD4 Rank 1 - Community Starter
edited December 2 in Oracle Analytics Cloud and Server

Hi,

We have 7 dataflows that have been running for year, but suddenly they just stopped. All of they orignanly schedulled to run daily until july 2025. When i look at job history i just seems as they have stopped running without any error message, and when i manually try to run them the job starts but never ends (and does not leave any error message). Even when i try to create a new flow that just reads 10 lines from the database an should save them as at filebased datasett, the same happens…

Any suggestions on what have happened? There have been no changes on the flow since the last successful run (july 3).

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod

    https://community.oracle.com/products/oracleanalytics/kb/articles/69-asking-in-community-vs-logging-an-sr-how-to-choose

    There must be something that changed, either in the software, or the output destination.
    I think a deeper dive into the logs and details will be required.

  • User_YIBD4
    User_YIBD4 Rank 1 - Community Starter

    Nothing has been changed i OAS due to holiday, but today i found this error i the enterprise manager log viewer: OBI-02306 OBI_SAW_SVS_RPC_ERROR:Datamodel service request error: 403

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @User_YIBD4 ,

    Error 403 denotes that access to the requested resource is forbidden.

    Are you still able to access the datasets used as inputs for the data flow (you should test it using the user who owns/runs the data flow)?

    Are you using connection-based datasets as inputs? If so, I would double-check that connection details/credentials are still valid, and that you can access them.

  • User_YIBD4
    User_YIBD4 Rank 1 - Community Starter

    I now also found this error in the logs before the jobs stopped.

    All jobs just moved data from one part of the database (EBS instance) to another schema i the same database, and all conneteions seems find. I am able to run the source datasetts that is baseed on sql queries.

    I am not able to find any other error messeages reated to the jobs i EM

  • User_WQKHO
    User_WQKHO Rank 3 - Community Apprentice

    Hi @User_YIBD4 ,

    Did you find a fix? got the same issue and the logs contain no information at all

    Thanks

  • Christian Berg -Oracle
    Christian Berg -Oracle Mod

    @User_WQKHO this thread was abandoned. If would be best if you open a new thread in which you explain your situation in detail with as much information, screenshots, and logs as possible.

This discussion has been closed.