Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

ACX Data Loading error

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

20-04-2019

We are loading in sales data via ACX file manager and Adobe SFTP. Currently works in PROD. We updated the data by adding 1 more column in the file. Testing in UAT and in UAT the Data Loading activity fails every time before it processes the file. Even AC support is having trouble with it.

The file is a .gz

We are pre-processing it with gpg --decrypt <%= vars.sourceFile %> | gunzip -c <%= vars.sourceFile %>, but it doesn't even get ar enough to pick up the file.

Any thoughts?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

22-04-2019

delete the file from history and then restart the file manager workflow.

hope you don't have lot of file otherwise you may have an issue with the number of file in your sftp and you will need to tweak this number in the JS

Thanks

Answers (6)

Answers (6)

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

22-04-2019

Can you share a screenshot of the error message? What if you remove the <%= vars.sourceFile %> after the gunzip -c? Did you make sure the file name is the same ? it needs to respect the regex in your file mapping

1738070_pastedImage_0.png

David

Avatar

Avatar
Validate 1
Level 1
RodneyLewis
Level 1

Likes

0 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile

Avatar
Validate 1
Level 1
RodneyLewis
Level 1

Likes

0 likes

Total Posts

15 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile
RodneyLewis
Level 1

25-02-2020

Hi, I'm on V7 and I'm having a similar issue... My GPG is not working at all though... 

 

While I'm trying to troubleshoot, I noticed one of the files "In process" in the File history of the File Mapping. 

 

Has anyone figured out how to stop this?

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

23-04-2019

I just forced it using the play button (in the ACX workflow) and it corrected itself on the next run. Everything is running now.

Avatar

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

23-04-2019

Can you check if the file is still existing in your sftp or in the path of the file mapping?

This error happened when ACX  file manager is note able to read the file last modified date.

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

23-04-2019

That worked! I didn't see the trash icon the first time in that window.

However, I now have an error on the ACS.FileManager

04/23/2019 9:58:07 AM BAS-010034 Unable to change date of file '/myFilePath/organizationSizeMap_20181119121613.txt'.

Thoughts?

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

22-04-2019

Looking at it closer today,

I looked at the File Manager workflow and it was giving me the error

04/22/2019 10:33:06 AM    jsxCallWorkflows    Skipping '20190421_061502-INCREMENTAL-transaction_lines-000000_0.gz' because a file for this feed is currently being processed.

I was able to find in the FileMapping/File History that there is a file that is stuck in "In process" status from 10/16/2018.

This makes sense as to why the File Manager JS is telling me the most recent file is being skipped since there is another file stuck in the process. And also why the Data loading activity kept erroring out because the file provider was not providing a file to it in the JS.

Any idea on how to unstick that file?