Skip to main content
Question

Permissions Error on External File Assistant - File Type is not available

  • November 17, 2023
  • 7 replies
  • 447 views

Forum|alt.badge.img+8
  • Do Gooder (Customer)
  • 29 replies

 Some users are receiving an error message “The File Type is not available” when trying to use a certain file type in External File Assistant. 

I have confirmed that changing to a different permission set resolves this issue, but I have not been able to pinpoint what needs to be granted in the orignial permission set.

How can I determine what projection or other grant needs to be added to the permission set to resolve the issue? 

I have tried using the debugger but the projection listed (ExternalFileAssistantHandling) is not the issue.

 



 

11:36:49 INFO - REQUEST method "GET"
11:36:49 INFO - REQUEST uri "https://abc.def.com:12345/main/ifsapplications/projection/v1/ExternalFileAssistantHandling.svc/GetDefaultFileTypeInfo(Company='DHP',FileType='ExtPosPayCheck',ProcessOption=IfsApp.ExternalFileAssistantHandling.ProcessOptionsEnum'Online')?odata-debug=json"
11:36:49 INFO - REQUEST protocol "HTTP/1.1"
11:36:49 INFO - REQUEST headers {"Host":"abc.def.com:12345","sec-ch-ua":"\"Not_A Brand\";v=\"8\", \"Chromium\";v=\"120\", \"Microsoft Edge\";v=\"120\"","Accept":"application/json;odata.metadata=full;IEEE754Compatible=true","X-Requested-With":"XMLHttpRequest","Accept-Language":"en-US,en;q=0.5","sec-ch-ua-mobile":"?0","User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0","sec-ch-ua-platform":"\"Windows\"","Sec-Fetch-Site":"same-origin","Sec-Fetch-Mode":"cors","Sec-Fetch-Dest":"empty","Referer":"https://abc.def.com:12345/main/ifsapplications/web/assistant/ExternalFileAssistant/Assistant;path=0.2026593824.1876323749.2098603466","Accept-Encoding":"gzip, deflate, br","Cookie":"XSRF-TOKEN=M5UP-MXQX-WJCB-C6E5-8KDZ-IM51-Y8Q5-XCGF; JSESSIONID=vJTeSE5Ie1G9QQNcJY-tLJKus8-_W6QOjzHpqyHQfNl7VmnMuqzE!-1182627715; _WL_AUTHCOOKIE_JSESSIONID=CXcu1hwkJSnkvg9Cd9nq","ECID-Context":"1.00jQFBTH04LFw0zzjr0Afz4cndy3zNIz90003F80008Ug;kXjE","Connection":"Keep-Alive","X-Forwarded-For":"10.10.48.155","X-WebLogic-KeepAliveSecs":"30","X-WebLogic-Request-ClusterInfo":"true","x-weblogic-cluster-hash":"wzCbc8umKb0cV2bauve9kqrjGm4"}
11:36:49 INFO - RESPONSE status {"code":"500","info":"Internal Server Error"}
11:36:49 INFO - RESPONSE headers {"OData-Version":"4.0","Content-Type":"application/json"}
11:36:49 INFO - RESPONSE body "{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":[{\"code\":20105,\"message\":\"ORA-20105: ExternalFileAssistantHandling.INVFILETYPE: The File Type is not available\"}]}}"
11:36:49 ERROR - INVFILETYPE - (Server Application Error): The File Type is not available Database error occurred. Contact administrator. undefined
11:36:49 ERROR - Command error: (INVFILETYPE) - The File Type is not available, details: "[{\"code\":20105,\"message\":\"ORA-20105: ExternalFileAssistantHandling.INVFILETYPE: The File Type is not available\"}]" undefined
11:36:49 DEBUG - CMD(1): Error: The File Type is not available

 

7 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

Hi @hreavis,

Please try granting ExternalFileAssistantHandling projection as per the error message. If the projection is already granted, then check if there is a difference in the access levels between the permission sets(Custom/Full etc.). 

Hope this helps!


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 29 replies
  • November 21, 2023

@Charith Epitawatta ExternalFileAssistantHandling is already fully granted - every entity action is granted and there are no Projection Action Grants for that projection.

Do you have any other suggestions?

Thanks!

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 13 replies
  • February 28, 2024

Is there an update on this error? 

We get one step further in the process but have the same error. Permissions for ExternalFileAssistant are fully granted.

 

 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 29 replies
  • February 28, 2024

@SAXBBSOT We are still experiencing this issue.


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 13 replies
  • March 27, 2024

We found the cause for our error “File Type XXX is not available for the user”.

In our case it was not a permission error. In IFS cloud it’s not possible to crerate new external file Types. See for details: https://community.ifs.com/finance-financials-42/create-a-new-external-file-type-30279?tid=30279&fid=42

The error is only triggered when we use file types we created in APPS 10. System defined file types are working. This means we have to adjust our workflow by using the default file types but separate with file Template per company instead of a file type per company.

The topic is also already on the idea wall: 

https://community.ifs.com/ideas/possibility-to-create-your-own-external-file-types-43875?tid=43875&postid=159347#post159347

 


Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 16 replies
  • April 15, 2025

Hello

We are experiencing the same issue: we migrated from IFSv8 vers Cloud Remote R24R2.

We have the External file templates for IFS v8

 

And when we login with IFSAPP, or any other user we get

 

What is the process to solve this issue ?  System defined file types are working. 

Help Greatly appreciated.

Best Regards


Forum|alt.badge.img+12
  • Hero (Customer)
  • 266 replies
  • April 17, 2025

I personally had to do a full customization to re-enable the creation and use of user-defined (i.e. not system defined) file types.

 

Several things needed to be done to both enable the creation of a new file type, file type template (especially an input template, haven’t checked output), and then using said file in the Assistant.

 

If there’s interest I can share how I accomplished it but unless you have access to studio developer and you’re willing to create a customization and associated delivery, you’re probably out of luck.


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