Question

Input string error

  • 6 February 2023
  • 4 replies
  • 107 views
M
Rank
Userlevel 2
Badge +5
  • MonaL
  • Sidekick (Partner)
  • 24 replies

 

Has anyone ever experienced the below error ? 

 

can anyone share a resolution that may have worked

Thanks

 

 

Errors when user tries to access any screen in IFS 

 

 

 

Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: For input string: "()1"

 

For input string: "()1"

   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)

4 replies

M
Rank
Userlevel 2
Badge +5

 

A
Rank
Userlevel 2
Badge +6

Hello @MonaL 

 

Do you get the error on the Lobby Page?

 

M
Rank
Userlevel 2
Badge +5

Hi Alexander

 

Errors appears when user tries to access any screen in IFS 

 

Thanks

Mona

A
Rank
Userlevel 2
Badge +6

Hi @MonaL ,

I am afraid we had a different issue, which appeared on the Lobby screen only. One of the datasources was returning NULLs and IFS could not handle this exception. We had to use NVL statement to convert Nulls to empty string or 0 depending on the result type.

 

Hope it helps, 

Alex

Reply


Terms & ConditionsCookie settings