{"action":"created","issue":{"url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/2","labels_url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/2/comments","events_url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/2/events","html_url":"https://github.com/DaveWellman/PerfCentral_v1/issues/2","id":71091689,"number":2,"title":"PCTD: TD5404 error running against TD15.x system","user":{"login":"DaveWellman","id":12125065,"avatar_url":"https://avatars.githubusercontent.com/u/12125065?v=3","gravatar_id":"","url":"https://api.github.com/users/DaveWellman","html_url":"https://github.com/DaveWellman","followers_url":"https://api.github.com/users/DaveWellman/followers","following_url":"https://api.github.com/users/DaveWellman/following{/other_user}","gists_url":"https://api.github.com/users/DaveWellman/gists{/gist_id}","starred_url":"https://api.github.com/users/DaveWellman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaveWellman/subscriptions","organizations_url":"https://api.github.com/users/DaveWellman/orgs","repos_url":"https://api.github.com/users/DaveWellman/repos","events_url":"https://api.github.com/users/DaveWellman/events{/privacy}","received_events_url":"https://api.github.com/users/DaveWellman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-26T16:49:03Z","updated_at":"2015-04-27T09:52:03Z","closed_at":null,"body":"I’ve found a problem that happens when we run against TD 15.0 - and in theory this could happen on any release if we’re looking at data from a customer defined table (i.e. where we’re extracting the data from anywhere OTHER than database DBC).\r\n\r\nWhen you are setting up the sql that updates the DATA_TS field, I think you’re simply copying the value from the extracted data (a timestamp value). That will work fine providing the extracted data column has a maximum of 2 decimal places for the seconds. On TD 15 some of the data that we’re looking at now uses up to 6 decimal places (no, I don’t know why either) and using this entire value causes a problem with our SQL – for instance sql ID=42.\r\n\r\nThe sql that you are currently building is\r\nUPDATE \"ward_pc_dbc\".PERFORMANCECENTRAL_CONTROL   SET DATA_TS = TIMESTAMP '2015-03-20 00:00:00.000000' WHERE DATA_IDENTIFIER = 'TASMSUMRY';\r\n\r\nNotice the TIMESTAMP value. You will need ot change your code to ensure that there are only ever a maximum of 2 decimal places.\r\nFortunately I think this is a fairly easy fix (although probably in a number of places). I think the TIMESTAMP values are always returned to your code as a string, in which case I think if when you insert the value into the sql (via a call to BuildSQL4 or manually) you use Left$(timestamp-value,22) that will truncate longer strings to the required precision\r\n"},"comment":{"url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/comments/96587650","html_url":"https://github.com/DaveWellman/PerfCentral_v1/issues/2#issuecomment-96587650","issue_url":"https://api.github.com/repos/DaveWellman/PerfCentral_v1/issues/2","id":96587650,"user":{"login":"Shabra23","id":12134555,"avatar_url":"https://avatars.githubusercontent.com/u/12134555?v=3","gravatar_id":"","url":"https://api.github.com/users/Shabra23","html_url":"https://github.com/Shabra23","followers_url":"https://api.github.com/users/Shabra23/followers","following_url":"https://api.github.com/users/Shabra23/following{/other_user}","gists_url":"https://api.github.com/users/Shabra23/gists{/gist_id}","starred_url":"https://api.github.com/users/Shabra23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shabra23/subscriptions","organizations_url":"https://api.github.com/users/Shabra23/orgs","repos_url":"https://api.github.com/users/Shabra23/repos","events_url":"https://api.github.com/users/Shabra23/events{/privacy}","received_events_url":"https://api.github.com/users/Shabra23/received_events","type":"User","site_admin":false},"created_at":"2015-04-27T09:52:03Z","updated_at":"2015-04-27T09:52:03Z","body":"I can see this issue and comment on it"}}