TPT script: error while executing TPT script

Tools
Enthusiast

TPT script: error while executing TPT script

Hi,

Iam new to Teradata and need to develop TPT script to load data from file to teradata table.

I have developed the script and while running iam getting the error like:

TPT19404 pmOpen Failed Requested file not found(4)

TPT19304 Fatal error opening file

Could any one help on this.. Its urgent.

Thanks,

Devallu Y

16 REPLIES
Supporter

Re: TPT script: error while executing TPT script

So the message states that the file does not exists 

did you check the file name in the script?

beside this you would need to share the tpt script...

Enthusiast

Re: TPT script: error while executing TPT script

Hi,

Thanks for reply..

I have checked the file and able to open the same in same path mentoned in TPT script.

For security reasons i can't share the TPT script.

is there any other reason for this error.

Thanks,

Devallu Y

Supporter

Re: TPT script: error while executing TPT script

TPT installation might be incomplete.

Can you run 

tbuild -V


Enthusiast

Re: TPT script: error while executing TPT script

I am able to run

tbuild -v <script>

Teradata Employee

Re: TPT script: error while executing TPT script

"tbuild -v <script>" is not valid syntax.

If you are providing the script, use the -f option.

If you would like further help on this you are going to have to provide the script, or at least portions of the script. Just remove all sensitive information. At a minimum, provide the text of the Data Connector Operator definition so that we can make sure you are providing all of the necessary information.

Are you using the "DirectoryPath" attribute in addition to the "FileName" attribute?

-- SteveF
Enthusiast

Re: TPT script: error while executing TPT script

Hi,

I have given full path along with file as below

VARCHAR FileName='/path/filename'

Supporter

Re: TPT script: error while executing TPT script

can you run and share

tbuild -V

UPPERCASE V to get the version info
Enthusiast

Re: TPT script: error while executing TPT script

Hi,

I have run tbuild -V

version is 13.10.00.08

Supporter

Re: TPT script: error while executing TPT script

In this case it is as feinholz stated
"If you would like further help on this you are going to have to provide the script, or at least portions of the script. Just remove all sensitive information. At a minimum, provide the text of the Data Connector Operator definition so that we can make sure you are providing all of the necessary information."