When I tried to run the below command to virtual table statistics creation, received the mentioned error.
python hanacleaner.py -k HANACLEANERKEY -vs true -vt HISTOGRAM -vn 40 -vtt RECORD_COUNT -vto SIMPLE -os true
Error message:
Traceback (most recent call last):
File "hanacleaner.py", line 2494, in
main()
File "hanacleaner.py", line 2434, in main
[nVTs, nVTsOptimized] = create_vt_statistics(vtSchemas, maxColumnsOfVT, defaultVTStatType, maxRowsForDefaultVT, largeVTStatType, otherDBVTStatType, ignore2ndMon, sqlman, logman)
File "hanacleaner.py", line 1307, in create_vt_statistics
statType = defaultVTStatType if getNbrRows(vt[0], vt[1], sqlman) <= maxRowsForDefaultVT else largeVTStatType
File "hanacleaner.py", line 1015, in getNbrRows
return int(run_command(sqlman.hdbsql_jAQaxU + " "SELECT COUNT(*) FROM "+schema+"."+table+" "").strip(' '))
ValueError: invalid literal for int() with base 10: ''
When I tried to run the below command to virtual table statistics creation, received the mentioned error.
python hanacleaner.py -k HANACLEANERKEY -vs true -vt HISTOGRAM -vn 40 -vtt RECORD_COUNT -vto SIMPLE -os true
Error message:
Traceback (most recent call last):
File "hanacleaner.py", line 2494, in
main()
File "hanacleaner.py", line 2434, in main
[nVTs, nVTsOptimized] = create_vt_statistics(vtSchemas, maxColumnsOfVT, defaultVTStatType, maxRowsForDefaultVT, largeVTStatType, otherDBVTStatType, ignore2ndMon, sqlman, logman)
File "hanacleaner.py", line 1307, in create_vt_statistics
statType = defaultVTStatType if getNbrRows(vt[0], vt[1], sqlman) <= maxRowsForDefaultVT else largeVTStatType
File "hanacleaner.py", line 1015, in getNbrRows
return int(run_command(sqlman.hdbsql_jAQaxU + " "SELECT COUNT(*) FROM "+schema+"."+table+" "").strip(' '))
ValueError: invalid literal for int() with base 10: ''