{"action":"created","issue":{"url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/3","repository_url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos","labels_url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/3/comments","events_url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/3/events","html_url":"https://github.com/progress/Spark-Toolkit-Demos/issues/3","id":342386050,"node_id":"MDU6SXNzdWUzNDIzODYwNTA=","number":3,"title":"schema ant create fails if startup.pf contains European settings","user":{"login":"cverbiest","id":1312691,"node_id":"MDQ6VXNlcjEzMTI2OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/1312691?v=4","gravatar_id":"","url":"https://api.github.com/users/cverbiest","html_url":"https://github.com/cverbiest","followers_url":"https://api.github.com/users/cverbiest/followers","following_url":"https://api.github.com/users/cverbiest/following{/other_user}","gists_url":"https://api.github.com/users/cverbiest/gists{/gist_id}","starred_url":"https://api.github.com/users/cverbiest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cverbiest/subscriptions","organizations_url":"https://api.github.com/users/cverbiest/orgs","repos_url":"https://api.github.com/users/cverbiest/repos","events_url":"https://api.github.com/users/cverbiest/events{/privacy}","received_events_url":"https://api.github.com/users/cverbiest/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-18T15:43:40Z","updated_at":"2018-07-18T15:53:28Z","closed_at":null,"author_association":"NONE","body":"Our startup.pf contains\r\n\r\n```\r\n-cpinternal utf-8\r\n-cpstream utf-8\r\n-cpcoll Basic\r\n-cpcase Basic\r\n-d dmy\r\n-numsep 46\r\n-numdec 44\r\n-T /tmp\r\n```\r\n\r\nthis causes ant create to fail, no .e files are available\r\nif I remove -d, -numsep and -numdec from startup.pf it succeeds.\r\n\r\n```\r\nant create\r\nBuildfile: /home/user/projects/Spark-Toolkit-Demos/support/schema/build.xml\r\n\r\n_init_env:\r\n     [echo] DLC Home: /usr/dlc\r\n     [echo] OS Arch: amd64\r\n\r\n_init_unix:\r\n\r\n_init_windows:\r\n\r\ncreate:\r\n[PCTVersion] PCT Version : pct-209-master-260e0a7951e4a94d04f43fc827196578e664bebb\r\n[PCTCreateBase] Database Sports2000 already exists\r\n[PCTLoadData]\r\n[PCTLoadData]   Loading Data.   Press STOP to terminate the load process.\r\n[PCTLoadData]                                                  Records   Total   Expected\r\n[PCTLoadData]   Table              Load file                   Loaded    Errors   Records\r\n[PCTLoadData]   ------------------ --------------------------- -------- -------- --------\r\n[PCTLoadData]\r\n[PCTLoadData]   Benefits           /home/user/project !ERROR!                 21\r\n[PCTLoadData]   BillTo             /home/user/project !ERROR!                  2\r\n[PCTLoadData]   Bin                /home/user/project !ERROR!                770\r\n[PCTLoadData]   Customer           /home/user/project !ERROR!               1117\r\n[PCTLoadData]   Department         /home/user/project !ERROR!                  8\r\n[PCTLoadData]   Employee           /home/user/project !ERROR!                 55\r\n[PCTLoadData]   Family             /home/user/project !ERROR!                 72\r\n[PCTLoadData]   Feedback           /home/user/project !ERROR!                  8\r\n[PCTLoadData]   InventoryTrans     /home/user/project !ERROR!                 75\r\n[PCTLoadData]   Invoice            /home/user/project !ERROR!                147\r\n[PCTLoadData]   Item               /home/user/project !ERROR!                 55\r\n[PCTLoadData]   LocalDefault       /home/user/project !ERROR!                 10\r\n[PCTLoadData]   Order              /home/user/project !ERROR!               3953\r\n[PCTLoadData]   OrderLine          /home/user/project !ERROR!              13970\r\n[PCTLoadData]   POLine             /home/user/project !ERROR!               5337\r\n[PCTLoadData]   PurchaseOrder      /home/user/project !ERROR!               2129\r\n[PCTLoadData]   RefCall            /home/user/project !ERROR!                 13\r\n[PCTLoadData]   Salesrep           /home/user/project !ERROR!                  9\r\n[PCTLoadData]   ShipTo             /home/user/project !ERROR!                  3\r\n[PCTLoadData]   State              /home/user/project !ERROR!                 51\r\n[PCTLoadData]   Supplier           /home/user/project !ERROR!                 10\r\n[PCTLoadData]   SupplierItemXref   /home/user/project !ERROR!                 56\r\n[PCTLoadData]   TimeSheet          /home/user/project !ERROR!                 25\r\n[PCTLoadData]   Vacation           /home/user/project !ERROR!                 12\r\n[PCTLoadData]   Warehouse          /home/user/project !ERROR!                 14\r\n[PCTLoadData] Load of database contents completed.\r\n[PCTLoadData] Errors/Warnings listed in .e files placed into same directory as .d files\r\n\r\nBUILD FAILED\r\n/home/user/projects/Spark-Toolkit-Demos/support/schema/build.xml:72: Return code : 1\r\n\r\nTotal time: 0 seconds\r\n```"},"comment":{"url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/comments/405981301","html_url":"https://github.com/progress/Spark-Toolkit-Demos/issues/3#issuecomment-405981301","issue_url":"https://api.github.com/repos/progress/Spark-Toolkit-Demos/issues/3","id":405981301,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNTk4MTMwMQ==","user":{"login":"DustinGrau-PSC","id":11320359,"node_id":"MDQ6VXNlcjExMzIwMzU5","avatar_url":"https://avatars1.githubusercontent.com/u/11320359?v=4","gravatar_id":"","url":"https://api.github.com/users/DustinGrau-PSC","html_url":"https://github.com/DustinGrau-PSC","followers_url":"https://api.github.com/users/DustinGrau-PSC/followers","following_url":"https://api.github.com/users/DustinGrau-PSC/following{/other_user}","gists_url":"https://api.github.com/users/DustinGrau-PSC/gists{/gist_id}","starred_url":"https://api.github.com/users/DustinGrau-PSC/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DustinGrau-PSC/subscriptions","organizations_url":"https://api.github.com/users/DustinGrau-PSC/orgs","repos_url":"https://api.github.com/users/DustinGrau-PSC/repos","events_url":"https://api.github.com/users/DustinGrau-PSC/events{/privacy}","received_events_url":"https://api.github.com/users/DustinGrau-PSC/received_events","type":"User","site_admin":false},"created_at":"2018-07-18T15:53:28Z","updated_at":"2018-07-18T15:53:28Z","author_association":"COLLABORATOR","body":"I'm sorry that you're running into this issue, but the provided ANT script is a courtesy for automating usage and relies on the PCT library which is a third-party component. This is outside the scope of the Spark toolkit and should be addressed as a support request regarding the PCTLoadData task in that project: https://github.com/Riverside-Software/pct\r\n\r\nThe workaround for this issue would be to use the Data Administration tool to manually load the .df and .d data into your target database."}}
{"actor":{"display_login":"DustinGrau-PSC"}}