| Subject: | TNA Timesheet File not processing menu "File Manager -> Watch" |
| Summary: | 1. Problem Details
TNA Timesheet File not processing menu "File Manager -> Watch"
2. Error Message (screenshot of the error)
ID: 104101 Date: Jul 1 2024 10:48AM User: NT SERVICE\SQLSERVERAGENT Module: TimesheetImportTI001ReadFile Machine: LINKAU-AZURE Status: Error
Log Message: Cannot bulk load. The file "E:\WebSites\LinkSOFT-EdgeBusinessSolutions\App_Data\FileManager\TNA Timesheet\1005 - Investment Fiji\TI001\Processing\Access is denied." does not exist or you don't have file access rights. Script: BULK INSERT [LT_ESS_TimesheetImport_BCP_TI001_TNATI00120240701104840443_512E673C81CF4A1DABA16ACA526C9D68] FROM 'E:\WebSites\LinkSOFT-EdgeBusinessSolutions\App_Data\FileManager\TNA Timesheet\1005 - Investment Fiji\TI001\Processing\Access is denied.' WITH ( FIRSTROW=2, FIELDTERMINATOR =',', ROWTERMINATOR ='\n' )
Log Data: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LT_ESS_TimesheetImport_BCP_TI001_TNATI00120240701104840443_512E673C81CF4A1DABA16ACA526C9D68]') AND type in (N'U')) DROP TABLE [dbo].[LT_ESS_TimesheetImport_BCP_TI001_TNATI00120240701104840443_512E673C81CF4A1DABA16ACA526C9D68]
CFD: T1=FileName,T2=TableName,LogData=SQL
T1: E:\WebSites\LinkSOFT-EdgeBusinessSolutions\App_Data\FileManager\TNA Timesheet\1005 - Investment Fiji\TI001\Processing\Access is denied.
T2: LT_ESS_TimesheetImport_BCP_TI001_TNATI00120240701104840443_512E673C81CF4A1DABA16ACA526C9D68
3. Environment Details
- URL: https://www.link247.com.au/LinkSOFT-EdgeBusinessSolutions
- Company: 1005
- Version: 15.30.240604P.GA
|
| Audit Notes: | Edited by sanjay on 15/07/24 14:06. |
| 01 Jul 2024 | 10:55AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 02-07-2024 10:50 PM Time Taken: 1.00 Notes: ETC extended from: 01/07/2024 to 02/07/2024 |
| Bula Team,
We connected to the Environment and diagnosed as below;- Verified all TNA setup
- Verified the File that was being uploaded to the folder from the menu "File Manager -> Watch"
No issues have been identified in the file however it keeps failing with messages as Cannot bulk load. The file "E:\WebSites\LinkSOFT-EdgeBusinessSolutions\App_Data\FileManager\TNA Timesheet\1005 - Investment Fiji\TI001\Processing\Access is denied."
We will get our technical team to diagnose further and advise.
Regards
Vineshwar Prasad |
|
| 15 Jul 2024 | 02:00PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-07-2024 01:58 PM Time Taken: 6.00 Notes: ETC extended from: 02/07/2024 to 16/07/2024 |
| Hi Vineshwar, Apologies for the delay. The azure environment is highly secured, and security changes must be thoroughly evaluated before they are applied. We have added more access to the Watch folder. Can you attempt this TNA "Watch" folder import in both Training and Production environments. Thx. |
|
| 15 Jul 2024 | 02:14PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-07-2024 06:06 PM Time Taken: 32.00 |
| The issue is occurring because of changes made on Azure environment to secure folders from "Cross Client Access". The following changes have been implemented: - Each site files have access to its own container using a user account named: "LinkSOFT-XXX" where XXX is the client abbreviation
- Clients cannot read (or access) other clients site files
- Folder permissions are managed through the user account defined on the application pool
- Each Client has their own "application pool" in IIS
To resolve this issue, the "Authenticated users" group was given "Execute" access to the Site Files "Root", followed by "Write/Delete" access to the "Site Specific" "File Manager". This results in each site having "delete" access to its own "Watch" folder so it can move completed files into the "Archive" folder. |
|