hash file error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Thu Dec 14, 2006 9:45 am
hash file error
Hi,
When I try to create a hash file. I am getting this error:
Hashed_File_1.DSLink2: DSD.UVOpen Invalid Account name -
I created a new account in manager. When I open hash file and I check
account option, it shows me the new account that I created. I selected that one and the file name.
When I run it its giving me this error.
Any help will be appreciated.
When I try to create a hash file. I am getting this error:
Hashed_File_1.DSLink2: DSD.UVOpen Invalid Account name -
I created a new account in manager. When I open hash file and I check
account option, it shows me the new account that I created. I selected that one and the file name.
When I run it its giving me this error.
Any help will be appreciated.
Re: hash file error
Isn't Account supposed to be the Project you are working in ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Precisely how did you "create a new account"? Which client? It can't be done in Manager by any means of which I am aware (at least not without creating a routine).
Precisely how did you create the hashed file? (Note, it's "hashed", not "hash" file.) What were the settings on the Stage tab of the Hashed File stage?
And precisely what are you doing when the error you report is emitted?
Precisely how did you create the hashed file? (Note, it's "hashed", not "hash" file.) What were the settings on the Stage tab of the Hashed File stage?
And precisely what are you doing when the error you report is emitted?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 14
- Joined: Thu Dec 14, 2006 9:45 am
[quote="chulett"]How did you 'create a new account' in the Manager? ...[/quote]
I went to Manager and open the project that I was running my job into, then created a new table definition(ABC).
After this I went to designer and in my hash file I gave that category name and selected my hash file definition(ABC). I selected the option Create file in my hashed file stage. When I ran the job, I got this error.
I went to Manager and open the project that I was running my job into, then created a new table definition(ABC).
After this I went to designer and in my hash file I gave that category name and selected my hash file definition(ABC). I selected the option Create file in my hashed file stage. When I ran the job, I got this error.
Ok. A 'table definition' is not an 'account'. The Account in a Hashed File stage is synonymous with the Project the job that uses it is running in. This would typically be left blank to indicate the 'current' project.
Your table definition should be either used with the 'Load' option on the Columns tab or dragged from the Repository Browser and dropped onto the link to the Hashed File. Either way will get you those columns in the stage, which is what I *assume* you are trying to accomplish.
ps. You have the 'Disable BBCode' option enabled / checked, which is why the quote in your post came out wrong. Uncheck it.
Your table definition should be either used with the 'Load' option on the Columns tab or dragged from the Repository Browser and dropped onto the link to the Hashed File. Either way will get you those columns in the stage, which is what I *assume* you are trying to accomplish.
ps. You have the 'Disable BBCode' option enabled / checked, which is why the quote in your post came out wrong. Uncheck it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 14
- Joined: Thu Dec 14, 2006 9:45 am
I started all over again. In designer, in hash file stage, I left the account name blank so it will take current project name by default, then I specify filename and checked create file option, job ran fine. But I can't find the hash file that it created. I went to Manager and checked, can't find the hash file.
[quote="chulett"]Ok. A 'table definition' is not an 'account'. The [b]Account[/b] in a Hashed File stage is synonymous with the [b]Project[/b] the job that uses it is running in. This would typically be left blank to indicate the 'current' project.
Your table definition should be either used with the 'Load' option on the Columns tab or dragged from the Repository Browser and dropped onto the link to the Hashed File. Either way will get you those columns in the stage, which is what I *assume* you are trying to accomplish.
ps. You have the 'Disable BBCode' option enabled / checked, which is why the quote in your post came out wrong. Uncheck it.[/quote]
[quote="chulett"]Ok. A 'table definition' is not an 'account'. The [b]Account[/b] in a Hashed File stage is synonymous with the [b]Project[/b] the job that uses it is running in. This would typically be left blank to indicate the 'current' project.
Your table definition should be either used with the 'Load' option on the Columns tab or dragged from the Repository Browser and dropped onto the link to the Hashed File. Either way will get you those columns in the stage, which is what I *assume* you are trying to accomplish.
ps. You have the 'Disable BBCode' option enabled / checked, which is why the quote in your post came out wrong. Uncheck it.[/quote]
Hi,datastagequestions wrote:I started all over again. In designer, in hash file stage, I left the account name blank so it will take current project name by default, then I specify filename and checked create file option, job ran fine. But I can't find the hash file that it created. I went to Manager and checked, can't find the hash file.
chulett wrote:Ok. A 'table definition' is not an 'account'. The Account in a Hashed File stage is synonymous with the Project the job that uses it is running in. This would typically be left blank to indicate the 'current' project.
Your table definition should be either used with the 'Load' option on the Columns tab or dragged from the Repository Browser and dropped onto the link to the Hashed File. Either way will get you those columns in the stage, which is what I *assume* you are trying to accomplish.
ps. You have the 'Disable BBCode' option enabled / checked, which is why the quote in your post came out wrong. Uncheck it.
If you want to use, created hashed file as lookup or some other job to process the data then, check the option "Use directory Path" of Stage tab and give the path.
For giving the path there are two cases.
1) If your server is running on NT box then you have to give the NT box storage Path. Ex:- c:\data\Hash
2)If your server is running on UNIX box then you have to give the UNIX box storage path for your project. Ex:- \data\hash
Put the fine name in the In Input Tab. After running the job you will find the File above specified path with give filename.
Then you can see the file in respected folder.
Hope this is what your looking .
The Manager will not point to the hashed file location, it will contain the metadata for that hashed file if you decide to load it. You can import the metadata from the physical hashed file, as noted in this thread the file you created will be located in the project directory.datastagequestions wrote:... But I can't find the hash file that it created. I went to Manager and checked, can't find the hash file...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>