I had got error message while I am executing the Data loading (file) through an workflow. Tried changing various parameters like Name of the file to load to Pre-process the file and added <%= vars.filename %> but I had found no positive result. The error is shown as follows.
PGS-220000 PostgreSQL error: ERROR: COPY from stdin failed: BAS-010006 Unknown error; rc=57 CONTEXT: COPY wkf1188162006_5, line 1
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @Aks333
I see that you are trying to read the directory as shared in the code and the data loading file is unable to pick the file from the location as it is unable to reach until the file rather the location gets pointed only until the directory.
Were you able to sort this issue and if not try to give the path followed by the filename to see if you are able to read the file now.
Hi @Aks333 ,
These are the possible reasons to fail in the data load:
- Malarrajan Sundarraj
Hi @Aks333 ,
Are you picking up the file from sftp or it is one off file from your local machine?
It will be difficult t solve the issue without looking at the config of the data loading activity.
If you are uploading a file from local make sure it is uploaded to server before running the workflow.
Cheers,
Deb
Views
Replies
Total Likes
Hi @Deb_Tripathy ,
Please find the below image about the configuration. I am uploading the file from my local machine ad had uploaded to the server. Kindly guide me for next steps.
Thanks,
Botla.
Views
Replies
Total Likes
Hi @Aks333 ,
Are you using and encrypted file? If so, you need to
1. select the "Pre Process File" option.
2. Use '|gpg --decrypt /x/x/xxx.pgp' command to decrypt
or
1. use it with a file collector activity.
2. select the "Pre Process File" option.
3. set <%= vars.filename %> in the command
Cheers,
Deb
Views
Replies
Total Likes
Hi @Deb_Tripathy & @msnavin ,
I had upload a .csv file which does not has any decryption key or not compressed and zipped. I had tried using above commands in "Pre Process File" option, but the result is still the same with same error flagging.
Do I need to change any settings in Workflow Properties as in below image?
Thanks in advance!
-Aks
Views
Replies
Total Likes
Hi @Aks333
If there is no encryption and Decryption, then we don't need to use the pre process file option.
Can you try using a file collector activity instead of uploading from local machine and in the data loading activity select the option, "specified in transition"?
Cheers,
Deb
Views
Replies
Total Likes
Hi @Aks333
I see that you are trying to read the directory as shared in the code and the data loading file is unable to pick the file from the location as it is unable to reach until the file rather the location gets pointed only until the directory.
Were you able to sort this issue and if not try to give the path followed by the filename to see if you are able to read the file now.
Hi @Aks333
Can you please let us know what type of pre processing are you planning to perform. Is it to do with unzip or decrypt related processing.
In case if this is decryption, do you already have the equivalent key added to the control panel.
Can you help share the preprocessing code that you were trying for which you were getting this error.
Thanks & Regards
Navin M. S.
Views
Replies
Total Likes