search

capitalone / giraffez

User-friendly Teradata client for Python
https://capitalone.github.io/giraffez
Apache License 2.0
108 stars 35 forks source link

load.py fails at line 258 #67

Closed clantroopss closed 4 years ago

clantroopss commented 5 years ago 
Connection: Connecting to data source 'db1' ...
Connection: Connection to 'db1' established successfully.
BulkLoad: Dropping table 'P_ADA.BM_TEMP_ROI_CUSTOMER_TEST1_wt'...
BulkLoad: Dropping table 'P_ADA.BM_TEMP_ROI_CUSTOMER_TEST1_log'...
BulkLoad: Dropping table 'P_ADA.BM_TEMP_ROI_CUSTOMER_TEST1_e1'...
BulkLoad: Dropping table 'P_ADA.BM_TEMP_ROI_CUSTOMER_TEST1_e2'...
BulkLoad: Executing ...
  source      => "againutf8.txt"
  output      => "P_ADA.BM_TEMP_ROI_CUSTOMER_TEST1"
BulkLoad: Initiating Teradata PT request (awaiting server)  ...
BulkLoad: Teradata PT request accepted.
BulkLoad: Processed 100001 rows
Connection: Closing Teradata connection ...
BulkLoad: Closing Teradata PT connection ...
BulkLoad: Teradata PT request complete.
Connection: Connection to 'db1' closed.
Traceback (most recent call last):
  File "c:\anaconda3\lib\site-packages\giraffez\io.py", line 146, in __iter__
    yield next(self.reader)
StopIteration

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "c:\anaconda3\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "c:\anaconda3\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Anaconda3\Scripts\giraffez.exe\__main__.py", line 9, in <module>
  File "c:\anaconda3\lib\site-packages\giraffez\__main__.py", line 25, in main
    MainCommand().run()
  File "c:\anaconda3\lib\site-packages\giraffez\core.py", line 80, in run
    args.run(args)
  File "c:\anaconda3\lib\site-packages\giraffez\commandline.py", line 431, in run
    exit_code = load.from_file(args.input_file, delimiter=args.delimiter, null=args.null, quotechar=args.quote_char, parse_dates=args.parse_dates)
  File "c:\anaconda3\lib\site-packages\giraffez\load.py", line 258, in from_file
    for i, line in enumerate(f, 1):
RuntimeError: generator raised StopIteration

(base) C:\MyPythonScript\Automation\excel>
clantroopss commented 5 years ago

The file is in 'utf-8' format with delimiters as '|' and it does read the data field name matches the one in database but then the connection closes

ChrisRx commented 5 years ago

What version of Python are you using? and could you run the command again with the flags -vv added?