Skip to main content
Question

Input string error

  • February 6, 2023
  • 4 replies
  • 165 views

Forum|alt.badge.img+5
  • 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

Forum|alt.badge.img+5
  • Author
  • Sidekick (Partner)
  • 24 replies
  • February 6, 2023

 


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 32 replies
  • February 25, 2023

Hello @MonaL 

 

Do you get the error on the Lobby Page?

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Partner)
  • 24 replies
  • February 25, 2023

Hi Alexander

 

Errors appears when user tries to access any screen in IFS 

 

Thanks

Mona


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 32 replies
  • February 26, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings