Question

Error while setting Baseline for Project

  • 15 June 2023
  • 2 replies
  • 76 views
SMANUEL
Rank
Userlevel 4
Badge +9

Dear Mates,

 

The following error occurred while setting Baseline for Project

 

Logs

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-30926: unable to get a stable set of rows in the source tables

ORA-30926: unable to get a stable set of rows in the source tables

ORA-06512: at line 19

ORA-06512: at "IFSAPP.ACTIVITY_ELEMENT_API", line 3174

ORA-06512: at "IFSAPP.ACTIVITY_ELEMENT_API", line 3338

ORA-06512: at "IFSAPP.ACTIVITY_API", line 5709

ORA-06512: at "IFSAPP.ACTIVITY_API", line 5716

ORA-06512: at "IFSAPP.PROJECT_API", line 8493

ORA-06512: at "IFSAPP.PROJECT_API", line 8509

ORA-06512: at line 9

at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)

at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)

at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)

at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)

--- End of inner exception stack trace ---

at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)

at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)

at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()

at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()

at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLSelectCommandReader.Read(Boolean prepare)

at Ifs.Fnd.Data.ADONetProvider.FndAPCommand.ExecuteDbDataReader(CommandBehavior behavior)

2 replies

M
Rank
Badge

As i know it’s oracle Database error message. It indicates that there is a problem with retrieving a stable set of rows in the source tables, leading to an error in the program execution. The error initially occurred at line 19, but it was raised by a procedure or function named "IFSAPP.ACTIVITY_ELEMENT_API." The error was then propagated to line 3174 of the same procedure or function. From there, it propagated to line 3338 within the same "IFSAPP.ACTIVITY_ELEMENT_API" procedure or function. The error was subsequently caught at line 5709 in the "IFSAPP.ACTIVITY_API" procedure or function. It then propagated to line 5716 within the same "IFSAPP.ACTIVITY_API" procedure or function. Finally, the error was caught at line 8493 in the "IFSAPP.PROJECT_API" procedure or function, and then propagated to line 8509 within the same procedure or function. The overall error stack trace ends at line 9, which is where the error was initially raised.

GAWIUK
Rank
Userlevel 2
Badge +4

Hi SMANUEL,

I wonder if it would be worth running a refresh project connections on all the objects in this project  to see if there are any data problems with the PCRE. 

 

Gareth

Reply


Terms & ConditionsCookie settings