API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 25th, 2018
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.24 KB | None | 0 0
raw download clone embed print report
  1. Informations 2018. 04. 26. 03:46:39
  2. -----------------------------------------------------------------
  3. App = Octopus system
  4. Module = Media
  5. Ver = 3.058.010 b1804240500 (bld:2018. 04. 24.)
  6. Lang = [ENG]
  7. DBParm = Connectstring='DSN=Mediacom_v17_test;CON=norbert_sram/Norbert_Sram/BUDMCM-LT333;UID=octopus;PWD=***********', ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
  8. Error id = 7599361
  9. -----------------------------------------------------------------
  10. Ini file:C:\Octopus_GRM\OctopusTest\Mediacom\octopus.ini
  11. Ini config: [Login] \ Encrypt=1 \ \ [MASTER] \ NAME=EDGE CENTRAL TEST \ DBMS="ODBC" \ DBParm="Connectstring='DSN=groupm_central_v17_test'" \ MASTER=1 \ [DATABASE1] \ NAME=Mediacom TEST \ DBMS="ODBC" \ DBParm="Connectstring='DSN=Mediacom_v17_test'" \
  12. -----------------------------------------------------------------
  13. SQLCA:
  14. DBParm = Connectstring='DSN=Mediacom_v17_test;CON=norbert_sram/Norbert_Sram/BUDMCM-LT333;UID=octopus;PWD=***********', ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'
  15. DBMS = ODBC
  16. SQLCode = 0, SQLDBCode = 0, SQLNRows = 1 SQLReturnData = SQL Anywhere
  17. SQLErrtext =
  18.  
  19. =================================================================
  20. Dataerror 2018. 04. 26. 03:46:39
  21. -----------------------------------------------------------------
  22. Select Error: SQLSTATE = S1000
  23. [SAP][ODBC Driver][SQL Anywhere]Server 'mdigital_dev': [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'media_id'.; DataWindow = dw_item; DataObjetc = db_media_buy_import_internet
  24. -----------------------------------------------------------------
  25. -----------------------------------------------------------------
  26. DataWindow = dw_item
  27. DataObjetc = db_media_buy_import_internet
  28. Hibás sor = 0
  29. -----------------------------------------------------------------
  30. Puffer = Primary
  31. A hibás sor száma kívül esik az értelmezési tartományon
  32. (0), vagy nem a PRIMARY vagy DELETE bufferben van.
  33.  
  34. -----------------------------------------------------------------
  35. SQLCode = -660
  36. SQLDBCode = -660
  37. Hibaüzenet = Select Error: SQLSTATE = S1000
  38. [SAP][ODBC Driver][SQL
  39. Anywhere]Server 'mdigital_dev': [Microsoft][ODBC
  40. SQL Server Driver][SQL Server]Invalid column name
  41. 'media_id'.
  42. -----------------------------------------------------------------
  43. RowCount = 0
  44. DeletedCount = 0
  45. FilteredCount = 0
  46. ModifiedCount = 0
  47. -----------------------------------------------------------------
  48. Filter = ?
  49. -----------------------------------------------------------------
  50. Sort = sort_order A,job_code A,media_name A,dealer_name A,date_from A,date_to A,spot_size A,technical_cost A
  51. -----------------------------------------------------------------
  52. Syntax =
  53. SELECT i.media_type, i.job_code, i.agency_comm_buy,
  54. i.i_online_fee,
  55. i.i_adserver_fee,
  56. i.agency_comm_on,
  57. i.media_comm,
  58. i.media_id, i.media_name, i.dealer_id,
  59. i.dealer_name, i.item_type,
  60. year(i.date_from) as
  61. year_of,
  62. i.date_from, i.date_to, i.spot_size,
  63. i.technical_cost,
  64. i.inet_topic_name,
  65. i.inet_surface_name,
  66. i.i_place,
  67. i.i_format,
  68. i.i_targeting,
  69. i.i_price_term,
  70. i.price_type_code
  71. as i_price_type,
  72. i.price,
  73. i.price_client,
  74. i.ins,
  75. i.gross, i.net, i.netnet,
  76. i.client, i.performed_flag,
  77. i.price_perf,
  78. i.price_perf_client,
  79. i.ins_perf,
  80. i.gross_perf,
  81. i.net_perf,
  82. i.netnet_perf,
  83. i.client_perf,
  84. i.disex_flag_1
  85. as disex_flag_1,
  86. i.disex_type_id_1 as disex_type_id_1,
  87. i.disex_name_1
  88. as disex_name_1,
  89. i.from_gross_flag_1 as from_gross_flag_1,
  90. i.agency_percent_1
  91. as agency_percent_1,
  92. i.agency_value_1 as agency_value_1,
  93. i.client_percent_1
  94. as client_percent_1,
  95. i.client_value_1 as client_value_1,
  96. i.disex_flag_2
  97. as disex_flag_2,
  98. i.disex_type_id_2 as disex_type_id_2,
  99. i.disex_name_2
  100. as disex_name_2, i.from_gross_flag_2 as from_gross_flag_2,
  101. i.agency_percent_2 as agency_percent_2,
  102. i.agency_value_2
  103. as agency_value_2,
  104. i.client_percent_2 as client_percent_2,
  105. i.client_value_2 as client_value_2,
  106. i.disex_flag_3
  107. as disex_flag_3,
  108. i.disex_type_id_3 as disex_type_id_3,
  109. i.disex_name_3
  110. as disex_name_3,
  111. i.from_gross_flag_3 as from_gross_flag_3,
  112. i.agency_percent_3
  113. as agency_percent_3,
  114. i.agency_value_3 as agency_value_3,
  115. i.client_percent_3
  116. as client_percent_3, i.client_value_3 as client_value_3,
  117. disex_flag_1
  118. as disex_flag_perf_1,
  119. disex_type_id_1 as disex_type_id_perf_1,
  120. disex_name_1
  121. as disex_name_perf_1,
  122. from_gross_flag_1 as from_gross_flag_perf_1,
  123. agency_percent_1
  124. as agency_percent_perf_1,
  125. agency_value_1 as agency_value_perf_1,
  126. client_percent_1
  127. as client_percent_perf_1,
  128. client_value_1 as client_value_perf_1,
  129. disex_flag_2
  130. as disex_flag_perf_2,
  131. disex_type_id_2 as disex_type_id_perf_2,
  132. disex_name_2
  133. as disex_name_perf_2, from_gross_flag_2 as from_gross_flag_perf_2,
  134. agency_percent_2 as agency_percent_perf_2,
  135. agency_value_2
  136. as agency_value_perf_2,
  137. client_percent_2 as client_percent_perf_2,
  138. client_value_2 as client_value_perf_2,
  139. disex_flag_3
  140. as disex_flag_perf_3,
  141. disex_type_id_3 as disex_type_id_perf_3,
  142. disex_name_3
  143. as disex_name_perf_3,
  144. from_gross_flag_3 as from_gross_flag_perf_3,
  145. agency_percent_3
  146. as agency_percent_perf_3,
  147. agency_value_3 as agency_value_perf_3,
  148. client_percent_3
  149. as client_percent_perf_3, client_value_3 as client_value_perf_3,
  150. i.advertising,
  151. i.media_comment,
  152. i.finance_comment,
  153. i.performance_comment,
  154. i.order_comment,
  155. i.po_number,
  156. i.line_number,
  157. i.planid,
  158. i.status,
  159. i.action,
  160. i.sort_order,
  161. i.oct_date_of_import,
  162. i.oct_buying_id,
  163. '0' as spot_error,
  164. '0' as dealer_error,
  165. '0' as dealer_selected,
  166.  
  167. '0' as spot_selected,
  168. cast('' as nvarchar(500)) as
  169. error_message,
  170. cast('' as nvarchar(500)) as information_message
  171. FROM
  172. v_media_buy_import i
  173. WHERE i.job_id = ?
  174. -----------------------------------------------------------------
  175. SQLSelect =
  176. SELECT
  177. i.media_type,
  178. i.job_code,
  179. i.agency_comm_buy,
  180.  
  181. i.i_online_fee,
  182. i.i_adserver_fee,
  183. i.agency_comm_on,
  184.  
  185. i.media_comm,
  186. i.media_id,
  187. i.media_name,
  188.  
  189. i.dealer_id,
  190. i.dealer_name,
  191. i.item_type,
  192.  
  193. year(i.date_from) as year_of,
  194. i.date_from,
  195.  
  196. i.date_to,
  197. i.spot_size,
  198. i.technical_cost,
  199.  
  200. i.inet_topic_name,
  201. i.inet_surface_name,
  202. i.i_place,
  203.  
  204. i.i_format,
  205. i.i_targeting,
  206. i.i_price_term,
  207.  
  208. i.price_type_code as i_price_type,
  209.  
  210. i.price,
  211.  
  212. i.price_client,
  213. i.ins,
  214. i.gross,
  215. i.net,
  216.  
  217. i.netnet,
  218. i.client,
  219.  
  220. i.performed_flag,
  221.  
  222. i.price_perf,
  223. i.price_perf_client,
  224. i.ins_perf,
  225.  
  226. i.gross_perf,
  227. i.net_perf,
  228. i.netnet_perf,
  229.  
  230. i.client_perf,
  231.  
  232. i.disex_flag_1 as disex_flag_1,
  233.  
  234. i.disex_type_id_1 as disex_type_id_1,
  235. i.disex_name_1
  236. as disex_name_1,
  237. i.from_gross_flag_1 as from_gross_flag_1,
  238.  
  239. i.agency_percent_1 as agency_percent_1,
  240. i.agency_value_1
  241. as agency_value_1,
  242. i.client_percent_1 as client_percent_1,
  243.  
  244. i.client_value_1 as client_value_1,
  245. i.disex_flag_2
  246. as disex_flag_2,
  247. i.disex_type_id_2 as disex_type_id_2,
  248.  
  249. i.disex_name_2 as disex_name_2,
  250. i.from_gross_flag_2
  251. as from_gross_flag_2,
  252. i.agency_percent_2 as agency_percent_2,
  253.  
  254. i.agency_value_2 as agency_value_2,
  255. i.client_percent_2
  256. as client_percent_2,
  257. i.client_value_2 as client_value_2,
  258.  
  259. i.disex_flag_3 as disex_flag_3,
  260. i.disex_type_id_3
  261. as disex_type_id_3,
  262. i.disex_name_3 as disex_name_3,
  263.  
  264. i.from_gross_flag_3 as from_gross_flag_3,
  265. i.agency_percent_3
  266. as agency_percent_3,
  267. i.agency_value_3 as agency_value_3,
  268.  
  269. i.client_percent_3 as client_percent_3,
  270. i.client_value_3
  271. as client_value_3,
  272.  
  273. disex_flag_1 as disex_flag_perf_1,
  274.  
  275. disex_type_id_1 as disex_type_id_perf_1,
  276. disex_name_1
  277. as disex_name_perf_1,
  278. from_gross_flag_1 as from_gross_flag_perf_1,
  279.  
  280. agency_percent_1 as agency_percent_perf_1,
  281. agency_value_1
  282. as agency_value_perf_1,
  283. client_percent_1 as client_percent_perf_1,
  284.  
  285. client_value_1 as client_value_perf_1,
  286. disex_flag_2
  287. as disex_flag_perf_2,
  288. disex_type_id_2 as disex_type_id_perf_2,
  289.  
  290. disex_name_2 as disex_name_perf_2,
  291. from_gross_flag_2
  292. as from_gross_flag_perf_2,
  293. agency_percent_2 as
  294. agency_percent_perf_2,
  295. agency_value_2 as agency_value_perf_2,
  296.  
  297. client_percent_2 as client_percent_perf_2,
  298. client_value_2
  299. as client_value_perf_2,
  300. disex_flag_3 as disex_flag_perf_3,
  301.  
  302. disex_type_id_3 as disex_type_id_perf_3,
  303. disex_name_3
  304. as disex_name_perf_3,
  305. from_gross_flag_3 as from_gross_flag_perf_3,
  306.  
  307. agency_percent_3 as agency_percent_perf_3,
  308. agency_value_3
  309. as agency_value_perf_3,
  310. client_percent_3 as client_percent_perf_3,
  311.  
  312. client_value_3 as client_value_perf_3,
  313.  
  314.  
  315. i.advertising,
  316. i.media_comment,
  317. i.finance_comment,
  318.  
  319. i.performance_comment,
  320. i.order_comment,
  321. i.po_number,
  322.  
  323. i.line_number,
  324.  
  325. i.planid,
  326. i.status,
  327.  
  328. i.action,
  329. i.sort_order,
  330. i.oct_date_of_import,
  331.  
  332. i.oct_buying_id,
  333.  
  334. '0' as spot_error,
  335. '
  336. 0' as dealer_error,
  337. '0' as dealer_selected,
  338.  
  339. '0' as spot_selected,
  340. cast('' as nvarchar(500))
  341. as error_message,
  342. cast('' as nvarchar(500)) as
  343. information_message
  344. FROM v_media_buy_import i
  345. WHERE
  346. i.job_id = :a_job_id
  347. -----------------------------------------------------------------
  348. UpdateKey InPlace = no
  349. UpdateTable = ?
  350. UpdateWhere = 0 — Key columns only
  351. Nested = no
  352. Processing = 1
  353. Arguments = a_job_id number
  354. > a_job_id = 0
  355. -----------------------------------------------------------------
  356.  
  357. END.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!