advertiser_strategy_operate.log 12 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
  1. 01/24/2021 03:54:48 PM INFO raw data from request is b'{"marketingGoal":"2","customCrowd":"1","scheduleType":"SCHEDULE_START_END","scheduleTimes":"SpecifiedTImePeriod","strategyBudget":"","bidType":10,"ocpxActionType":2,"campaignName":"222","groupName":"22","gender":0,"platformOs":0,"clickTrackUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz","impressionUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz","actionbarClickUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz","creativeCategory":null,"actionBarText":"22","imageCnt":10,"description":"22","useAppMarket":"1","appIds":[622955],"sceneId":[6,7,3],"scheduleTime":"111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110","siteId":[{"appId":622955,"siteId":""}],"beginTime":"2021-01-23","endTime":"2021-02-02","agesRange":[24,18,31,41,50],"region":[],"convertId":"","excludePopulation":[],"population":[10099095],"strategyState":"1","appStore":["huawei","oppo","vivo","xiaomi","meizu","smartisan"],"accountId":23212,"strategyName":"55"}'
  2. 01/24/2021 03:54:48 PM INFO *************************************** NEW REQUEST ***************************************
  3. 01/24/2021 03:54:48 PM INFO raw data from request is {'marketingGoal': '2', 'customCrowd': '1', 'scheduleType': 'SCHEDULE_START_END', 'scheduleTimes': 'SpecifiedTImePeriod', 'strategyBudget': '', 'bidType': 10, 'ocpxActionType': 2, 'campaignName': '222', 'groupName': '22', 'gender': 0, 'platformOs': 0, 'clickTrackUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'impressionUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'actionbarClickUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz', 'creativeCategory': None, 'actionBarText': '22', 'imageCnt': 10, 'description': '22', 'useAppMarket': '1', 'appIds': [622955], 'sceneId': [6, 7, 3], 'scheduleTime': '111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110', 'siteId': [{'appId': 622955, 'siteId': ''}], 'beginTime': '2021-01-23', 'endTime': '2021-02-02', 'agesRange': [24, 18, 31, 41, 50], 'region': [], 'convertId': '', 'excludePopulation': [], 'population': [10099095], 'strategyState': '1', 'appStore': ['huawei', 'oppo', 'vivo', 'xiaomi', 'meizu', 'smartisan'], 'accountId': 23212, 'strategyName': '55'}
  4. 01/24/2021 03:54:49 PM ERROR Traceback (most recent call last):
  5. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  6. cursor, statement, parameters, context
  7. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  8. cursor.execute(statement, parameters)
  9. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  10. result = self._query(query)
  11. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  12. conn.query(q)
  13. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  14. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  15. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  16. result.read()
  17. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  18. first_packet = self.connection._read_packet()
  19. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  20. packet.raise_for_error()
  21. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  22. err.raise_mysql_exception(self._data)
  23. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  24. raise errorclass(errno, errval)
  25. pymysql.err.OperationalError: (1054, "Unknown column 'schedule_type' in 'field list'")
  26. The above exception was the direct cause of the following exception:
  27. Traceback (most recent call last):
  28. File "E:\ai_ads\advertiser_strategy_operate.py", line 68, in post
  29. df.to_sql(name="ctop_ai_kuaishou_advertiser_strategy", con=engine, if_exists='append', index=False)
  30. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  31. method=method,
  32. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  33. method=method,
  34. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  35. raise err
  36. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  37. table.insert(chunksize, method=method)
  38. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  39. exec_insert(conn, keys, chunk_iter)
  40. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  41. conn.execute(self.table.insert(), data)
  42. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  43. return meth(self, multiparams, params)
  44. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  45. return connection._execute_clauseelement(self, multiparams, params)
  46. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  47. distilled_params,
  48. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  49. e, statement, parameters, cursor, context
  50. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  51. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  52. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  53. raise exception
  54. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  55. cursor, statement, parameters, context
  56. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  57. cursor.execute(statement, parameters)
  58. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  59. result = self._query(query)
  60. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  61. conn.query(q)
  62. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  63. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  64. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  65. result.read()
  66. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  67. first_packet = self.connection._read_packet()
  68. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  69. packet.raise_for_error()
  70. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  71. err.raise_mysql_exception(self._data)
  72. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  73. raise errorclass(errno, errval)
  74. sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'schedule_type' in 'field list'")
  75. [SQL: INSERT INTO ctop_ai_kuaishou_advertiser_strategy (schedule_type, schedule_times, strategy_budget, bid_type, ocpx_action_type, campaign_name, group_name, gender, platform_os, click_track_url, impression_url, actionbar_click_url, creative_category, action_bar_text, image_cnt, description, use_app_market, app_ids, scene_id, schedule_time, site_id, begin_time, end_time, ages_range, region, convert_id, exclude_population, population, strategy_state, app_store, account_id, strategy_name, campaign_type) VALUES (%(schedule_type)s, %(schedule_times)s, %(strategy_budget)s, %(bid_type)s, %(ocpx_action_type)s, %(campaign_name)s, %(group_name)s, %(gender)s, %(platform_os)s, %(click_track_url)s, %(impression_url)s, %(actionbar_click_url)s, %(creative_category)s, %(action_bar_text)s, %(image_cnt)s, %(description)s, %(use_app_market)s, %(app_ids)s, %(scene_id)s, %(schedule_time)s, %(site_id)s, %(begin_time)s, %(end_time)s, %(ages_range)s, %(region)s, %(convert_id)s, %(exclude_population)s, %(population)s, %(strategy_state)s, %(app_store)s, %(account_id)s, %(strategy_name)s, %(campaign_type)s)]
  76. [parameters: {'schedule_type': 'SCHEDULE_START_END', 'schedule_times': 'SpecifiedTImePeriod', 'strategy_budget': '', 'bid_type': 10, 'ocpx_action_type': 2, 'campaign_name': '222', 'group_name': '22', 'gender': 0, 'platform_os': 0, 'click_track_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (70 characters truncated) ... e=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'impression_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (70 characters truncated) ... e=__CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'actionbar_click_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (73 characters truncated) ... _CSITE__&androidIdMd5=__ANDROIDID2__&timestamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz', 'creative_category': None, 'action_bar_text': '22', 'image_cnt': 10, 'description': '22', 'use_app_market': '1', 'app_ids': '[622955]', 'scene_id': '[6, 7, 3]', 'schedule_time': '111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110', 'site_id': "[{'appId': 622955, 'siteId': ''}]", 'begin_time': '2021-01-23', 'end_time': '2021-02-02', 'ages_range': '[24, 18, 31, 41, 50]', 'region': '[]', 'convert_id': '', 'exclude_population': '[]', 'population': '[10099095]', 'strategy_state': '1', 'app_store': "['huawei', 'oppo', 'vivo', 'xiaomi', 'meizu', 'smartisan']", 'account_id': 23212, 'strategy_name': '55', 'campaign_type': '2'}]
  77. (Background on this error at: http://sqlalche.me/e/13/e3q8)