we want to Upgrade 4.5 to 4.9, but can't use templates.

[EricTsuei]

Hi,
We have used Tactic 4.5 for a  long time.
Recently I  want to evaluate 4.9 to see if we can do some upgrades.
We got some problems when installing.
PSQL can't use the default locale(Chinese), install.py reported lots of errors. only can use English Locale to install PSQL.
Now we can use 4.9 on windows server 2019. PSQL 14, Python3.7

But we have encountered our first problem,4.9 can not use 4.5 project template.
report this error message:

Error: current transaction is aborted, commands ignored until end of transaction block


   

Our 4.5 server's database is too big now, backup .sql file size over 10GB, so we don't want to upgrade from old 4.5 database. we want to make a new server.
So, How to use 4.5 project template?

[EricTsuei]

I used win32_service.py debug mode to get some error trace, please wee below:

Code:

Starting TACTIC v4.9.0.a01 ...

[23/Aug/2022:15:14:14] ENGINE Bus STARTING
[23/Aug/2022:15:14:14] ENGINE Serving on http://127.0.0.1:8100
[23/Aug/2022:15:14:14] ENGINE Bus STARTED
127.0.0.1 - - [23/Aug/2022:15:14:25] "GET /tactic/ HTTP/1.1" 200 109357 "" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"
127.0.0.1 - - [23/Aug/2022:15:14:26] "POST /tactic/default/Api/ HTTP/1.1" 200 119658 "http://192.168.13.119/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"
127.0.0.1 - - [23/Aug/2022:15:14:27] "POST /tactic/default/Api/ HTTP/1.1" 200 863827 "http://192.168.13.119/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"
127.0.0.1 - - [23/Aug/2022:15:14:41] "GET /tactic/admin/ HTTP/1.1" 200 109576 "http://192.168.13.119/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"
127.0.0.1 - - [23/Aug/2022:15:14:43] "POST /tactic/default/Api/ HTTP/1.1" 200 863827 "http://192.168.13.119/tactic/admin/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"
[23/Aug/2022:15:15:19] HTTP
Traceback (most recent call last):
  File "C:/Program Files/Southpaw/tactic/src\pyasm\command\command.py", line 267, in execute_cmd
    ret_val = cmd.execute()
  File "C:/Program Files/Southpaw/tactic/src\pyasm\prod\service\api_xmlrpc.py", line 287, in execute
    self2.results = exec_meth(self, ticket, meth, args)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\prod\service\api_xmlrpc.py", line 319, in exec_meth
    results = meth(self, ticket, *new_args, **kwargs)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\prod\service\api_xmlrpc.py", line 5930, in execute_cmd
    Command.execute_cmd(cmd)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\command\command.py", line 267, in execute_cmd
    ret_val = cmd.execute()
  File "C:/Program Files/Southpaw/tactic/src\tactic\command\project_template_cmd.py", line 274, in execute
    self.import_template()
  File "C:/Program Files/Southpaw/tactic/src\tactic\command\project_template_cmd.py", line 404, in import_template
    installer.execute()
  File "C:/Program Files/Southpaw/tactic/src\tactic\command\plugin.py", line 954, in execute
    self.import_manifest(nodes)
  File "C:/Program Files/Southpaw/tactic/src\tactic\command\plugin.py", line 1116, in import_manifest
    Schema.get(reset_cache=True)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\biz\schema.py", line 1392, in get
    search = Search("sthpw/schema")
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 146, in __init__
    self.search_type_obj = SearchType.get(search_type)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 6508, in get
    search_type = cls._get_data(base)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 6777, in _get_data
    results = select.execute(sql)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\sql.py", line 1860, in execute
    self.cursor.execute(statement)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:/Program Files/Southpaw/tactic/3rd_party/python3/site-packages\cherrypy\_cprequest.py", line 628, in respond
    self._do_respond(path_info)
  File "C:/Program Files/Southpaw/tactic/3rd_party/python3/site-packages\cherrypy\_cprequest.py", line 687, in _do_respond
    response.body = self.handler()
  File "C:/Program Files/Southpaw/tactic/3rd_party/python3/site-packages\cherrypy\lib\encoding.py", line 219, in __call__
    self.body = self.oldhandler(*args, **kwargs)
  File "C:/Program Files/Southpaw/tactic/3rd_party/python3/site-packages\cherrypy\_cpdispatch.py", line 54, in __call__
    return self.callable(*self.args, **self.kwargs)
  File "C:/Program Files/Southpaw/tactic/3rd_party/python3/site-packages\cherrypy\_cptools.py", line 374, in default
    body = subhandler(*(vpath + rpcparams), **params)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\prod\service\api_xmlrpc.py", line 602, in new
    cmd.execute_cmd(cmd)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\command\command.py", line 342, in execute_cmd
    ExceptionLog.log(e)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\exception_log.py", line 58, in log
    exception_log = SObjectFactory.create("sthpw/exception_log")
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 6926, in create
    search_type_obj = SearchType.get(search_type)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 6508, in get
    search_type = cls._get_data(base)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\search.py", line 6777, in _get_data
    results = select.execute(sql)
  File "C:/Program Files/Southpaw/tactic/src\pyasm\search\sql.py", line 1860, in execute
    self.cursor.execute(statement)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

[23/Aug/2022:15:15:19] HTTP
Request Headers:
  Remote-Addr: 127.0.0.1
  HOST: 192.168.13.119
  USER-AGENT: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36
  ACCEPT: */*
  ORIGIN: http://192.168.13.119
  REFERER: http://192.168.13.119/tactic/admin/
  ACCEPT-ENCODING: gzip, deflate
  ACCEPT-LANGUAGE: zh-CN,zh;q=0.9,en;q=0.8
  COOKIE: login_ticket=70075dd7f7a2ccc8b3a; sidebar_status=%7B%22%2FAdmin_views%2Fuser_admin%22%3Atrue%2C%22%2FAdmin_views%2Fproject_admin%22%3Atrue%7D
  X-FORWARDED-FOR: 192.168.13.214
  X-FORWARDED-HOST: 192.168.13.119
  X-FORWARDED-SERVER: localhost
  CONNECTION: Keep-Alive
  Content-Type: text/xml
  Content-Length: 1349
127.0.0.1 - - [23/Aug/2022:15:15:19] "POST /tactic/default/Api/ HTTP/1.1" 200 335 "http://192.168.13.119/tactic/admin/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/104.0.0.0 Safari/537.36"

[EricTsuei]

I installed 4.8 and use the same project template.
give me this error:
   
also can't use