icoggin
Community profile icoggin Level 1
Job title here
Location here
2 BADGES
Level 1

Level 1

Learn more
Joined the community 12-05-2021 6:50:24 AM
Offline
Top badges earned by icoggin
Customize the badges you want to showcase on your profile
Load File Activity: Uploading new file hangs with no response
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Classic
Hello all has anyone come across this one? I have plenty of space. Other files can load and this file looks like a completely ordinary 1.6k lines of tab delimited text. No column headers are very long or contain spaces or odd characters. If something was wrong with the file I would expect to see an error message from Campaign? I upload new file from local machine and all I then get is the Uploading "xxx.txt" message and nothing at all happens. If I click on "Confirm" the file has not been upload...

Views

16

Likes

0

Replies

1
Re: Adobe Campaign Load File. File structure change ignored
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
In case someone searches on error message codes. I also got this again and the different error message for this: BAS-010048 The field 'Day' with value '30-13-52' in '30-13-52' is too long. Maximum of 2 characters.Again the sort code field was automatically detected as Date and then was again not picking up my change to Text. I had copied the workflow, deleted and re-added the activity all to no avail. But I overcame the error when I deleted the sort code field and manually added in a field with ...

Views

15

Likes

0

Replies

0
Re: Adobe Campaign workflow Load File WDB-200001 error
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
Hi EwelinaKolacz. I do this on Adobe Campaign by clicking on Marketing Activities. I usally then change to List view ("change display mode" icon in the top right corner just below the user porifle icon) and I select on "workflow" in the tick boxes in the bottom left. Then enter in whatever the name is in the search box and hit enter. Once found, hover the mouse over the workflow and three icons appear on the right hand side. The middle of these is a "duplicate element" button (like two sheets of...

Views

23

Likes

0

Replies

0
Re: Adobe Campaign Direct Mail content want to display pe...
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Classic
Thanks LaurentLam. I was wondering if I would have to adopt such an approach. New double field created and used only for the segmentation. Old text field used in output. It works well.

Views

81

Likes

0

Replies

0
Re: Adobe Campaign workflow Load File WDB-200001 error
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
Hello all - an update this which may help anyone coming across this in future. I spoke to my Adobe help and he indicated that the workflow or part of it had been corrupted. The workaround was to duplicate the workflow and start using the new copy. I did this (and also in the copy deleted the Load File and added a new one) and when I Started that copied workflow it went succesfully past the block and no more WDB-200001 error. Then deleting the old workflow and renaming my copy back to the origina...

Views

94

Likes

0

Replies

2
Re: Adobe Campaign Load File. File structure change ignored
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
Thanks David It is definitely something like that. Clearing the cache and restarting will do the trick I expect. It eventually went away also after other edits and saves and restarts which I guess must have updated the cache.

Views

96

Likes

0

Replies

0
Adobe Campaign Direct Mail content want to display pence, i.e. 1 as 1.00, 2 as 2.00 etc.
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Classic
The input file has the field as a "0.00" (etc.) string but I need to check in a segmentation if the value is > 50. I cannot get the workflow to run without in the Load File activity, column definitions changing the field to as numeric. I use Float (double precision) to keep the decimals (i.e. the pence)Later I need to output this field into the Direct Mailing and need it displayed as "0.00" (etc.) again. I can use the function ToString on the field but it still displays as 0.So I was trying to u...

Views

120

Likes

0

Replies

2
Adobe Campaign workflow Load File WDB-200001 error
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
Hello all. I had a recent workflow stopped working after a while with an error (see below) on the Load file step which had previously worked. I’m pretty sure I did not change that process although I did change other ones in the workflow. I tried deleting the Load File step and adding a new one back in. No change to the error message.Error Message: WDB-200001 SQL statement 'INSERT INTO XtkWorkflowEvent (iEventIdentifier, tsCreation, tsProcessing, sActivity, iStatus, iKeepResult, sTransition, iWor...

Views

115

Likes

0

Replies

3
Adobe Campaign Load File. File structure change ignored
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
The issue I have seen several time is this. In a workflow, in the Load File process. I "Upload a new file from a local machine" this has UK sortcodes in it (e.g. in format 30-20-10). This file has about 60 columns so on the "File Structure" step I use the "Detect structure from new file" option.Then the UK bank sortcode field is auto-detected as a "Date". Before the Load File is saved and the workflow is run. I got to "Column Definition" and change the datatype for that sortcode field to "text"W...

Views

128

Likes

0

Replies

3
Re: Please suggest this error's solution: The schema for...
Avatar
Validate 1
Level 1
icoggin
Level 1

Likes

0 likes

Total Posts

10 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
icoggin
- Adobe Campaign Standard
This was a useful pointer. I had a workflow which did all sorts of enrichments and reconciliations, including one to Profiles. So on the face of it a different problem. What it was doing was using a reconciliation step to another schema. On the Reconciliation activity it had Identification option "Identify the document from the working data" checked and a target and join elements selected. After that I needed to have a later reconciliation step to profiles where it's identification option "Ident...

Views

87

Likes

0

Replies

0
Likes given to