Skip to main content
Question

Input string error

  • Feb 6, 2023 12:30 PM UTC
  • 4 replies
  • 218 views

Forum|alt.badge.img+5

 

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)
  • Feb 6, 2023 12:32 PM UTC

 


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • Feb 25, 2023 10:11 AM UTC

Hello @MonaL 

 

Do you get the error on the Lobby Page?

 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Partner)
  • Feb 25, 2023 2:25 PM UTC

Hi Alexander

 

Errors appears when user tries to access any screen in IFS 

 

Thanks

Mona


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • Feb 26, 2023 7:05 AM UTC

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